Trigger generation in an active database management system

Details Trigger generation in an active database management system Trigger generation in an active database management system

1996-07-17

1997-10-21

Kulik, Paul V.

395616, 395676, 395683, G06F 1730

Patent

active

056806027

ABSTRACT:
Triggers for automatically starting an extract process in response to the committing of update data to a repository by an update process. In one embodiment, triggers are associated with particular extract processes and are started upon the committing of update data to the repository by an update process. Upon being started, each trigger determines whether any of the update data is within the extract view of the extract process that it is associated with and, if so, evaluates a predetermined condition specified for the trigger. If the condition is satisfied, the trigger translates the update data within the extract view into the extract view and starts the extract process. In another embodiment, triggers are bound to repository entities within the view of an extract process and are started upon the updating of the corresponding entities. Upon being started, each trigger evaluates a predetermined condition specified for entity post-image and, if the condition is satisfied, adds the post-image to data being accumulated for the extract process. Upon the commitment of the update, all extract processes for which data has been accumulated are started after making available the data accumulated for the process. In yet another embodiment, if the condition specified for the entity post-image is satisfied, the trigger executes a trigger query against the updated entity instance to dynamically generate a list of triggers which are then executed.

REFERENCES:
patent: 5133075 (1992-07-01), Risch
patent: 5471629 (1995-11-01), Risch
patent: 5592664 (1997-01-01), Starkey
Angelika M. Kotz et al., "Supporting Semautic Rules by a Generalized Event Trigger Mechanism,", Advances in Database Technology -EDBT '88, 1988, pp. 76-91.
"Improving the Software Process with Active Repositories" by H. Jasper, Universitat Oldenburg, FB Informatik, Oldenburg, Germany -pp. 379-390.
"Ode as an Active Database: Constraints and Triggers" by N. Gehani et al, Proceedings of the 17 International Conf. 9/91 -pp. 317-326.
"Rule management in Object Oriented Databases: A Uniform Approach" by O. Diaz et al, Proc. of the 17th International Conf. 9/91, pp. 317-326.
"Organizing Long-running Activities with Triggers and Transactions" by U. Dayal et al, 1990 ACM, pp. 204-214.
"The Architecture of an Active Data Base Management System" by D.R. McCarthy et al, 1989 ACM, pp. 215-224.
"Active Object-Oriented Database Design Using Active Object/Behavior Diagrams" by P. Bichler et al, 1994 IEEE Workshop, pp. 163-171.
"A Framework for Handling Errors. . .Object-Oriented DBMS" by H. Wang et al -1994 IEEE Workshop -pp. 132-136.
"Making a Federated System Active" by J.M. Blanco et al, Proc. of Dexa '92 Int. Conf. -Sept. 2-4, 1992, pp. 345-350.
"Design of Sentinel: An object-oriented DBMS with event-based rules" by S. Chakravarthy et al, Information and Software Technology Issue vol. 36, No. 9 pp. 555-568, 1994.
"Integrating Active and Deductive Rules" by J. Harrison et al, Proc. of 1st Int. Workshop, Aug./Sep. 1993 -pp. 288-305.
"Deriving Active Rules . . .Object-oriented Database" by O. Diaz -Proc of Dexa '92 Int'l Conf. Sep. 2-4, 1992, pp. 332-337.
"A Model for Active Ojbect Oriented Database" by C. Beeri et al -Proc. of the 17th Int'l Conf. 9/91 -pp. 337-349.
"Heterogeneous Object Model-View Relationships" by S. F. Griffin -IBM Technical Disclosure Bulletin -vol. 33, No. 6B, Nov. 1990 pp. 242-243.
"Object Integrity Using Rules" by C.Medieros and P. Pfeffer, pp.219-230, ECOOP'91, European Conference on Object-Oriented Programming, Jul. 1991.
"Rules Are Objects Too: A Knowledge Model For An Active,Object-Oriented Database System ", by Dayal et al, pp. 129-143, Advances In Object Oriented . . .Systems -9/27-9/30, 1988.
"Monitoring database Objects" by T. Risch, pp. 445-453, Proceedings of the Fifteenth International Conference on Very Large Data Bases, Aug. 22-25, 1989, Amsterdam.
"Extensions To Starburst: Objects, Types, Functions and Rules", by Guy M. Lohman et al, pp. 94-110, Oct. 1991, vol. 34, No. 10, Communications of the ACM.
"The Reflective Approach for Data-Driven Rules" by O. Etzion, Intelligent and Cooperative Information Systems, 1993 Int'l. Conf. IEEE, pp. 350-358.
"A Declarative Approach to Active Databases" by S. Ceri, Data Engineering, 1992 8th International Conference, pp. 452-456.

Affiliated with

Also associated with

Rating

Trigger generation in an active database management system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Trigger generation in an active database management system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Trigger generation in an active database management system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1015381