Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-12-22
2001-05-29
Black, Thomas (Department: 2171)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06240417
ABSTRACT:
TECHNICAL FIELD
The present invention relates generally to data processing systems and, more particularly, to the integration of legacy databases with ODBC-compliant application programs.
BACKGROUND OF THE INVENTION
Many of today's application programs utilize the Open Database Connectivity (ODBC) interface to access data in Database Management Systems (DBMSs) using the Structured Query Language (SQL). The ODBC interface provides interoperability, where a single application program can access data from many different DBMSs. This interoperability allows an application developer to develop, compile, and ship an application program without targeting a specific DBMS. When a user then buys the application program, the user can add modules, known as database drivers, which link the application program to the user's choice of DBMSs. The ODBC interface is more clearly described in
ODBC
2.0
Programmer's Reference and SDK Guide
, Microsoft Press (1994), at pages 3-15, 23-87, and 181-519.
When accessing a DBMS using the ODBC interface, an application program utilizes various functions of the interface to issue ODBC commands containing SQL statements to the database driver, which then sends the SQL statements to the DBMS. After receiving the SQL statements, the DBMS processes them. Although the ODBC interface provides interoperability, many existing DBMSs (known as legacy DBMSs) either do not have an ODBC database driver for use with an ODBC-compliant application program or do not allow access from entities other than a single application program that acts as the legacy DBMS's only client. In both of these situations, an ODBC-compliant application program cannot access the data contained in the legacy DBMS. Because there are many legacy DBMSs, this limitation is significant, as the limitation renders the data in these legacy DBMSs inaccessible. It is therefore desirable to integrate legacy DBMSs with application programs that utilize the ODBC interface.
SUMMARY OF THE INVENTION
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, connects to 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 client program 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.
In accordance with a first aspect of the present invention, a method is provided in a data processing system for a client computer program on a workstation to access data stored in a database of a host computer. The database is maintained by a server computer program. In accordance with this method, an ODBC command is received from the client computer program, where the ODBC command requests access to the data of the database stored in the host computer. The ODBC command is converted into user interface commands for the server computer program, and the user interface commands are issued to the server computer program to perform the access of the data requested by the ODBC command.
In accordance with a second aspect of the present invention, a method is provided in a data processing system for an integration component to facilitate client program access of data maintained in a database by a server program. The integration component receives a database access request from the client program to directly access the data in the database. The integration component further converts the database access request into a command suitable for the server program and issues the command to the server program to effectuate the database access request to access the data in the database.
In accordance with a third aspect of the present invention, a data processing system is provided comprising a host computer and a workstation. The host computer includes a secondary storage device containing a database with data, a memory containing a server program that manages the database, and a processor for running the server program. The workstation includes a memory containing a client program that issues database commands to directly access the data in the database and an integrator component for receiving the database commands, for converting the database commands into application-specific commands for the server program, and for issuing the application-specific commands to the server program to effectuate the data access requested by the client program. The workstation further includes a processor for running the client program and the integrator component.
REFERENCES:
patent: 5611076 (1997-03-01), Durflinger et al.
patent: 5642515 (1997-06-01), Jones et al.
patent: 5689698 (1997-11-01), Jones et al.
patent: 5713014 (1998-01-01), Durflinger et al.
patent: 5749079 (1998-05-01), Yong et al.
patent: 5752027 (1998-05-01), Familiar
patent: 5754841 (1998-05-01), Carino, Jr.
patent: 5794250 (1998-08-01), Carino, Jr. et al.
patent: 5796393 (1998-08-01), MacNaughton et al.
patent: 5930786 (1999-07-01), Carino, Jr. et al.
patent: 5937402 (1999-08-01), Pandit
patent: 6052685 (2000-04-01), Eastwick et al.
Rumba® Tools for HLLapi- WinHLLAPI, Wall Data Inc., Kirkland, Wa., 1995, pp. 2-1 -3-13 and 6-1 -6-163.
ODBC 2.0 Programmer's Reference and SDK Guide, Microsoft Press, Redmond, Wa., 1994, pp. 3-15, 23-87, and 181-519.
Finkelstein, ODBC: Beware the Hype, Client Server Databases; Network Computing, pp. CS3-CS4, Jan. 1994.
Read, WWW in an Open Office System, Client Server Computing, International Semina on IEE Digest No. 1995/184, vol. 1, pp. 16/1-16/5.
Rishe, Managing Network Resources for Efficient Reliable Information, Parallel and Distributed Information Systems, 1994., Proceedings of the Third International Conference, pp. 223-226.
Eastwick Michael W.
Miskin Gregory K.
Avaya Technology Corp.
Black Thomas
Coby Frantz
Volejnicek David
LandOfFree
Integration of legacy database management systems with... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Integration of legacy database management systems with..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Integration of legacy database management systems with... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2469478