Automatic schema suggestion model for NoSQL document-stores databases

New generation databases also called NoSQL (Not only SQL) databases are highly scalable, flexible, and low-latent. These types of databases emerge as a result of the rigidity shown by traditional databases to handle today’s data which is voluminous, highly diversified and generated at a very high ra...

Full description

Saved in:
Bibliographic Details
Published in:Journal of big data 2018-12, Vol.5 (1), p.1-17, Article 46
Main Authors: Imam, Abdullahi Abubakar, Basri, Shuib, Ahmad, Rohiza, Watada, Junzu, González-Aparicio, María T.
Format: Article
Language:English
Subjects:
Big Data
Communications Engineering
Computational Science and Engineering
Computer Science
Data Mining and Knowledge Discovery
Data security
Database Management
Database modeling
Document-model databases
Information Storage and Retrieval
Mathematical Applications in Computer Science
Networks
NoSQL databases
Query languages
Schema suggestion
Storage capacity
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:New generation databases also called NoSQL (Not only SQL) databases are highly scalable, flexible, and low-latent. These types of databases emerge as a result of the rigidity shown by traditional databases to handle today’s data which is voluminous, highly diversified and generated at a very high rate. With NoSQL, problems such as database expansion difficulties, low query performance and low storage capacity are addressed. However, the inherent complexity of contemporary datasets coupled with programmers’ low NoSQL modeling competence are increasingly making database modeling and design vastly challenging, especially when parameters like consistency, availability and scalability are to be balanced in accordance with system requirements. As such, a schema suggestion model for NoSQL databases is posed to address this balancing issue. The proposed model aims to abstractly suggest schemas at the initial stage of system development based on user defined system requirements and CRUD (Create, Read, Update and Delete) operations among others. This is achieved through the adaptation of exploratory and experimental approaches of research. Also, few mathematical formulas are introduced to calculate clusters availability during entity mappings. A comparison was conducted between the schema produced using the proposed model and the one without. Results obtained shows substantial improvement in the areas of security and read–write query performance.
ISSN:2196-1115
2196-1115
DOI:10.1186/s40537-018-0156-1