Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-01-21
1999-07-27
Kulik, Paul V.
Data processing: database and file management or data structures
Database design
Data structure types
395101, 395104, 395105, 395710, G06F 1730
Patent
active
059307951
ABSTRACT:
A framework for a query compiler and run-time environment for resolving a table reference to a dynamic table that is first identified at run-time but is initially unknown at compile-time. A parser parses the table reference and creates a parsed representation for the table that identifies the type of dynamic table. A code generator creates executable plans containing run-time table object representations (TAOB), from the parsed representations, that contain the type of dynamic table. The TAOB is also extended to provide for parameters that are definable at run-time, including a table ID of the actual table entity being referenced. A routine is embedded in a run-time routine that checks the type of dynamic table in the TAOB and dispatches control to one of a plurality of corresponding routines, depending upon the type of dynamic table. The corresponding routines use the extended TAOB to dynamically link the table reference to the dynamic table, depending upon the type of dynamic table. Once the dynamic table has been linked to the table reference, query processing continues as if that table were a base or derived table.
REFERENCES:
patent: 5093916 (1992-03-01), Karp et al.
patent: 5613120 (1997-03-01), Palay et al.
patent: 5615400 (1997-03-01), Cowsar et al.
patent: 5680619 (1997-10-01), Gudmundson et al.
Martin C. Sturzenbecker, "Building an Object-Oriented Environment for distributed Manufacturing Software", IEEE, pp. 1972-1978, Jan. 1991.
ISO-ANSI working Draft, "Information Technology--Database Language SQL", Jim Melton, editor, International Organization for Standardization and American National Standards Institute, Jul. 1992.
IBM Corporation, "IBM Database 2: SQL Reference--for common servers", Version 2, 1994,1995.
Chen Yao-Ching Stephen
Chow Jyh-Herng
Cochrane Roberta Jo
Fuh Gene Y.C.
Mattos Nelson Mendonca
Corrielus Joan M.
International Business Machines - Corporation
Kulik Paul V.
LandOfFree
Supporting dynamic tables in SQL query compilers does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Supporting dynamic tables in SQL query compilers, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Supporting dynamic tables in SQL query compilers will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-892987