COMPARATIVE STUDY OF RELATIONAL AND NON- RELATIONS DATABASE PERFORMANCES USING ORACLE AND MONGODB SYSTEMS
Azhi Faraj, Bilal Rashid, Twana Shareef · 2014
With the substantial growth in volume and complexity of data used in the digital world large organizations need to handle a variety of unstructured data. Traditionally relational database systems have been used to store, process and retrieve data although other types of databases such as hierarchical, network, graph have existed before 1970, yet their commercial goals were not achieved until recent years. These databases (called NoSQL or Non-relational databases) are complements to relational databases and are used by world's largest organizations such as Google, Amazon and Facebook. This research compares the performance of relational and non-relational databases namely Oracle, and MongoDB by executing complex queries on a large set of data that is available in document-based mode and is converted to Oracle tables. The results show that data retrieval is significantly faster in MongoDB however some mathematical queries such as aggregation functions(sum, count, AVG) are better suited to Oracle RDBMS.