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.
Powerful and efficient tools...
- 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