Published: 2025-04-01
Design and Development of a Data Warehouse for PT. CMS Using the Nine-Step Kimball Method
DOI: 10.35870/ijsecs.v5i1.3453
Downloads
Abstract
A fully automated and structured management system in today's era is very important to support more efficient use when making decisions in a company. PT Cipta Mulia Surabaya, a company involved in the construction, mechanical, and purchasing sectors, is also one of the companies that has a management system to manage company data. Since the establishment of this company, the management system used has not used technology that has been developed in the current era or the management system is still done semi-manually, so that it can cause less than optimal in making a decision or planning. To overcome this problem, researchers created an application entitled Data Warehouse Design and utilized the Nine Step Kimball method which consists of 9 (nine) stages. With this Data Warehouse Design and Construction, it is hoped that it can help management in decision making or simplify the planning process. In the process of creating this Data Warehouse Design and Construction system, the author uses a software that functions as a local server so that it can run an application that is being developed, the author himself uses XAMPP software as a local server, in addition to being a local server, XAMPP can also manage databases. While the software for the text editor, the author uses Visual Studio Code. It is expected that with this application system, the company's performance can be optimized
Keywords
Article Information
This article has been peer-reviewed and published in the International Journal Software Engineering and Computer Science (IJSECS). The content is available under the terms of the Creative Commons Attribution 4.0 International License.
-
Issue: Vol. 5 No. 1 (2025)
-
Section: Articles
-
Published: %750 %e, %2025
-
License: CC BY 4.0
-
Copyright: © 2025 Authors
-
DOI: 10.35870/ijsecs.v5i1.3453
AI Research Hub
This article is indexed and available through various AI-powered research tools and citation platforms. Our AI Research Hub ensures that scholarly work is discoverable, accessible, and easily integrated into the global research ecosystem. By leveraging artificial intelligence for indexing, recommendation, and citation analysis, we enhance the visibility and impact of published research.
Ardan Habib Amirullah
Informatics Engineering Study Program, Universitas Stikubank, Semarang City, Central Java Province, Indonesia
Yunus Anis
Informatics Engineering Study Program, Universitas Stikubank, Semarang City, Central Java Province, Indonesia
-
Pratama, I. P. A. E., & Pradipta, I. G. A. (2020). Desain dan implementasi data warehouse untuk prediksi penjualan produk pada Toko Mekarsari. Jurnal Teknologi Informasi dan Terapan, 5(1), 65-72. https://doi.org/10.25047/jtit.v5i1.81
-
Hariyanto, B., & MT, I. (2004). Sistem manajemen basis data. Bandung: Informatika.
-
Jogiyanto, H. M. (2019). Sistem teknologi informasi. Yogyakarta : Andi.
-
Sihotang, H. T. (2019). Sistem informasi pengagendaan surat berbasis web pada Pengadilan Tinggi Medan. Journal of Science and Social Research, 3(1), 6-9. https://doi.org/10.31227/osf.io/bhj5q
-
Harumy, T. H. F. (2018). Sistem informasi absensi pada PT. Cospar Sentosa Jaya menggunakan bahasa pemprograman Java. Jurnal Teknik dan Informatika, 5(1), 63-70.
-
Connolly, T. M., & Begg, C. E. (2022). A practical approach to design, implementation, and management (4th ed.). Massachusetts.
-
Suni, E. K. (2021). Analisis dan perancangan data warehouse untuk mendukung keputusan redaksi televisi menggunakan metode nine-step Kimball. Jurnal Teknik Informatika, 11(2), 197-206. https://doi.org/10.15408/jti.v11i2.8560
-
Hasan, F. N., & Febriandirza, A. (2021). Perancangan data warehouse untuk data penelitian di perguruan tinggi menggunakan pendekatan nine steps methodologhy. Pseudocode, 8(1), 49-57. https://doi.org/10.33369/pseudocode.8.1.49-57
-
Risyad, S. A. (2023). Pengertian, karakteristik, dan arsitektur data warehouse. Dibimbing. https://dibimbing.id/blog/detail/pengertian-karakteristik-dan-arsitektur-data-warehouse (Accessed on June 7, 2024)
-
Darudiato, S. (2020). Perancangan data warehouse penjualan untuk mendukung kebutuhan informasi eksekutif Cemerlang Skin Care. Seminar Nasional Informatika, 2020(semnasIF), 350-359.
-
Akbar, M., & Rahmanto, Y. (2020). Desain data warehouse penjualan menggunakan nine step methodology untuk business intelegency pada PT Bangun Mitra Makmur. Jurnal Informatika dan Rekayasa Perangkat Lunak, 1(2), 137-146. https://doi.org/10.33365/jatika.v1i2.331
-
Kurniasari, D. (2022). SQL Server untuk data analysis. DQLab. https://dqlab.id/apa-itu-sql-server-yuk-kenali-fungsinya-untuk-data-analysis (Accessed on June 9, 2024)
-
Andriani, K. W. (2021). Pengaruh nilai pelanggan dan kualitas layanan terhadap kepuasan pelanggan pada PT Pos Indonesia (Persero) Cabang Singaraja. Ekuitas Jurnal Pendidikan Ekonomi, 4(1), 54-69. https://doi.org/10.23887/ekuitas.v4i1.15565
-
Imaan, A., Fathima, S., & Adnan, F. (2024). Advancements in data management and warehousing: Enhancing MIS through modern technologies. MJET, 1(1), 75-83. https://doi.org/10.70592/mjet.2024.1.01.006
-
Jukić, N., & Velasco, M. (2010). Data warehousing requirements collection and definition. International Journal of Business Intelligence Research, 1(3), 66-76. https://doi.org/10.4018/jbir.2010070105
-
Vatumalae, V., Rajagopal, P., & Sundram, V. (2020). Warehouse management system of a third party logistics provider in Malaysia. International Journal of Economics and Finance, 12(9), 73. https://doi.org/10.5539/ijef.v12n9p73
-
Sihaloho, T., & Hidayati, N. (2023). Pengaruh penerapan warehousing management system terhadap kinerja operasional pergudangan perusahaan logistik XYZ. Manajemen IKM: Jurnal Manajemen Pengembangan Industri Kecil Menengah, 18(2), 101-112. https://doi.org/10.29244/mikm.18.2.101-112
-
Jukić, N., & Jukić, B. (2012). Modeling-centered data warehousing learning. International Journal of Business Intelligence Research, 3(4), 74-95. https://doi.org/10.4018/jbir.2012100104
-
Han, J., Kamber, M., & Pei, J. (2012). Data preprocessing. In Data mining: Concepts and techniques (pp. 83-124). Morgan Kaufmann. https://doi.org/10.1016/b978-0-12-381479-1.00003-4
-
Maswanganyi, N., Fumani, N., Khoza, J. K., Thango, B., & Lerato, M. (2024). Evaluating the impact of database and data warehouse technologies on organizational performance: A systematic review. Available at SSRN 4997368. https://doi.org/10.20944/preprints202410.0059.v1
-
Rahman, N. (2010). Incremental load in a data warehousing environment. International Journal of Intelligent Information Technologies, 6(3), 1-16. https://doi.org/10.4018/jiit.2010070101
-
Sasmal, S. (2024). Data warehousing revolution: AI-driven solutions. International Research Journal of Engineering and Applied Sciences, 12(1), 01-06. https://doi.org/10.55083/irjeas.2024.v12i01001
-
Ahmadi, S. (2023). Optimizing data warehousing performance through machine learning algorithms in the cloud. International Journal of Science and Research, 12(12), 1859-1867. https://doi.org/10.31219/osf.io/aeyg6.
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.