ECTS - University of Pisa
| Modules | Area | Type | Hours | Teacher(s) | |
| BASI DI DATI II | INF/01 | LEZIONI | 72 |
|
Database systems occupy a central position in our information-based society, and computer scientist and database application designers should have a good knowledge about both the theoretical and the engineering concepts that underline these systems to ensure the application performance desired. The student who completes the course successfully will be able to demonstrate advanced knowledge of the main issues related to the implementation of classical centralized relational database systems in order to be a sophisticated user of database technology and a high-performance applications developer. The student will also learn about data models that are more general than the standard relational data model.
In the written exam, the student must demonstrate the use of knowledge of the course contents to solve problems. During the oral exam the student must be able to demonstrate knowledge of the course contents and be able to discuss the topics thoughtfully and with propriety of expression.
Methods:
The course requires good knowledge about programming, algorithms, computer architecture, mathematical logic, and databases.
Delivery: face to face
Learning activities:
Attendance: Strongly advised
Teaching methods:
The course first describes some advanced data models. The notion of semi-structured data is presented, together with some data models to deal with this kind of data. Specific attention is dedicated to the XQuery and XPath Data Model, and to the XQuery language. The RDF language and the OWL logic are presented as a notable example of a formalism to describe ontologies. Then, the course presents the main approaches to the implementation of centralized relational database systems. Particular attention will be paid to the fundamental concepts about relational database systems architecture, the main structures and algorithms to implement the modules for the management of permanent memory, the buffer, the storage structures, the access methods, the transactions and recovery, the concurrency, the cost-based query optimization. The final part of the course is dedicated to the approaches to physical database design and tuning to ensure the application performance desired.
A. Albano, Relational DBMS Internals, 2013. The textbook is available for free on the web. W3C reference manuals about XQuery, RDF and OWL.
Written, with intermediate tests, and oral.
