当前位置:网站首页>[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:
边栏推荐
- 640. Solving Equations: Simple Simulation Problems
- 串口服务器调试助手使用教程,串口调试助手使用教程【操作方式】
- 司空见惯 - 股市狠狠下跌后,何時能反弹?
- Zhaoqi Technology Innovation High-level Talent Entrepreneurship Competition Platform
- Digital Collection Platform System Development Practice
- 池化技术有多牛?来,告诉你阿里的Druid为啥如此牛逼!
- 【语义分割】DeepLab系列
- TCP为什么是三次握手和四次挥手?
- 线上线下课程教学培训小程序开发制作功能介绍
- 小程序-语音播报功能
猜你喜欢
Azure IoT Partner Technology Empowerment Workshop: IoT Dev Hack
数学建模学习视频及资料集(2022.08.10)
易观分析联合中小银行联盟发布海南数字经济指数,敬请期待!
Appium进行APP自动化测试
BCG库简介
面试面到了一个腾讯30k出来的,有见识到何为精通MySQL调优
易基因|深度综述:m6A RNA甲基化在大脑发育和疾病中的表观转录调控作用
Meaning and names of 12 nautical miles, 24 nautical miles and 200 nautical miles
Flask框架——基于Celery的后台任务
win2012安装Oraclerac失败
随机推荐
“国资云”和“国家云”能给市场带来怎样的变革?
antd组件中a-modal设置固定高度,内容滚动显示
网络安全(加密技术、数字签名、证书)
Appium进行APP自动化测试
MQTT服务器搭建
【MindSpore易点通机器人-02】设计与技术选型
微信小程序,自定义输入框与导航胶囊对其
正则表达式(包含各种括号,echo,正则三剑客以及各种正则工具)
SWIG教程《二》
[Semantic Segmentation] DeepLab Series
基于ArcGIS水文分析、HEC-RAS模拟技术在洪水危险性及风险评估
TestLink导出用例转换工具
It is reported that the original Meitu executive joined Weilai mobile phone, the top product may exceed 7,000 yuan
Steam教育在新时代中综合学习论
sql语句 异常 Err] 1064 – You have an error in your SQL syntax; check the manual that corresponds to your
TCP为什么是三次握手和四次挥手?
使用mysq语句操作数据库
池化技术有多牛?来,告诉你阿里的Druid为啥如此牛逼!
systemui屏蔽通知栏
王学岗—————————哔哩哔哩直播-手写哔哩哔哩硬编码录屏推流(硬编)(26节课)