This paper presents a detailed framework for extracting process events from database management systems (DBMSs) for process analytics purposes. We analyze the standard auditing features of Oracle 12c and PostgreSQL 16 and evaluate their suitability for process mining applications. Based on this analysis, we propose optimized configurations for technological event collection. Four distinct methods of event collection are discussed in detail: interacting with audit files using log collectors, modifying custom procedures with HTTP request integration, implementing proxy servers between the DBMS and clients, and directly querying service tables. The practical implementation of each method is demonstrated, highlighting its respective advantages and disadvantages in terms of data comprehensiveness, system performance, and integration complexity. Experimental results indicate that a modular approach combining multiple collection methods offers the most robust solution. For process mining performing, our framework enables organizations to capture, normalize, and aggregate database events in an efficient manner, facilitating deeper insights into operational processes while maintaining system performance. The proposed solutions address key challenges in the collection of technical logs and provide a scalable architecture that supports advanced process analysis techniques.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Building a System for Collecting Process Events from Database Management Systems for the Purpose of Process Analytics Performing

  • Egor A Pogorelko,
  • Kirill D Yangel,
  • Lev M Bagnyuk,
  • Arina I Zakharova,
  • Yuliya V Gracheva,
  • Ilya V Ovsyannikov,
  • Timur R Abdullin

摘要

This paper presents a detailed framework for extracting process events from database management systems (DBMSs) for process analytics purposes. We analyze the standard auditing features of Oracle 12c and PostgreSQL 16 and evaluate their suitability for process mining applications. Based on this analysis, we propose optimized configurations for technological event collection. Four distinct methods of event collection are discussed in detail: interacting with audit files using log collectors, modifying custom procedures with HTTP request integration, implementing proxy servers between the DBMS and clients, and directly querying service tables. The practical implementation of each method is demonstrated, highlighting its respective advantages and disadvantages in terms of data comprehensiveness, system performance, and integration complexity. Experimental results indicate that a modular approach combining multiple collection methods offers the most robust solution. For process mining performing, our framework enables organizations to capture, normalize, and aggregate database events in an efficient manner, facilitating deeper insights into operational processes while maintaining system performance. The proposed solutions address key challenges in the collection of technical logs and provide a scalable architecture that supports advanced process analysis techniques.