A flight data warehouse for a travel agent consists of six, Ask an Expert

Engineering

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).

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M91722843

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

A small sports club keeps information about its members and

A small sports club keeps information about its members and the fees they pay. The secretary wants to be able to record when members pay and print a report similar to that in the figure below. last n me - first_narne - p ...

Subject digital securityimagine a scenario that you go to a

Subject: Digital security Imagine a scenario that you go to a restaurant and pay the meal using your credit card. What communication parties are involved and what information is exchanged in order to complete this transa ...

Question a typical feedback form consists some questions

Question: A typical feedback form consists some questions where students have to give a numerical "grade" and one or more comments fields. Select one or more design platforms and design a preliminary draft of the digital ...

Assignment 1 network access controlin a business

Assignment 1: Network Access Control In a business environment, controlling who has access to business information and at what level is critical for facilitating day-to-day business operations. The emphasis of Network Ac ...

After sal aurigemma received his phd from the university of

After Sal Aurigemma received his PhD from the University of Hawaii, he became an assistant professor at the University of Tulsa. There, he introduced the school to Aloha Friday, when people come to work in their colorful ...

Decision support systemsnbspvary greatly in application and

Decision support systems vary greatly in application and complexity, but they all share specific features. A typical Decision support systems has four components: data management, model management, knowledge management ...

A group of students made the following scores on a 10-item

A group of students made the following scores on a 10-item quiz in psychological statistics: {5, 6, 7, 7, 7, 8, 8, 9, 9, 10, 10} What is the variance, treating these scores as a sample?

Reminder all files must be closed when you are done with

Reminder: All files must be closed when you are done with them, even if it stops early due to an IOError. If you're using with, this will happen automatically. If you're trying to close things manually using .close(), th ...

Scheme questionthe following program can be used to

Scheme Question The following program can be used to determine if a given interpreter is using applicative-order evaluations or normal-order evaluation: (define (p)(p)) (define (test x y) (if (= x 0) 0 y)) (test 0 (p)) ( ...

Answer the following question whats the difference between

Answer the following Question : What's the difference between public, protected, and private members? What's the difference between static binding and dynamic binding?

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert