Orchid: Integrating Schema Mapping and ETL

  title={Orchid: Integrating Schema Mapping and ETL},
  author={Stefan De\ssloch and Mauricio A. Hern{\'a}ndez and Ryan Wisnesky and Ahmed Radwan and Jindan Zhou},
  journal={2008 IEEE 24th International Conference on Data Engineering},
This paper describes Orchid, a system that converts declarative mapping specifications into data flow specifications (ETL jobs) and vice versa. Orchid provides an abstract operator model that serves as a common model for both transformation paradigms; both mappings and ETL jobs are transformed into instances of this common model. As an additional benefit, instances of this common model can be optimized and deployed into multiple target environments. Orchid is being deployed in FastTrack, a data… CONTINUE READING
Highly Cited
This paper has 81 citations. REVIEW CITATIONS


Publications citing this paper.
Showing 1-10 of 46 extracted citations

A schema aware ETL workflow generator

Information Systems Frontiers • 2014
View 5 Excerpts
Highly Influenced

METL: Managing and Integrating ETL Processes

VLDB PhD Workshop • 2009
View 4 Excerpts
Highly Influenced

Schema Mappings: From Data Translation to Data Cleaning

A Comprehensive Guide Through the Italian Database Research • 2018
View 1 Excerpt

PolyFuse: A Large-Scale Hybrid Data Fusion System

2017 IEEE 33rd International Conference on Data Engineering (ICDE) • 2017

81 Citations

Citations per Year
Semantic Scholar estimates that this publication has 81 citations based on the available data.

See our FAQ for additional information.


Publications referenced by this paper.
Showing 1-10 of 16 references

Clip: a Visual Language for Explicit Schema Mappings

2008 IEEE 24th International Conference on Data Engineering • 2008
View 1 Excerpt

Optimizing ETL processes in data warehouses

21st International Conference on Data Engineering (ICDE'05) • 2005
View 1 Excerpt

The Data Warehouse ETL Toolkit

R. Kimball, J. Caserta
Wiley Publishing, • 2004
View 1 Excerpt

Modeling and managing ETL processes

VLDB PhD Workshop • 2003
View 1 Excerpt

Rondo : A Programming Platform for Generic Model Management

SalesTaxRate ORDERS DID Quantity UnitPrice, O - DETAILS PID PName, +4 authors O - DETAILS PID PName PRODUCTS OID PID OrderID Order ProductName
View 1 Excerpt

Similar Papers

Loading similar papers…