Teaching Workshop
A.Y. 2023/2024
Learning objectives
The aim of the lab is to provide the basic knowledge and skills about computer science tools for modeling, defining, and managing digital historical archives.
Expected learning outcomes
The student will acquire the following knowledge and skills:
- fundamental principles of the relational model for the definition of a historical archive (database)
- languages and tools for extracting information from a relational database
- languages and tools for the representation of historical knowledge with semantic web formalisms
- fundamental principles of the relational model for the definition of a historical archive (database)
- languages and tools for extracting information from a relational database
- languages and tools for the representation of historical knowledge with semantic web formalisms
Lesson period: First semester
Assessment methods: Giudizio di approvazione
Assessment result: superato/non superato
Single course
This course cannot be attended as a single course. Please check our list of single courses to find the ones available for enrolment.
Course syllabus and organization
Single session
Responsible
Lesson period
First semester
Course syllabus
The lectures will be focused on the following topics:
1. Data, information and information systems. Representation and processing of information relevant to historical sciences, introduction to database management systems (DBMS).
2. The relational model. Relational model theory, null values, relationships between tables, data consistency, integrity constraints, relational algebra, projection and selection, set operations.
3. The SQL language and the PostgreSQL dialect. Creation of a database, definition of associations between tables, inserting data into a database, violation of the constraints of foreign key, modification and deletion of tables, query of a database, selection conditions, joins of tables, sorting criteria, and further query examples.
4. Exercises related to the employment of information technologies for the representation and management of information relevant to the historical sciences. PostgreSQL DBMS tutorials on creating a database, inserting data into a database, editing and deleting tables, querying a database, selection conditions, joining tables, and more query examples.
5. The evolution of the Web, introduction to the concept of the Semantic Web.
1. Data, information and information systems. Representation and processing of information relevant to historical sciences, introduction to database management systems (DBMS).
2. The relational model. Relational model theory, null values, relationships between tables, data consistency, integrity constraints, relational algebra, projection and selection, set operations.
3. The SQL language and the PostgreSQL dialect. Creation of a database, definition of associations between tables, inserting data into a database, violation of the constraints of foreign key, modification and deletion of tables, query of a database, selection conditions, joins of tables, sorting criteria, and further query examples.
4. Exercises related to the employment of information technologies for the representation and management of information relevant to the historical sciences. PostgreSQL DBMS tutorials on creating a database, inserting data into a database, editing and deleting tables, querying a database, selection conditions, joining tables, and more query examples.
5. The evolution of the Web, introduction to the concept of the Semantic Web.
Prerequisites for admission
No prior knowledge is required, however it is preferable to have a minimum of basic computer skills.
Teaching methods
Lectures are planned with the help of slides and teaching materials that will be progressively made available on the Ariel platform teaching website. Specific lectures will be focused on the analysis of real case studies aimed at illustrating the concrete application of the theoretical contents addressed during the lessons.
Teaching Resources
Slides and teaching materials will be provided by the professor on the Ariel platform teaching website. In particular, the teaching material refers to the following bibliography:
1. A. Albano, G. Ghelli, R. Orsini, "Foundations of Data Bases". fundamentalidibasididati.it. and. September 2021;
2. R. Elmasri, S. B. Navathe, "Fundamentals of database systems". Pearson. 7th edition. 2015;
3. S. Castano, A. Ferrara, S. Montanelli, "Information, knowledge and Web for the humanities". Pearson. 2009.
1. A. Albano, G. Ghelli, R. Orsini, "Foundations of Data Bases". fundamentalidibasididati.it. and. September 2021;
2. R. Elmasri, S. B. Navathe, "Fundamentals of database systems". Pearson. 7th edition. 2015;
3. S. Castano, A. Ferrara, S. Montanelli, "Information, knowledge and Web for the humanities". Pearson. 2009.
Assessment methods and Criteria
The exam consists in the oral discussion of articles relating one or several topics of the course. The articles to be analysed are agreed in advance with the professor. As an alternative, it is possible to deliver a summary of the studied articles. The oral discussion or the summary aims to verify that the student has understood the content and is able to highlight the aspects of the studied work in a conscious, critical way, and with adequate language properties.
Professor(s)
Reception:
To be agreed by scheduling an appointment
Room 37 (3rd floor) or Microsoft Teams