WCSE 2017
ISBN: 978-981-11-3671-9 DOI: 10.18178/wcse.2017.06.041

A Domain Specific Language for Scripting ETL Process

Sunisa Junsawang, Yachai Limpiyakorn

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.