Perbaikan Algoritma Otomasi Konfigurasi Data Warehouse pada Sistem Rule-based CRM

Tikno, Tikno (2008) Perbaikan Algoritma Otomasi Konfigurasi Data Warehouse pada Sistem Rule-based CRM. Masters thesis, Institut Teknologi Sepuluh Nopember.

[thumbnail of 5106201807-Master_thesis.pdf] Text
5106201807-Master_thesis.pdf
Restricted to Repository staff only

Download (23MB)

Abstract

Perancangan data warehouse merupakan salah satu tahap yang penting berkaitan dengan keberhasilan implementasi data warehouse, terutama dalam hal kinerja sistem. Kesalahan pada tahap ini akan menjadi pemicu pemborosan sumber daya (resources) yang tidak perlu. Karena itu, diperlukan suatu cara untuk merancang data warehouse yang efektif bagi kepentingan perusahaan. Kim et al. (2003) telah melakukan penelitian yang menghasilkan algoritma otomasi konfigurasi data warehouse dari sistem rule-based CRM. Penelitian tersebut menghasilkan konfigurasi yang efektif dengan menyeleksi tabel yang diperlukan oleh sistem. Namun, algoritma tersebut masih meninggalkan masalah redundansi. Penelitian ini ditujukan untuk memberikan solusi berupa perbaikan algoritma otomasi sehingga redundansi pada hasil akhir otomasi dapat ditiadakan. Hasil penelitian menunjukkan bahwa perbaikan algoritma ini berhasil mengatasi masalah redundansi dan menghasilkan efisiensi waktu sebesar rata-rata 44,07% pada proses pembentukan ANALYSIS_TERMS, serta penghematan ruang penyimpanan sebesar 40,43% pada kasus yang dicontohkan oleh algoritma sebelumnya.
===================================================================================================================================
Data warehouse design is a crucial stage for the successful implementation of a data warehouse, particularly regarding system performance. A fault at this stage will trigger unnecessary resource waste. Therefore, an effective method is needed to design a data warehouse that serves organizational interests. Kim et al. (2003) conducted research that proposed an algorithm to automate data warehouse configuration within a rule-based CRM system. Their research yielded an effective configuration by selecting the tables truly required by the system; however, it still suffered from redundancy issues. This research aims to provide a solution by improving the automation algorithm so that redundancy in the final automation result can be eliminated. The results show that the improved algorithm successfully resolves the redundancy problem and achieves an average time efficiency of 44.07% in the ANALYSIS_TERMS generation process, along with a 40.43% storage space savings in the case study demonstrated by the previous algorithm.

Item Type: Thesis (Masters)
Additional Information: RTIf 005.740 68 Tik p
Uncontrolled Keywords: otomasi, datawarehouse,rule-based CRM, redundansi, automation, data warehouse, rule-based CRM, redundancy
Subjects: Q Science > QA Mathematics > QA76.9.D37 Data warehousing.
Divisions: Faculty of Information Technology > Informatics Engineering > 55101-(S2) Master Thesis
Depositing User: magang .
Date Deposited: 18 Sep 2026 07:48
Last Modified: 18 Sep 2026 07:48
URI: http://repository.its.ac.id/id/eprint/144690

Actions (login required)

View Item View Item