Multivocal Literature Mapping on DSLs and Tools for Entity-Relationship Modeling
Abstract
The variety of database system technologies that became available in recent years makes difficult the selection of tools for modeling entity-relationship (ER). In this sense, we contribute with an overview of the recent innovations through a systematic literature mapping complemented by research in the gray literature.This paper scopes ten (10) primary studies focused on Domain-Specific Languages (DSL) and identifies fifty-five (55) tools already applied in industry and academia for ER modeling at the conceptual, logical, and physical level. Hence, as a significant increment to existing mapping studies, this presents the state of the art and practice for ER modeling, including its characterization and research gaps.
Keywords:
Multivocal Literature Mapping, Domain-Specific Languages, Database Modeling Tools, Entity-relationship model
References
ANSI, A. N. S. I. (1975). Interim Report: ANSI/X3/SPARC Study Group on DBMSs 75-02-08. ACM SIG on Management of Data.
Ayadi, M. G., Bouslimi, R., and Akaichi, J. (2016). A framework for medical and health care databases and data warehouses conceptual modeling support. Network Modeling Analysis in Health Informatics and Bioinformatics.
Celikovic, M., Dimitrieski, V., Aleksic, S., Ristic, S., and Lukovic, I. (2014). A DSL for EER Data Model Specification. In 23rd Int. Conf. on Information Systems Development, pages 290–297.
Chen, P. P.-S. (1976). The Entity-relationship Model - Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1):9–36.
Cook, T. and Campbell, D. (1979). Quasi-Experimentation: Design and Analysis Issues for Field Settings. Houghton Mifflin.
Cougo, P. (2013). Modelagem conceitual e projeto de banco de dados. Elsevier.
Dimitrieski, V., Celikovic, M., Aleksic, S., Ristic, S., Alargt, A., and Lukovic, I. (2015). Concepts and Evaluation of the Extended Entity-relationship Approach to Database Design in a Multi-paradigm Information System Modeling Tool. Computer Languages, Systems & Structures, 44(Part C):299–318.
Dyba, T. and Dingsøyr, T. (2008). Strength of evidence in systematic reviews in software engineering. In 2nd ACM-IEEE Int. Symp. on Empirical Software Engineering and Measurement, pages 178–187. ACM.
Fowler, M. (2010). Domain Specific Languages. Addison-Wesley, 1st edition.
Garousi, V. and Felderer, M. and Mäntylä, M. V. (2019). Guidelines for including grey literature and conducting multivocal literature reviews in software engineering. Information & Software Technology, 106:101–121.
Gregersen, H. and Jensen, C. S. (1999). Temporal entity-relationship models-a survey. IEEE Transactions on Knowledge and Data Engineering, 11(3):464–497.
Hammer, M. and Mc Leod, D. (1981). Database Description with SDM: A Semantic Database Model. ACM Transactions on Database Systems, 6(3):351–386.
Jagannathan, D., Fritchman, B. L., Guck, R. L., Thompson, J. P., and Tolbert, D. M. (1988). SIM: A Database System Based on the Semantic Data Model. ACM SIGMOD Record, 17(3):46–55.
Kersten, M., Zhang, Y., Ivanova, M., and Nes, N. (2011). SciQL, a Query Language for Science Applications. In Work. on Array Databases, pages 1–12. ACM.
Litwin, W., Abdellatif, A., Zeroual, A., Nicolas, B., and Vigier, P. (1989). MSQL: A Multidatabase Language. Information Sciences, 49:59–101.
Lorenz, M., Hesse, G., and Rudolph, J.-P. (2016). Object-relational Mapping Revised - A Guideline Review and Consolidation. In 11th International Joint Conference on Software Technologies, pages 157–168.
Ma, Z. and Yan, L. (2010). A Literature Overview of Fuzzy Conceptual Data Modeling. Information Science and Engineering, 26:427–441.
Mazairac, W. and Beetz, J. (2013). BIMQL - an open query language for building information models. Advanced Engineering Informatics, 27(4):444–456.
Mernik, M., Heering, J., and Sloane, A. M. (2005). When and How to Develop Domain-specific Languages. ACM Computer Survey, 37(4):316–344.
Petersen, K., Feldt, R., Mujtaba, S., and Mattsson, M. (2008). Systematic Mapping Studies in Software Engineering. In 12th Int. Conf. on Evaluation and Assessment in Software Engineering, pages 68–77. BCS Learning & Dev. Ltd.
Shipman, D. W. (1981). The Functional Data Model and the Data Languages DAPLEX. ACM Transactions Database Systems, 6(1):140–173.
Siau, K. (2012). Innovations in Database Design, Web Applications, and Information Systems Management. Information Science Reference.
Tian, H., Sunderraman, R., Calin-Jageman, R., Yang, H., Zhu, Y., and Katz, P. (2006). NeuroQL: A Domain-specific Query Language for Neuroscience Data. In Int. Conf. on Current Trends in Database Technology, pages 613–624. Springer.
Torres, A., Galante, R., Pimenta, M. S., and Martins, A. J. B. (2017). Twenty years of object-relational mapping: A survey on patterns, solutions, and their implications on application design. Information and Software Technology.
Van Deursen, A., Klint, P., and Visser, J. (2000). Domain-specific languages: An annotated bibliography. ACM SIGPLAN Notices, 35(6):26–36.
Vara, J., Bollati, V., Jiménez, A., and Marcos, E. (2014). Dealing with Traceability in the MDD of Model Transformations. Trans. on Soft. Eng., 40(6):555–583.
Voelter, M. (2009). Best Practices for DSLs and Model-Driven Development. Journal of Object Technology, 8(6):79–102.
Ayadi, M. G., Bouslimi, R., and Akaichi, J. (2016). A framework for medical and health care databases and data warehouses conceptual modeling support. Network Modeling Analysis in Health Informatics and Bioinformatics.
Celikovic, M., Dimitrieski, V., Aleksic, S., Ristic, S., and Lukovic, I. (2014). A DSL for EER Data Model Specification. In 23rd Int. Conf. on Information Systems Development, pages 290–297.
Chen, P. P.-S. (1976). The Entity-relationship Model - Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1):9–36.
Cook, T. and Campbell, D. (1979). Quasi-Experimentation: Design and Analysis Issues for Field Settings. Houghton Mifflin.
Cougo, P. (2013). Modelagem conceitual e projeto de banco de dados. Elsevier.
Dimitrieski, V., Celikovic, M., Aleksic, S., Ristic, S., Alargt, A., and Lukovic, I. (2015). Concepts and Evaluation of the Extended Entity-relationship Approach to Database Design in a Multi-paradigm Information System Modeling Tool. Computer Languages, Systems & Structures, 44(Part C):299–318.
Dyba, T. and Dingsøyr, T. (2008). Strength of evidence in systematic reviews in software engineering. In 2nd ACM-IEEE Int. Symp. on Empirical Software Engineering and Measurement, pages 178–187. ACM.
Fowler, M. (2010). Domain Specific Languages. Addison-Wesley, 1st edition.
Garousi, V. and Felderer, M. and Mäntylä, M. V. (2019). Guidelines for including grey literature and conducting multivocal literature reviews in software engineering. Information & Software Technology, 106:101–121.
Gregersen, H. and Jensen, C. S. (1999). Temporal entity-relationship models-a survey. IEEE Transactions on Knowledge and Data Engineering, 11(3):464–497.
Hammer, M. and Mc Leod, D. (1981). Database Description with SDM: A Semantic Database Model. ACM Transactions on Database Systems, 6(3):351–386.
Jagannathan, D., Fritchman, B. L., Guck, R. L., Thompson, J. P., and Tolbert, D. M. (1988). SIM: A Database System Based on the Semantic Data Model. ACM SIGMOD Record, 17(3):46–55.
Kersten, M., Zhang, Y., Ivanova, M., and Nes, N. (2011). SciQL, a Query Language for Science Applications. In Work. on Array Databases, pages 1–12. ACM.
Litwin, W., Abdellatif, A., Zeroual, A., Nicolas, B., and Vigier, P. (1989). MSQL: A Multidatabase Language. Information Sciences, 49:59–101.
Lorenz, M., Hesse, G., and Rudolph, J.-P. (2016). Object-relational Mapping Revised - A Guideline Review and Consolidation. In 11th International Joint Conference on Software Technologies, pages 157–168.
Ma, Z. and Yan, L. (2010). A Literature Overview of Fuzzy Conceptual Data Modeling. Information Science and Engineering, 26:427–441.
Mazairac, W. and Beetz, J. (2013). BIMQL - an open query language for building information models. Advanced Engineering Informatics, 27(4):444–456.
Mernik, M., Heering, J., and Sloane, A. M. (2005). When and How to Develop Domain-specific Languages. ACM Computer Survey, 37(4):316–344.
Petersen, K., Feldt, R., Mujtaba, S., and Mattsson, M. (2008). Systematic Mapping Studies in Software Engineering. In 12th Int. Conf. on Evaluation and Assessment in Software Engineering, pages 68–77. BCS Learning & Dev. Ltd.
Shipman, D. W. (1981). The Functional Data Model and the Data Languages DAPLEX. ACM Transactions Database Systems, 6(1):140–173.
Siau, K. (2012). Innovations in Database Design, Web Applications, and Information Systems Management. Information Science Reference.
Tian, H., Sunderraman, R., Calin-Jageman, R., Yang, H., Zhu, Y., and Katz, P. (2006). NeuroQL: A Domain-specific Query Language for Neuroscience Data. In Int. Conf. on Current Trends in Database Technology, pages 613–624. Springer.
Torres, A., Galante, R., Pimenta, M. S., and Martins, A. J. B. (2017). Twenty years of object-relational mapping: A survey on patterns, solutions, and their implications on application design. Information and Software Technology.
Van Deursen, A., Klint, P., and Visser, J. (2000). Domain-specific languages: An annotated bibliography. ACM SIGPLAN Notices, 35(6):26–36.
Vara, J., Bollati, V., Jiménez, A., and Marcos, E. (2014). Dealing with Traceability in the MDD of Model Transformations. Trans. on Soft. Eng., 40(6):555–583.
Voelter, M. (2009). Best Practices for DSLs and Model-Driven Development. Journal of Object Technology, 8(6):79–102.
Published
2021-12-01
How to Cite
RIQUELMO, Jonnathan; BERNARDINO, Maicon; BASSO, Fábio; RODRIGUES, Elder.
Multivocal Literature Mapping on DSLs and Tools for Entity-Relationship Modeling. In: REGIONAL SCHOOL OF SOFTWARE ENGINEERING (ERES), 5. , 2021, Evento Online.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2021
.
p. 149-158.
DOI: https://doi.org/10.5753/eres.2021.18460.
