Patent US6052685A successfully refreshed from Google Patents.
US6052685A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Integration of legacy database management systems with ODBC-compliant application programs
Assignee: Avaya Inc
•
Filing: 1997-08-13
•
Granted: 2000-04-18
•
Expires: 2017-08-13
Abstract
Abstract A database integrator is provided to an application program that utilizes the ODBC interface so as to enable the application program to access the data in a legacy DBMS. The application program ("the client program") is located on a workstation, and the legacy DBMS is located on a host computer. The legacy DBMS is used primarily by an application program ("the server program"). The database integrator receives ODBC commands from the client program, and unlike database drivers interacting with non-legacy DBMSs that send SQL statements to the DBMS, the database integrator instead converts these commands into server program-specific commands to manipulate the user interface of the server program, establishes a connection with the server program over a terminal emulation session, and issues the server program-specific commands to the server program by using the terminal emulator. These server program-specific commands manipulate the server program's user interface to display the appropriate data so that the database integrator can then access it. In this manner, the database integrator accesses the data in the legacy DBMS indirectly by issuing user interface commands to the server program, because the database integrator cannot typically access the legacy DBMS directly. This indirect access enables the client program to gain access to the data in a database that it would not otherwise be able to access.
Inventors
- 👤 Michael W. Eastwick
- 👤 Gregory K. Miskin
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 20:49
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; G06F16/258; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99941; Y10S707/99944
Claims Analysis
Total Claims: 8
Claim 1
Independent Claim
248 words
A method in a data processing system for providing a client application program running on a workstation with access to data stored in a Database Management System (DBMS) of a host computer running a server application program that maintains the DBMS, comprising: the client application program issuing a first ODBC command to a database integrator component; the database integrator component receiving the first ODBC command and forming a connection with the server application program over a terminal emulation session with the host computer created by a terminal emulator that emulates the host computer; the client application program issuing a second ODBC command to the database integrator component, the second ODBC command requesting access to the data stored in the DBMS; the database integrator component receiving the second ODBC command, converting the second ODBC command into user interface commands that control a user interface of the server application program, with the user interface providing access to at least a portion of the data of the DBMS, and issuing the user interface commands to the server application program via the terminal emulation session to provide the access to the data; the server application program receiving the user interface commands and accessing the data responsive to receiving the user interface commands; the client application program issuing a third ODBC command to the database integrator component; and the database integrator component receiving the third ODBC command and terminating the connection with the server application program responsive to receiving the third ODBC command.
Claim 2
Independent Claim
248 words
A method in a data processing system for providing a client application program running on a workstation with access to data stored in a Database Management System (DBMS) of a host computer running a server application program that maintains the DBMS, comprising: the client application program issuing a first ODBC command to a database integrator component; the database integrator component receiving the first ODBC command and forming a connection with the server application program over a terminal emulation session with the host computer created by a terminal emulator that emulates the host computer; the client application program issuing a second ODBC command to the database integrator component, the second ODBC command requesting access to the data stored in the DBMS; the database integrator component receiving the second ODBC command, converting the second ODBC command into user interface commands that control a user interface of the server application program, with the user interface providing access to at least a portion of the data of the DBMS, and issuing the user interface commands to the server application program via the terminal emulation session to provide the access to the data; the server application program receiving the user interface commands and accessing the data responsive to receiving the user interface commands; the client application program issuing a third ODBC command to the database integrator component; and the database integrator component receiving the third ODBC command and terminating the connection with the server application program responsive to receiving the third ODBC command.
Claim 3
Dependent Claim
57 words
The method of claim 1 wherein the second ODBC command performs functionality, wherein the workstation contains a database with user interface commands that perform the functionality of the second ODBC command, and wherein converting the second ODBC command includes accessing the database and identifying the user interface commands that perform the functionality of the second ODBC command.
Claim 4
Dependent Claim
103 words
The method of claim 1, wherein the user interface displays the data of the DBMS at a location on the user interface, wherein the method further includes creating a database containing user interface commands by a navigator program receiving an indication of the location of where the data is displayed on the user interface, wherein converting the second ODBC command includes accessing the database to determine the location of where the data is displayed on the user interface, and wherein issuing the user interface commands includes issuing the user interface commands to access the data at the determined location on the user interface.
Claim 5
Dependent Claim
55 words
The method of claim 3 wherein the user interface has a plurality of screens, wherein the data is displayed on one of the plurality of screens which is not accessible, and wherein issuing the user interface commands includes issuing the user interface commands to render accessible the one screen on which the data is displayed.
Claim 6
Dependent Claim
20 words
The method of claim 1 wherein issuing the user interface commands includes issuing the user interface commands using WinHLLAPI functions.
Claim 7
Dependent Claim
32 words
The method of claim 1 wherein the server application program accessing the data includes reading the data and returning the read data to the client application program via the database integrator component.
Claim 8
Dependent Claim
17 words
The method of claim 1 wherein the server application program accessing the data includes updating the data.
References Cited (Backward Citations)
US5749079A
Cited
US5642515A
Cited
US5611076A
Cited
US5713014A
Cited
US5752027A
Cited
US5826253A
Cited
US5918224A
Cited
US5689698A
Cited
US5754841A
Cited
US5794250A
Cited
US5796393A
Cited
US5991751A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-04-18 | 2003-10-18 | 2004-04-18 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-04-18 | 2007-10-18 | 2008-04-18 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-04-18 | 2011-10-18 | 2012-04-18 | $7700.00 | Window Closed / Lapsed |