A flight data warehouse for a travel agent consists of six d
Question and Solution
A flight data warehouse for a travel agent consists of six dimensions: traveler, departure (city), departure time, arriv
85 % (324 Review)
A flight data warehouse for a travel agent consists of six dimensions: traveler, departure (city), departure time, arrival, arrival time, and flight; and two measures: count( ) and avg fare( ), where avg fare( ) stores the concrete fare at the lowest level but the average fare at other levels. (a) Suppose the cube is fully materialized. Starting with the base cuboid [traveler, departure, departure time, arrival, arrival time, flight], what specific OLAP operations (e.g., roll-up flight to airline) should one perform to list the average fare per month foreach business traveler who flies American Airlines (AA) from Los Angeles in 2009? (b) Suppose we want to compute a data cube where the condition is that the minimum number of records is 10 and the average fare is over $500. Outline an efficient cube computation method (based on common sense about flight data distribution).
Your answer will be ready within 2-4 hrs. Meanwhile, check out other millions of Q&As and Solutions Manual we have in our catalog.
Crazy for Study is a platform for the provision of academic help. It functions with the help of a team of ingenious subject matter experts and academic writers who provide textbook solutions to all your course-specific textbook problems, provide help with your assignments and solve all your academic queries in the minimum possible time.
Disclaimer: Crazy For Study provides academic assistance to students so that they can complete their college assignments and projects on time. We strictly do not deliver the reference papers. This is just to make you understand and used for the analysis and reference purposes only.