Matlab Routines Used for Real Time ETL Method


Article Preview

This paper describes how to build routines in Matlab environment for improved ETL process. New architecture real time ETL process stills automated without human – database administrator interference, in cost of reduced accuracy rendered by level of trust. This method is constructed in Matlab environment, due to simple transformation and convert routines and functions. Important is the selection of proper environment for implementation of real time ETL process. Using enhanced architecture of real time ETL process implemented in Matlab make this process stills automated without human – database administrator interference, in cost of reduced accuracy. This method provides a simple transformation and converting routines and functions. First we are describing advantages of Matlab environment followed by real time ETL process description and problem how to achieve real – time in real world. In next part we present our enhanced near real time ETL model with new architecture. And finally we show how to use Matlab routines and toolkit to achieve simplicity in ETL phases of data warehouse needed for simulation and modeling.



Edited by:

Mohamed Othman




R. Halenar, "Matlab Routines Used for Real Time ETL Method", Applied Mechanics and Materials, Vols. 229-231, pp. 2125-2129, 2012

Online since:

November 2012





[1] S. Westland, C. Ripamonty: Computational color science using Matlab, John Wiley & Sons, Ltd.; 2004. ISBN 0-470-84562-7 hardback.

[2] S. Kozielski, R. Wrembel, New Trends in Data Warehousing and Data Analysis,. Springer; 2009. ISBN 978-0-387-87430-2.

[3] L. Reeves, A Manager's Guide to Data Warehousing, Published by Wiley Publishing, Inc.; 2009. ISBN: 978-0-470-17638-2.

[4] P. Tanuska, O. Moravcik, P. Vazan, The base testing activities proposal,. In: DAAAM International Vienna 2009: No. 1 Annals of DAAAM for 2009 & Processings of the 20th International DAAAM Symposium. 25-28 November 2009, Vienna, Austria. ISSN 978-3-901509-70-4.


[5] M. Strémy, A. Eliáš: Virtual laboratory communication. In: Annals of DAAAM and Proceedings of DAAAM Symposium. - ISSN 1726-9679. - Vol. 20, No. 1 Annals of DAAAM for 2009 & Proceedings of the 20th international DAAAM symposium Intelligent manufacturing & automation: Focus on theory, practice and education, 25 - 28th November 2009, Vienna, Austria. - Vienna : DAAAM International Vienna, 2009. - ISBN 978-3-901509-70-4, s. 0139-0140.


[6] M. Kebisek, P. Schreiber, I. Halenar, Knowledge Discovery in Databases and its application in manufacturing,. In International workshop Innovation Information Technologies – Theory and Practice; 2010 September 06-10, Dresden, Germany, pp.204-207.

[7] A. Trnka, RFM Analysis as a Part of DMAIC Phases,. In: 2011 International Conference on Database and Data Mining (ICDDM 2011) : 25-27, March, 2011 : Proceedings / editors: Steve Thatcher and Liu Guiping. - Sanya : IEEE, 2011. - 1 CD-ROM. - ISBN 978-1-4244-9610-5. - S. 278-281.