Artikel Jurnal ANALISIS OPTIMASI QUERY SQL MENGGUNAKAN TEKNIK HEURISTIC PADA KASUS DATA TRANSAKSI PELANGGAN YANG LAYAK MENDAPATKAN REKOMENDASI PRODUK
Download Jurnal Disini
A company now needs to innovate in promoting good products to increase product sales, one of the ways is to provide product recommendations to customers. The way to get these recommendations is done by identifying sales transaction data then divided based on the type of product that many customers buy, then providing product recommendations based on the type of product most often purchased by customers in a certain period.
Problems that occur are to display Product recommendation data requires a considerable amount of time, caused by many rows of data processed in the database, other than that the other problem is the selection of the optimal query in displaying product recommendation data can also affect the speed of access to data. So it is necessary to do an analysis to find out which queries are more optimal for displaying product recommendations. A query is said to be optimal if the access time for data has the minimum time when conducting operations using certain techniques.
The technique used in this study is the Heuristic Technique. This technique was chosen because it can reduce the complexity of optimization, but it can also solve problems by slightly ignoring whether the solution is proven correctly, but this technique can produce the most optimal solution. This study produced recommendations that could be used, so that it was hoped that in the process of processing product recommendation data within a database the company could be more quickly carried out.