What specific olap operations should one performin order

Assignment Help Basic Computer Science

Reference no: EM131007131

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, andavg fare, where avg fare stores the concrete fare at the lowest level but average fare atother levels.

(a) Suppose the cube is fully materialized. Starting with the base cuboid [traveller,departure, departure time, arrival, arrival time, flight], what specific OLAP operations(e.g., roll-up flight to airline) should one performin order to list the average fare permonth for each business traveler who flies American Airlines (AA) from L.A. in theyear 2004?

(b) Suppose we want to compute a data cube where the condition is that the minimumnumber of records is 10 and the average fare is over $500. Outline an efficient cubecomputation method (based on common sense about flight data distribution).

Reference no: EM131007131

Questions Cloud

What is the own-price elasticity of demand : Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ..

Find the approximate equilibrium quantity and price : If 3000 two-bedroom houses are demanded per year, at a price of $500,000 per unit. However, for every $40,000 increase in the price per unit, the quantity of units demanded falls by 200. Find the demand curve. Find the supply curve. Find the approxim..

What specific olap operations should one performin order : 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, andavg fare, where avg fare stores the concrete fare at the lowest level ..

Calculate the price elasticity of demand for appetizers : The South Beach Café recently reduced appetizer prices from $10 to $8 for afternoon “early bird” customers and enjoyed a resulting increase in sales from 75 to 125 orders per day. Beverage sales also increased from 400 to 550 units per day. Calculate..

Draw the entity-relationship diagram for the above scenario : Prepare a document of requirement analysis and justify the need to create the system for the above case study. Draw the entity-relationship diagram for the above scenario

Do you believe that most criminal activity is a product : Do you believe that most criminal activity is a product of their environment in which the criminals are raised? Do you believe that criminal activity is a product of a combination of both genetics and environment

User Account

All Pages