Research of NOSQL and SQL and Designing a Better Database Schema for Databases
Shivam Kumar Giri1, Chidanandan V2, Narendran Rajagopalan3
1Shivam Kumar Giri, National Institute of Technology, Thiruvettakudy Karaikal (Puducherry), India.
2Chidanandan V, National Institute of Technology, Thiruvettakudy Karaikal (Puducherry), India.
3Narendran Rajagopalan, National Institute of Technology, Thiruvettakudy Karaikal (Puducherry), India.
Manuscript received on 15 August 2019 | Revised Manuscript received on 27 August 2019 | Manuscript Published on 06 September 2019 | PP: 177-182 | Volume-8 Issue- 6S, August 2019 | Retrieval Number: F10360886S19/19©BEIESP | DOI: 10.35940/ijeat.F1036.0886S19
Open Access | Editorial and Publishing Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: The amount of data storage and querying is increasing day by day. The requirement of data-storage, security, scalability and management is an alarming issue. Structured Query Language (SQL) databases was designed to overcome most of the trouble faced over tradition file storage system. But the alarming rate of data storage leads to Not only Structured Query Language (NoSQL) databases. in this paper, various aspects of SQL and NoSQL are compared with respect to their data management and to develop a better schema for data management is attempted.
Keywords: Key, Documents, Collections, Grouping, Schema, Attributes, Record, Data Dependencies, Sharding, Scaling, Data Replication.
Scope of the Article: Database Theory and Application