当前在线人数8352
首页 - 分类讨论区 - 电脑网络 - 数据库版 -阅读文章
未名交友
[更多]
[更多]
文章阅读:Re: 这有做data warehouse 或者 data architect 的吗?
[同主题阅读] [版面: 数据库] [作者:webbew] , 2017年02月06日16:58:29
webbew
进入未名形象秀
我的博客
[上篇] [下篇] [同主题上篇] [同主题下篇]

发信人: webbew (未必), 信区: Database
标  题: Re: 这有做data warehouse  或者 data architect 的吗?
发信站: BBS 未名空间站 (Mon Feb  6 16:58:29 2017, 美东)

This answer is right. ERD is for transactional or operational database. It's
normalized and optimized for insert and update. Data warehouse is for
analytics and reports. It's denormalized and optimized for select. It uses
dimensional models, such as star/snowflake schema.
【 在 peterw7788 (SmallStone) 的大作中提到: 】
: Using OLAP to create a data cube. implement star schema with registration
: table as fact table such as SFRSTCR. Then, join with student or student-
term
:  dimension and course dimension. that is your model.  



--
※ 来源:·WWW 未名空间站 网址:mitbbs.com 移动:在应用商店搜索未名空间·[FROM: 152.]

[上篇] [下篇] [同主题上篇] [同主题下篇]
[转寄] [转贴] [回信给作者] [修改文章] [删除文章] [同主题阅读] [从此处展开] [返回版面] [快速返回] [收藏] [举报]
 
回复文章
标题:
内 容:

未名交友
将您的链接放在这儿

友情链接


 

Site Map - Contact Us - Terms and Conditions - Privacy Policy

版权所有,未名空间(mitbbs.com),since 1996