Traditional Culture Encyclopedia - Traditional festivals - What kind of important role does data warehouse play in the trend of database technology development?
What kind of important role does data warehouse play in the trend of database technology development?
Database storage of data is a two-dimensional storage logic, if you want to locate a data, through several tables to jointly query, you need to traverse the tables involved, inefficient.
And the data warehouse with block logic for storage, through several logical tables to query the fact table, at the same time to locate, directly fetch the number, the speed of several orders of magnitude.
And the data warehouse divides the data according to dimension tables and fact tables, which is more conducive to doing OLAP analysis, provides more imagination for data visualization, and provides decision support for policy makers and leaders.
- Previous article:Spring Festival customs in Australia and America.
- Next article:Dragon Boat Festival rope called what
- Related articles
- What is the origin of traditional culture in life?
- How about Jining?
- Is sea power a basic strategic theory?
- Is it okay to put potatoes in an airtight bucket
- How to drive the enthusiasm of the staff?
- Simple handmade lantern tutorial
- 7 poems about spring (500 words)
- Modern industrial system in the revitalization and development plan of the former central Soviet area in Jiangxi, Fujian and Guangdong
- What is the development prospect of physical stores?
- What is the beauty of China's poems?