DocumentCode
3323928
Title
Orchid: Integrating Schema Mapping and ETL
Author
Dessloch, Stefan ; Hernandez, M.A. ; Wisnesky, Ryan ; Radwan, Ahmed ; Zhou, Jindan
Author_Institution
Dept. of Comput. Sci., Univ. of Kaiserslautern, Kaiserslautern
fYear
2008
fDate
7-12 April 2008
Firstpage
1307
Lastpage
1316
Abstract
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.
Keywords
data handling; formal specification; query processing; ETL; FastTrack; IBM Information Server; Orchid; abstract operator model; data flow specifications; data transformation toolkit; declarative mapping specifications; schema mapping; Computer science; Data engineering; Data flow computing; Data mining; Filtering; Merging; Programming profession; Prototypes; Software tools; Warehousing;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 2008. ICDE 2008. IEEE 24th International Conference on
Conference_Location
Cancun
Print_ISBN
978-1-4244-1836-7
Electronic_ISBN
978-1-4244-1837-4
Type
conf
DOI
10.1109/ICDE.2008.4497540
Filename
4497540
Link To Document