Projects developed for the Database Technologies class.
All the projects developed used the Cultural Facilities schema presented below.
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.
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.
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.