DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI

Authors

  • Spits Warnars Fakultas Teknologi Informasi, Universitas Budi Luhur, Jl. Petukangan Selatan, Kebayoran Lama, Jakarta 12260, Telepon: 021-5853753

:

https://doi.org/10.9744/informatika.10.2.86-93

Keywords:

Data warehouse, ETL, ETL algorithm, ETL table, constructive merge loading.

Abstract

Data Warehouse for higher education as a paradigm for helping high management in order to make an effective and efficient strategic decisions based on reliable and trusted reports which is produced from Data Warehouse itself. Data Warehouse is not a software, hardware or tool but Data Warehouse is an environment where the transactional database is modelled in other view for decision making purposes. ETL (Extraction, Transformation and Loading) is a bridge to build Data Warehouse and transform data from transactional database. In every fact and dimension table will be inserted with fields which represent the construction merge loading as an ETL (Extraction, Transformation and Loading) extraction. ETL needs an ETL table and ETL process where ETL table as table connectivity between tables in OLTP database and tables in Data Warehouse and ETL process will transform data from table in OLTP database into Data Warehouse table based on ETL table. The extraction process will be run with a table database as differentiate ETL process and an ETL algorithm which will be run automatically in idle transactional process, along with daily transactional database backup when the information system are not used.

Downloads

Published

2011-10-01

How to Cite

Warnars, S. (2011). DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI. Jurnal Informatika, 10(2), 86-93. https://doi.org/10.9744/informatika.10.2.86-93

Issue

Vol. 10 No. 2 (2009): NOVEMBER 2009

Section

Articles

License

Authors who publish with this journal agree to the following terms:


  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).