Orchid: Integrating Schema Mapping and ETL

This paper describes Orchid, a system that converts declarative mapping specifications into data flow specifications s) 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 transformation toolkit in IBM Information Server.

• Type: Conference
• Year: 2008
• Where: ICDE
• Authors: Stefan Dessloch, Mauricio A. Hernández, Ryan Wisnesky, Ahmed Radwan, Jindan Zhou
• Keywords: Abstract Operator Model, Common Model, Data Transformation Toolkit, Database, ICDE 2008