US5995974A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Database server for handling a plurality of user defined routines (UDRs) expressed in a plurality of computer languages
Assignee: International Business Machines Corp
•
Filing: 1997-08-27
•
Granted: 1999-11-30
•
Expires: 2017-08-27
Abstract
Abstract User Defined Routines (UDRs), capable of being expressed in one or more languages, are handled by determining a language native to the UDR, for example, by looking up a system catalog. If a language manager associated with the native language has not been loaded already, the language manager is loaded into a server memory. If the UDR has not already been instantiated, the UDR is instantiated and initialized. Then an execution context for the UDR is created and the UDR is executed. Loading of the language manager is handled by a general language interface capable of initializing the language manager, loading the language manager, creating a language manager context, and executing the language manager.
Inventors
- 👤 Jeffrey A. Anton
- 👤 Michael F. Schippling
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 21:49
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2433; G06F16/2438; G06F16/245; G06F16/2452; Y; Y10; Y10S; Y10S707/00; Y10S707/912; Y10S707/922; Y10S707/953; Y10S707/961; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99944
Claims Analysis
Total Claims: 23
Claim 1
Independent Claim
100 words
A method, performed bv a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and providing a Java language manager which communicates with a Java virtual machine using shared memory.
Claim 2
Independent Claim
100 words
A method, performed bv a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and providing a Java language manager which communicates with a Java virtual machine using shared memory.
Claim 3
Independent Claim
91 words
A method, performed by a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR by looking up a system catalog; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; and creating an execution context for the UDR.
Claim 4
Independent Claim
91 words
A method, performed by a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR by looking up a system catalog; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; and creating an execution context for the UDR.
Claim 5
Independent Claim
109 words
A method, performed by a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, creating and initializing a routine descriptor (RDESC) structure, a routine instance (RINST) structure, a language descriptor (LDESC) structure and a module descriptor structure (MDESC).
Claim 6
Independent Claim
109 words
A method, performed by a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, creating and initializing a routine descriptor (RDESC) structure, a routine instance (RINST) structure, a language descriptor (LDESC) structure and a module descriptor structure (MDESC).
Claim 7
Independent Claim
110 words
A method, performed by a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, providing a general language interface capable of initializing the language manager, loading the language manager, creating a language manager context, and executing the language manager.
Claim 8
Independent Claim
110 words
A method, performed by a database server, for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, the method comprising: determining a language native to a UDR; checking whether a language manager associated with the determined native language already has been loaded and if not, loading the language manager into a server memory; checking whether the UDR already has been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, providing a general language interface capable of initializing the language manager, loading the language manager, creating a language manager context, and executing the language manager.
Claim 9
Dependent Claim
135 words
A computer system, comprising: a processor; a memory array coupled to said processor; a display coupled to said processor; a data storage device coupled to said processor for storing a database management system (DBMS) for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, and software residing on the memory array or the data storage device to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and compiling and executing the UDR in a language-specific virtual machine.
Claim 10
Dependent Claim
135 words
A computer system, comprising: a processor; a memory array coupled to said processor; a display coupled to said processor; a data storage device coupled to said processor for storing a database management system (DBMS) for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages, and software residing on the memory array or the data storage device to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and compiling and executing the UDR in a language-specific virtual machine.
Claim 11
Dependent Claim
16 words
The computer system of claim 5, wherein the language-specific virtual machine comprises a Java virtual machine.
Claim 12
Dependent Claim
145 words
A computer system, comprising: a processor; a memory array coupled to said processor; a display coupled to said processor; a data storage device coupled to said processor for storing a database management system (DBMS) for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages; software residing on the memory array or the data storage device to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, a routine descriptor (RDESC) structure, a routine instance (RINST) structure, a language descriptor (LDESC) structure and a module descriptor structure (MDESC).
Claim 13
Dependent Claim
145 words
A computer system, comprising: a processor; a memory array coupled to said processor; a display coupled to said processor; a data storage device coupled to said processor for storing a database management system (DBMS) for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages; software residing on the memory array or the data storage device to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, a routine descriptor (RDESC) structure, a routine instance (RINST) structure, a language descriptor (LDESC) structure and a module descriptor structure (MDESC).
Claim 14
Dependent Claim
148 words
A computer system, comprising: a processor; a memory array coupled to said processor; a display coupled to said processor; a data storage device coupled to said processor for storing a database management system (DBMS) for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages; software residing on the memory array or the data storage device to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, a general language interface capable of initializing a language manager, loading the language manager, creating a language manager context, and executing the language manager.
Claim 15
Dependent Claim
148 words
A computer system, comprising: a processor; a memory array coupled to said processor; a display coupled to said processor; a data storage device coupled to said processor for storing a database management system (DBMS) for handling one or more User Defined Routines (UDRs) capable of being expressed in one or more languages; software residing on the memory array or the data storage device to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, a general language interface capable of initializing a language manager, loading the language manager, creating a language manager context, and executing the language manager.
Claim 16
Dependent Claim
94 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and looking up a system catalog in determining the language native to the UDR.
Claim 17
Dependent Claim
94 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and looking up a system catalog in determining the language native to the UDR.
Claim 18
Dependent Claim
107 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, creating and initializing instructions for a routine descriptor (RDESC) structure, a routine instance (RINST) structure, a language descriptor (LDESC) structure and a module descriptor structure (MDESC).
Claim 19
Dependent Claim
107 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and, creating and initializing instructions for a routine descriptor (RDESC) structure, a routine instance (RINST) structure, a language descriptor (LDESC) structure and a module descriptor structure (MDESC).
Claim 20
Dependent Claim
107 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory and providing a general language interface capable of initializing the language manager, loading the language manager, creating a language manager context, and executing the language manager; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; and creating an execution context for the UDR.
Claim 21
Dependent Claim
107 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory and providing a general language interface capable of initializing the language manager, loading the language manager, creating a language manager context, and executing the language manager; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; and creating an execution context for the UDR.
Claim 22
Dependent Claim
93 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and executing the UDR in a variety of languages using a routine manager.
Claim 23
Dependent Claim
93 words
Computer software for a DBMS, the software residing on a computer readable medium and comprising instructions for causing a computer to perform the following operations: determining a language native to the UDR; checking whether a language manager associated with the native language already has been loaded and if not, loading the language manager into a server memory; checking if the UDR has already been instantiated and if not, instantiating and initializing the UDR; creating an execution context for the UDR; and executing the UDR in a variety of languages using a routine manager.
References Cited (Backward Citations)
US5257366A
Cited
US5566332A
Cited
US5613117A
Cited
US5450583A
Cited
US5442779A
Cited
US5680618A
Cited
US5765179A
Cited
US5689633A
Cited
US5870562A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-11-29 | 2003-05-31 | 2003-11-30 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-29 | 2007-05-31 | 2007-11-30 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-29 | 2011-05-31 | 2011-11-30 | $7700.00 | Window Closed / Lapsed |