×

Parallel optimized triggers in parallel processing database systems

  • US 6,374,236 B1
  • Filed: 12/04/1999
  • Issued: 04/16/2002
  • Est. Priority Date: 12/04/1999
  • Status: Expired due to Term
First Claim
Patent Images

1. A method for accessing a subject table in a computer system, comprising:

  • (a) defining a trigger for a subject table partitioned across a plurality of processing units of a computer system, wherein each of the processing units manages at least one partition of the subject table;

    (b) performing a triggering event in the computer system as defined by the trigger, wherein the triggering event is split into a plurality of step messages in order to access the subject table partitioned across a plurality of processing units of the computer system, each of the step messages is assigned to one of the processing units managing one or more of the partitions of the subject table, and at least some of the step messages can be performed simultaneously and in parallel by the processing units;

    (c) generating a spool table in the computer system in response to the triggering event, wherein the spool table stores one or more necessary records accessed from the subject table by the triggering event, the spool table has a plurality of partitions, each of the partitions of the spool table corresponds to one of the partitions of the subject table, and each of the processing units manages at least one of the partitions of the spool table; and

    (d) performing a triggered action in the computer system as defined by the trigger and in response to the triggering event, wherein the triggered action is split into a plurality of step messages in order to access the necessary records stored in the spool table, each of the step messages is assigned to one of the processing units managing one or more of the partitions of the spool table, and at least some of the step messages can be performed simultaneously and in parallel by the processing units.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×