tag:blogger.com,1999:blog-4343577048896213264.post4948982619244410515..comments2023-05-02T06:28:50.632-05:00Comments on Call IT Anything: Data Warehouse Data Modeling For CIOsDale Sandershttp://www.blogger.com/profile/04982909782090993322noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4343577048896213264.post-17546771950968642422011-09-11T13:50:49.204-05:002011-09-11T13:50:49.204-05:00Good article. We use a flat data model for most da...Good article. We use a flat data model for most data, and don't use cubes. The flat data model retains all the original data detail, so more flexibility is allowed and storage requirements are small. <br /><br />We go a step further and don't use SQL at all. In our experience, SQL is well suited for updating data, but poorly suited for analysis. We use a separate data base engine that we Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4343577048896213264.post-34938755858895627872011-09-10T22:44:21.766-05:002011-09-10T22:44:21.766-05:00I could have really used this a year ago! : )
Wha...I could have really used this a year ago! : )<br /><br />What are you thoughts on the architecture from the book "The Corporate Information Factory"?<br />1) Central Data Warehouse aggregates data from source applications in third normal form.<br />2) Information then flows into subject area specific data marts in star schema form to support easy drilling and reports.Glen McCallumhttp://glenmccallum.comnoreply@blogger.com