Question: Why is online analytical processing usually conducted on warehoused data or dimensional data bases rather than on data in transactional databases?

Why is online analytical processing usually conducted on warehoused data or dimensional data bases rather than on data in transactional databases?

Step by Step Solution

★★★★★

3.41 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Data in data warehouses covers results of operations over a lon... 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

354-B-A-I-S (4055).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Q:

What is online analytical processing (OLAP)?

Q:

Why do creditors usually accept a plan for financial rehabilitation rather than demand liquidation of the business? Discuss.

Q:

Why is charge usually transferred by electrons rather than by protons?

Q:

What is a mritidimerisional database? It is a relational database that stores data in tables that consist of rows and columns It is a used to store data for optimized online transactional processing...

Q:

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Q:

Homework 6 1.Which of the following tasks cannot be performed in a Pivot Table? a. b. Validate Data c. d. 2.What is the best slice and dice technique use to do the following: Display the average...

Q:

A large online retailer has set up a private web space to sell to its customers that are businesses. These transactions are generally conducted through negotiated contracts. How does the company use...

Q:

Which of the following is the best admission of confidentiality? Group of answer choices The right of an individual access to his or her information The right of an individual to limit disclosure of...

Q:

Organizations are constantly looking for ways to outperform their rivals on a strategic level. Analyzing the data they have accessible in their database is one technique to achieve this. Internal...

Q:

only do question 1,3,6,9,10,15 specialist data quality data redundancy data type data warehouse database database design database management system (DBMS) metadata multiuser database NoSQL online...

Q:

Relational DBMS query languages provide easy access to information about the organizations activities. Does this mean that online, real-time processing should be used for all transactions? Does an...

Q:

Please explain as much as you can about this formula. This formula is found in the column cells of Group. Columns SSS. ColumnH is Group . Date 1/10/2010 1/10/2010 Amount $137.74 $137.74 Vendor SSS...

Q:

A company had the following sales transactions: Total debit card sales = $ 2 9 0 , 0 0 0 . Total credit card sales = $ 4 6 0 , 0 0 0 . Total cash sales = $ 8 8 0 , 0 0 0 . Total check sales = $ 1 4 0...

Q:

LO.1, 2, 3, 4 Cerulean Corporation has two equal shareholders, Eloise and Olivia. Eloise acquired her Cerulean stock three years ago by transferring property worth $700,000, basis of $300,000, for 70...

Q:

List and describe the technologies used in this case study.

Q:

In what sense are U.S. farms now digital firms? Explain your answer.

Q:

How is information technology changing the way farmers run their business?

Q:

On april 30, 1990, Jack purchased a $1,000 10% par-value seven-year bond having semiannual coupons; these were payable at the end of each October as well as on the anniversaries of the purchase. Jack...

Q:

Pacific Healthcare is an investor-owned hospital chain that owns and operates nine hospitals in Washington, Oregon, and northern California. Marcia Long, a recent graduate of a prominent health...

Q:

In the WACC Sensitivity tab on the accompanying spreadsheet, alter the cells as described below to see how changes to WACC s inputs impact the WACC. Write a few sentences describing each change. FED...