Question

Define the term data warehouse. Explain its characteristics

Answer 1

Answer:

A data warehousing is defined as a technique for collecting and managing data from varied sources to provide meaningful business insights. It is electronic storage of a large amount of information by a business which is designed for query and analysis instead of transaction processing.

The key characteristics of a data warehouse are as follows:

• Some data is denormalized for simplification and to improve performance.
• Large amounts of historical data are used.
• Queries often retrieve large amounts of data.
• Both planned and ad hoc queries are common.
• The data load is controlled.