EERCASE: Uma Ferramenta Robusta para Projeto Conceitual de Banco de Dados
Resumo
Considerando a pluralidade de notações Enhanced Entity-Relationship (EER) e a carência de ferramentas robustas, este artigo apresenta a ferramenta EERCASE. Construída com base nas melhores práticas do paradigma Model Driven Development (MDD), EERCASE é capaz de impedir construções sintaticamente inválidas, indicar e explicar os erros de semântica estática e gerar código de definição de dados impondo restrições não triviais. EERCASE tem sido usada para apoiar o ensino e a prática de projeto EER e oferece recursos não disponibilizados por outras ferramentas.
Palavras-chave:
Enhanced Entity–Relationship, Projeto Conceitual, Banco de Dados
Referências
Bavota, G., Gravino, C., Oliveto, R., De Lucia, A., Tortora, G., Genero, M., and Cruz-Lemus, J. A. (2011). Identifying the weaknesses of uml class diagrams during datamodel comprehension. In International Conference on Model Driven Engineering Languages and Systems, pages 168–182. Springer.
Brambilla, M., Cabot, J., and Wimmer, M. (2017). Model-Driven Software Engineeringin Practice: Second Edition.Synthesis Lectures on Software Engineering, 3(1):1–207.
Chen, P. P.-S. (1976). The entity-relationship model-toward a unified view of data. ACM transactions on database systems (TODS), 1(1):9–36.
Calvanese, D., Lenzerini, M. On the interaction between ISA and cardinality constraints. In: Data Engineering, 1994. Proceedings.10th International Conference, v.14, no.18, p. 204-213, 1994.
Dullea, J., Song, I. Y., Lamprou, I. An analysis of structural validity in entity relationship modeling. Data and Knowledge Engineering, v. 47, n. 2, p. 167–205, 2003.
Elmasri, R. and Navathe, S. B. (2016). Fundamentals of Database Systems, Seventh Edition. Person, Boston, MA, USA.
Fidalgo, R. D. N., De Souza, E., España, S., De Castro, J., and Pastor, O. (2012). EERMM: A metamodel for the enhanced entity-relationship model. In Conceptual Modeling, volume 7532 of Lecture Notes in Computer Science, pages 515–524. Springer.
Song, Il-Yeol, Mary Evans, and Eun K. Park. A comparative analysis of entity-relationship diagrams. Journal of Computer and Software Engineering 3.4 (1995): 427-459.
Brambilla, M., Cabot, J., and Wimmer, M. (2017). Model-Driven Software Engineeringin Practice: Second Edition.Synthesis Lectures on Software Engineering, 3(1):1–207.
Chen, P. P.-S. (1976). The entity-relationship model-toward a unified view of data. ACM transactions on database systems (TODS), 1(1):9–36.
Calvanese, D., Lenzerini, M. On the interaction between ISA and cardinality constraints. In: Data Engineering, 1994. Proceedings.10th International Conference, v.14, no.18, p. 204-213, 1994.
Dullea, J., Song, I. Y., Lamprou, I. An analysis of structural validity in entity relationship modeling. Data and Knowledge Engineering, v. 47, n. 2, p. 167–205, 2003.
Elmasri, R. and Navathe, S. B. (2016). Fundamentals of Database Systems, Seventh Edition. Person, Boston, MA, USA.
Fidalgo, R. D. N., De Souza, E., España, S., De Castro, J., and Pastor, O. (2012). EERMM: A metamodel for the enhanced entity-relationship model. In Conceptual Modeling, volume 7532 of Lecture Notes in Computer Science, pages 515–524. Springer.
Song, Il-Yeol, Mary Evans, and Eun K. Park. A comparative analysis of entity-relationship diagrams. Journal of Computer and Software Engineering 3.4 (1995): 427-459.
Publicado
04/10/2021
Como Citar
SILVA, Edson A.; FIDALGO, Robson N..
EERCASE: Uma Ferramenta Robusta para Projeto Conceitual de Banco de Dados. In: DEMONSTRAÇÕES E APLICAÇÕES - SIMPÓSIO BRASILEIRO DE BANCO DE DADOS (SBBD), 36. , 2021, Rio de Janeiro.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2021
.
p. 87-92.
DOI: https://doi.org/10.5753/sbbd_estendido.2021.18168.
