DIPARTIMENTO DI INGEGNERIA DELL'INFORMAZIONE
E SCIENZE MATEMATICHE

UNIVERSITA' DEGLI STUDI DI SIENA
 
Home
  Privacy e Cookie policy


Education

Insegnamento
Advanced database systems

 
a.a. 2013-2014
Corso Lm Computer and Automation Engineering [IS]
Anno 1
Semestre II
Obiettivi 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.
Ore 54
Crediti 6
Link corso http://www.dii.unisi.it/~franco/Teaching/teaching.php
Docente Franco Scarselli

Note
More information is available on the course home page.

Programma
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.

Testi consigliati
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