DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI
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 a...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Petra Christian University
2009-01-01
|
| Series: | Jurnal Informatika |
| Subjects: | |
| Online Access: | http://puslit2.petra.ac.id/ejournal/index.php/inf/article/view/18250 |
| _version_ | 1828370493512613888 |
|---|---|
| author | Spits Warnars |
| author_facet | Spits Warnars |
| author_sort | Spits Warnars |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-14T06:39:34Z |
| format | Article |
| id | doaj.art-d70a957d73284a01a8871faed4291f6b |
| institution | Directory Open Access Journal |
| issn | 1411-0105 |
| language | English |
| last_indexed | 2024-04-14T06:39:34Z |
| publishDate | 2009-01-01 |
| publisher | Petra Christian University |
| record_format | Article |
| series | Jurnal Informatika |
| spelling | doaj.art-d70a957d73284a01a8871faed4291f6b2022-12-22T02:07:23ZengPetra Christian UniversityJurnal Informatika1411-01052009-01-011028693DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGISpits WarnarsData 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.http://puslit2.petra.ac.id/ejournal/index.php/inf/article/view/18250Data warehouseETLETL algorithmETL tableconstructive merge loading. |
| spellingShingle | Spits Warnars DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI Jurnal Informatika Data warehouse ETL ETL algorithm ETL table constructive merge loading. |
| title | DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI |
| title_full | DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI |
| title_fullStr | DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI |
| title_full_unstemmed | DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI |
| title_short | DESAIN ETL DENGAN CONTOH KASUS PERGURUAN TINGGI |
| title_sort | desain etl dengan contoh kasus perguruan tinggi |
| topic | Data warehouse ETL ETL algorithm ETL table constructive merge loading. |
| url | http://puslit2.petra.ac.id/ejournal/index.php/inf/article/view/18250 |
| work_keys_str_mv | AT spitswarnars desainetldengancontohkasusperguruantinggi |