Question
A data warehouse of a train company contains information about train segments. It consists of six dimensions, namely, departure station, arrival station, trip, train, arrival
A data warehouse of a train company contains information about train segments. It consists of six dimensions, namely, departure station, arrival station, trip, train, arrival time, and departure time, and three measures, namely, number of passengers, duration, and number of kilometers. Define the OLAP operations to be performed in order to answer the following queries. Propose the dimension hierarchies when needed. 1. Total number of kilometers made by Alstom trains during 2012 departing from French or Belgian stations. 2. Total duration of international trips during 2012, that is, trips departing from a station located in a country and arriving at a station located in another country. 3. Total number of trips that departed from or arrived at Paris during July 2012. 4. Average duration of train segments in Belgium in 2012. 5. For each trip, average number of passengers per segment, which means take all the seg- ments of each trip and average the number of passengers.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started