| | | corso | | | |
Decision support databases
Codice: | 662AA | Crediti: | 6 | Semestre: | 1 | Sigla: | DSD | |
|
Settore disciplinare: | INF/01 - Informatica |
Docente
Salvatore Ruggieri
Tel. 0502212782Ultima versione disponibile: programma da confermare per l’a.a. 2017/2018
Obiettivi di apprendimento
The course presents the main approaches to the design and implementation of decision support databases, and the characteristics of business intelligence tools and computer based information systems used to produce summary information to facilitate appropriate decision-making processes and make them more quick and objectives. Particular attention will be paid to themes such as conceptual and logical Data Warehouses design, data analysis using analytic SQL, algorithms for selecting materialized views, data warehouse systems technology (indexes, star query optimization, physical design, query rewrite methods to use materialized views). A part of the course will be dedicated to a set of case studies.
Programma
- Information systems and computer-based information systems in organizations.
- Decision Support System Based on Data Warehouses.
- Data Models for Data Warehouses and On-line Analytical Processing.
- Conceptual and logical design in Data Warehouses.
- Algorithms for Selecting Materialized Views.
- Data Warehouse Systems Technology: Indexes, Star Query Optimization,
- Physical Design, Query Rewrite Methods to Use Materialized Views.
- Case studies.