Multivocal Literature Mapping on DSLs and Tools for Entity-Relationship Modeling
Resumo
A variedade de tecnologias de sistemas de banco de dados que se tornou disponível nos últimos anos dificulta a seleção de ferramentas para modelagem de entidade-relacionamento (ER). Nesse sentido, contribui-se com um levantamento de inovações recentes por meio de um mapeamento sistemático complementado por uma pesquisa na literatura cinza. Este trabalho abrange um conjunto final de 10 estudos primários focados em Linguagens Específicas de Domínio (DSL) e identifica 55 ferramentas já aplicadas na indústria e academia para modelagem ER em nível conceitual, lógico e físico. Assim, este estudo apresenta o estado da arte e da prática para modelagem ER, incluindo sua caracterização e lacunas de pesquisa.
Palavras-chave:
Revisão Multivocal de Literatura, Linguagens de Domínio Específico, Ferramentas de Modelagem de Dados, Modelo Entidade-Relacionamento
Referências
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.
Publicado
01/12/2021
Como Citar
RIQUELMO, Jonnathan; BERNARDINO, Maicon; BASSO, Fábio; RODRIGUES, Elder.
Multivocal Literature Mapping on DSLs and Tools for Entity-Relationship Modeling. In: ESCOLA REGIONAL DE ENGENHARIA DE SOFTWARE (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.
