Storing and Retrieving Data

Objectives

  1. Understand the differences between SQL and NO SQL databases;
  2. Design and Implement a SQL database;
  3. Design and Implement a document based (NO SQL) database;
  4. Perfom extraction operations in both SQL and NO SQL databases;
  5. Understand the differences between OLTP and OLAP operations and the implications it brings to database design;
  6. Perform Extraction, Transform, and Load (ETL) operations;
  7. Design a Data Warehouse and understand the advantages of different architectures and data models.

General characterization

Code

200174

Credits

4.0

Responsible teacher

Flávio Luís Portas Pinheiro

Hours

Weekly - Available soon

Total - Available soon

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English

Prerequisites

No frequency requirements.

Bibliography

  • Kristina Chodorow,. MongoDB: The Definitive Guide: Powerful and Scalable Data Storage 2ndEdition. "O'Reilly Media, Inc.", 2014
  • Ramez Elmasri and Shamkant B. Navathe. Fundamentals of Database Systems 7th Edition. Pearson Global Edition (2008)
  • John L. Viescas. Sql queries for mere mortals: a hands-on guide to data manipulation in sql. Pearson Education India (2018);
  • Dan Sullivan. NoSQL for mere mortals. Addison-Wesley Professional (2015);
  • Alejandro Vaisman, and Esteban Zimányi. Data warehouse systems.Data-Centric Systems and Applications (2014).

Teaching method

Theoretical and practical classes.

Evaluation method

50% Homework Assignments + 50% Final group project or 100% Final Written Exam

Subject matter

The Storing and Retrieving of Data course unit covers an introduction to SQL and NO SQL Databases, ETL operations, and Data Warehousing. Students will learn the advantages and disadvantages of each solution (SQL vs NO SQL) in order to be better to decide which solution is best for their needs. Students will learn the differences of developing databases for Transaction Oriented (OLTP) or Analytical (OLAP) operations. Finally, the course will cover the main concepts and definitions of Data Warehousing, the role of ETL operations in retrieving data from OLTP systems, the main differences among the different Data Warehousing architectures, and the basic Data Warehousing operations.

Programs

Programs where the course is taught: