The student who completes the course successfully will be able to demonstrate a solid knowledge of advanced techniques for designing database management systems and software systems.Moreover, the student is expected to acquire knowledge on reliability engineering and quantitative evaluation of dependability. Finally he/she will be able to perform, working in group, a software project and produce all necessary documentation.
In the written exam (2 hours), the student must demonstrate his/her knowledge of the course material and to organise an effective and correctly written reply. During the oral exam the student must be able to demonstrate his/her knowledge of the course material and be able to discuss the reading matter thoughtfully and with propriety of expression. Through the project the student must demonstrate the ability to put into practice and to execute, with critical awareness, the activities illustrated or carried out under the guidance of the teacher during the course.
Conceptual and logical design of relational databases. SQL language. UML concepts and techniques.
Delivery: face to face
This course is organized in two sections addressing different issues in the design of software systems.
The first section covers (i) advanced databases management systems topics: data storage, data indexing and query planning, transaction management, data warehouse and data analytics. (ii) topics in reliability engineering: fundamentals of Faults, Errors, Failures; Fault tolerace techniques; Stable storage implementation; Recovery System; Reliability and Availability measures.
The second section addresses software system development issues: all phases of the software life cycle are crossed. The development process management and planning is illustrated and accompanied by related supporting tools; also the international quality standards for these phases are presented and the maturity models.
"Database Systems Concepts", Silberschatz, Korth and Sudarshan, McGraw Hill
"Basic Concepts and Taxonomy of Dependable and Secure Computing", IEEE Trans. on DEpendable and Secure Computing, vol. 1, n. 1, 2004
C. Bernardeschi, slides at http://www.iet.unipi.it/c.bernardeschi/SistemiInformativi.html
"Software Engineering" Ian Sommerville, Addison-Wesley; 9 Har/Psc edizione
G.Vaglini, slides at http://elearn.ing.unipi.it/course/view.php?id=1202
Attendance is not mandatory but highly recommended.