ISBN: 978-981-11-3671-9 DOI: 10.18178/wcse.2017.06.041
A Domain Specific Language for Scripting ETL Process
Abstract— Extract-Transform-Load, ETL, is considered as general preprocessing for data preparation of
heterogeneous sources such as data warehouse. The model-based ETL is user-friendly but hardly scales up
with large complex systems. This research thus presents an approach of code-based ETL of which the
commands are stated in a domain specific language, rather than programming or query languages. The DSL
has developed to support domain experts for scripting ETL processes without the requirement of
programming skill. This would result in less defects and resource consumption for the organization.
Index Terms— domain specific language, ETL, relational algebra, query, data warehouse.
Sunisa Junsawang, Yachai Limpiyakorn
Department of Computer Engineering, Chulalongkorn University, THAILAND
Cite: Sunisa Junsawang, Yachai Limpiyakorn, "A Domain Specific Language for Scripting ETL Process," Proceedings of 2017 the 7th International Workshop on Computer Science and Engineering, pp. 239-243, Beijing, 25-27 June, 2017.