Relational Data Modeling on the Document-Based NoSQL

  • Muhammad Riza Alifi Bandung State Polytechnic
  • Transmissia Semiawan Bandung State Polytechnic
  • Djoko C.U. Lieharyani Bandung State Polytechnic
  • Hashri Hayati Bandung State Polytechnic
Keywords: Document-Based NoSQL, Data Modelling, Extended Reference, Computed

Abstract

Data management technology that continues to develop and boost the popularity of document-based not only structured query language (NoSQL) has become the most-used data model. Behind its popularity, data management technology offers an intriguing advantage, namely flexible data storage, whether in terms of data forms and sizes or structured and unstructured data. However, this data modeling flexibility has its challenge due to its impact on more complex scheme creations, without being accompanied by any need-based design patterns. This study aims to model relational data on the document-based NoSQL at its conceptual, logical, and physical levels. The conceptual design was developed based on processes, rules, and business requirements. The logical and physical designs were developed based on the extended references and computed design patterns determined from the operating workload. The relational data model design on the document-based NoSQL was successfully formed using the entity relationship diagram (ERD) with Chen notation for the conceptual, and collection relationship diagram (CRD) for both logical and physical levels. The conceptual design focused on the representation of entities, attributes, and relationships. Unlike the conceptual design which tends to be abstract, the focus of the logical design is on the collection schema (embedded and reference) representation, including design patterns influenced by the formation of relationships. Furthermore, the focus of physical level design is to represent the schema in a more concrete form. The physical design is almost the same as the logical one, the difference lies only in the detail addition for data types and structures. The evaluation of data model designs was also carried out for each level. This study contributes to designing a data model with the advantage of read-intensive capability since a joint operation among collections is not required and the computation process recurrence for derivative attributes is not necessary.

References

V.C. Storey and I. Y. Song, “Big Data Technologies and Management: What Conceptual Modeling Can Do,” Data and Knowl. Eng., Vol. 108, pp. 50–67, Mar. 2017.

H.E. Samra, A.S. Li, B. Soh, and M.A. AlZain, “Review of Contemporary Database Design and Implication for Big Data,” Int. J. Smart Educ., Urban Soc., Vol. 12, No. 4, pp. 1–11, Oct. 2021.

K. Shin, C. Hwang, and H. Jung, “NoSQL Database Design Using UML Conceptual Data Model Based on Peter Chen’s Framework,” Int. J. Appl. Eng. Res., Vol. 12, No. 5, pp. 632–636, Dec. 2017.

A. Silberschatz, H.F. Korth, and S. Sudarshan, Database System Concepts, 7th ed., New York, AS: McGraw-Hill Book Company, 2020.

IBM Cloud Education (2020) “Data Modeling,” [Online], https://www.ibm.com/cloud/learn/data-modeling, access date: 28-Sep-2021.

S. Bjeladinovic, “A Fresh Approach for Hybrid SQL/NoSQL Database Design Based on Data Structuredness,” Enterp. Inf. Syst., Vol. 12, No. 8–9, pp. 1202–1220, Oct. 2018.

G. Hampel, “Preparing the Conceptual Model of a Database,” QUAESTUS Multidiscip. Res. J., Vol. 19, pp. 290–304, Jun. 2021.

J.R. Lourenço, dkk., “Choosing the Right NoSQL Database for the Job: A Quality Attribute Evaluation,” J. Big Data, Vol. 2, pp. 1-26, Aug. 2015.

A. Schram and K.M. Anderson, “MySQL to NoSQL: Data Modeling Challenges in Supporting Scalability,” SPLASH '12: Proc. 3rd Annu. Conf. Syst., Program., Appl.: Softw. Humanit., 2012, pp. 191-202.

L. Schaefer (2021), “What Is NoSQL?” [Online], https://www.mongodb.com/nosql-explained, access date: 6-Sep-2021.

J. Pokorný, “Functional Querying in Graph Databases,” Vietnam J. Comput. Sci., Vol. 5, pp. 95–105, May 2018.

A. Meier and M. Kaufmann, “NoSQL Databases,” in SQL & NoSQL Databases, Wiesbaden, Germany: Springer Fachmedien Wiesbaden, 2019, pp. 201–218.

A. Haseeb and G. Pattun, “A Review on NoSQL: Applications and Challenges,” Int. J. Adv. Res. Comput. Sci., Vol. 8, No. 1, pp. 203-207, 2017.

Y. Genkina (2020) “Data Modeling with MongoDB,” [Online], https://webassets.mongodb.com/_com_assets/cms/mongodb_data_modeling_with_mongodb-44y55ekiu3.pdf, access date: 6-Sep-2021.

P. Atzeni, F. Bugiotti, L. Cabibbo, and R. Torlone, “Data Modeling in the NoSQL World,” Comput. Stand., Interfaces, Vol. 67, pp. 1-14, Jan. 2020.

J. LaBreck and D. Coupal (2020) “Advanced Schema Design Patterns,” [Online], https://webassets.mongodb.com/_com_assets/cms/mongodb_advanced_schema_design_patterns-pndclmx967.pdf, access date: 6-Sep-2021.

B. Thalheim, “Conceptual Model Notions – A Matter of Controversy: Conceptual Modelling and its Lacunas,” Enterp. Model., Inf. Syst. Archit. (EMISAJ), Vol. 13, pp. 9–27, Feb. 2018.

T. Semiawan, “User Interface Design Analysis Pertaining to Computational Thinking Framework,” Proc. 8th Int. Conf. Inform., Environ., Energy, and Appl., 2019, pp. 238–242.

Published
2022-08-24
How to Cite
Muhammad Riza Alifi, Transmissia Semiawan, Djoko C.U. Lieharyani, & Hashri Hayati. (2022). Relational Data Modeling on the Document-Based NoSQL. Jurnal Nasional Teknik Elektro Dan Teknologi Informasi, 11(3), 183-191. https://doi.org/10.22146/jnteti.v11i3.3704
Section
Articles