80 likes | 156 Views
Chapters 4~8. The TWO. Multi-dimensional model What we meant mostly when referring a cube or a data warehouse Tabular model Not common, possible term project. The Three. ROLAP, MOLAP, and HOLAP
E N D
The TWO • Multi-dimensional model • What we meant mostly when referring a cube or a data warehouse • Tabular model • Not common, possible term project
The Three • ROLAP, MOLAP, and HOLAP • ROLAP – relational DB with aggregates, possibly pre-calculated, if not could be slow, if yes, could be too many • MOLAP, generally what we meant by a CUBE • H = R + M • This is very old, in my opinion, concept no one really give much of a consideration
Misc • Data Source Views – chapter 9 • Proactive caching – a fancy name for preprocessed/pre-calculated aggregates • XML definitions • Every object in a cube is defined following the XML format – not really new
Chapter 5 • SSDT (SQL Server Data Tool), used to be the BI development studio, is really the Visual Studio 2010 • Give a demo – end of the story
Chapter 6 • Data Mart – a database with a lot of tables • Known concepts • Dimension • Measure • Star schema • Snowflakes • Follow the steps from 118 to 129 • The use of Cube Wizard (page 120 ~121) could be useful • Do NOT compress your tables
Chapter 7 • Very important • Very useful • Excellent candidate for a term project
Chapter 8 • See the discussions for Chapter 7 • We will go over Chapters 9 and 10 in more detailed discussions than Chapter 8 .