Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer
Vol 3 No 2 (2019): Februari 2019

Analisis Dan Perancangan Data Warehouse Menggunakan Pendekatan Mixed-Driven (Studi Pada Dinas Komunikasi dan Informatika Kabupaten Sidoarjo)

Qomarul Umam (Fakultas Ilmu Komputer, Universitas Brawijaya)
Satrio Agung Wicaksono (Fakultas Ilmu Komputer, Universitas Brawijaya)
Welly Purnomo (Fakultas Ilmu Komputer, Universitas Brawijaya)



Article Info

Publish Date
07 Jan 2019

Abstract

Today technology is possible to help people in their daily activity. Technology also help people in important things. Technology has been implemented by several Organisasi Perangkat Daerah (OPD), there are Badan Perencanaan dan Pembangunan Daerah (BAPPEDA) and Badan Pengelolaan Keuangan dan Aset Daerah (BPKAD) Kabupaten Sidoarjo to conduct reporting. However, the submission of reports carried out still uses On-Line Transaction Processing (OLTP). Therefore, Dinas Komunikasi dan Informatika (DISKOMINFO) Kabupaten Sidoarjo built a data warehouse that is useful for integrating all OLTP data on each OPD, so that the reporting data source becomes centralized and is also useful as OLTP data back-up. The first stage in building a data warehouse is requirements analysis. In this case, requirements analysis data warehouse uses a mixed-driven approach. Based on the results of the requirements analysis, three information packages have been obtained, they are information package budget planning, budget proposal, and budget realization. The information package produced two multidimensional designs in the form of star schema and based on the results of validation testing by conducting expert judgment and verification testing using Requirement Traceability Matrix (RTM) showed that the design that had been made was 100% valid and according to user needs.

Copyrights © 2019






Journal Info

Abbrev

j-ptiik

Publisher

Subject

Computer Science & IT Control & Systems Engineering Education Electrical & Electronics Engineering Engineering

Description

Jurnal Pengembangan Teknlogi Informasi dan Ilmu Komputer (J-PTIIK) Universitas Brawijaya merupakan jurnal keilmuan dibidang komputer yang memuat tulisan ilmiah hasil dari penelitian mahasiswa-mahasiswa Fakultas Ilmu Komputer Universitas Brawijaya. Jurnal ini diharapkan dapat mengembangkan penelitian ...