Kilat
Vol 8 No 1 (2019): KILAT

Studi Literatur Basis Data SQL dan NoSQL

Widya Nita Suliyanti (STT-PLN)



Article Info

Publish Date
17 May 2019

Abstract

With the increasing need to store large amounts of unstructured and semi-structured data, the database that used to be mostly using SQL technology, began using the NoSQL database. The purpose of this paper is to conduct a literature study of the characteristics, advantages and disadvantages of SQL and NoSQL databases. This literature study shows that there are differences in SQL databases and based on characteristics (ACID for SQL vs. BASE and CAP for NoSQL); data model (relational for SQL and key-value for NoSQL); data structure (structured for SQL and non- or semi-structured for NoSQL); process (subquery, join and grouping / aggregation and complex queries faster only for SQL); and the number of servers used (single large server for SQL and multiple multiple levels for NoSQL). A literature review for further SQL and NoSQL applications is needed in the future.

Copyrights © 2019






Journal Info

Abbrev

kilat

Publisher

Subject

Automotive Engineering Civil Engineering, Building, Construction & Architecture Computer Science & IT Electrical & Electronics Engineering Energy

Description

KILAT Journal is a scientific journal published by STT-PLN. KILAT Journal is published twice in one year in April and October and contains the results of research in the fields of Mechanical Engineering, Electrical Engineering, Civil Engineering and Information Engineering, Law and Economics related ...