Boots – shoes – and leggings
Patent
1995-01-23
1998-02-10
Black, Thomas G.
Boots, shoes, and leggings
395611, 395612, 395700, 3642821, 3642804, 364DIG1, G06F 1730
Patent
active
057179115
ABSTRACT:
An SQL program executor and an SOL compiler both include options for avoiding recompilations of execution plans whenever the runtime object and the compile time object referenced by an execution plan meet predefined schema similarity criteria. Thus, recompilation is sometimes avoided even though the compile time object has been altered or the run time object is not the same object as the compile time object. To enable late binding, schema information is stored in each execution plan for each object to be accessed by the execution plan. The stored schema information is a subset of the full object schema, and includes information about all the aspects of the objects to be accessed which must remain unchanged in order for the execution plan to be operable. While executing a compiled program, the SQL executor avoids recompilations of execution plans whenever the runtime object and the compile time object referenced by an execution plan meet predefined schema similarity criteria. When a recompilation of an SQL program is required, only the execution plans which do not meet the schema similarity criteria are recompiled if the compiled program has been assigned appropriate runtime parameters. The late binding features of the SQL executor also enable a compiled program to access objects distinct from the objects referenced by the program at compile time. Similarly, the SQL compiler includes the ability to recompile only those execution plans which do not meet the schema similarity criteria and thus are inoperable.
REFERENCES:
patent: 5201046 (1993-04-01), Goldberg et al.
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5504885 (1996-04-01), Alashqur
patent: 5511190 (1996-04-01), Sharma et al.
"The Basic Principles of Query Optimization in Relational Database Management Systems"; J. Freytag; Information Processing 89, San Francisco, (Aug. 28-Sep. 1, 1989); No. Congress 11; pp. 801-807.
Celis Pedro
Davis Elizabeth G.
Gilbert Gary M.
Madrid Louise M.
Maier Donald S.
Black Thomas G.
Robinson Greta L.
Tandem Computers Inc.
LandOfFree
Relational database system and method with high availability com does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Relational database system and method with high availability com, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database system and method with high availability com will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2086542