Implementasi OLAP dan Optimasi Query Pada Basis Data Produksi Servo Dengan Pendekatan Algoritma Genetika

Rudiyanto, Rudiyanto (2021) Implementasi OLAP dan Optimasi Query Pada Basis Data Produksi Servo Dengan Pendekatan Algoritma Genetika. Undergraduate thesis, Institut Teknologi Sepuluh Nopember.

[thumbnail of Rudiyanto_Buku Proyek Akhir.pdf] Text
Rudiyanto_Buku Proyek Akhir.pdf - Accepted Version
Restricted to Repository staff only until 1 April 2024.

Download (3MB) | Request a copy
[thumbnail of 10311710000027-Undergraduate_Thesis.pdf] Text
10311710000027-Undergraduate_Thesis.pdf
Restricted to Repository staff only

Download (3MB) | Request a copy

Abstract

Station Packing Line Servo digunakan sebagai proses pengemasan produk dan material servo. Permasalahan yang timbul yaitu data informasi mengenai material, belum tersimpan kedalam basis data produksi servo, sedangkan, data tersebut merupakan data penting sebagai tracer data. Semakin bertambahnya data yang masuk kedalam basis data, maka volume dan eksekusi query pada basis data produksi servo akan semakin lama.
Dengan adanya permasalahan tersebut, Proyek Akhir ini bertujuan untuk mengimplementasikan Application Programming Interface (API), agar data informasi material dapat tersimpan kedalam basis data. Data informasi material diolah kedalam platform website integrated – Online Analytical Processing (OLAP) yang menerapkan sistem OLAP, yang dapat menyimpan data dalam jumlah yang besar, dari beberapa sumber yang berbeda dan dalam waktu yang lama. Agar performa dapat bekerja stabil, maka, Algoritma Genetika dapat diterapkan untuk melakukan pencarian query, berdasarkan relasi tabel pada basis data, dengan waktu eksekusi lebih cepat dalam hitungan detik, menit, bahkan jam.
Hasil Proyek Akhir ini menunjukkan bahwa eksekusi program API memiliki nilai rata – rata tertinggi 22,855 detik, dengan selisih waktu 3,183 detik dari perbandingan sebelum implementasi API. Pada pengujian optimasi query, metode terbaik adalah M2S crossover dengan rata – rata 227,6 detik, dengan selisih waktu 4 milidetik dari perbandingan metode CHUNK crossover.
================================================================================================
Station Packing Line Servo is used as a servo product and material packaging process. The problem that arises is that the information data about the material has not been stored into the servo production database, meanwhile, the data is important data as tracer data. The more data that enters the database, the volume and execution of queries on the servo production database will take longer.
With these problems, this Final Project aims to implement an Application Programming Interface (API), so that material information data can be stored in a database. Material information data is processed into an integrated website platform – Online Analytical Processing (i-OLAP) that implements the OLAP system, which can store large amounts of data, from several different sources and for a long time. In order for performance to work stable, then, Genetic Algorithm can be applied to perform query searches, based on table relations in the database, with faster execution times in seconds, minutes, and even hours.
The results of this final project show that the execution of the API program has the highest average value of 16.688 seconds, with a time difference of 3.183 seconds from the comparison before the API implementation. In the query optimization test, the best method is the M2S crossover with an average of 227.6 seconds, with a time difference of 4 milliseconds from the comparison of the CHUNK crossover method.

Item Type: Thesis (Undergraduate)
Uncontrolled Keywords: Algoritma Genetika, CHUNK crossover, Datawarehouse, M2S crossover, OLAP (On-line Analytical Processing), Algoritma Genetika.
Subjects: Q Science > QA Mathematics > QA336 Artificial Intelligence
Q Science > QA Mathematics > QA402.5 Genetic algorithms. Interior-point methods.
Q Science > QA Mathematics > QA76.758 Software engineering
Q Science > QA Mathematics > QA76.76.A63 Application program interfaces
Q Science > QA Mathematics > QA76.76.S64 Software maintenance.
Q Science > QA Mathematics > QA76.9.D37 Data warehousing.
Q Science > QA Mathematics > QA76.9D338 Data integration
T Technology > T Technology (General) > T57.5 Data Processing
T Technology > T Technology (General) > T57.84 Heuristic algorithms.
T Technology > T Technology (General) > T58.5 Information technology. IT--Auditing
T Technology > T Technology (General) > T58.6 Management information systems
T Technology > T Technology (General) > T58.8 Productivity. Efficiency
T Technology > TS Manufactures > TS161 Materials management.
T Technology > TS Manufactures > TS195 Packaging
Divisions: Faculty of Vocational > 36304-Automation Electronic Engineering
Depositing User: Rudiyanto Rudiyanto
Date Deposited: 04 Mar 2022 04:25
Last Modified: 04 Mar 2022 04:25
URI: http://repository.its.ac.id/id/eprint/94777

Actions (login required)

View Item View Item