System and method for query planning for execution using conditional operators

A query processing coordination planning unit for preparing a query processing to obtain requested data from one or more data sources, the query processing coordination planning unit comprising:

• a request preparation coordinator for preparing a user request for execution against one or more data sources using one or more query operation providers, the request preparation coordinator having:
• an operation support table service unit for providing information from an operation support table which describes supported operations of the query operation providers;
• a conditional operator handler for handling interpretation of a conditional query processing sequence defining a sequence of invocation of the query operation providers for preparing the user request, the conditional operator handler using the information provided by the operation support table service unit for the interpretation;
• and
• a sequence manager for managing invocation of the query operation providers in accordance with the conditional query processing sequence for translating a logical representation of the user request into a physical representation of a user request and generating an execution plan expressed by the physical representation of a user request for execution of the physical representation of the user request in accordance with the execution plan.

A method of preparing a user request for data from one or more data sources for execution, the method comprising the steps of:

• receiving a user query;
• interpreting a conditional query processing sequence defining a sequence of invocation of query operation providers;
• invoking the query operation providers in the conditional query processing sequence;
• translating a logical representation of the user request into a physical representation of a user request using the query operation providers invoked;
• and
• generating an execution plan expressed by the physical representation of a user request using the query operation providers for execution of the physical representation of the user request in accordance with the execution plan.

A memory containing computer executable instructions that can be read and executed by a computer for carrying out a method of preparing a user request for data from on one or more data sources for execution, the method comprising the steps of:

• receiving a user query;
• interpreting a conditional query processing sequence defining a sequence of invocation of query operation providers;
• invoking the query operation providers in the conditional query processing sequence;
• translating a logical representation of the user request into a physical representation of a user request using the query operation providers invoked;
• and
• generating an execution plan expressed by the physical representation of a user request using the query operation providers for execution of the physical representation of the user request in accordance with the execution plan.