Why does the data warehouse need to be separate from the operational databases?


The conclusion that a data warehouse must be maintained separately from the operational database reflects several issues. The transaction processing system needs a data structure that supports performance. A normalized database aids users but adds complexity that can yield performance inefficiency. Data mining systems need an organization that permits broad queries. The data warehouse permits the integration of data still maintained in legacy systems. And the complexities of modern business can benefit from the ability to analyze data extensively in ways not permitted in traditional databases.

Business

You might also like to view...

The face amount of the note that the maker promises to pay at maturity is known as the ____________________

Fill in the blank(s) with correct word

Business

An auditor may best test commissions expense for salespeople when control risk is low by performing which of the following procedures?

a. Analytical procedures. b. Tagging and tracing. c. Alternative procedures. d. Subsequent proof of cash.

Business

Discuss with an example how marketers have adapted to people's changing views toward nature

What will be an ideal response?

Business

VALS groups of consumers motivated by ________ are those who are guided by knowledge and principle.

A. ideals B. success C. achievement D. self-expression E. rewards

Business