Traditional Culture Encyclopedia - Traditional culture - Why Data Warehouses Cannot Replace Databases and Become "Business Data Warehouses
Why Data Warehouses Cannot Replace Databases and Become "Business Data Warehouses
In short, databases are designed to be transaction-oriented and data warehouses are designed to be subject-oriented.
Databases generally store online transaction data, while data warehouses generally store historical data.
Databases are designed to avoid redundancy as much as possible and are generally designed using paradigm-compliant rules, and data warehouses are designed to intentionally introduce redundancy and are designed in an anti-paradigm way.
Databases are designed to capture data, data warehouses are designed to analyze data, and its two basic elements are dimension tables and fact tables. Dimension is the perspective of the problem, such as time, department, the dimension table puts the definition of these things, the fact table puts the data to be queried, along with the ID of the dimension.
- Related articles
- What traditional cultural knowledge have foreign classic traditional literary works learned?
- Psp button doesn't work. Can I use other handles instead?
- Is Confucian Ritualism a Family World Culture
- Is it necessary to learn traditional culture in kindergarten?
- For a girl, how to wear a fisherman's hat to look the best?
- How to eat glutinous rice well in Ciba?
- How to eat crispy oyster rolls and how to make crispy oyster rolls and ingredients.
- The Influence of China Tradition on Xiao Hong
- How to steam steamed bread with old noodles
- What's delicious on the solstice in winter?