Active database systems for monitoring and surveillance
ISI'03 Proceedings of the 1st NSF/NIJ conference on Intelligence and security informatics
The scheme design for active information system
KES'06 Proceedings of the 10th international conference on Knowledge-Based Intelligent Information and Engineering Systems - Volume Part II
| Hi-index | 0.00 |
Event-condition-action (or ECA) rules are used to capture active capability. While a number of research protorypes of active database systems have been built, ECA rule capability in Relational DBA4Ss is still vey limited. In this paper, we address the problem of turning a traditional database management system into a full-fledged active database system without changing the underlying system. The advantages of this approach are: transparency; ability to add active capability without changing the client programs,. retain relational DBMS's underlying functionality; and persistence of ECA rules using the native database functionality. In this paper we describe how complete active database semantics can be supported on an existing SQL Server (Sybuse, in our case) by adding a mediator, termed ECA Agent, between the SQL Server and the clients. ECA rules are fully supported through the ECA Agent without changing applications or the SQL Server. Composite events are detected in the ECA Agent and actions are invoked in the SQL Server. Events are persisted in the native database system. ECA Agent is designed to connect to SQL Server by using Sybase connectivity products. The architecture, design, and implementation details are presented in this paper.