INFORMATION SYSTEMS
Academic year and teacher
If you can't find the course description that you're looking for in the above list,
please see the following instructions >>
- Versione italiana
- Academic year
- 2015/2016
- Teacher
- FABRIZIO RIGUZZI
- Credits
- 6
- Didactic period
- Primo Semestre
- SSD
- ING-INF/05
Training objectives
- The main goal of the course consists in enabling the students to perform the physical design of relational database and to develop complex applications that interface to a database. Moreover, the course will illustrate the basic principles of big data.
The main acquired knowledge are relative to:
Data Base Management Systems (DBMS) technologies,
query elaboration,
transaction management,
physical organization of the SQL Server, Oracle and DB2 DBMS,
datawarehouse technologies.
The basic acquired abilities (that are the capacity of applying the acquired knowledge) are:
physical design of a database,
development of complex applications that interface with a database,
logical design of a datawarehouse. Prerequisites
- The following concepts and knowledge provided by the courses "Basi di Dati" and "Fondamenti di Informatica" are mandatory:
relational data model,
SQL data manipulation and query language,
procedural programming languages (Java, C). Course programme
- The course is composed of 48 hours of teaching partly in the classroom and partly in the laboratory.
Introduction to the main DBMS (4 hours): SQL Server, Oracle, DB2.
SQL in programming languages (16 hours): Persistent Stored Modules, JDBC, Object-relational mappings, ADO.NET, constraints and triggers.
DBMS technologies (12 hours): hardware, records in blocks, storage manager, indexes, hashing, physical organization in SQL Server, external sort, query elaboration, query optimization.
Physical design (4 hours): physical design in SQL Server, Oracle, DB2.
Transaction management (6 hours).
Datawarehouse and OLAP (6 hours). Didactic methods
- The course is divided into 48 hours of lectures partly in the classroom and partly in the computer laboratory.
The lectures will cover all the course topics and will include also guided exercises on the computer regarding SQL in programming languages. Learning assessment procedures
- The aim of the exam is to verify at which level the learning objectives previously described have been achieved.
The examination is composed of a written test, a test on theory and a project.
The written test consists of four exercises: one on recovery, one on transaction scheduling, one on indexes and one on computing the cost of a query. The test lasts two hours. It is worth 16 points. The use of any personal PC or smart phone is not allowed. The use of teaching material is allowed.
The test on theory consists of three questions on the theoretical topics of the course. It is worth 9 points. The use of any personal PC or smart phone is not allowed. The use of teaching material is not allowed.
The project consists in developing an application that connects to a database. The application can be written in any programming language. The database must contain at least 5 tables. The DBMS must be SQL Server, Oracle or DB2. It is worth 7 points.
The final mark is given by the sum of the marks in the three parts. The exam is passed if the mark in the written test is at least 9 and the sum of the marks of the project and the test on theory is at least 9.
The three parts can be taken in different exam dates. Reference texts
- Teacher's handouts.
Fabrizio Riguzzi, Arianna Fabbri, and Elena Zuffi. Sistemi informativi. Collana Progetto Leonardo. Esculapio, Bologna, Italia, novembre 2011, isbn 978-88-7488-472-8.
