当前位置:网站首页>[Data warehouse design] Why should enterprise data warehouses be layered?(six benefits)
[Data warehouse design] Why should enterprise data warehouses be layered?(six benefits)
2022-08-10 15:06:00 【Qingpingle's technical column】
I. Should the data warehouse be layered?
Since the data warehouse is the place where data is stored and calculated, why do you need tiering?It is also the data scale, which is determined by the business scenario.It can be said that when the data warehouse construction of many companies is just starting, most of the data is subjected to rough data access. After ETL is performed, it is directly connected to the business, and reports are generated or imported into the business system for direct use.
Later, with the development of the company's business, the precipitation of data, and the development of the data warehouse to a certain stage, it was found that the use of data was disorganized and various businesses were directly calculated from the original data.This results in various repeated calculations (maybe the two tables are only a few fields apart, but everyone ran it once), which seriously wastes computing resources and storage resources, and costs enterprises a great deal.At this time, everyone has to think about how to standardize storage and computing, and how to minimize enterprise costs.In particular, companies with larger data scales have stronger demands.
Of course, your company's data scale is small, and it is not necessary to have no layering. Of course you can.There is no need to implement such norms. The disadvantage of norms is that they have to pay a lot of labor costs to implement norms and supervise the implementation of norms.The final choice should be considered in combination with the cost of your business, and everything should be based on reality.
Second, the benefits of data warehouse layering
1. Clear data structure:
Each data layer has its scope, so that we can more easily locate and understand when working with tables.
2. Data bloodline tracking:
In simple terms, it can be understood in this way. What we finally give to the business integrity is a business table that can be used directly, but there are many sources of it. If there is a problem with a source table, we hope to be able to quickly and accurately locate it.problem and understand the scope of its harm.
3. Reduce repetitive development:
边栏推荐
- 池化技术有多牛?来,告诉你阿里的Druid为啥如此牛逼!
- 正则表达式(包含各种括号,echo,正则三剑客以及各种正则工具)
- 程序员=加班??——掌握时间才能掌握人生
- TCP为什么是三次握手和四次挥手?
- Lilac Garden
- High-paid programmers & interview questions series 135 How do you understand distributed?Do you know CAP theory?
- Zhaoqi Technology Innovation High-level Talent Entrepreneurship Competition Platform
- 640. 求解方程 : 简单模拟题
- Zijin Example
- 物资采购小程序开发制作功能介绍
猜你喜欢
易观分析联合中小银行联盟发布海南数字经济指数,敬请期待!
MySQL 原理与优化:Update 优化
使用Uiautomator2进行APP自动化测试
机器学习总结(一)
Redis -- Nosql
学习MySQL 临时表
Analysys and the Alliance of Small and Medium Banks jointly released the Hainan Digital Economy Index, so stay tuned!
Azure IoT Partner Technology Empowerment Workshop: IoT Dev Hack
Do not access Object.prototype method ‘hasOwnProperty‘ from target object....
从洞察到决策,一文解读标签画像体系建设方法论
随机推荐
XML基本学习
Parallels 将扩展桌面平台产品,以进一步改善在 Mac 上运行 Windows 的用户体验和工作效率
MySQL Principle and Optimization: Update Optimization
Pytest framework optimization
网络初识(二)
DB2查询2个时间段之间的所有月份,DB2查询2个时间段之间的所有日期
MQTT服务器搭建
1004 (tree array + offline operation + discretization)
Appium for APP automation testing
Systemui status bar to add a new icon
@RequestBody的使用[通俗易懂]
Lilac Garden
Rich Dad Poor Dad Reading Notes
网络安全(加密技术、数字签名、证书)
Flask框架——MongoEngine使用MongoDB数据库
1004(树状数组+离线操作+离散化)
Websocket realizes real-time change of chart content
“国资云”和“国家云”能给市场带来怎样的变革?
奢侈品鉴定机构小程序开发制作功能介绍
王学岗————直播推流(软便)03x264集成与camera推流