etl processes and scheduled automated processe

#ETL PROCESSES AND SCHEDULED AUTOMATED PROCESSE GENERATOR#

#ETL PROCESSES AND SCHEDULED AUTOMATED PROCESSE GENERATOR#

Thus the execution environment consists of code generator components and the components implementing the application framework. It should be emphasized that ETL-PL actually presumes the dynamic execution of ETL models or, more precisely, the executable code is generated at runtime. To this end, a specific ETL platform (ETL-PL) is introduced to technologically support both the modeling of ETL processes (i.e., the creation of models in accordance with the introduced DSLs) and the automated transformation of the created models into the executable code of a specific application framework (representing ETL-PL’s execution environment).

The focus of this paper is the actual implementation of the formal specification of an ETL process. Thus, in accordance with the DSM approach, several new domain-specific languages (DSLs) are introduced, each defining concepts relevant for a specific aspect of an ETL process. The proposed solution is based on the formal specification of ETL processes and the implementation of such formal specifications. This paper proposes a novel solution for automating ETL processes using the domain-specific modeling (DSM) approach. As a result, current research in this area is focused on ETL process conceptualization and the automation of ETL process development. Yet, the dynamics of modern business systems demand a more agile and flexible approach to their development. Information Systems and e-Business Management, 36 pagesĪbstract The development of Extract–Transform–Load (ETL) processes is the most complex, time-consuming and expensive phase of data warehouse development. Automating ETL processes using the domain-specific modeling approach

Etl processes and scheduled automated processe