EERCASE: A Robust Tool for Conceptual Design of Database
Abstract
Considering the plurality of Enhanced Entity-Relationship (EER) notations and the lack of robust tools, this article presents the EERCASE tool. Based on the best practices of the Model Driven Development (MDD) paradigm, EERCASE is able to prevent syntactically invalid constructions, point out and explain static semantic errors, and generate data definition code considering non-trivial constraints. EERCASE has been used to support EER modeling teaching and practice, as well as offers resources not available through other tools.
Keywords:
Enhanced Entity–Relationship, Conceptual Project, Database
References
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.
Published
2021-10-04
How to Cite
SILVA, Edson A.; FIDALGO, Robson N..
EERCASE: A Robust Tool for Conceptual Design of Database. In: DEMOS AND APPLICATIONS - BRAZILIAN SYMPOSIUM ON DATABASES (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.
