Data Warehousing

• Database Systems.
• Entity relationship model 
• SQL

Exposition of the theoretical foundations underlying the Data Warehousing technology.
Resolution of practical problems of analysis and multi-dimensional conception.
Project and Implementation of a Data Warehouse (DW), using a tutorial approach, encompassing all steps, from analysis to optimization of the ETL and DW
Monitoring the implementation, in a group, of the practical design and implementation of DW 

When the students complete the course successfully, they should be able to
– Develop knowledge and comprehension skills in the area of Data Warehousing, relying on exposition in the classroom for teaching and research, in the texts performed by students and guided by the teacher.
– Analyze, design, build and administer a data warehouse.
– Develop the ability to apply the knowledge acquired in solving specific problems of life.
– To instil a professional attitude in developing their tasks by knowledge acquired and the ability to understand the scope, applicability and opportunity in specific situations of everyday life.

1. Introduction and Concepts of Data Warehousing
2. Data Warehouse Architecture
3. Multidimensional Analysis and Star Schema
4. Project of Data Warehouses
5. Extraction, Transformation and Loading (ETL)
6. Aggregates and Performance in Data Warehousing

NAO

Bibliography available in the library:

• Ralph Kimball, Margy Ross (2002); The data warehouse toolkit : the complete guide to dimensional modeling; Ed. John Wiley & Sons Inc; ISBN 0-471-20024-7; 1A-5-110 (ISEC) – 12058
• Paulraj Ponniah (2010); Data Warehousing – Fundamentals for IT Professionals, Ed. John Wiley & Sons, Inc; ISBN 978-0-470-46207-2 ; 1A-5-155 (ISEC) – 16034
• Robert Stackowiak, Joseph Rayman, Rick Greenwald(2007), Oracle data warehousing and business intelligence solutions, Ed. John Wiley & Sons, Inc, 2007; ISBN 0-471-91921-7, 1A-5-146 (ISEC) – 14236
• Matthias Jarke et al(2003), Fundamentals of Data Warehouses, 2nd edition, Springer-Verlag; ISBN 3-540-42089-4 ; 1A-5-117 (ISEC) – 12647
• Matteo Golfarelli and Stefano Rizzi (2009); Data warehouse design : modern principles and methodologies, , McGraw-Hill, 2009; ISBN 978-0-07-161039-1; 1A-5-158 (ISEC) – 16129
• Ralph Kimball, Laura Reeves, Margy Ross, Warren Thornthwaite (1998);The Data Warehouse Lifecycle Toolkit Ed. John Wiley & Sons, Inc; ISBN 0-471-25547-5; 1A-5-91 (ISEC) – 10924
• Richard Kachur(2000); Data Warehouse Management Handbook, Prentice Hall; ISBN 0-13-083346-0; 1A-5-93 (ISEC) – 10993
• Christopher Adamson (2006); Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance, Wiley Publishing; ISBN 0-471-77709-9; 1A-5-143 (ISEC) – 13830

Additional Bibliography : 

• Costa, João (2023), Apontamentos de Data Warehousing,  http://moodle.isec.pt