Performance Improvement for Enterprise Resource Planning Systems using Big Data Technologies

Abstract

During Enterprise Resource Planning system lifetime, the response time increasing while the amount of data is increasing because data is retrieving from the relational database, where the more data to be processed the more time needs to response. A new data storage system has been developed called NoSQL, which stands for “Not Only SQL or Non SQL systems”. NoSQL systems have been designed for large-scale data storage and apply parallel data processing. To identify and develop the optimal solution to reduce the time of huge data processing in the Odoo framework. The proposed solution is to import data from Odoo database and store it in NoSQL data storage and build Odoo module that is able to read and write data from both PostgreSQL Database (which is not distributed database) and suitable NoSQL database. This research aims to solve the Odoo performance latency problem, this reduce storage costs, because it is cheaper to store archived data based on NoSQL infrastructure, Open-source software and easy to extending in future, Also can use data for mining “data mining”.