ISBN: 978-981-11-3671-9 DOI: 10.18178/wcse.2017.06.038
Case Study of ETL Java Code Generation from Domain Specific Language
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.