Traditional Culture Encyclopedia - Traditional culture - What is the difference between cloud number warehouse and traditional data warehouse?

What is the difference between cloud number warehouse and traditional data warehouse?

1, the BI field focuses on statistical analysis, the traditional database focuses on online transactions. Statistical analysis of the amount of data are generally larger, focusing on the query, a query for large quantities of data, but traditional databases are generally designed to support online transactions, so the insertion of more updates, the query tends to be only based on the conditions of the query.

2, three-dimensional warehouse with the difference between ordinary warehouses: three-dimensional warehouse is generally higher. Its height is generally more than 5 meters, limited to 40 meters, common between 7-25 meters. Its also mechanized warehouse. Because the shelves in more than 5 meters, artificial has been bad on the shelves in and out of the goods operation, and therefore must rely on mechanical operation.

3, the database is transaction-oriented design, data warehouse is subject-oriented design. Databases generally store online transaction data, data warehouses store generally historical data. "Time-related": databases save information without emphasizing that there must be time information.

4, database refers to a collection of data, data warehouse is also a collection of data, big data is also a place to process and store data. But the difference lies in the application scenarios, and the technical principles of construction are not the same.

5, to solve the traditional number of warehouses from the current state of the number of warehouse construction, real-time number of warehouses is an easy to confuse the concept of the number of warehouses according to the traditional experience of the analysis, the number of warehouses have an important function, that is, to be able to record the history.