The course has as main objective to provide the fundamental concepts on: database management systems (DBMS), the SQL language, and the study of techniques and methods of data design and modeling and methods of designing a database data.
During the course, students will apply the knowledge acquired on local servers in order to carry out real and practical CRUD (Create, Read, Update, Delete) operations on databases on local servers.
Particular attention is paid to the techniques for carrying out the functional analysis, the collection of requirements and the definition of the processes of the work context where the database will be inserted.
Knowledge and understanding
To understand the structure of IT systems, the collection of requirements and their modeling in order to be aware of the context in which the databases are located.
To understand the main concepts of management and design of database systems.
Knowing and understanding concepts and tools for querying databases of different types.
To understand the differences between the various types of databases: relational, and the study of data warehouses as well as big data and NoSQL.
Applying knowledge and understanding
To collect the needs, to understand the requirements set by the context and to extract the essential information in order to model the data, to write requirements documents, to know the design principles and to query the datasets.
To recognize the required fundamentals that are needed in the design and in the implementation of the database, from traditional data to digital data.
Making judgements
Being able to analyze, collect and interpret data from a complex context and be able to adopt the most efficient design solution.
Communication skills
Orally explain your project choices in a clear way with an appropriate technical vocabulary with regards to the fundamental concepts in database management.
Learning skills
Through the concepts and notions acquired during the course, the student will be able to undertake subsequent studies with a high degree of autonomy.
knowledge and understanding: students will acquire knowledge concerning standard tools recommended by the World Wide Web Consortium (W3C) to semantically represent, reason on, and query information present on the Web.
Applying knowledge and understanding: students will be able to construct logic models concerning various application domains, also called web ontologies, applying the standard W3C technology together with data and information present on the Web. In addition, students will be able to use the most widespread automated reasoners to determine logic inferences regarding web ontologies already constructed and, therefore to deduce implicit information present in them.
Making judgements: students will be able to evaluate quality of ontologies and to choose adequate semantic web tools for knowledge representation and reasoning in various situations.
Communication skills: students will acquire adequate communication skills and appropriateness of expression when communicating questions concerning knowledge representation and reasoning on the Web, also in presence of non-expert interlocutors.
Learning skills: students will gain the skill of adapting knowledge learned to new contexts and to keep themselves up-to-date by consulting specialized sources in the ambit of the Semantic Web.
Lectures, hands-on exercises, laboratory.
Lectures in which explanations of the principal notions and tools of the semantic Web are enriched with various examples and case studies, presented with the purpose of stimulating discussions in class and of facilitating the understanding of the topics.
Learning assessment may also be carried out on line, should the conditions require it.
1. Basic notions of information systems (Teaching materials provided by the instructor)
1. Introduction to information systems
2. Software life cycle
3. Software development methodology
4. Architectural analysis of software systems
5. Collection and management of requirements
2. Models and languages of databases
1. Introduction to Database Management Systems (Chapter 1)
2. Relational model (Chapter 2)
3. Elements of Algebra and relational calculus (Chapter 3, teaching materials provided by the instructor)
4. SQL language (Chapter 4)
5. Relational DBMS: MySQL (Teaching materials provided by the instructor)
6. Other types of databases (Teaching materials provided by the instructor)
3. Design of databases
1. Design methodologies (Chapter 6)
2. Conceptual Design (Chapter 7)
3. Logical Design (Chapter 8)
4. Introduction to normalization (Chapter 9, teaching materials provided by the instructor)
5. Elements of PHP: the aim is creating pages with access to MySQL database (Teaching materials provided by the instructor)
Introduction to the Semantic Web: motivation, examples, hints at the semantic modelling method (ontologies) and at logic.
- Data model dati Resource Description Framework (RDF), hints at projects such as Facebook Open Graph Protocol, Google Graph, DBPedia.
- SPARQL language for querying RDF graphs and introduction to important SPARQL endpoints.
- RDF Schema language (hints at RDFS foundational and not foundational ontologies for the Digital Humanities).
- Web Ontology Language (OWL) 2 language, examples of foundational and not foundational ontologies for the Digital Humanities.
- Introduction to the Semantic Rule Language (SWRL), to description logics (logic theories permitting to express semantic web languages) and related inference tools.
1. BASI DI DATI 5/ED CON CONNECT, di Paolo Atzeni, Stefano Ceri, Piero Fraternali, Stefano Paraboschi, Riccardo Torlone - Casa editrice: Mc-Graw-Hill (2018), chap. 1 (pp. 3-14), chap. 2 (pp. 15-39), chap. 3 (teaching materials provided by the instructor), chap. 4 (pp. 91-147), chap. 6 (pp. 197-234), chap. 7 (pp. 241-271), chap. 8 (pp. 281-319), chap. 9 (teaching materials provided by the instructor).
2. Teaching materials provided by the instructor
Please remember that in compliance with art 171 L22.04.1941, n. 633 and its amendments, it is illegal to copy entire books or journals, only 15% of their content can be copied.
For further information on sanctions and regulations concerning photocopying please refer to the regulations on copyright (Linee Guida sulla Gestione dei Diritti d’Autore) provided by AIDRO - Associazione Italiana per i Diritti di Riproduzione delle opere dell’ingegno (the Italian Association on Copyright).
All the books listed in the programs can be consulted in the Library.
1. A semantic Web Primer (third edition). Grigoris Antoniou, Paul Groth, Frank van Harmelen, and Rinke Hoekstra, 2012. The MIT Press, Cambrigde, Massachusetts, London, England (pp. 288).
2. Semantic Web for the Working Ontologist (Third Edition). Dean Allemang and James Hendler and Fabien Gandon, 2020. Morgan and Claypool (pp. 510).
Texts have not to be studied entirely, they are intended as supports to lessons and slides.
Please remember that in compliance with art 171 L22.04.1941, n. 633 and its amendments, it is illegal to copy entire books or journals, only 15% of their content can be copied.
For further information on sanctions and regulations concerning photocopying please refer to the regulations on copyright (Linee Guida sulla Gestione dei Diritti d’Autore) provided by AIDRO - Associazione Italiana per i Diritti di Riproduzione delle opere dell’ingegno (the Italian Association on Copyright).
All the books listed in the programs can be consulted in the Library.