Browse Prior Art Database

Updating Profile Tables In Event Driven Business Analytics Applications Using Dynamic Configuration

IP.com Disclosure Number: IPCOM000237954D
Publication Date: 2014-Jul-23
Document File: 3 page(s) / 62K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for updating profile tables in event driven business analytics applications using dynamic configuration.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 3

Updating Profile Tables In Event Driven Business Analytics Applications Using Dynamic Configuration

Business analytics applications need to perform updates to profile or fact tables on a regular basis. A profile table can be updated by processing a batch of event data to perform calculations that aggregate the event data into the profile table. Extraction of dimensional and measurement data from the event, transformation of raw measurement data from the event into aggregated facts and loading the facts into the appropriate database table can be implemented by programmatic code.

Disclosed is a method and system for updating profile tables in event driven business analytics applications using dynamic configuration. According to embodiments of the present invention, updating the profile tables involves the use of data from incoming events and existing values in the profile tables as input to calculations. The calculations can be a group of mathematical aggregators that perform common mathematical functions or a custom calculation. The output values from the calculations are then used to update the profile tables.

In accordance with an embodiment of the present invention, the method and system performs configurable updating of profile tables by using static Extensible Markup Language (XML) configuration. The XML configuration can be utilized to define the data model, the calculations needed for fact aggregation, and reusable field mappings between the incoming event data, profile tables and calculations to facilitate extraction, transformation and loading at runtime. At runtime, an XML configuration facilitates the mapping of the incoming event to a series of steps that facilitate retrieval of a profile row from the database, aggregation of the fact data from the incoming event into the profile row and uploading it back into the database. The method and system reduces the overall complexity of customizing a solution by providing a layer to configure the profile table updates. Accordingly, the data model and mappings are defined in terms of metadata. Hence, dynamic configurable updates of the profile tables are possible by simply editing the metadata without modifying and recompiling program instructions.

The figure below illustrates the steps for updating a profile table in accordance with the method and system disclosed herein.

1


Page 02 of 3

Figure

As illustrated, when an incoming event is received, the profile update matching the event data can be selected for execution. Subsequently, a profile row associated with the selected profile update can be retrieved. There...