Titulo Estágio
Data Models Deployment
Áreas de especialidade
Engenharia de Software
Sistemas de Informação
Local do Estágio
DEI-FCTUC
Enquadramento
There are many tools for the development of data models, such as the Entity-Relationship (ER) model. Many of these tools not only design the data model, but also generate physical scripts that can directly deploy a database. However, today’s application scenarios are becoming more complex. The data used in the models is distributed in multiple database management systems, ranging from edge to cloud layers. Also, the paradigm of multiple teams working on distinct steps of software development, such as design and deployment, has changed due to the recent requirements of Continuous Integration and Continuous Delivery (CI/CD). The designer of today’s applications is no longer restricted to centralized systems or to specific project steps, requires a global vision of the system, and demands better tools to enable the continuous development and maintenance of highly complex distribute systems.
The aim of this work is to transform a single ER model into a complete system, considering different layers, different nodes, and different databases. While the entire process is challenging, overcoming these challenges will create an incredible tool for the future development of these systems.
Objetivo
The primary goal of this dissertation is to design, develop, and implement a system that automatically deploys a data model designed and produced on the Online Database Architect (ONDA) database design software. Such system must consider the definitions and setup made by the designer and then automatically deploy the system into physical nodes located in different layers, from the edge to the cloud. In addition, an API for data collection from the edge nodes will also be necessary.
By the end of the internship, the student will have used a well-defined Software Engineering process, identified architectural drivers, designed a software architecture, evaluated this architecture, implemented, and tested the system.
Plano de Trabalhos - Semestre 1
1) Review of the literature
2) Understand the internals of ONDA software
3) Specification of requirements, solution design and evaluation
4) Definition of the Backlog
5) Writing of the intermediate report
Work results of the semester:
• List of requirements and prioritisation
• General architecture
• Intermediate report
Plano de Trabalhos - Semestre 2
6) Sprint-oriented implementation, validation, and refinement of the system.
7) Writing of the final report
Work results of the semester:
• New version of ONDA with automatic deployment module
• Final report
Condições
The work will be conducted in CISUC. The eligible student will have at disposal all the necessary computational platforms, tools, and devices required.
Orientador
Vasco Pereira (DEI-FCTUC), Bruno Cabral (DEI-FCTUC), Jorge Bernardino (DEIS-ISEC)
vasco@dei.uc.pt 📩