Back to results
US 2009/0024570 A1Published application
User defined query rewrite mechanism
AssigneeOracle Internatonal Corporation
InventorsAdiel Yoaz, Sriram Krishnamurthy, Qin Yu
Life of this patent
Estimating the term…
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.
Claims20
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.
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.
6 more elements
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.
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.
3 more elements
Dependencies are inferred from the claim text.