Engineering in Computer Science and Artificial Intelligence

General objectives: The goal of the course is the investigation on the basic concepts of Data Management systems, emphasizing both the relational model and various NoSQL models. Several major issues related to the theory and the design of relational data management systems are covered, including concurrency control, recovery, file and index organizations, query processing, OLAP and OLTP. A good knowledge of the fundamentals of Programming Structures, Programming Languages, and Databases (SQL, relational data model, Entity-Relationship data model, conceptual and logical database design) is required. Knowledge and understanding: The student will have a good knowledge on how a Data Management System, even a NoSL one, works, how it is structured, and how it is designed. Also, the student will acquire knowledge of the architecture of a database management system and of its main modules (transaction manager, recovery manager, query evaluator). The student will also acquire a good understanding of how to design the physical organization of relations (files and indices), and how the query optimizer of a Data Management system works. Applying knowledge and understanding: The students will be able to design her/his own Data Management system, including the concurrence control module, the recovery module, the access file method, and the query optimizer. Making judgements: The student will be able to evaluate various kinds of Data Management systems, including NoSQL ones, and will be able to choose the right technique for concurrency, recovery, and query processing in specific application contexts. Communication skills: The students will acquire a good knowledge on how to illustrate the algorithms and the techniques at the basis of a modern Data Manager. Learning skills: The student will be able to understand any new architecture and approach to Data Management that will become popular in the future.