Modelling long duration transactions with time constraints in active database

The applications like situation assessment, object tracking, trading & stock control, and workflow management require actions to be taken in stringent time frame for full benefit of the system. These applications also require identifying the occurrence of desired event, to take appropriate action when an event of interest is found to have occurred while maintaining timing constraints. Active database with ECA rule provides the mechanism to capture the different database events and provide timely response but do not guarantee timely processing of real time transactions because of their inability to express time constraints explicitly. Most of the time constrained real life application requires both active and real time characteristics. Long duration transactions with explicit time constraints are more vulnerable to failures and they are subject to heavy compensations in case of aborts. The paper intends to investigate the construct required for modelling of transactions with timing constraints, cooperation semantics and run time monitoring of these constraints in active database.