QODM: A query-oriented data modeling approach for NoSQL databases

Author(s):  
Xiang Li ◽  
Zhiyi Ma ◽  
Hongjie Chen

The chapter discusses the necessity for data modeling in NoSQL world. The NoSQL data modeling is a huge challenge because one of the main features of NoSQL databases is that they are schema-free, that is they allow data manipulation without the need for the previous modeling or developing an entity-relationship (ER) or similar model. Although the absence of a schema can be an advantage in some situations, with the increase in the number of NoSQL database implementations, it appears that the absence of a conceptual model can be a source of substantial problems. In order to better understand the need for data modeling in NoSQL databases, first the basic structure of an ER model and an analysis of its limitations are summarized, especially regarding an application in NoSQL databases. The concept and Object modeling notation is presented as one of the possible solutions for data modeling in NoSQL databases.


2021 ◽  
Vol 5 (5) ◽  
pp. 162-169
Author(s):  
Shreya Banerjee ◽  
Sourabh Bhaskar ◽  
Anirban Sarkar ◽  
Narayan C. Debnath

These days, NoSQL (Not only SQL) databases are being used as a deployment tool for Data Warehouses (DW) due to its support for dynamic and scalable data modeling capabilities. Yet, decision-makers have faced several challenges to accept it as a major choice for implementation of their DW. The most significant one among those challenges is a lack of common conceptual model and a systematic design methodology for different NoSQL databases. The objective of this paper is to resolve these challenges by proposing an ontology based formal conceptual model for NoSQL based DWs. These proposed concepts are capable of realizing the cube concepts for visualization of multi-dimensional data in NoSQL based DW solutions. In this context, two strategies are specified, implemented and illustrated using a case study for devising of the proposed conceptual model.


Sign in / Sign up

Export Citation Format

Share Document