Titulo Estágio
ER+ to ORM
Áreas de especialidade
Engenharia de Software
Sistemas de Informação
Local do Estágio
DEI-CISUC
Enquadramento
The Entity-Relationship (ER) model is an extraordinary tool to design databases. However, it lacks some features that rose from the evolution of recent computing paradigms, such as Cloud and Edge Computing. We proposed ER+ has a model to solve some shortcomings of the original ER, introducing data transformation and transport between data sources and data storage locations in the conceptual model.
The next step is to be able to convert ER+ to Object-Relational Mapping (ORM), and add this feature to a design tool, such as ONDA (already developed within our department). The result will be a design tool to convert a single ER model into a unique object-oriented system, considering different layers, from edge to cloud, able to distribute this system amongst the nodes and different databases.
Objetivo
The primary goal of this dissertation is to design, develop, and implement a system that can automatically read the ER+ model and transform it using ORM, integrated on the ONDA database design software. Such system must consider the definitions and setup made by the designer and then transform the conceptual model into objects that can be used to implement the system.
Plano de Trabalhos - Semestre 1
1 - Review of the literature.
2 – Understand the ONDA software and how to make changes.
3 – Elicitation of detailed requirements to implement an ORM.
4 –Writing of the intermediate report
Plano de Trabalhos - Semestre 2
5 – Develop an ORM solution for a conceptual model.
6 - Assess the developed solution.
7 - Sprint-oriented implementation, validation, and refinement of the system.
8 - Writing of the final report
Condições
The eligible student will have at disposal all the necessary computational platforms, tools and devices.
Observações
Supervision:
CISUC:
Bruno Cabral (bcabral@dei.uc.pt )
Professor Auxiliar
Vasco Pereira (vasco@dei.uc.pt )
Professor Auxiliar
DEIS-ISEC:
Jorge Bernardino (jorge@isec.pt )
Professor Coordenador
Orientador
Vasco Pereira
vasco@dei.uc.pt 📩