Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 8: Toll Road (apa)

This cube stores data about vehi­cles dri­ving on a toll road.

We have three di­men­si­ons with the fol­lo­wing hier­ar­chi­cal struc­tu­re:

Table A.E.54.1 - toll road

Plea­se build the Ag­gre­ga­ti­on Path Array and as­su­me the fol­lo­wing end-​user re­qui­re­ment:

"a month­ly re­port for the types of vehi­cles on each road"

Select the cor­re­spon­ding cells in the APA and choo­se a cube to ma­te­ria­li­ze, then high­light the de­ri­va­ti­ves of this cube.

So­lu­ti­on

Fi­gu­re A.E.54.1 - The re­sul­ting APA with the red­un­dan­cy free-​set high­ligh­ted

Size of the redundancy-​free set (in­clu­ding the base cube): 36

Re­qui­red cubes, the ma­te­ria­liza­ti­on de­cis­i­on and de­ri­va­ti­ves

The blue area re­p­res­ents the end-​user re­qui­re­ments ("a month­ly re­port for the types of vehi­cles on each road"), they are met by ma­te­ria­li­zing cube v = (V_ty, R_ro, T_m) (dark blue cell "T_m"). The area to the right of the black line in­clu­des all de­ri­va­ti­ves of v.

Fi­gu­re A.E.54.2 - De­ri­va­ti­ves of cube v = (V_ty, R_ro, T_m)

This ex­er­ci­se is part of a case study: dfm - apa log