Skip to main content
SpringerLink
Log in

Performance Issues in Data Extraction Methods of ETL Process for XML Format in Oracle 11g

  • Conference paper
Beyond Databases, Architectures, and Structures (BDAS 2014)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 424))

Abstract

The article presents problems of data extraction and transmission as a parts of ETL process based on Oracle database example. Taking into attention more and more widespread cloud computing technologies it must be noticed that bandwidth of data links could be a serious limitation nowadays. The article describes technologies useful for data extraction in xml format from Oracle database. Further, the comparison of different methods taking into account both efficiency and volume of data to be transmitted, is presented. Finally several proposals on tuning these parts of ETL process are developed. The purpose of the article is to point the most efficient way of data extraction in XML format for Oracle database according to any existing nonfunctional requirements such us software portability, bandwidth limitation etc.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Efficient xml interchange (January 2014), http://www.w3.org/XML/EXI/

  2. Extensible markup language (xml) (January 2014), http://www.w3.org/XML/

  3. Balboni, P., Fontana, F.: Cloud computing: A guide to evaluate and negotiate cloud service agreements in the light of the actual european legal framework. ICT Law Review 1, 12–17 (2013)

    Google Scholar 

  4. El-Sappagh, S.H.A., Hendawi, A.M.A., Bastawissy, A.H.E.: A proposed model for data warehouse ETL processes. Journal of King Saud University - Computer and Information Sciences 23(2), 91–104 (2011), http://www.sciencedirect.com/science/article/pii/S131915781100019X

    Article  Google Scholar 

  5. Geeta, A.: Oracle xml db: Choosing the best xml type storage option for your use case. Oracle Corporation (December 2009)

    Google Scholar 

  6. Graham, C., Correia, J., Coyle, D., Biscotti, F., Cheung, M., Contu, R., Dharmasthira, Y., Eid, T., Eschinger, C., Granetto, B., Swinehart, H.H., Mertz, S., Pang, C., Raina, A., Sommer, D., Sood, B., Wurster, M.D.L., Zhang, J.: Market share: All software markets (March 2012)

    Google Scholar 

  7. Harper, S.: Working with pl/sql, oracle Corporation (November 2007)

    Google Scholar 

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

    Chapter  Google Scholar 

  9. Kakish, K., Kraft, T.A.: Etl evolution for real-time data warehousing. In: Proceedings of the Conference on Information Systems Applied Research (2012) ISSN: 2167–1508

    Google Scholar 

  10. Snyder, S.L.: Efficient xml interchange compression and performance benefits: development, implementation and evaluation (March 2010)

    Google Scholar 

  11. Wiak, S., Drzymała, P., Welfle, H.: Using oracle tools to generate multidimensional model in warehouse. Przegld Elektrotechniczny (2012) ISSN: 0033–2097

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, 16 Akademicka St., 44-100, Gliwice, Poland

    Lukasz Wycislik

Authors
  1. Lukasz Wycislik
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Lukasz Wycislik .

Editor information

Editors and Affiliations

  1. Silesian University of Technology Inst. Computing Science, Gliwice, Poland

    Stanislaw Kozielski

  2. Silesian University of Technology Institute of Informatics, Gliwice, Poland

    Dariusz Mrozek

  3. Silesian University of Technology, Gliwice, Poland

    Pawel Kasprowski

  4. Silesian University of Technology, Gliwice, Poland

    Bożena Małysiak-Mrozek

  5. Silesian University of Technology, Gliwice,, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer International Publishing Switzerland

About this paper

Cite this paper

Wycislik, L. (2014). 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., Kostrzewa, D. (eds) Beyond Databases, Architectures, and Structures. BDAS 2014. Communications in Computer and Information Science, vol 424. Springer, Cham. https://doi.org/10.1007/978-3-319-06932-6_56

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-06932-6_56

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-06931-9

  • Online ISBN: 978-3-319-06932-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation