Previous Topic: Adapter Feature Advanced TopicsNext Topic: Adapter Configuration File with Event Singularity


Event Singularity

Event singularity is an Adapter mechanism that provides a process which prevents insertion of duplicate raw data into the T_Raw_Data table.

Without Event singularity, when the Adapter runs against a data source and loads Events into the database, no validation is performed for an identical event. The Event Singularity feature resolves this by providing the ability to specify whether or not to check Events for their singularity before insertion and what to do if the situation should occur. This verification process may, however, adversely impact the performance of the Adapter.

The solution enables the user to define a key, which can be based on the fields of the Event. Such a key represents the Event's uniqueness, which means that if two Events have same key, they are identical Events.

It is also possible to specify what action is taken in the event that a duplicate key is already found in the database. These actions are discussed below.

Note: The key can be defined as a combination of several fields from the Translator.