数据库与数据仓库的区别（The difference between a database and a data warehouse）.doc

数据库与数据仓库的区别（The difference between a database and a data warehouse） The difference between a database and a data warehouse In short, databases are transaction oriented design, and data warehouses are subject oriented. The database generally stores online transaction data, and the data warehouse usually stores historical data. Database design is to avoid redundancy as far as possible. Generally, the rules are designed according to the rules of the paradigm. The design of data warehouse is designed to introduce redundancy and adopt reverse paradigm to design. A database is designed to capture data. A data warehouse is designed to analyze data. Its two basic elements are the dimension table and the fact table. Dimension is the angle of view, for example, time, Department, dimension table is the definition of these things, in fact, there are data to query, and at the same time there is dimension of ID. Conceptually, there is some obscurity. Any technology is for application services, and it can be easily understood in conjunction with applications. Take banking as an example. The database is the data platform of the transaction system, and every transaction that the customer does in the bank will be written into the database and recorded. Here, it can be simply understood as accounting with the database. Data warehouse is the data platform of the analysis system. It acquires data from the transaction system, and summarizes and processes the data. It provides the decision makers with the basis for decision making. For example, how many transactions are there in a month in a branch of a bank, and what is the current deposit balance of the branch?. If there are too many deposits and many consumer transactions, it is necessary for the region to set up ATM. Obviously, the amount of business in a bank is huge, usually calculated in millions or even tens of millions. The transaction system is real-time, which requires timeliness. It takes a few seconds for customers to deposit