Predictive Performance Comparison Analysis of Relational & NoSQL Graph Databases
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2017, Vol 8, Issue 5
Abstract
From last three decades, the relational databases are being used in many organizations of various natures such as Education, Health, Business and in many other applications. Traditional databases show tremendous performance and are designed to handle structured data with ACID (Atomicity, Consistency, Isolation, Durability) property to manage data integrity. In the current era, organizations are storing more data i.e. videos, images, blogs, etc. besides structured data for decision making. Similarly, social media and scientific applications are generating large amount of semi-structured data of varied nature. Relational databases cannot process properly and manage such large amount of data efficiently. To overcome this problem, another paradigm NoSQL databases is introduced to manage and process massive amount of unstructured data efficiently. NoSQL databases are divided into four categories and each category is used according to the nature and need of the specific problem. In this paper we will compare Oracle relational database and NoSQL graph database using optimized queries and physical database tuning techniques. The comparison is two folded: in the first iteration we compare various kinds of queries such as simpler query, database tuning of Oracle relational database such as sub databases and perform these queries in our desired environments. Secondly, for this comparison we will perform predictive analysis for the results obtained from our experiments.
Authors and Affiliations
Wisal Khan, Ejaz ahmed, Waseem Shahzad
Keywords
Related Articles
- EP ID EP259144
- DOI 10.14569/IJACSA.2017.080564
- Views 111
- Downloads 0
Sensitivity Analysis and Validation of Refractive Index Estimation Method with Ground Based Atmospheric Polarized Radiance Measurement Data
Sensitivity analysis and validation of the proposed refractive index estimation method with ground based atmospheric polarized radiance measurement data is conducted. Through the sensitivity analysis, it is found that De...
Performance of Spectral Angle Mapper and Parallelepiped Classifiers in Agriculture Hyperspectral Image
Hyperspectral Imaging (HSI) is used to provide a wealth of information which can be used to address a variety of problems in different applications. The main requirement in all applications is the classification of HSI d...
THE IMPACT OF COGNITIVE TOOLS ON THE DEVELOPMENT OF THE INQUIRY SKILLS OF HIGH SCHOOL STUDENTS IN PHYSICS
The purpose of the study was to compare the effectiveness of two teaching strategies that utilize two different cognitive tools on the development of students’ inquiry skills in mechanics. The strategies were used to hel...
Reengineering Framework to Enhance the Performance of Existing Software
Term reengineering refers to improve the quality of the system. Continues maintenance and aging degrade the performance of the software system. Right approach and methodology must be adapted to perform reengineering. Wit...
A Routing Calculus with Distance Vector Routing Updates
We propose a routing calculus in a process algebraic framework to implement dynamic updates of routing table using distance vector routing. This calculus is an extension of an existing routing calculus DRωπ where routing...