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

Case Study of ETL Java Code Generation from Domain Specific Language

Sunisa Junsawang, Yachai Limpiyakorn

Abstract— Extract-Transform-Load, ETL, is the integration layer in data warehouse environment. The quality of ETL contributes to the accuracy and the correctness of data, it is expensive, though. This paper aims to improve the process productivity and usability. A domain-specific language has been developed for scripting ETL processes. Alternatively, the input of ETL scripts written by non-technical users in Excel format is also allowed. The paradigm of code-to-code transformation is applied for transforming the textual, domain-specific language into Java code. The etlDSL code generator is implemented with MVC architecture design. A case study and the user evaluation of the proposed approach are also discussed. The overall rating is satisfaction.

Index Terms— domain specific language, ETL, query, data warehouse, software process improvement.

Sunisa Junsawang, Yachai Limpiyakorn
Department of Computer Engineering, Chulalongkorn University, THAILAND


Cite: Sunisa Junsawang, Yachai Limpiyakorn, "Case Study of ETL Java Code Generation from Domain Specific Language," Proceedings of 2017 the 7th International Workshop on Computer Science and Engineering, pp. 219-223, Beijing, 25-27 June, 2017.