Topic 2. Data Warehousing and Decision Support
Back to ModuleGroupDataManagement > DMModuleProgramOverviewHS0910 > DMLectureDW01, DMLectureDW02, DMLectureDW03.
- 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
- 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.