Abstract
Abstract In real-time Business Analytics scenarios, like Business Activity Monitoring (BAM) or Operational Intelligence, speeding up ETL is fundamental to provide business users with up-to-date data in order to support decision-making process and to optimize business operations. Conventional ETL processes extract data from heterogeneous operational data sources, transform them according to some predefined semantic and syntactic rules, and finally load results into a new (relational or data warehouse) model, in order to be processed both for business monitoring or analysis. Usually the whole loading process is presented as a technical aspect, far from business facts. In real-time Business Analytics context the traditional ETL approach can still be valid, provided that ETL process has to be designed in a way that circumscribes individual business events and facts and makes them independent one from another. In this context we propose a control-flow- based approach to ETL process modeling, which starts from business facts identification, and represents ETL processes using BPMN notation, which is the foundation for machine-readable code. Our main contribution consists in a proposal for structuring ETL processes and related objects and in its application to a business case.
Published Version
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.