This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
2008 IEEE 24th International Conference on Data Engineering
Orchid: Integrating Schema Mapping and ETL
Cancun, Mexico
April 07-April 12
ISBN: 978-1-4244-1836-7
Stefan Dessloch, Department of Computer Science, University of Kaiserslautern, Kaiserslautern, Germany. dessloch@informatik.uni-kl.de
Mauricio A. Hernandez, IBM Almaden Research Center, San Jose, CA, US. mauricio@almaden.ibm.com
Ryan Wisnesky, School of Engineering and Applied Sciences, Harvard University, Cambridge, MA, US. ryan@eecs.harvard.edu
Ahmed Radwan, Department of Electrical and Computer Engineering, University of Miami, Miami, FL, US. a.radwan@umiami.edu
Jindan Zhou, Department of Electrical and Computer Engineering, University of Miami, Miami, FL, US. j.zhou@umiami.edu
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 transformation toolkit in IBM Information Server.
Citation:
Stefan Dessloch, Mauricio A. Hernandez, Ryan Wisnesky, Ahmed Radwan, Jindan Zhou, "Orchid: Integrating Schema Mapping and ETL," icde, pp.1307-1316, 2008 IEEE 24th International Conference on Data Engineering, 2008
Usage of this product signifies your acceptance of the Terms of Use.