This course introduces the concepts of database technology used in Business Intelligence. More precisely, this includes multidimensional databases and data warehouses, as well as ETL processes. Necessary techniques will be presented for designing, implementing, exploiting, and maintaining data warehouses.
A particular focus will be given on the problems posed by heterogeneous data integration and data quality. The students will learn how to define, measure and maintain data quality in the context of data warehousing. Classical notions of data warehousing and OLAP are developed: ETL, architecture, conceptual and logical design, query processing and optimization. At the end of this course, the student will know how to efficiently design, construct and query a data warehouse.
Person in charge
Alberto Abello Gamazo (
Petar Jovanovic (
Technical Competences of each Specialization
CEE5.1 - Capability to participate in improvement projects or to create service systems, providing in particular: a) innovation and research proposals based on new uses and developments of information technologies, b) application of the most appropriate software engineering and databases principles when developing information systems, c) definition, installation and management of infrastructure / platform necessary for the efficient running of service systems.
CEE5.3 - Capability to work in interdisciplinary engineering services teams and, provided the necessary domain experience, capability to work autonomously in specific service systems.
CEC2 - Capacity for mathematical modelling, calculation and experimental design in engineering technology centres and business, particularly in research and innovation in all areas of Computer Science.
Generic Technical Competences
CG3 - Capacity for mathematical modeling, calculation and experimental designing in technology and companies engineering centers, particularly in research and innovation in all areas of Computer Science.
CTR3 - Capacity of being able to work as a team member, either as a regular member or performing directive activities, in order to help the development of projects in a pragmatic manner and with sense of responsibility; capability to take into account the available resources.
CB7 - Ability to integrate knowledges and handle the complexity of making judgments based on information which, being incomplete or limited, includes considerations on social and ethical responsibilities linked to the application of their knowledge and judgments.
CB9 - Possession of the learning skills that enable the students to continue studying in a way that will be mainly self-directed or autonomous.
Database physical desing for analytical queries
Star-join and join indexes; Bitmaps; Materialized views; Spatio-temporal data
Extraction, Transformation and Load
Data quality; Integration; ETL management
In these activities, the lecturer will introduce the main theoretical concepts of the subject. Besides lecturing, cooperative learning techniques will be used. These demand the active participation of the students, and consequently will be evaluated. Objectives:123 Contents:
Theory: The theory lectures comprise the teacher's explanations and problem solving. The students will also have some contents to be read and prepared outside the classroom.
Laboratory: Mainly, the lab sessions will be dedicated to the practice (with and without computer) of the concepts introduced in the theory lectures, by means of exercises that will be done during the class time. Some tools will be used for the design and practice on a specific DBMS or tool (e.g., Oracle). There will be three project deliverables that will be done outside the class.
Specifically, it will be assumed knowledge on:
- UML class diagrams
- Relational algebra
- SQL queries
- Relational views
- B-tree operations (i.e., insertion and splits)
- Basic concepts on physical query optimization
El contingut de l'assignatura no canviarà.
The content of the subject will not change.
Es modificaran les classes magistrals per classes invertides (flipped classroom) en que l'estudiant haurà d'estudiar materials (texts i videos) de forma independent abans de la sessió corresponent, que es dedicarà a la realitazió d'exercicis i discussió/resolució de dubtes.
Lectures will be transformed into flipped classrooms, where the student goes through materials (texts and videos) autonomously before the corresponding sessions, which will be devoted to exercises and discussion, as well as solving doubts.
El métode d'avaluació no canviarà.
Evaluation method will not change.
La realització d'exercicis, discussions i resolució de dubtes es farà de forma remota.
Exercises, discussions and doubt resolution will be moved to remote.
Where we are
B6 Building Campus Nord
C/Jordi Girona Salgado,1-3
08034 BARCELONA Spain
Tel: (+34) 93 401 70 00