Shulou(Shulou.com)05/31 Report--

What is the difference between database and data warehouse? many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can get something.

There are two levels / perspectives to answer this interesting question:

1, logical level / conceptual level: database and data warehouse are actually the same or very similar, both organize and manage data through some database software and based on a certain data model. However, databases usually pay more attention to business transaction processing (OLTP), while data warehouses pay more attention to the data analysis level (OLAP). As a result, there will be great differences in database models.

The database usually pursues transaction speed, transaction integrity, data consistency, and so on. In the database model, it mainly follows the normal form model (1NF, 2NF, 3NF, etc.), thus minimizing data redundancy and ensuring referential integrity. Data warehouse emphasizes the efficiency of data analysis, the speed of complex query, and the correlation analysis between data, so in the database model, data warehouse likes to use multi-dimensional model, so as to improve the efficiency of data analysis.

2. Product implementation: database and data warehouse software are somewhat different. Databases usually use row storage, such as SAP ASE,Oracle and Microsoft SQL Server, while data warehouses tend to use column storage, such as SAP IQ,SAP HANA.

Data warehouse is a topic-oriented (Subject Oriented), integrated (Integrate), relatively stable (Non-volatile), reflecting historical changes (Time Variant) of the data set, used to support management decisions.

So-called:

Topic-oriented: the data in the data warehouse is organized according to a certain topic domain.

Integration: refers to the systematic processing of the original distributed database to eliminate inconsistencies in the source data.

Relatively stable: it means that once a data enters the data warehouse, it only needs to be loaded and refreshed regularly.

Reflect historical changes: to make quantitative analysis and prediction of the development process and future trend of the enterprise through this information.

The construction of data warehouse is a project and a process, not a product that can be purchased. The way of enterprise data processing is to process information in the form of online transaction processing, and to make decisions using information, and to manage information in the process of information application.

The emergence of data warehouse is not to replace the database. At present, most data warehouses are implemented by relational database management systems. The main differences between a data warehouse and a database are:

The database is transaction-oriented, and the data warehouse is topic-oriented.

Databases generally store online transaction data, while data warehouses generally store historical data.

The database design is to avoid redundancy as much as possible, and the data warehouse intentionally introduces redundancy in the design.

Databases are designed to capture data, and data warehouses are designed to analyze data.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.