A domain-specific language for managing ETL processes
Чланак у часопису (Објављена верзија)
Метаподаци
Приказ свих података о документуАпстракт
Maintenance of Data Warehouse (DW) systems is a critical task because any downtime or data loss can have significant consequences on business applications. Existing DW maintenance solutions mostly rely on concrete technologies and tools that are dependent on: the platform on which the DW system was created; the specific data extraction, transformation, and loading (ETL) tool; and the database language the DW uses. Different languages for different versions of DW systems make organizing DW processes difficult, as minimal changes in the structure require major changes in the application code for managing ETL processes. This article proposes a domain-specific language (DSL) for ETL process management that mitigates these problems by centralizing all program logic, making it independent from a particular platform. This approach would simplify DW system maintenance. The platform-independent language proposed in this article also provides an easier way to create a unified environment to cont...rol DW processes, regardless of the language, environment, or ETL tool the DW uses.
Кључне речи:
Domain-specific language, Extraction transformation and loading, Data warehouse, Platform-independent models, Model-driven developmentИзвор:
PeerJ Computer Science, 26-01-2024, 10, e1835Издавач:
- PeerJ
Институција/група
Fakultet organizacionih naukaTY - JOUR AU - Popović, Aleksandar AU - Ivković, Vladimir AU - Trajković, Nikola AU - Luković, Ivan PY - 2024-01-26 UR - https://rfos.fon.bg.ac.rs/handle/123456789/2751 AB - Maintenance of Data Warehouse (DW) systems is a critical task because any downtime or data loss can have significant consequences on business applications. Existing DW maintenance solutions mostly rely on concrete technologies and tools that are dependent on: the platform on which the DW system was created; the specific data extraction, transformation, and loading (ETL) tool; and the database language the DW uses. Different languages for different versions of DW systems make organizing DW processes difficult, as minimal changes in the structure require major changes in the application code for managing ETL processes. This article proposes a domain-specific language (DSL) for ETL process management that mitigates these problems by centralizing all program logic, making it independent from a particular platform. This approach would simplify DW system maintenance. The platform-independent language proposed in this article also provides an easier way to create a unified environment to control DW processes, regardless of the language, environment, or ETL tool the DW uses. PB - PeerJ T2 - PeerJ Computer Science T1 - A domain-specific language for managing ETL processes IS - e1835 VL - 10 DO - doi.org/10.7717/peerj-cs.1835 ER -
@article{ author = "Popović, Aleksandar and Ivković, Vladimir and Trajković, Nikola and Luković, Ivan", year = "2024-01-26", abstract = "Maintenance of Data Warehouse (DW) systems is a critical task because any downtime or data loss can have significant consequences on business applications. Existing DW maintenance solutions mostly rely on concrete technologies and tools that are dependent on: the platform on which the DW system was created; the specific data extraction, transformation, and loading (ETL) tool; and the database language the DW uses. Different languages for different versions of DW systems make organizing DW processes difficult, as minimal changes in the structure require major changes in the application code for managing ETL processes. This article proposes a domain-specific language (DSL) for ETL process management that mitigates these problems by centralizing all program logic, making it independent from a particular platform. This approach would simplify DW system maintenance. The platform-independent language proposed in this article also provides an easier way to create a unified environment to control DW processes, regardless of the language, environment, or ETL tool the DW uses.", publisher = "PeerJ", journal = "PeerJ Computer Science", title = "A domain-specific language for managing ETL processes", number = "e1835", volume = "10", doi = "doi.org/10.7717/peerj-cs.1835" }
Popović, A., Ivković, V., Trajković, N.,& Luković, I.. (2024-01-26). A domain-specific language for managing ETL processes. in PeerJ Computer Science PeerJ., 10(e1835). https://doi.org/doi.org/10.7717/peerj-cs.1835
Popović A, Ivković V, Trajković N, Luković I. A domain-specific language for managing ETL processes. in PeerJ Computer Science. 2024;10(e1835). doi:doi.org/10.7717/peerj-cs.1835 .
Popović, Aleksandar, Ivković, Vladimir, Trajković, Nikola, Luković, Ivan, "A domain-specific language for managing ETL processes" in PeerJ Computer Science, 10, no. e1835 (2024-01-26), https://doi.org/doi.org/10.7717/peerj-cs.1835 . .