Ateneo - UPO

Data base: main data models used by data base systems (DBMS). Relational model: main theoretical aspects and practical design principles. Introduction to the SQL language and its applications for database management.
Data warehouse: methods and techniques to gather, analyse, summarize and re-organize operational data to support strategic decision-making.
No-SQL: the characteristics and query methods of the main types of no-SQL databases, the criteria for choosing between the different types of no-SQL databases

Atzeni, Ceri, Fraternali, Paraboschi, Torlone Basi di Dati: Modelli e Linguaggi di Interrogazione Mc Graw-Hill, quinta edizione, 2018
M. Golfarelli, S. Rizzi: “Data Warehose”, McGraw-Hill, Milano
A. Ploetz, D. Kandhare, S. Kadambi, X. Wu, Seven NoSQL Databases in a Week, Packt Publishing Limited, 2018

Knowledge and understanding:
- methodologies of analysis and organization of relational structures, implementation of these structures in relational databases, including with the necessary queries
- methodologies for retrieving, analyzing, synthesizing and re-organizing operational data; design methodologies for the conceptual level and for the logical level in the field of relational datawarehousing
- design methodologies for the conceptual level and for the logical level in the noSQL context
Applying knowledge and understanding:
- ability to design both at a conceptual level and to a logical level, and to query in the context of relational databases
- ability to design at a conceptual level and to create a logical level in the context of relational datawarehousing, starting from operational data sources
- ability to design at a conceptual level and at a logical level in the context of different noSQL databases
Making judgements:
- ability in the conceptual and logical design of a relational database and in its interrogation
- ability to determine the facts of interest, granularity, dimensions and dimensional hierarchies for a data warehouse
- ability to evaluate the specific characteristics of a noSQL database focusing on the application context
Communication skills:
Students must acquire and know how to use the terminology of the area and must be able to discuss aspects of design, modeling and queries in the different database fields.
Learning skill
- analyzing, modeling and querying data in the context of relational databases
- analyzing and modeling data from heterogeneous sources
- analyzing data to model them in the noSQL environment by making the most suitable design choices

None.

Face-to-face lectures and exercises in classroom and in computer science lab. Teaching materials will also be provided through the DIR platform.

Students with physical disabilities, Learning Disabilities or Special Education Needs can request specific services and tools via the Staff Sviluppo e Coordinamento Carriere e Servizi alle Studentesse e agli Studenti, consulting the University webpage:

https://www.uniupo.it/en/services/services-students-physical-or-learning-disabilities

Students with disabilities, learning disabilities or special education needs, once they have contacted the University Staff, can refer to the tutor in charge of the course to define the examination modalities, concerning academic aspects.

Written examination (2 hours). The exam is composed by 3 parts, each of which on a different section of the course (data base, data warehouse and no-SQL). Each part can in turn be composed by theoretical questions and exercises to be solved.
Passing requires to correctly complete a minimum of 2 sections.

Databases: introduction to the main database management systems (DBMS). The relational model is studied in depth, in particular the main theoretical aspects and more practical aspects are presented with design examples, paying attention to the quality of the implemented models (e.g. normal forms). The course is divided into the following parts: Relational Model; Entity-Relationship Model; Translation of the ER Model into Relational Model. The architecture of a DBMS is also briefly described, following the general description scheme with three levels of abstraction: external, logical and physical. The basics of indexes and transactions are introduced. Introduction to the SQL language for table management and data manipulation.
Data warehouse: objectives and architectures; techniques to find and reconcile operational data; OLAP query languages; models and techniques for the implementation of the conceptual multidimensional data model in the relational field.
No-SQL: main No-SQL approach (key-value, column, document e graph): characteristics, , query languages, and performance evaluation criteria.

Students must have acquired the following knowledge, skills, and abilities:
- knowledge of the methodological and formal tools for designing the logical and physical structures of a relational database
- knowledge and use of the SQL language
- knowledge of techniques for retrieving and reconciling operational data
- general knowledge of OLAP query languages and
- knowledge of model and technique management skills for the implementation of the conceptual multidimensional data model in the relational field
- knowledge of the founding principles of NoSQL databases.
- knowledge of NoSQL design principles and ability to evaluate design choices.

The students have to be able to demonstrate the ability and skills:
- to designing a relational database
- to use SQL language
- to formulate OLAP queries
-to design and to retrieve information in NO-SQL databases