Abstract
The paper, presents an approach to developing and running ETL processes implemented in Oracle Data Integrator (ODI), on the example of a hospital information system. Thanks to inversion of the classical order of ETL stages to Extract-Load-Transform (ELT) sequence, ODI simplifies and improves efficiency of most common ETL tasks. Several new features introduced in 12c version positively affects productivity, efficiency and functionality as well.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Burns, D.: Tuning parallel execution, http://oracledoug.com/px.pdf (visited on November 2014)
Espinosa, R.: ETLs: Talend open studio vs pentaho data integration (kettle). comparative, https://churriwifi.wordpress.com/2010/06/01/comparing-talend-open-studio-and-pentaho-data-integration-kettle/ (visited on November 2014)
Jestratjew, A., Kwiecień, A.: Using cloud storage in production monitoring systems. In: Kwiecień, A., Gaj, P., Stera, P. (eds.) CN 2010. CCIS, vol. 79, pp. 226–235. Springer, Heidelberg (2010)
Kakish, K., Kraft, T.A.: ETL evolution for real-time data warehousing. In: Proceedings of the Conference on Information Systems Applied Research (2012)
Levin, J.: Open source ETL tools vs commercial ETL tools http://www.jonathanlevin.co.uk/2008/03/open-source-etl-tools-vs-commerical-etl.html (visited on November 2014)
Shaker, H., El-Sappagha, A., Abdeltawab, M., Hendawib, A., El Bastawissyb, A.H.: A proposed model for data warehouse ETL processes. Journal of King Saud University - Computer and Information Sciences 23, 91–104 (2011)
Testut, J.: Oracle data integrator 12c architecture overview (February 2014), http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf (visited on November 2014)
Wiak, S., Drzymała, P., Welfle, H.: Using ORACLE tools to generate multidimensional model in warehouse. Przeglad Elektrotechniczny, 0033–2097 (2012)
Wycislik, L.: Access control system based on generalization of RBAC model-concept, architecture and sample implementation. Technologie przetwarzania danych. TPD 2010. III Konferencja naukowa, Poznan, 21-23 czerwca 2010. Materialy konferencyjne (2010)
Wycislik, L.: Performance issues in data extraction methods of ETL process for XML format in oracle 11g. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B. (eds.) BDAS 2014. CCIS, vol. 424, pp. 581–589. Springer, Heidelberg (2014)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Wycislik, L., Augustyn, D.R., Mrozek, D., Pluciennik, E., Zghidi, H., Brzeski, R. (2015). E–LT Concept in a Light of New Features of Oracle Data Integrator 12c Based on Data Migration within a Hospital Information System. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_17
Download citation
DOI: https://doi.org/10.1007/978-3-319-18422-7_17
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-18421-0
Online ISBN: 978-3-319-18422-7
eBook Packages: Computer ScienceComputer Science (R0)