Topic 2. Data Warehousing and Decision Support

Back to ModuleGroupDataManagement > DMModuleProgramOverviewHS0910 > DMLectureDW01, DMLectureDW02, DMLectureDW03.

Detailed Content ^

• Star Schema, Snowflake Schema
• Extraction, Transformation, Loading
• DWH Maintenance
• OLAP, incl. Implementation; relational and multidimensional storage; Cubes; Analytical Tools of MS are good for demonstration
• View Materialization

Issues not covered by this topic: ^

• ...

Comments: ^

• Which software to use (if any)? MS SqlServer comes with Tools for the ETL-Process and Analysis (OLAP), good for demonstration. I had a diploma-thesis on this subject with this software for a hospital (Thomas Olnhoff)
• Pls. add some more details here.