Consistent Design of Relational Databases using EERCASE
DOI:
https://doi.org/10.5753/jidm.2022.2537Keywords:
EER, Case tool, SQLAbstract
This article introduces EERCASE, a Computer Aided Software Engineering tool that is based on the best practices of the Model Driven Development paradigm to provide a consistent environment for relational database design. EERCASE follows the graphical notation of the Enhanced Entity–Relationship model according to Elmasri and Navathe, implements the EERMM metamodel to avoid syntactically invalid constructs, shows and describes static semantic errors, and generates data definition code that takes into account advanced structural validations. The theoretical and technical framework used for the implementation of EERCASE is discussed, with emphasis on the restrictive and informative validations performed by it. In addition, considering feedbacks on modeling errors and code generation, EERCASE is also presented as a computational environment that favors active learning.
Downloads
References
Bavota, G., Gravino, C., Oliveto, R., Lucia, A. D., Tortora, G., Genero, M., and Cruz-Lemus, J. A. Identifying the weaknesses of uml class diagrams during data model comprehension. In International Conference on Model Driven Engineering Languages and Systems. Springer, Berlin, Heidelberg, pp. 168–182, 2011.
Brambilla, M., Cabot, J., and Wimmer, M. Model-Driven Software Engineering in Practice: Second Edition. Synthesis Lectures on Software Engineering 3 (1): 1–207, 2017.
Calvanese, D. and Lenzerini, M. On the interaction between isa and cardinality constraints. In Proceedings of 1994 IEEE 10th International Conference on Data Engineering. IEEE, Houston, TX, USA, pp. 204–213, 1994.
Chen, P. P.-S. The entity-relationship model—toward a unified view of data. ACM transactions on database systems (TODS) 1 (1): 9–36, 1976.
Codd, E. F. A relational model of data for large shared data banks. Communications of the ACM 26 (1): 64–69, 1983.
Dullea, J., Song, I.-Y., and Lamprou, I. An analysis of structural validity in entity-relationship modeling. Data & Knowledge Engineering 47 (2): 167–205, 2003.
Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, Seventh Edition. Person, Boston, MA, USA, 2016.
Fidalgo, R., Alves, E., España, S., Castro, J., and Pastor, O. Metamodeling the enhanced entity-relationship model. JIDM 4 (3): 406–420, 2013.
Fidalgo, R. D., Souza, E. M. D., España, S., Castro, J. B. D., and Pastor, O. Eermm: a metamodel for the enhanced entity-relationship model. In International Conference on Conceptual Modeling. Springer, Berlin, Heidelberg, pp. 515–524, 2012.
Ramakrishnan, R., Gehrke, J., and Gehrke, J. Database management systems. Vol. 3. McGraw-Hill, New York, 2003.
Silberschatz, A., Sudarshan, S., and Korth, H. F. Database System Concepts. Vol. 7. McGraw-Hill, New York, 2019.
Silva, E. and Fidalgo, R. Eercase: Uma ferramenta robusta para projeto conceitual de banco de dados. In Anais Estendidos do XXXVI SBBD. SBC, Porto Alegre, RS, Brasil, pp. 87–92, 2021.
Song, I.-Y., Evans, M., and Park, E. K. A comparative analysis of entity-relationship diagrams. Journal of Computer and Software Engineering 3 (4): 427–459, 1995.