Method for efficient query execution using dynamic queries in database environments

A method providing query execution plans for distributed database environments having distributed partitioned views comprising the steps of:

• analyzing offered queries to determine if said offered queries comprise predicate expressions and/or sub-queries;
• providing dynamic start-up filters for inclusion in query execution plans, said start-up filters, when applied, removing redundant partitions from query plan execution, wherein the dynamic start-up filters are chosen based on the predicate expressions found in the offered queries;
• classifying said offered queries according to whether said offered queries comprise predicate expressions and sub-queries;
• executing a function to generate start-up expressions for said offered queries having said predicate expressions;
• executing a function to generate start-up conjunctions such that an array of conjunction expressions rgTemp is created for each of said predicate expressions found in said offered queries;
• and
• generating a set of conjunctions for storage in a conjunction array for each of said predicate expressions.

A method providing query execution plans for distributed database environments having distributed partitioned views comprising the steps of:

• analyzing offered queries to determine if said offered queries comprise predicate expressions and/or sub-queries;
• providing dynamic start-up filters for inclusion in query execution plans, said start-up filters, when applied, removing redundant partitions from query plan execution, wherein the dynamic start-up filters are chosen based on the predicate expressions found in the offered queries;
• classifying said offered queries according to whether said offered queries comprise predicate expressions and sub-queries;
• executing a function to generate start-up expressions for said offered queries having said sub-queries;
• executing a function to generate query start-up conjuncts, said query start-up conjuncts generation function producing an array of conjunction expressions rgTemp1;
• performing a check to determine if said rgTemp1 array contains conjuncts;
• returning no start-up filters if no conjuncts are present in said rgTemp1 array;
• and
• returning conjunctions of all conjuncts present in said rgTemp1 array.

A method providing query execution plans for distributed database environments having distributed partitioned views comprising the steps of:

• analyzing offered queries to determine if said offered queries comprise predicate expressions and/or sub-queries;
• providing dynamic start-up filters for inclusion in query execution plans, said start-up filters, when applied, removing redundant partitions from query plan execution, wherein the dynamic start-up filters are chosen based on the predicate expressions found in the offered queries;
• classifying said offered queries according to whether said offered queries comprise predicate expressions and sub-queries;
• executing a function to generate start-up expressions for said offered queries having said sub-queries;
• executing a function to generate query start-up conjuncts, said query start-up conjuncts generation function producing an array of conjunction expressions rgTemp1;
• performing a check to determine if said query is an operator with a predicate expression and the operator only returns matches by applying expressions;
• executing a function to generate start-up conjunctions on the expression;
• executing a function to generate query start-up conjuncts on each child executed if the result of the parent execution is the execution of the child and the output value from the child is returned;
• storing results in said rgTemp1 array;
• and
• returning said rgTemp1 array.