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

1995-04-11

1996-10-08

Kulik, Paul V.

Boots, shoes, and leggings

364DIG1, 3642821, G06F 1730

Patent

active

055640478

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: 5471629 (1995-11-01), Risch
"Improving the Software Process with Active Repositories" by H. Jasper, Universitat Oldenburg, FB Informatik, Oldenburg, Germany-pp. 379-390.
"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.-Sep. 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 Object Oriented Database" by C. Beeri et al -Proc. of the 17th Int'l Conf. Sep. 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.
Guy M. Lohman et al., "Extensions to Starburst--Objects, Types, Functions and Rules," Next-Generation Database Systems, Communications of the ACM, Oct. 1991, vol. 34 No. 10, pp. 94-109.
Opher Etzion, "The Reflective Approach for Data-Driven Rules," 1993 Int'l Conf. on Intelligent and Cooperative Information Systems, IEEE, pp. 350-358.
Stefano Ceri, "A Declarative Approach to Active Databases," 1992 8th Int'l Conf. on Data Engineering, IEEE, pp. 452-456.
Tore Risch, "Monitoring Database Objects," Proceedings of 15th Int'l Conf. on Very Large Data Bases, Aug. 1989, pp. 445-453.
C. B. Medeiros et al., "Object Integrity Using Rules," Proceedings of ECOOP '91, Jul. 1991, pp. 219-230.
Umeshwar Dayal et al. "Rules are Objects Too: A Knowledge Model for an Active, Object-Oriented Database System," 2d Int'l Workshop on Object-Oriented Database Systems, Sep. 1988, pp. 129-143.
D. R. McCarthy et al.,"The Architecture of an Active Database Management System," SIGMOD Record, vol. 18 No. 2, Jun. 1989, pp. 215-224.
U. Dayal et al., "Organizing Long -Running Activities with Triggers and Transactions," SIGMOD Record, vol. 19 No. 2, Jun. 1990, pp. 204-214.
N. Gelani et al., "Ode as an Active Database: Constraints and Triggers," Proceedings of 17th Int'l Conf. on Very Large Data Bases, Sep. 1991, pp. 327-336.
Oscar Diaz et al., "Rule Management in Object Oriented Databases: A Uniform Approach," Proceedings of 17th Int'l Conf. on Very Large Data Bases, Sep. 1991, pp. 317-326.
Angelika M. Kotz et al.,"Supporting Semantic Rules by a Generalized Event/Trigger Mechanism," Advances in Database Technology-EDBT '88, 1988, pp. 76-91.

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-65420