发信人: 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-
: dimension and course dimension. that is your model.
※ 来源:·WWW 未名空间站 网址：mitbbs.com 移动：在应用商店搜索未名空间·[FROM: 152.]