DATABASES
BASI DI DATI
Databases
Informatica Applicata
| A.Y. | Credits |
|---|---|
| 2014/2015 | 12 |
| Lecturer | Office hours for students | |
|---|---|---|
| Maurizio Maffi | Tuesday morning on appointment. |
Assigned to the Degree Course
| Date | Time | Classroom / Location |
|---|
Learning Objectives
The objective of this course is to introduce information systems and to describe the data models and techniques of conceptual design, logical and physical development and management of databases.
Program
01. Introduction to Information Systems:
01.01 Knowledge management and information systems.
01.02 Data Base Management Systems (DBMS).
01.03 Life cycle of DBMS.
02. Conceptual design of databases:
02.01 Analysis of the requirements.
02.02 Model Entity-Relationship (E-R).
02.03 Strategies project.
02.04 Integration of diagrams.
03. Logical design of databases:
03.01 Relational model.
03.02 Optimization of E-R models.
03.03 Restoration of E-R models.
03.04 From R-E model to the relational model.
03.05 Normalization.
04. Query languages:
04.01 Relational algebra: basic operators.
04.02 Relational algebra: auxiliary operators.
04.03 Relational Calculus.
04.04 Structured Query Language (SQL).
04.05 Subqueries in SQL.
04.06 Language Data Definition in SQL.
04.07 Language of updating data in SQL.
04.08 Views in SQL.
05. Secondary storage devices and file management:
05.01 Secondary Storage Devices and buffer management.
05.02 Organization of the files.
05.03 Indexing.
05.04 B-tree.
05.05 B +-tree.
05.06 Organizations static hash.
05.07 Organization Dynamic hash.
06. Architecture of DBMS:
06.01 Transactions and anatomy of the DBMS.
06.02 Management of failures and recovery techniques.
06.03 Management of the scheduling.
06.04 Theory of serializability.
06.05 Serializability and competition.
06.06 Locking techniques.
06.07 Database and distributed transactions.
06.08 Object-oriented, multimedia and NoSQL databases.
06.09 XML databases.
06.10 Methods of joins.
06.11 Optimization of queries.
07. Laboratory activities:
07.01 Introduction to MySQL on the Linux operating system.
07.02 Architecture of the MySQL server and client.
07.03 Development MySQL database driven.
07.04 Access to MySQL database using PHP.
Bridging Courses
Although there are no mandatory prerequisites for this exam, students are strongly recommended to take it after Algorithms and Data Structures, Computer Architecture, Procedural and Logic Programming.
It is also worth noticing that the topics covered by this course will be used in Integrated Geographical Databases.
Teaching, Attendance, Course Books and Assessment
- Teaching
Theory lectures and laboratory exercises, both face-to face and on-line.
- Attendance
Although recommended, course attendance is not mandatory.
- Course books
Per la teoria:
- Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi e Riccardo Torlone: "Basi di dati 4/ed", McGraw-Hill, 2014
(copre le sezioni 01, 02, 03, 04, 05 e 06 del programma)
- Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi e Riccardo Torlone: "Basi di dati - Modelli e linguaggi di interrogazione 4/ed", McGraw-Hill, 2013
(copre le sezioni 01, 02, 03, 04 del programma)
Per le esercitazioni:
- Dorbolò, Guidi, "Guida a SQL 2/ed", McGraw-Hill, 2004.
- MySQL Reference Manual.
- Assessment
Individual laboratory project, written exam and (optional) oral exam.
- Disabilità e DSA
Le studentesse e gli studenti che hanno registrato la certificazione di disabilità o la certificazione di DSA presso l'Ufficio Inclusione e diritto allo studio, possono chiedere di utilizzare le mappe concettuali (per parole chiave) durante la prova di esame.
A tal fine, è necessario inviare le mappe, due settimane prima dell’appello di esame, alla o al docente del corso, che ne verificherà la coerenza con le indicazioni delle linee guida di ateneo e potrà chiederne la modifica.
Notes
The course is offered both face-to-face and on-line within the Laurea Degree Program in Applied Computer Science.
| « back | Last update: 08/08/2014 |
