USER DEFINED QUERY REWRITE MECHANISM

• US 20090024570A1
• Filed: 07/20/2007
• Published: 01/22/2009
• Est. Priority Date: 07/20/2007
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Yu, Qin, Yoaz, Adiel, Krishnamurthy, Sriram
• Application Number:
  US11/781,139
• Publication Number:
  US 20090024570A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24547 Optimisations to support specific applications; Extensibility of optimisers

Abstract

A database statement contains a table function. The database statement is compiled by a database statement compiler. The database statement is rewritten by replacing the table function with a replacement database statement.

Claims

1. A computer-implemented method, comprising:

compiling a database statement that contains a table function, wherein said compiling said database statement includes;

generating a replacement database statement for said table function, and

rewriting said database statement by replacing said table function with said replacement database statement.

2. The computer-implemented method of claim 1, wherein generating a replacement database statement includes calling a replacement function that generates the replacement database statement.

3. The computer-implemented method of claim 2,

wherein the steps further include determining that a replacement function is associated with the said table function;

and

wherein calling a replacement function is performed in response to determining that a replacement function is associated with said table function.

4. The computer-implemented method of claim 1,

wherein said table function is contained within a TABLE clause;

and

wherein rewriting said database statement includes replacing said TABLE clause.

5. The computer-implemented method of claim 1, wherein said table function is not enclosed within a TABLE clause.

11. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.

12. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2.

13. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 3.

14. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4.

15. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

6. A computer-implemented method, comprising:

compiling a first database statement that contains a table function, wherein compiling said first database statement includes;

executing a function to generate a first replacement database statement for said table function, and

rewriting said first database statement by replacing said table function with said replacement database statement;

compiling a second database statement that contains said table function, wherein said compiling said second database statement includes;

executing said function to return a second replacement database statement for said table function, and

rewriting said second database statement by replacing said table function with said second replacement database statement;

wherein the second replacement database statement is different than said first replacement database statement; and

wherein the implementation of said function is the same when the function is executed to generate said first replacement database statement and said second replacement database statement.

16. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 6.

7. The computer-implemented method, wherein the steps further include:

a database server receiving a DDL statement that defines said implementation; and

said database server storing metadata that defines said implementation.

17. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 7.

8. A computer-implemented method, comprising:

a database server receiving one or more DDL statements that define an function implementation for a certain function to call to generate a replacement database statement for a table function;

in response to receiving said one or more DDL statements, generating metadata that associates said function implementation with said table function;

said database server compiling a database statement that contains said table function, wherein compiling said database statement includes;

based on the metadata, determining to execute said certain function;

executing said certain function to generate a replacement database statement for said table function, and

rewriting said database statement by replacing said table function with said replacement database statement.

9. The computer-implemented method of claim 8, wherein said table function is a rewrite-only function.

10. The computer-implemented method of claim 8, wherein:

said one or more DDL statements define an object method of an object type and an implementation for said object method, wherein said certain function is said object-method; and

said one or more DDL statements associate said object type with said table function.

18. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.

19. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9.

20. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 10.