Robust Partitioning Scheme for Accelerating SQL Database

SQL Databases have shown tremendous performance in the last four decades. Data consistency, isolation, and durability are the main strengths of SQL databases. However, in relational databases, computing joins are time-consuming at run time. To address this issue, we propose to utilize the Oracle partitioning technique to enhance specific query performance. Physical database tuning approaches of SQL databases are being used to speed up each SQL statement such as partitioning and indexing. With the partitioning technique, the Oracle 11g RDBMS efficiency performance improves by approximately absolute 50%. Additionally, we compare its performance with the state-of-the-art NoSQL graph database (Neo4j).