Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider a data warehouse for a train company, which wishes to study sales of train tickets. The data warehouse has dimensions on time, customers, routes,

Consider a data warehouse for a train company, which wishes to study sales of train tickets. The data warehouse has dimensions on time, customers, routes, and trains, and it also includes a measure on ticket amount. The time dimension has a hierarchy of date & time < date < month < year.

1. How many cuboids will the cube contain, including the base and apex cuboids?

2. Starting with the base cuboid [day,customer,route,train], which OLAP operations should be performed in order to list the total amount of tickets collected for a specific route (e.g. Route243), for a given year (e.g. 2021)?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial Databases 2nd Symposium Ssd 91 Zurich Switzerland August 1991 Proceedings Lncs 525

Authors: Oliver Gunther ,Hans-Jorg Schek

1st Edition

3540544143, 978-3540544142

More Books

Students also viewed these Databases questions