Question: How are the summary views in a data warehouse different from views in an operational database?

How are the summary views in a data warehouse different from views in an operational database?

Step by Step Solution

★★★★★

3.41 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To improve operational efficiency certain data are transformed into sum... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

210-B-A-I-S (2301).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Q:

How is a data warehouse different from a database? How are they similar?

Q:

How might a company use both an operational database and a data warehouse in the preparation of its annual report?

Q:

How are a file and a database different from each other?

Q:

9. How are the summary views in a data warehouse different from views in an operational database?

Q:

Introduction Data warehouses are used to contain data used to support decision making. Data accumulated by a business is a valuable resource and often contains information about factors that affect...

Q:

Introduction Data warehouses are used to contain data used to support decision making. Data accumulated by a business is a valuable resource and often contains information about factors that affect...

Q:

I. ... ............ exists when it is possible to make changes in the data storage characteristics without affecting an application program's ability to access data. 2. Which of the following is NOT...

Q:

INTERNATIONAL REVIEW OF L AW C OMPUTERS & TECHNOLOGY , VOLUME 11, N UMBER 2, P AGES 251-261, 1997 The Data Mart: A New Approach to Data Warehousing PAM ELA PIPE Introduction Vendors have recently...

Q:

To read the article describing the components of Payn'e CRM Framework The link below also describes the framework and gives you some insights in relation to how to apply it...

Q:

CONSOLIDATED BANK OF GHANA (CBG) FINDS A NEW RECIPE FOR ANALYZING ITS DATA In August 2018, the Governor of the Bank of Ghana (BOG), announced a merger of five local banks in Ghana, namely Beige Bank,...

Q:

Show that there is a root of the equation below between 1 and 2. 4x36x2 + 3x-2=0 SOLUTION Let f(x) = 4x - 6x + 3x - 2. We are looking for a solution of the given equation, that is, a number c between...

Q:

Complete the ADT SortedList by finishing all the constructors and methods in the class template SortedList.h (C++) SortedList.h: #ifndef _SORTED_LIST #define _SORTED_LIST #include"Node.h" template...

Q:

2.29 Metabolic rate. In Example 2.7 you examined the metabolic rates of 7 men. Here are the metabolic rates for 12 women from the same study: 995 1425 1396 1418 1502 1256 1189 913 1124 1052 1347 1204...

Q:

Lord Coke had this to say about bribery: "Though the bribe be small, yet the fault is great." Do you agree that the size of the bribe is unimportant in determining legal or ethical wrongdoing?

Q:

Give some examples of field names that you would use for the Customer table in Figure. What data type would you assign to each field using Microsoft Access, and how large would you make each text...

Q:

Identify the different data types available for creating data fields in Microsoft Access. Similarly, identify the different types of numbers (e.g., Long integer) you can use if you define a field as...

Q:

The Furry Friends Foundation is a non-profit organization that finds homes for abandoned animals that are suitable for adoption. FFF began operations with a bequest from a wealthy gentleman who lived...

Q:

To promote the sale of some specialty goods, Teal Mountain Ltd . began a generous return policy for its customers. Customers can return merchandise for up to three months following the date of the...

Q:

Brief Exercise 12-4 Direct versus Indirect Method L04 Brief Exercise 12-4 Direct versus Indirect Method 2-4. 12-5 For each of the Murrains items, indicate whether it would appear on a statement of...

Q:

Chapter 14 Exercises/Problems Assignment Saved Help Save & Exit Submit 100 Check my wote 7 Perit Industries has $140,000 to invest. The company is trying to decide between two alternative uses of the...