Lectures

• When: Friday, 10:00 - 12:00 (occasionally also 12:00-13:00) starting from March 4 until May 27, 2022


• Where: Classroom A7, DIAG, via Ariosto 25, Roma
  You can connect remotely by using Zoom with the link https://uniroma1.zoom.us/j/88389166727?pwd=N3RLVWVUZGdvUU5SYWFOaWtCZFlXZz09

• Lectures 1, 2 (March 4)
  • Course Introduction; Introduction to Big Data


• Lectures 3,4,5 (March 11)
  • Graph Databases: Introduction to Graph databases; Graph DBs vs relational DBs; Graph Abstract Data Type and Implementation of Graphs; Querying Graph Databases;Types of Graph Databases


• Lectures 6, 7, 8 (March 18)
  • Property Graph Databases: A Neo4j overview


• Lectures 9, 10, 11 (March 25)
  • Graph Databases: Resource Description framework (RDF); RDFS; Graph Databases: RDF storage


• Lectures 12, 13, 14 (April 1)
  • SPARQL; Linked Open Data


• April 8 - Lecture cancelled


• April 15 - Easter break


• Lectures 15, 16, 17 (April 22)
  • Aggregate Data Models: the notion of aggregate; NoSQL data models: Key-value, Document-based and Column-family; a brief note on Data Modeling in NoSQL databases; Distribution Models


• Lectures 18, 19 (April 29)
  • A MongoDB overview


• Lectures 20, 21, 22 (May 6)
  • Consistency in Aggregate Databases
  • Data Warehousing: introduction; architectures; ETL;


• Lectures 23, 24, 25 (May 13)
  • Data Warehousing: multidimensional model; Accessing Data Warehouses: reports, dashboards,OLAP, data mining; ROLAP vs. MOLAP.


• Lectures 26, 27 (May 20)
  • Data Warehousing: Conceptual Modeling of DWs and the Dimensional Fact Model; logical modeling of DWs; star schema and snowflake schema; views.


• May 27
  • Presentations of students' projects

Slides

To access the material you have to register with your institutional account.

Books (suggested -- slides cover all topics in the course)

• NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Pramod J. Sadalage and Martin Fowler. Addison-Wesley. 2013
• Data Warehouse Design: Modern Principles and Methodologies. Matteo Golfarelli and Stefano Rizzi. McGraw-Hill. 2009.

Exams

(1) Development of a small project. Students are strongly encouraged to propose their own idea for projects. As a suggestion, they can refer to (and also select from) the following list of tools. The project connected to a tool consists, for example, in studying the logical data model(s) adopted by the tool, the native storage data structure it uses, the query language it provides, and highlighting further distinguishing features. Also, a demonstration of the basic use of the tool through one or more examples is required. Presentation connected to projects (possibly through slides) should last around 20 minutes (including the demo).

1. Graph database and RDF tools
   1. OrientDB (it has features of both document and graph DBMSs).
   2. ThingSpan (the new product incorporating InfiniteGraph functionalities)
   3. HyperGraphDB
   4. GraphDB (free edition).
   5. Blazegraph
   6. Allegrograph
   7. Virtuoso
2. key-value database tools
   1. Redis
   2. Riak
   3. Memcached
   4. Voldemort
3. document database tools
   1. Couchbase
   2. MarkLogic (Enterprise NoSQL)
4. column-family database tools
   1. Cassandra
   2. Hbase
   3. Hypertable
5. DataWarehousing tools
   1. Hive
   2. Qlikview (a proprietary front-end tool for Business intelligence. A personal edition can be downloaded for study purposes. Being it a front-end tool, the focus of student analysis should be on the mechanisms provided by the tool for data analytics, and for multidimensional access to data, rather than on data models or storage data structure).

Note: This kind of projects can be developed individually or by groups of two students. In this latter case, presentation should be equally separated into two parts, one managed by each member of the group, and the overall presentation time can be extended to 30-40 minutes.

The exam will consist in the project presentation with possible additional questions on the topics covered by this section of the Large Scale Data Management Course.

To have a project assigned, students must send an email to lembo@diag.uniroma1.it indicating the kind project they are willing to present (please, do not start working on a project before you have it assigned).

(2) Article Presentation

Article presentation consists in preparing a 20 minute presentation about scientific papers assigned by the lecturer or proposed by students. Send an email to lembo@diag.uniroma1.it to ask for the assignment of papers to study as final work (please, do not start studying a paper for exam presentation before you have it assigned).

Note: Article presentation can be carried out only individually

Note: Both project and paper presentations and paper will be preferably carried out during the office ours. Students are however required to send an email in advance to fix the exact date and hour of their presentation.