Flexible and Customizable NL Representation of Requirements for ETL processes
نویسندگان
چکیده
The design of an Extract – Transform – Load (ETL) workflow for the population of a Data Warehouse is a complex and challenging procedure. In previous work, we have presented an ontology-based approach to facilitate the conceptual design of an ETL scenario. In this paper, we elaborate on this work, by investigating the application of Natural Language (NL) techniques to the ETL environment and we present a flexible and customizable template-based mechanism for generating natural language representations for the ETL process requirements and operations.
منابع مشابه
Ontology-Driven Conceptual Design of ETL Processes Using Graph Transformations
One of the main tasks during the early steps of a data warehouse project is the identification of the appropriate transformations and the specification of inter-schema mappings from the source to the target data stores. This is a challenging task, requiring firstly the semantic and secondly the structural reconciliation of the information provided by the available sources. This task is a part o...
متن کاملBPMN-Based Conceptual Modeling of ETL Processes
Business Intelligence (BI) solutions require the design and implementation of complex processes (denoted ETL) that extract, transform, and load data from the sources to a common repository. New applications, like for example, real-time data warehousing, require agile and flexible tools that allow BI users to take timely decisions based on extremely up-to-date data. This calls for new ETL tools ...
متن کاملRequirements Analysis Method For Extracting-Transformation-Loading (Etl) In Data Warehouse Systems
The data warehouse (DW) system design involves several tasks such as defining the DW schemas and the ETL processes specifications, and these have been extensively studied and practiced for many years. The problems in heterogeneous data integration are still far from being resolved due to the complexity of ETL processes and the fundamental problems of data conflicts in information sharing enviro...
متن کاملNonlinear H Control for Uncertain Flexible Joint Robots with Unscented Kalman Filter
Todays, use of combination of two or more methods was considered to control of systems. In this paper ispresented how to design of a nonlinear H∞ (NL-H∞) controller for flexible joint robot (FJR) based on boundedUKF state estimator. The UKF has more advantages to standard EKF such as low bios and no need toderivations. In this research, based on spong primary model for FJRs, same as rigid robot...
متن کاملDynamic-ETL: a hybrid approach for health data extraction, transformation and loading
BACKGROUND Electronic health records (EHRs) contain detailed clinical data stored in proprietary formats with non-standard codes and structures. Participating in multi-site clinical research networks requires EHR data to be restructured and transformed into a common format and standard terminologies, and optimally linked to other data sources. The expertise and scalable solutions needed to tran...
متن کامل