Dr. Patrick Marcel

Data warehouse and OLAP (M2)

schedule.

As of Sept. 2009, I share this module with Veronika Peralta. Below are the notes I used before Sept. 2009 and most of this material will also be used after Sept. 2009. I am translating these notes from french into english. Please do not hesitate to contact me if you detect typos.

• warehousing 1: introduction, data integration, modeling
• warehousing 2: architecure, ETL, refreshing, warehousing projects
• olap 1: datacube manipulations
• olap 2: query processing
• olap 3: models and query languages
• conceptual design (by Veronika Peralta)
• An overview of the researches led in Blois:
  • computing appropriate representations
  • OLAP query personnalization
  • recommending multidimensional queries
  • Query recommendations for OLAP discovery driven analysis
  • using design guidelines to improve DW logical design

assignment

Links you may find useful :

• benchmark APB-1
• benchmark TPC-DS
• ETL open source Talend
• open source OLAP server Mondrian, and the ppt of a talk given by Julian Hyde (founder of the mondrian engine)
• A survey on Open Source tools for BI
• the article MDX allows complex multidimensional queries
• the article An Overview of Data Warehousing and OLAP Technology
• bibliographie DW et OLAP
• more info on my research page