Data Modeling and NoSQL Databases - A Systematic Mapping Review
- 13 July 2021
- journal article
- review article
- Published by Association for Computing Machinery (ACM) in ACM Computing Surveys
- Vol. 54 (6), 1-26
- https://doi.org/10.1145/3457608
Abstract
Modeling is one of the most important steps in developing a database. In traditional databases, the Entity Relationship (ER) and Unified Modeling Language (UML) models are widely used. But how are NoSQL databases being modeled? We performed a systematic mapping review to answer three research questions to identify and analyze the levels of representation, models used, and contexts where the modeling process occurred in the main categories of NoSQL databases. We found 54 primary studies where we identified that conceptual and logical levels received more attention than the physical level of representation. The UML, ER, and new notation based on ER and UML were adapted to model NoSQL databases, in the same way, formats such as JSON, XML, and XMI were used to generate schemas through the three levels of representation. New contexts such as benchmark, evaluations, migration, and schema generation were identified, as well as new features to be considered for modeling NoSQL databases, such as the number of records by entities, CRUD operations, and system requirements (availability, consistency, or scalability). Additionally, a coupling and co-citation analysis was carried out to identify relevant works and researchers.Keywords
Funding Information
- Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - Brasil (CAPES) - Finance Code 001
This publication has 50 references indexed in Scilit:
- Modeling and Management of Big Data: Challenges and opportunitiesFuture Generation Computer Systems, 2016
- Informed Schema Design for Column Store-Based Database ServicesPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2015
- Guidelines for conducting systematic mapping studies in software engineering: An updateInformation and Software Technology, 2015
- A Big Data Modeling Methodology for Apache CassandraPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2015
- Transforming UML class diagrams into HBase based on meta-modelPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2014
- Database Design for NoSQL SystemsLecture Notes in Computer Science, 2014
- Model-Driven Design of Graph DatabasesLecture Notes in Computer Science, 2014
- MySQL to NoSQLPublished by Association for Computing Machinery (ACM) ,2012
- NoSQL evaluation: A use case oriented surveyPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2011
- Systematic literature reviews in software engineering – A tertiary studyInformation and Software Technology, 2010