EXECUTION PLAN PREPARATION IN APPLICATION SERVER

• US 20130166588A1
• Filed: 12/22/2011
• Published: 06/27/2013
• Est. Priority Date: 12/22/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Gruschko, Boris, Friedmann, Bjoern, Mohr, Christian, Foebel, Florian, Strenge, Martin
• Granted Patent: US 9,002,813 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/24524 Access plan code generation and invalidation; Reuse of access plans
• CPC Class Codes: G06F 16/3344 using natural language analysis

Abstract

A system and method for execution plan preparation. One or more processors executing an application process of an application server receive a request from a client computer over a network. The one or more processors parse the request to determine one or more components of the request. An execution plan for the request is generated based on the one or more components determined by the parsing, and the execution plan is then sent to a database for execution of the request by a database process.

Claims

1. A computer-implemented method comprising:

receiving, by one or more processors executing an application process of an application server, a request from a client computer over a network;

parsing, by the one or more processors, the request to determine one or more components of the request;

generating, by the one or more processors, an execution plan for the request based on the one or more components determined by the parsing; and

sending, by the one or more processors, the execution plan to a database for execution of the request by a database process.

2. The method in accordance with claim 1, further comprising executing the request by the database process.

3. The method in accordance with claim 2, further comprising receiving, by the one or more processors executing the application process and from the database process, a reply representing the executed request.

4. The method in accordance with claim 1, wherein the execution plan is generated with metadata from a distributed metadata cache in the application server.

5. A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:

receiving a request from a client computer over a network;

parsing the request to determine one or more components of the request;

generating an execution plan for the request based on the one or more components determined by the parsing; and

sending the execution plan to a database for execution of the request by a database process.

6. A computer program product in accordance with claim 5, wherein the operations further comprise:

executing the request by the database process.

7. A computer program product in accordance with claim 6, wherein the operations further comprise:

receiving, from the database process, a reply representing the executed request.

8. A computer program product in accordance with claim 5, wherein the execution plan is generated with metadata from a distributed metadata cache in an application server.

9. A system comprising:

at least one programmable processor associated with an application server; and

a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one programmable processor to perform operations comprising;

receiving a request from a client computer over a network;

parsing the request to determine one or more components of the request;

generating an execution plan for the request based on the one or more components determined by the parsing; and

sending the execution plan to a database for execution of the request by a database process.

10. A system in accordance with claim 9, wherein the execution plan is generated with metadata from a distributed metadata cache in the application server.