The difference between a data warehouse and a database

Source: Internet
Author: User

Data Warehouse is a subject-oriented (Subject oriented), integrated (integrate), relatively stable (non-volatile), data collection that reflects historical changes (time Variant). Used to support management decisions.
The so-called (1) topic-oriented: Index data in the warehouse is organized according to a certain subject domain.
(2) Integration: Refers to the original distributed database data through the system processing, collated to eliminate inconsistencies in the source data.
(3) Relative Stability: Once a data into the data warehouse only need to periodically load, refresh.
(4) Reflect historical changes: through this information, the enterprise's development process and future trends to make quantitative prediction.
Data Warehouse construction is a project, a process, not a product that can be purchased. The enterprise data processing method is the form of online transaction processing information, and the use of information for decision-making, in the information application process management information.
The advent of the Data warehouse is not to replace the database. At present, most of the data warehouse is still using the relational database pipe
Management system. The main difference between a data warehouse and a database is that:
(1) database is a transaction-oriented design, the Data Warehouse is subject-oriented design.
(2) database is generally stored online transaction data, Data Warehouse storage is generally historical data.
(3) database design is to avoid redundancy as far as possible, data warehouse design is intended to introduce redundancy.
(4) The database is designed for capturing data, and the Data Warehouse is designed to analyze the data.

The difference between a data warehouse and a database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.