Article From:https://www.cnblogs.com/weiying121/p/9033721.html

 1、Topic oriented.

\n

Data in data warehouse is organized according to a certain topic domain.

\n

A topic is an abstract concept, which refers to the key aspects of the user\’s use of a data warehouse to make decisions, and a topic is usually related to multiple operating information systems. The data organization of an operational database is oriented to transaction processing tasks, and each business system is separated from each other.

\n

2、Integrated.

\n

Data warehouse data are processed, collected and collated on the basis of the original data extraction and cleaning of the original data. It is necessary to eliminate the inconsistency in the source data so as to ensure that the information in the data warehouse is a consistent global message about the whole enterprise. Transaction oriented operating databaseUsually related to some specific applications, databases are independent and heterogeneous.

\n

3、Relatively stable.

\n

Data warehouse data are mainly used for enterprise decision analysis. The data operation involved is mainly data query. Once a certain data enters the data warehouse, it will be kept in general for a long time, that is, there is a large number of query operations in the data warehouse, but the modification and deletion operations are very few, usually only need to be fixed regularly.Load and refresh. The data in the operational database is usually updated in real time, and the data change in time.

\n

 

\n

 4、Reflect historical changes.

\n

The data in the data warehouse usually contains historical information. The system records the information of the enterprise from the point of the past time point (such as the point of applying the data warehouse) to the current phases. Through this information, it can make a quantitative analysis and prediction of the development and future trend of the enterprise. The main concern of the operating databaseData within a current period of time.

Leave a Reply

Your email address will not be published. Required fields are marked *