SQL Database with physical database tuning technique and NoSQL graph database comparisons

Relational databases are used in many organizations of various natures from last three decades such as Education, health, businesses and in many other applications. SQL databases are designed to manage structured data and show tremendous performance. Atomicity, Consistency Isolation, Durability (ACI...

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:2019 IEEE 3rd Information Technology, Networking, Electronic and Automation Control Conference (ITNEC) s. 110 - 116
Hlavní autoři: Khan, Wisal, Ahmad, Waqas, Luo, Bin, Ahmed, Ejaz
Médium: Konferenční příspěvek
Jazyk:angličtina
Vydáno: IEEE 01.03.2019
Témata:
NoSQL databases
NoSQL Graph database
Organizations
Physical database tuning
Relational databases
Servers
Structured Query Language
tablespaces
Tuning
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Popis
Shrnutí:Relational databases are used in many organizations of various natures from last three decades such as Education, health, businesses and in many other applications. SQL databases are designed to manage structured data and show tremendous performance. Atomicity, Consistency Isolation, Durability (ACID) property of Relational databases is used to manage data integrity and consistency. Physical database techniques are used to increase the performance of relational databases. Tablespaces also called subfolder is one of the physical database technique used by Oracle SQL database. Tablespaces are used to store the data logically in separate data files. Now-a-days huge amount and varied nature (unstructured and semi structured) of data is generated by the various organizations i.e., videos, images, blogs etc. This large amount of data is not handled by the SQL databases efficiently. NoSQL databases are used to process and analyze the large amount of data efficiently. Four different types of NoSQL databases are used in the industry according to the organization requirement. In this article, first, we do the physical database tuning of the Oracle Relational database and then compared with NoSQL Graph database. Relational database performance is increased up to 50% due to physical database tuning technique (Tablespaces). Besides, physical database tuning approach of relational database NoSQL graph database performed better in all our proposed scenarios.
DOI:10.1109/ITNEC.2019.8729264