×

Rewriting table functions as SQL strings

  • US 20060235837A1
  • Filed: 04/18/2005
  • Published: 10/19/2006
  • Est. Priority Date: 04/18/2005
  • Status: Active Grant
First Claim
Patent Images

1. A relational database management system of the type wherein a table function returns a set of result rows which are represented in an SQL statement by a container for the table function, the relational database management system having the improvement comprising:

  • a rewrite method associated with the table function that returns an SQL string that when executed will return an equivalent set of result rows, the relational database system executing the rewrite method prior to executing the container to obtain the SQL string and thereupon rewriting the SQL statement such that the container for the table function is replaced by the returned SQL string.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×