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.
Highlights
ETL merupakan sebuah proses penting yang merupakan bagian dari Data Warehouse yang berfungsi untuk mentransfer data yang ada pada basisdata transaksi kedalam basisdata Data Warehouse yang sudah dimodelkan sedemikian rupa berdasarkan hypercubes yang dibentuk berdasarkan laporan-laporan yang sering dipakai manajemen tingkat atas
trusted reports which is produced from Data Warehouse itself. Data Warehouse is
Data Warehouse is an environment where the transactional database is modelled in other view for decision making purposes
Summary
Fakultas Teknologi Informasi, Universitas Budi Luhur Jl. Petukangan Selatan, Kebayoran Lama, Jakarta 12260, Telepon: 021-5853753. Data Warehouse bukanlah sebuah perangkat lunak, perangkat keras atau perkakas akan tetapi Data Warehouse adalah suatu keadaan dimana database transaksi dimodelkan pada model lain yang ditujukan untuk membuat keputusan. Extraction, Transformation and Loading (ETL) adalah sebuah jembatan untuk membentuk Data Warehouse dan merubah data dari basisdata transaksi. Didalam setiap tabel fakta dan dimensi akan diselipkan dengan fields yang mencirikan pemanggilan constructive merge sebagai sebuah ETL proses. Proses ETL membutuhkan tabel ETL dan proses ETL dimana tabel ETL berfungsi sebagai padanan tabel antara tabel basisdata OLTP dan tabel pada Data Warehouse dan proses ETL akan mentransformasikan data yang berasal dari tabel pada basisdata OLTP kedalam tabel pada Data Warehouse berdasarkan tabel ETL. Kata kunci: Data warehouse, ETL, algoritma ETL, Tabel ETL, pemanggilan constructive merge
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
