M1 DMKM – Complex data warehouses

Department of Computer Science and Statistics, ICOM, Université Lumière Lyon 2
Year 2014-2015

Instructors

• Fadila Bentayeb (coordinator)
• Jérôme Darmont

Objectives

• Be able to apply all steps of the data warehousing process: multidimensional modeling, Extract-Transform-Load (ETL), On-Line Analysis Process (OLAP)
• Experiment with performance enhancing data structures (indexes, materialized views…)
• Test alternative physical models such as object-oriented and XML data warehouses

Prerequisites

• Knowledge of database design
• Practice of database management systems
• Mastery of SQL
• Basics in object-oriented analysis (UML) and programming

Outline

1. Introduction to Business Intelligence (FB)
2. Data warehouse design and ETL (Extract, Transform, Load) process (FB)
3. OLAP approaches and operators (FB)
4. Performance tuning (FB)
5. Complex data warehouses (JD)
6. ETL & OLAP tools (FB)

Assessment

• Final exam (60%)
• Case study (40%)

Organization

Fused lectures, labwork & tutoring (42h)

My sessions:

1. March 6, 9:30am-12:30pm, room K199
2. April 24, 10am-1pm, room K199
3. May 7, 1pm-4pm, room K199
4. May 15, 10am-1pm, room K199
5. May 22, 10am-1pm, room K199

On-line material

• Slides of Part 5 – JD (978 Ko)
• PL/SQL course
• 2014 exam exercise with solution (34 Ko)
• Labwork #1 text and solution (Star object datamart) (34 Ko)
• Labwork #2 text and solution (Snowflake object datamart) (32 Ko)
• 2015 exam exercise with solution (23 Ko)

Bibliography / Webography

• W.H. Inmon, Building the Data Warehouse (Fourth Edition), Wiley, 2004
• R. Kimball and M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition), Wiley, 2002
• R. Kimball and J. Caserta, The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming and Delivering Data, Wiley, 2004
• E. Thomsen, OLAP Solutions: Building Multidimensional Information Systems (Second Edition), Wiley, 2002
• K. Rudin, C. Buss, and W.H. Inmon, Data Warehouse Performance, Wiley, 1998
• J. Darmont and O. Boussaïd (Eds.), Processing and Managing Complex Data for Decision Support, IGI, 2006
• D. Lemire, Data Warehousing and OLAP: A Research-Oriented Bibliography
• SQL Language Reference, Oracle
• PL/SQL Language Reference, Oracle

Other online resources

• SQL Developer (free Oracle client) – Connection information:
  • Connection name: your choice
  • User name: your login (the one you use in class)
  • Password: your password (still the one you use in class)
  • Host: disora.univ-lyon2.fr
  • Port: 1522
  • SID: bd10