Automated client/server operation partitioning

• US 8,364,751 B2
• Filed: 06/25/2008
• Issued: 01/29/2013
• Est. Priority Date: 06/25/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Meijer, Erik, Kulkarni, Dinesh Chandrakant, Warren, Matthew J., Hejlsberg, Anders
• Primary Examiner(s): Patel, Ashok
• Assistant Examiner(s): GOLDBERG, ANDREW C
• Application Number:
  US12/145,523
• Publication Number:
  US 20090327220A1
• Time in Patent Office: 1,679 Days
• Field of Search: 707/3
• US Class Current: 709/203
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

An operation (such as a relational query) may be processed on a processing engine (such as a relational database server) on behalf of a client. A conventional processing involves the delivery of the operation to the processing engine, which executes the entire operation to completion and returns a result data set. It may be more efficient to allocate part of the operation to be performed on the client, but a developer may be unable or unavailable to rewrite the operation in a distributed manner. Instead, the operation may be automatically partitioned into a pre-engine client portion, a processing engine portion, and a client portion, and the instructions of each portion may be automatically allocated respectively to the client, the server, and the client. The partitioning may be adjusted to conserve computing resources, such as bandwidth and storage, and the instructions may be reordered to improve the processing of the operation.

Claims

1. A method of evaluating an operation comprising instructions to process by a processing engine for a client on a device having a processor, the method comprising:

executing on the processor instructions to;

partition the operation into a partitioned operation having a pre-engine portion executed by the client, a processing engine portion executed by the processing engine, and a post-engine portion executed by the client;

after partitioning the operation between a first instruction in the client executed portion and a last instruction in the processing engine portion, adjust the partitioned operation according to at least one instruction adjusting rule by moving at least one instruction other than the first instruction in the client executed portion and the last instruction in the processing engine portion to the other of the processing engine portion and the client executed portion;

execute the pre-engine portion at the client to produce a pre-engine partially executed operation;

send the pre-engine partially executed operation to the processing engine;

receive a processing engine partially executed operation from the processing engine after sending the pre-engine partially executed operation; and

execute the post-engine portion of the computing engine partially executed operation at the client to complete the operation execution.

2. The method of claim 1:

the processing engine comprising a relational data query processor, and

the operation comprising a relational query targeting data accessible to the relational data query processor.

3. The method of claim 1, the operation comprising a language integrated query specified in a programming language.

4. The method of claim 1, the partitioning comprising:

expanding portions of the partitioned query executed by one of the client and the processing engine, and

equivalently compacting portions of the partitioned query executed by the other of the client and the processing engine.

5. The method of claim 4, the partitioning between the client and the processing engine related to at least one of:

processing capacity of the processing engine;

processing capacity of the client;

computational load of the processing engine;

computational load of the client;

storage capacity of the processing engine;

storage capacity of the client; and

communications capacity between the processing engine and the client.

6. The method of claim 1, the partitioning comprising reducing the size of at least one of the pre-engine partially executed operation and the processing engine partially executed operation.

7. The method of claim 1, an instruction adjusting rule comprising:

identifying a compacting instruction in the post-engine portion that compacts the post-engine portion and can be equivalently executed in the processing engine portion, and

upon identifying the compacting instruction, moving the compacting instruction to the processing engine portion.

12. The method of claim 1, sending the pre-engine partially executed operation to the processing engine comprising:

identifying an processing engine expression tree portion comprising a portion of the expression tree to be executed by the processing engine; and

sending the pre-engine partially executed operation and the processing engine expression tree portion to the processing engine.

8. A storage device storing instructions to evaluate an operation to process by a processing engine for a client, the instructions comprising:

partitioning the operation into a partitioned operation having a pre-engine portion executed by the client, a processing engine portion executed by the processing engine, and a post-engine portion executed by the client, and

