andremmori/feup-tbda

Projects developed for the Database Technologies class using SQL for Relational and Object Relational Models, MongoDB and Neo4j.

FEUP-TBDA

Projects developed for the Database Technologies class.

Developed by

• André Mori
• Jiahao Zhang

Projects

All the projects developed used the Cultural Facilities schema presented below.

Project 1 - Query Optimization

Analyse several SQL execution plans in a test database. Assess the impact of indexes and statistics and the use of different strategies for query organization

The project can be found here.

Project 2 - Object Relational

Think about the possibilities open by the object-relational schema, with respect to the relational schema, namely the use of user defined types, with objects combining data structures and the functions to manipulate them, inheritance, nested tables and vectors, object references and comparison and sorting methods. Develop a small illustrative database

The project can be found here.

Project 3 - NoSQL

Build a small DB using two distinct NoSQL approaches, a document database (MongoDB) and a graph database (Neo4j) and compare both approaches and with the relational approach

The project can be found here.