TTL: a transformation, transference and loading approach for active monitoring
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
| Hi-index | 0.00 |
Enterprise information management systems deal with management of business information within organizations in order to support decision-making processes or day-to-day operations that require the availability of knowledge. The business information from such systems is typically analyzed using monitoring systems that are designed with traditional data-warehouse and batch ETL (extract, transform and load) technologies. Often, the batch nature of such technologies imposes undesirable delays in the visibilities and evaluation of the performance, opportunity, and threats for the rapidly changing business environment. In this paper, we present the architecture and implementation of a business performance monitoring system with real-time monitoring capability for an enterprise information management system that handles electronic contracts. A novel capture, transform, and update process based on database triggers that is capable of incrementally updating the performance data warehouse in real time will be given in detail. To simplify and support real-time data, an effective data model based on database views to combine historical and real time data is introduced in the data store of the monitoring system. An actual implementation of a performance monitoring dashboard will be given to demonstrate the effectiveness and practicability of our architecture.