Students will study the solutions adopted in the physical design of databases, with a particular focus on the technologies for crash recovery, for concurrency control, for distributed transaction management and for efficient execution of queries. Moreover, students will be introduced to the architectures for data analysis and data mining and to the design of information systems in a web environment.
More information is available on the course home page.
Introduction to the technologies used in physical design of databases. Data allocation and data structures adopted in DBMS. Common indexes and indexes for special application domains. Concurrency control. Disaster recovery. Query optimization. Distributed transaction management.
OLAP systems. The OLAP multi-dimensional model and its logical implementation. Introduction to data mining. Examples of the technologies and the applications faced in data mining.
The typical architecture of a web information system. Examples of the technologies exploited to access a DBMS from a web application.
Active databases and related SQL extensions.
Il materiale usato dal docente a lezione copre tutti gli argomenti sviluppati nel corso ed è disponibile sull’home page del corso. Una lista dei testi consigliati per eventuali approfondimenti è inclusa all’interno di tale materiale.
The course slides, which are available on the course web page, discuss all the topics presented in the course. A list of the suggested books is available inside the slides.
Dipartimento di Ingegneria dell'Informazione e Scienze Matematiche - Via Roma, 56 53100 SIENA - Italy