A Systematic Literature Review: Database Optimization Techniques

Big data optimization is the main thing in getting accurate and fast data. The condition of the data at this time is very much, therefore optimization must be done. As technology develops, more and more data is generated, some data optimization techniques still take a long time to get optimal results. This research paper aims to find out several ways of optimizing the database with several existing techniques. The design used is a literature review. The criteria for the papers used are those published in 2005–2020. In the paper that we have researched, there are several ways to optimize a database, the methods used, and the challenges that will exist during database optimization. Based on the collected papers, it was found that there are indeed many ways to optimize the database. Then there are many methods in database optimization that use the Map Reduce Algorithm, and it is proven that the algorithm can reduce the amount of work time when transferring data, and there are several challenges in database optimization. This research paper shows how to optimize the database from several sources. Then there is an explanation of the methods or algorithms used in database optimization.