Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Database Systems pp 1–2Cite as

Web ETL

  • Living reference work entry
  • First Online:

  • 148 Accesses

Synonyms

ETL using Web data extraction techniques

Definitions

As ETL (acronym for extraction, transformation, and loading) is a well-established technology for the extraction of data from several sources, their cleansing, normalization, and insertion into a data warehouse (e.g., a business intelligence system), Web ETL stands for an ETL process where the external data to be inserted into the data warehouse is extracted from semi-structured Web pages (e.g., in HTML or PDF format) using Web data extraction techniques.

Particularly, back-end interchange of structured data just using the Web, e.g., two database systems exchanging data with Web electronic data interchange (EDI) technology (EDI stands for techniques and standards for the transmission of structured data, e.g., over the Web, in an application-to-application context.), is not a Web ETL process as no semi-structured data needs to be transformed using Web data extraction techniques.

Key Points

Powerful and efficient tools...

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

Recommended Reading

  1. Baumgartner R, Flesca S, Gottlob G. Visual web information extraction with Lixto. In Proceedings of the 27th International Conference on Very Large Data Bases; 2001. p. 119–28.

    Google Scholar 

  2. Baumgartner R, Frölich O, Gottlob G, Harz P, Herzog M, Lehmann P. Web data extraction for business intelligence: the Lixto approach. In Proceedings of the Datenbanksysteme in Business, Technologie und Web (BTW); 2005. p. 48–65.

    Google Scholar 

  3. Frölich O. Optimierung von Geschäftsprozessen durch Integrierte Wrapper-Technologien. Dissertation, Institute of Information Systems, Vienna University of Technology; 2006.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Lixto Software GmbH, Vienna, Austria

    Oliver Frölich

Authors
  1. Oliver Frölich
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Oliver Frölich .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, Georgia, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, Ontario, Canada

    M. Tamer Özsu

Section Editor information

  1. Computing Lab., Oxford Univ., Wolfson Building, Parks Road, OX1 3QD, Oxford, UK

    Georg Gottlob

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media New York

About this entry

Cite this entry

Frölich, O. (2016). Web ETL. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_1166-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_1166-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics

Search

Navigation