Pembangunan Aplikasi Pelaporan Perijinan dengan Online Analytical Processing (OLAP)

Dimara Kusuma Hakim

doi:10.30595/juita.v1i3.439

Authors

Dimara Kusuma Hakim

DOI:

https://doi.org/10.30595/juita.v1i3.439

Keywords:

Data Warehouse, License Application, OnLine Analytical Processing (OLAP), permit report application, data analysis permit database

Abstract

Business licensing data in a district that has been collected in a database, it will be useful when it is analyzed, so a lot of important information will be obtained. The government need a system that can help them to analyze data easily. Online Analytical Processing (OLAP) is an implementation of Data warehousing that can help reporting and analyzing well. OLAP can map the data with cube dimensions, each dimension can be easily compared, so the decision maker can find the problems that faced easily and quickly. Some of the problems that solved in this research are : Progress Report on Company Registration in several years, the Number of Companies by the type of business, Development of Investment, the number of SIUP by District, , the number of SIUP by business class, the number of license based on its type, Construction Permit (IMB) in several years, and the Number of Disorders Permits (HO) by several classification. Reporting application in data Licensing are built in this research with OLAP technology.Â Based on the Chi-Square testing performed for business licensing data which contain 100-1161 records, the Chi-Square value are 45,89 â€“ 80, greater than Chi-Square table (13,28), there is significantly different for time consuming between SQL and OLAP.Â When data are reduced for 90 records, the Chi-Square value is 2.01, less than Chi-Square table, there is no significantly different for time consuming between SQL and OLAP

References

Bernardino J., Madeira, H., 2000, Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing, http://www.inf.fuberlin. de/~hinze/caise00_DC/came diakses terakhir tanggal 18 Agustus 2011.

Bogdanova, G. dan Georgieva, T., 2004, Analyzing The Data In Olap Data Cubes, http://scigems.math.bas.bg:8080/jspui/bitstream/10525/822/1/ijita12-4-p06.pdf diakses terakhir pada tanggal 1 Juli 2011.

Hermawan, Y., 2005, Konsep OLAP dan Aplikasinya Menggunakan Delphi, Andi, Yogyakarta.

Keith, S., Kaser, O., Lemire, D., Analyzing Large Collection of Electronic Text Using OLAP, http://lemire.me/fr/abstracts/TR05001.html diakses terakhir tanggal 1 Juli 2011.

Langit, L., 2007, Foundations of SQL Server 2005 Business Intelligence, Apress Publishing, New York - United States of America.

Madeira, H., Costa, J., Vieira, M., 2003, The OLAP and Data Warehousing Approaches for Analysis and Sharing of Results from Dependability Evaluation Experiments, http://citeseerx.ist.psu.edu/viewdoc/download?doi=1 0.1.1.104&rep1&type=pdf.

Pressman, R.S., 2001, Software Engineering (A Practitioner’s Approach), 5th Ed., McGraw-Hill Companies, Inc.