Patent
1995-10-27
1999-02-23
Trammell, James P.
G06F 945
Patent
active
058753346
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, this invention provides a uniform way of treating local and host variables, provides an efficient way of performing bind-in/bind-out processes, creates a single execution plan requiring only a single run-time interpreter, and requires minimum enhancements to existing SQL2 compilers. In addition, this invention enables the application of global optimization techniques for optimizing both the control aspects and query aspects of the original control statement.
REFERENCES:
patent: 5201046 (1993-04-01), Goldberg et al.
patent: 5291582 (1994-03-01), Bapat
patent: 5432930 (1995-07-01), Song
patent: 5487132 (1996-01-01), Cheng
patent: 5546570 (1996-08-01), McPherson, Jr. et al.
patent: 5617567 (1997-04-01), Doktor
patent: 5675804 (1997-10-01), Sidik et al.
Chow Jyh-Herng
Fuh You-Chin (Gene)
Mattos Nelson Mendonca
Tran Brian T.
Chavis John Q.
Dawkins Marilyn Smith
International Business Machines - Corporation
Trammell James P.
LandOfFree
System, method, and program for extending a SQL compiler for han does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System, method, and program for extending a SQL compiler for han, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System, method, and program for extending a SQL compiler for han will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-314733