PENGEMBANGAN DATA WAREHOUSE DAN ON-LINE ANALYTICAL PROCESSING (OLAP) UNTUK PENEMUAN INFORMASI DAN ANALISIS DATA (Studi Kasus : Sistem Informasi Penerimaan Mahasiswa Baru STMIK AMIKOM PURWOKERTO)

Giat Karyono

Abstract


Background preparation of this thesis report, Silva (2007) mentions that
the competition for students between universities was inevitable as it grows,
universities should equip themselves to survive in the competition that ultimately
colleges that are not sensitive to compete. The demand for a high performance
organization that has also faced by STMIK AMIKOM Purwokerto. Existing data
on the colleges that are so big and much needed storage space allocation will be
helped and be efficient with the data warehouse (Wikramanayake, 2006). Based
on the data management / decision makers in education institutions is always a
constant attempt to find an information / decision analysis that are useful in the
search for new students. For the needs of the analysis method was used OLAP
(OnLine Analytical Processing) which presents the data in the form of
multidimensional query that is easier to be presented and analyzed.
Data collection methods used in the preparation of this report include the
method of observation of interviews and field studies, literature, internet search,
as well as observing systems that are already running.
This research was conducted with the following steps: 1) The analysis
system that includes the current SIPMB analysis, identification of the cause of the
problem, analysis of system requirements. 2) System design, including design of
data warehouses and OLAP applications PMB. This design produces data
warehouse architecture, data modeling dimensional, the establishment of a data
warehouse, OLAP stakeholders PMB, PMB OLAP viewpoint, scenario, model
systems, and user interface design. 3) Implementation, covers the application of
OLAP applications PMB and operations performed included, 4) testing system,
test the product in accordance with ISO 9126 software includes six quality
characteristics of Functionality, Reliability, Usability, efficiency, Maintainability,
Portability. In order not to interfere the performance of the operational databases
(OLTP) SIPMB process of creating a data warehouse is done on different
machines by performing replicate of the database used SIPMB. For the needs of
the application is made data analysis OLAP PMB. These applications could
present multidimensional data in grid view. Analysis of these data may include
analysis of specialization in new student enrollment based on the period of new
admissions, enrollment surge, home school, home province and district,
Pengembangan Data Warehouse dan On-line Analytical Processing (OLAP) Untuk
Penemuan Informasi Dan Analisis Data
Jurnal Telematika Vol. 4 No.2 Agustus 2011 14
registration information, day, month, or year. So that the results of data analysis
can be the management in determining the appropriate marketing strategies to
increase the number of freshmen applicants either currently running or for
admission in the coming year.


Full Text:

PDF (Indonesian)

References


Ariana, Azimah, 2007. Perancangan Data Warehouse Akademik UNAS, Fasilkom

UI

Ingham, J, 2000, Data warehousing : A tool for the outcomes assessment process,

IEEE Transaction on Education. 43 (2). 132-136

Inmon, W.H, 1993, “The operational data store,” PRISM Tech Topic, Vol. 1

____________, 1996, Building the Data Warehouse. New York: John Wiley

____________, 2005, Building the Data Warehouse, 2nd Edition, New York:

John Wiley

Inmon, W H, Richard, D.H, 2005, Building the Data Warehouse Fourth Edition,

Wiley Publishing, Inc. Indianapolis, Indiana

Jogiyanto, HM, 1999, Analisis dan Disain sistem informasi Pendekatan

Terstruktur Teori dan Praktek Aplikasi Bisnis, Andi Offset, Yogyakarta

Kenan Technology, An Introducttion to Multidimesional Database Technology,

Presentasi SIBK Multidimesional Database and Online Analytical

Processing Material, Slide by Prof. Bizan Fazlollahi

Kenneth E. Kendall & Julie E. Kendal, 2002, System Analysis And Desaign

Person Education International, p.192

Teletech, 2006, Case Study – Financial Services, Colorado

Wardiana, W, 1990, Perkembangan Teknologi Informasi Indonesia, Pusat

Penelitian Century, Bantam Books, New York

Ward J, Peppard J, 2003, Strategic Planning for Information Systems, Third

Edition. West Susse: John Willey & Sons Ltd

Warnars, Spits, 2010, Tata Kelola Database Perguruan Tinggi yang Optimal

dengan Datawarehouse. Telkomnika. Vol.8 No.1

Wikramanayake GN, Goonetillake JS, 2006, Managing Very Large Databases

and Data Warehousing. Sri Lankan Journal of Librarianship and

Information Management, 2(1):22-29

Whitten, J.L.and Bentley, L.D, 1998, System Analysis & Desaign Methods, 4

th

edition. Irwin/McGraw-Hill International Co. New York




DOI: http://dx.doi.org/10.35671/telematika.v4i2.211

Refbacks

  • There are currently no refbacks.



Indexed by:

          

Jurnal Telematika

ISSN 2442-4528 (online) | ISSN 1979-925X (print)
Published by : Universitas Amikom Purwokerto
Jl. Let. Jend. POL SUMARTO Watumas, Purwonegoro - Purwokerto Telp (0281) 623321 Fax (0281) 621662
Email: telematika@amikompurwokerto.ac.id

 This work is licensed under a Creative Commons Attribution-ShareAlike 4.0