20810260 - Tecnologie e Architetture per la Gestione dei Dati

The goal of the course is to present models, methods and systems that play a fundamental role in database technology, together with discussions on the recent evolution of the technology itself. The directions of development to be considered include integration of heterogeneous and autonomous systems; databases for business intelligence and decision support. After taking the course, the student will know the major features of relational database technology, the methods for data integration, and for the design of data warehouses.

Curriculum

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, database performance analysis and modeling. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice) D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004 Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

In-person lectures and in-class practice (except for periods of sanitary emergency), with optional remote access through Microsoft Teams

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects. One of them will be evaluated towards the exam. All the others will not be evaluated, but they will be essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, data warehousing. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

Class lectures, class exercises, practical activities (projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Modalità Frequenza

Not compulsary

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects, which are not evaluated but they are essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, database performance analysis and modeling. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice) D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004 Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

In-person lectures and in-class practice (except for periods of sanitary emergency), with optional remote access through Microsoft Teams

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects. One of them will be evaluated towards the exam. All the others will not be evaluated, but they will be essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, data warehousing. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

Class lectures, class exercises, practical activities (projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Modalità Frequenza

Not compulsary

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects, which are not evaluated but they are essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, database performance analysis and modeling. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice) D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004 Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

In-person lectures and in-class practice (except for periods of sanitary emergency), with optional remote access through Microsoft Teams

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects. One of them will be evaluated towards the exam. All the others will not be evaluated, but they will be essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, data warehousing. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

Class lectures, class exercises, practical activities (projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Modalità Frequenza

Not compulsary

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects, which are not evaluated but they are essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, database performance analysis and modeling. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice) D. Menasce et al. Performance by Design: Computer Capacity Planning by Example, 2004 Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

In-person lectures and in-class practice (except for periods of sanitary emergency), with optional remote access through Microsoft Teams

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects. One of them will be evaluated towards the exam. All the others will not be evaluated, but they will be essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.

scheda docente | materiale didattico

Programma

Database technology: physical structures, transaction management, distributed architectures. Data bases for decision support, data warehousing. Seminars on recent topics in database management.

Testi Adottati

P. Atzeni et al. Basi di dati 5/Ed. McGraw-Hill, 2018 (or any major database textbook, contact the instructor for advice)
Additional material available on the course site:
http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Bibliografia Di Riferimento

Additional material available on the course site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/BDIIindex.html

Modalità Erogazione

Class lectures, class exercises, practical activities (projects), to be developed along lines provided by the instructor. Should the COVID-19 emergency continue, the course will implement all the indications provided by the university. If needed video-lectures will be broadcast and recorded, with the appropriate modes of interaction with students, on site or remote.

Modalità Frequenza

Not compulsary

Modalità Valutazione

The written examination contains 3-6 exercises, aimed at verifying the level of effective comprehension of the concepts and the ability of the student to apply them in practical contexts. Optional midterms are also offered, with the same structure. Students are required to develop small projects, which are not evaluated but they are essential in the preparation for the exam. All the exam (and midterm) tests of previous years (since 1998) are available on the course Web site: http://www.dia.uniroma3.it/~atzeni/didattica/BD/compitiPDF/index.html During the COVID-19 emergency, the exam could be held in an oral way, possibly preceded by written exercises. For each student, the whole exam is held in one day.