after partitioning the operation between a first instruction in the client executed portion and a last instruction in the processing engine portion, adjust the partitioned operation according to at least one instruction adjusting rule by moving at least one instruction other than the first instruction in the client executed portion and the last instruction in the processing engine portion to the other of the processing engine portion and the client executed portion;

executing the pre-engine portion at the client to produce a pre-engine partially executed operation, and

executing the post-engine portion of a processing engine partially executed operation at the client to complete the operation execution;

sending the pre-engine partially executed operation produced by the client executed portion execution component to the processing engine, and

receiving the processing engine partially executed operation from the processing engine after sending the pre-engine partially executed operation.

9. The system of claim 8, the operation comprising a language integrated query specified in a programming language.

10. The system of claim 8, comprising:

an expression tree transforming component configured to transform the operation into an expression tree before the partitioning.

13. The system of claim 8, the processing engine communications component configured to:

identify an processing engine expression tree portion comprising a portion of the expression tree to be executed by the processing engine; and

send the pre-engine partially executed operation and the processing engine expression tree portion to the processing engine.

11. A method of evaluating an operation comprising a language-integrated query to process by a processing engine comprising a relational data query processor for a client on a device having a processor, the method comprising:

executing on the processor instructions to;

transform the operation into an expression tree;

partition the operation into a partitioned operation having a pre-engine portion executed by the client, a processing engine portion executed by the processing engine, and a post-engine portion executed by the client;

expand at least one portion of the partitioned query executed by one of the client and the processing engine, and equivalently compacting portions of the partitioned query executed by the other of the client and the processing engine, related to at least one of;

processing capacity of the processing engine,

processing capacity of the client,

computational load of the processing engine,

computational load of the client,

storage capacity of the processing engine,

storage capacity of the client, and

communications capacity between the processing engine and the client;

after partitioning the operation between a first instruction in the client executed portion a last instruction in the processing engine portion, adjust the partitioned operation according to at least one instruction adjusting rule by moving at least one instruction other than the first instruction in the client executed portion and the last instruction the processing engine portion to the other of the processing engine portion and the client executed portion according to instruction adjusting rules comprising at least one of;

upon identifying a compacting instruction in the post-engine portion that compacts the post-engine portion and be equivalently executed in the processing engine portion, moving the compacting instruction to the processing engine portion;

upon identifying a compacting instruction in the processing engine portion that compacts the processing engine portion and be equivalently executed in the pre-engine portion, moving the compacting instruction to the pre-engine portion;

upon identifying a compacting instruction that compacts the operation, follows a computationally intensive instruction, and be equivalently executed before the computationally intensive instruction, moving the compacting instruction before the computationally intensive instruction;

upon identifying a relocatable instruction in the processing engine component that is preferably executed by the client, follows an unrelocatable instruction that is preferably executed by the processing engine, and be equivalently executed in the pre-engine portion, moving the relocatable instruction into the pre-engine portion;

upon identifying a relocatable instruction in the processing engine component that is preferably executed by the client, is preceded by an unrelocatable instruction that is preferably executed by the processing engine, and be equivalently executed in the post-engine portion, moving the relocatable instruction into the post-engine portion;

upon identifying a relocatable instruction in the pre-engine component that is preferably executed by the processing engine, precedes an unrelocatable instruction that is preferably executed by the client, and be equivalently executed in the processing engine portion, moving the relocatable instruction into the processing engine portion; and

upon identifying a relocatable instruction in the post-engine component that is preferably executed by the processing engine, follows an unrelocatable instruction that is preferably executed by the client, and be equivalently executed in the processing engine portion, moving the relocatable instruction into the processing engine portion;

execute the pre-engine portion at the client to produce a pre-engine partially executed operation;

send the pre-engine partially executed operation to the processing engine;

receive a processing engine partially executed operation from the processing engine after sending the pre-engine partially executed operation; and

execute the post-engine portion of the computing engine partially executed operation at the client to complete the operation execution.