What is a data warehouse?

What will be an ideal response?


A data warehouse is a non-operational database intended for use by Business Intelligence applications. A data warehouse is a database system that has data, programs and personnel who specialize in the preparation of data for Business intelligence processing. Databases in data warehouses are frequently denormalized to speed up BI processes. The components of a data warehouse include programs for data extraction/cleaning/preparation, data warehouse DBMSs, data warehouse metadata and data warehouse data. The data warehouse metadata database records the date warehouse data's source, format assumptions, constraints and other relevant facts.

Business

You might also like to view...

Pedro, CEO of a successful IT company, is constantly reading press releases, ads, and news articles about his competition. He regularly checks information about new competitive products and visits trade shows to study his competition. Pedro is involved in

A. environmental observation. B. TQM. C. corporate spying. D. management by observation. E. competitive intelligence.

Business

An alternate way to increase sales volume is to increase the usage rates among users by having consumers use the product in new ways

Indicate whether the statement is true or false

Business

Advertising campaigns involving issues ranging from health care, education, and environmental sustainability to human rights and personal safety can be classified under ________ marketing

A) corporate image B) internal C) social D) place E) person

Business

Service-oriented businesses take the same approach to pricing their "product" as product-oriented businesses

Indicate whether the statement is true or false

Business