Patent ID: 6684203
Filing Date: 2004-01-27
Classification: G06F,Y10S

Abstract:
A method for processing a given query that requires retrieval of data from a particular table and a join between the particular table and one or more constrained tables and that specifies one or more constraints on said one or more constrained tables, the method comprising the steps of;populating the particular table that is not referenced by said given query with data from a constrained table of said one or more constrained tables, wherein said data from said constrained table satisfies at least one constraint of said one or more constraints that constrain said constrained table; transforming the given query to produce a transformed query that references said particular table; causing every process responsible for execution of the given query to access data required from the constrained table by accessing said data from said particular table; and a plurality of slave processes each executing a portion of operations needed to execute said given query, wherein each of said plurality of slave processes accesses said particular table.