Ask Singapore Homework?

Upload a photo of a Singapore homework and someone will email you the solution for free.



Question

International Baccalaureatte | Further Maths HL
No Answers Yet

Help Jacob! Anyone can contribute an answer, even non-tutors.

Answer This Question
Jacob
Jacob

International Baccalaureatte chevron_right Further Maths HL

Consider a data warehouse that holds information on traffic. From our transactional databases, we have access to all metadata information about all the vehicles in traffic, about the route starting points and destinations, as well as about the drivers.

1. Sketch a data warehouse schema.

2. Develop an example hierarchy over dimensions for addresses, for time, for drivers. 3.Give an example for each of the functionalities roll-up, drill-down, slice and dice. (hint: describe a “before” view of the data cube, and an “after” view of the data cube).

Date Posted: 1 year ago
Views: 62