Scheduling Optimization For Extract, Transform, Load (ETL) Process On Data Warehouse Using Round Robin Method (Case Study: University Of XYZ)

Authors

  • Agung Yudha Berliantara Universitas Brawijaya
  • Satrio Agung Wicaksono Universitas Brawijaya
  • Aryo Pinandito Universitas Brawijaya

DOI:

https://doi.org/10.25126/jitecs.20172232

Abstract

ETL scheduling is a challenging and exciting issue to solve. The ETL scheduling problem has many facets, one of which is the cost of time. If it is not handled correctly, it may take a very long time to execute and inconsistent data in very large data. In this study using Round-robin algorithm method that proved able to produce efficient results and in accordance with conventional methods. After doing the research, the difference between these two methods is about execution time. Through this experiment, the Round-robin scheduling method gives a more efficient execution time of up to 61% depending on the amount of data and the number of partitions used.

References

U. Brawijaya, “Universitas Brawijaya,†Universitas Brawijaya, [Online]. Available: http://www.ub.ac.id/. [Accessed 8 November 2016].

R. Kimball dan J. Caserta, The Data Warehouse ETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, Wiley, 2004.

A. Karagiannis, P. Vassiliadis dan AlkisSimitsis, “Scheduling strategies for efficient ETL execution,†Elsevier, 2013.

P. Krzyzanowski, “Paul Krzyzanowski's Site,†2015. [Online]. Available: https://www.cs.rutgers.edu/~pxk/416/notes/07-scheduling.html. [Accessed 18 September 2016].

R. Sreekumar dan S. Balaji, “ETL Scheduling in Real-Time Data Warehousing,†International Journal of Computer Science & Engineering Technology (IJCSET), vol. 5, 2014.

M. Bala, O. Boussaid dan Z. Alimazighi, “P-ETL: Parallel-ETL based on the MapReduce Paradigm,†IEEE, 2014.

S. Kozielski dan R. Wrembel, New Trends in Data Warehousing and Data Analysis, 3rd penyunt., Springer Science & Business Media, 2008.

Sybase Inc., “SyBooks Online,†2009. [Online]. Available: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1550/html/sqlug/sqlug448.htm. [Accessed10 November 2016].

J. Bernardino dan H. Madeira, “Experimental Evaluation of a New Distributed Partitioning Technique for Data Warehouses,†IEEE, pp. 318-319, 2001.

Downloads

Published

2017-12-04

How to Cite

Berliantara, A. Y., Wicaksono, S. A., & Pinandito, A. (2017). Scheduling Optimization For Extract, Transform, Load (ETL) Process On Data Warehouse Using Round Robin Method (Case Study: University Of XYZ). Journal of Information Technology and Computer Science, 2(2). https://doi.org/10.25126/jitecs.20172232

Issue

Vol. 2 No. 2: November 2017

Section

Articles

License

Creative Commons License Creative Common Attribution-ShareAlike 3.0 International (CC BY-SA 3.0)

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).