Patent ID: 6470331
Filing Date: 2002-10-22
Classification: G06F,Y10S

Abstract:
A method for accessing a subject table in a computer system, comprising:(a) partitioning the subject table across a plurality of processing units of the computer system, wherein each of the processing units manages at least one partition of the subject table; (b) splitting a request to access the subject table into a pluality of step messages, wherein each of the step messages comprises one or more actions, 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) retrieving one or more necessary records for the actions from the partition of the subject table and storing the retrieved necessary records into a corresponding partition of a spool table, wherein the necessary records are selected in such a manner such that only one of the actions involved in the request needs to access the partition of the subject table; and (d) performing remaining ones of the actions against the corresponding partition of the spool table rather than the partition of the subject table.