What is a data warehouse, and what is the difference between a database

) is a subject-oriented (SubjectOriented), integrated (Integrate), relatively stable (Non-Volatile), reflecting historical changes (TimeVariant) collection of data used to support management decisions.

(1) Theme-oriented: refers to the data in the data warehouse is organized according to a certain theme domain.

(2) integration: refers to the original dispersed database data through systematic processing, organization to eliminate inconsistencies in the source data.

(3) relatively stable: refers to once a data into the data warehouse only need to regularly load, refresh.

(4) reflecting historical changes: refers to the information to make quantitative analysis and prediction of the development history and future trends of the enterprise.

The emergence of data warehouse is not to replace the database. At present, most data warehouses are still managed with relational database management

management system. The main differences between data warehouses and databases are:

(1) Databases are designed to be transaction-oriented and data warehouses are designed to be subject-oriented.

(2) Databases generally store online transactional data, and data warehouses generally store historical data.

(3) Databases are designed to avoid redundancy as much as possible, and data warehouses are designed to intentionally introduce redundancy.

(4) Databases are designed to capture data, data warehouses are designed to analyze data.

What is a data warehouse and how is it different from a database

Tags.