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 by adding 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...

Under proper storage conditions, film-based records are predicted to last up to 500 years

Indicate whether the statement is true or false.

Business

Most audits result in unqualified audit opinions.

Answer the following statement true (T) or false (F)

Business

What action would the management take if it wants to gain more ownership control of the firm??

A. ?Issue more growth stocks B. ?Solicit and get stockholders' proxies C. ?Repay a portion of the loan D. ?Repurchase shares of common stock E. ?Pay cumulative dividends to preferred stocks

Business

What is the legal significance of a material misrepresentation in an insurance application?

A) The contract is automatically voided from its inception. B) The contract is voidable at the insurer's option. C) Loss payments are reduced by the degree of the misrepresentation. D) The insurer is immediately entitled to a higher premium.

Business