By Topic

An agent-based approach to extending the native active capability of relational database systems

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

2 Author(s)
Lijuan Li ; Comput. & Inf. Sci. & Eng. Dept., Florida Univ., Gainesville, FL, USA ; Chakravarthy, S.

Event-condition-action (or ECA) rules are used to capture active capability. While a number of research prototypes of active database systems have been built, ECA rule capability in relational DBMSs is still very limited. 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 and active capability without changing the client programs; retain relational DBMS's underlying functionality; and persistence of ECA rules using the native database functionality. We describe how complete active database semantics can be supported on an existing SQL server (Sybase, 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

Published in:

Data Engineering, 1999. Proceedings., 15th International Conference on

Date of Conference:

23-26 Mar 1999