Â鶹Éç

Argomenc dl curs
- Physical data storage - Indexing and hashing - Query processing and optimization - Transaction processing - Concurrency control - Recovery

Modalité de ensegnament
The course includes frontal lectures, exercises, and lab exercises.

Obietifs formatifs
Knowledge and Understanding - D1.4 Understand the key principles, the structures and the organization of relational databases and methods for designing and developing databases. - D1.9 Know in detail the principles of relational database systems and methods for designing, developing and optimizing databases. Applying knowledge and understanding - D2.13 Be able to develop efficient and optimized applications based on relational databases Ability to make judgments - D3.1 Be able to collect and interpret useful data and to judge information systems and their applicability. - D3.2 Be able to work autonomously according to the own level of knowledge and understanding. Communication skills - D4.1 Be able to use one of the three languages English, Italian and German, and be able to use technical terms and communication appropriately. Learning skills - D5.1 Have developed learning capabilities to pursue further studies with a high degree of autonomy. - D5.3 Be able to follow the fast technological evolution and to learn cutting edge IT technologies and innovative aspects of last generation information systems.

Sort de ejam
The assessment for the course consists of a single written exam at the end of the term. The exam includes verification questions, transfer-of-knowledge questions, and exercises. Verification questions are used to assess learning outcomes related to knowledge and understanding, while transfer-of-knowledge questions and exercises evaluate the ability to apply that knowledge in practical contexts.

Criters de valutazion
The written exam counts 100% of the grade. The exam is evaluated according to the following criteria: clarity, completeness and correctness of answers.

Bibliografia obligatora

Abraham Silberschatz, Henry Korth, and S. Sudarshan. Database System Concepts. McGraw-Hill Science/Engineering/Math, Boston, 5th edition, May 2005. ISBN 978-0-07-295886-7. 

Bibliografia aconsieda

Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer D. Widom. Database Systems: The Complete Book. Pearson College Div, Upper Saddle River, N.J, 2th edition, 2008. ISBN 978-0-13-187325-4. 

Deplù informazions
- PostgreSQL (https://www.postgresql.org) - PgAdmin (https://www.pgadmin.org)