Schema proposition model for NoSQL applications

This paper proposes a schema proposition model for physical and logical modeling of NoSQL (Not Only SQL) document-store databases. Unlike the traditional databases which are rigid in design, the NoSQL databases are flexible, scalable, and low-latent making them to house big data efficiently. However...

Full description

Saved in:
Bibliographic Details
Main Authors: Imam, A.A., Basri, S., Ahmad, R., González-Aparicio, M.T.
Format: Article
Published: Springer Verlag 2019
Online Access:https://www.scopus.com/inward/record.uri?eid=2-s2.0-85053940221&doi=10.1007%2f978-3-319-99007-1_3&partnerID=40&md5=a3eeda1667359b1d8b40bb0c10d2cd19
http://eprints.utp.edu.my/23647/
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:This paper proposes a schema proposition model for physical and logical modeling of NoSQL (Not Only SQL) document-store databases. Unlike the traditional databases which are rigid in design, the NoSQL databases are flexible, scalable, and low-latent making them to house big data efficiently. However, issues such as dataset complexity coupled with programmers� low competency are making database modeling and designing very challenging, especially in balancing the significant parameters like availability, consistency and scalability. The proposed model aims to address this balancing by abstractly proposing schemas to programmers with respect to user defined system requirements, Create, Read, Update and Delete (CRUD) operations, etc. Exploratory and experimental approaches were adopted in this research. System requirement formulas were introduced to compute the expected performance. A mini system was developed to validate the proposed model by comparing the manually generated schema to the schema generated through the proposed model. Results obtained indicated a significant improvement in the schema generated by the proposed model. © Springer Nature Switzerland AG 2019.