System, method, and program for extending a SQL compiler for handling control statements packaged with SQL query statements
US5875334A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Oct 27, 1995 |
| Grant date | Feb 23, 1999 |
| Priority date | — |
| Expiry date | Oct 27, 2015 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24524
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
This invention provides an integrated compiler for compiling SQL3 control statements having procedural, i.e., control, information packaged together with query, i.e., non-procedural, statements. A query extractor contained within the parser extracts the query statement from the control statement leaving a control skeleton. The query statement is processed as usual through a query compiler for generating executable plans with the exception that the name resolution function for resolving variables is modified for looking up local variables. This modification takes into account the mapping of local and host variables to create a unification of local and host variables. The control skeleton is processed through a control analyzer which generates a representation of the control flow and a scope and symbol table. The control analyzer also unifies the local and host variables. A plan synthesizer then takes as input the control flow information, symbol tables, and individual executable plans for the query statements and generates a meta-plan comprising a merger of a top level plan for the control skeleton and sub-plans representing the executable plans of the query statement. Therefore, th…
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.