System for and method of emulating a database system

• US 20030016237A1
• Filed: 03/08/2001
• Published: 01/23/2003
• Est. Priority Date: 03/08/2001
• Status: Abandoned Application

• Current Assignee: Orchid Systems Incorporated
• Original Assignee: Orchid Systems Incorporated
• Inventors: Hickey, Neil
• Application Number:
  US09/802,081
• Publication Number:
  US 20030016237A1
• Time in Patent Office: Days
• US Class Current: 345/700
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A method of and system for providing one or more third-party program(s) the ability to access and cache the data of an existing software application that does not support standard database protocols. The invention employs a database shaping application for generating a rule set during a training sequence. The database shaping application monitors requests for data from third party programs and, according to the rule set, accesses the requested data from one or more existing host applications and translates the accessed data into a standard database protocol format, thereby emulating a database of the existing host application(s).

Claims

1. A system for providing one or more third-party program(s) the ability to access data of an existing software application that does not support standard database protocols, comprising:

a database shaping computer operating a database shaping application;

a training terminal communicatively connected to the database shaping computer for establishing a rule set during a training sequence;

a shaper rule set storage device for storing the rule set established during the training sequence communicatively connected to the database shaping computer;

one or more client computers operating one or more third-party program(s) which use standard database protocols, the one or more client computers communicatively connected to the database shaping computer;

a host computer operating an existing host software application that does not support standard database protocols, the host computer including a data storage device storing resident data and communicatively connected to the database shaping computer and a host terminal;

wherein the database shaping application, according to the rule set established during the training sequence, monitors requests for data transmitted from the one or more client computers via the one or more third-party program(s), and emulates a standard database by accessing the resident data stored on the data storage device via the existing host software application and translating the accessed resident data into a standard protocol format.

2. The system of claim 1, further comprising additional host computers operating one or more host applications that do not support standard database protocols communicatively connected to the database shaping computer accesses the resident data via the one or more host applications.

3. The system of claim 1, wherein one or more networks provide communicative connections between the database shaping computer and the host computer, the training terminal, and the one or more client computers.

4. The system of claim 1, wherein the host computer and the database shaping computer, or the database shaping computer and the one or more client computers are the same device.

5. The system of claim 1, wherein the host computer, the database shaping computer, and the one or more client computers are the same device.

6. The system of claim 1, further comprising an auxiliary storage device communicatively connected to the database shaping computer, the auxiliary storage device storing data that may be accessed by the database shaping application for combination with the resident data.

7. A method of training a database emulation system to access an existing software application in order to emulate a database, the database emulation system comprising a database shaping computer operating a database shaping application communicatively connected to a training terminal for establishing a rule set during a training sequence, a shaper rule set storage device for storing the rule set, and a host computer operating an existing host application, the method comprising the steps of:

defining from the training terminal the requests and response data items as database tables and fields;

accessing from the training terminal via the database shaping application the existing host application;

exercising the existing host application from the training terminal via the database shaping application to create a sample database update, insert, or query request for one or more of the database tables and fields, and to generate a sample response, wherein the steps of exercising the existing host application are stored in the rule set; and

determining if further training is required, and reverting to the defining step if further training is required.

8. The method claim 7, wherein the database emulation system further comprises multiple existing host applications which are accessed and exercised via the database shaping application.

9. A method of using a database emulation system to emulate a database, the database emulation system comprised of a database shaping computer operating a database shaping application and communicatively connected to a rule shaper storage device storing a rule set, a client computer operating a third party program using standard database protocols, and a host computer operating a host application, the method comprising the steps of:

starting the database emulation application;

receiving at the database shaping computer a data request transmitted using a standard database protocol from the third party program;

executing via the database shaping application the rule set stored in the rule shaper storage device, whereby the host application is accessed and exercised to return a response data packet; and

transmitting a reply via the database shaping application to the third party program, thereby emulating a database.

10. The method of claim 9, wherein the response data packet transmitted to the third party program is an exception if an error was generated in accessing the host application.

11. The method of claim 9, wherein in the database emulation system further comprises additional host computers operating one or more host applications that are accessed and exercised by the database shaping application.

14. The method of claim 9, wherein the response data packet transmitted to the third party program is an exception if an error was generated in accessing the existing host software application.

12. A cached database emulation system for providing on-demand caching of data of an existing software application that does not support standard database protocols by updating a database that may support standard database protocols, comprising:

a database shaping computer operating a database shaping application;

an update database communicatively connected to the database shaping computer;

a training terminal communicatively connected to the database shaping computer for establishing a rule set during a training sequence;

a shaper rule set storage device for storing the rule set established during the training sequence communicatively connected to the database shaping computer;

one or more client computers operating one or more third-party program(s) which use standard database protocols, the one or more client computers communicatively connected to the database shaping computer;

a host computer operating an existing host software application that does not support standard database protocols, the host computer including a data storage device storing resident data and communicatively connected to the database shaping computer and a host terminal;

wherein the database shaping application, according to the rule set established during the training sequence, monitors requests for data transmitted from the one or more client computers via the one or more third-party program(s), and extracts requested data from the update database if present in the update database, or alternatively emulates a standard database by accessing the resident data stored on the data storage device via the existing host software application and translating the accessed resident data into response data in a standard protocol format and copies the request and the requested data to the update database.

13. A method of using a cached database emulation system to cache the data of an existing software application by on-demand updating of a database that supports standard database protocols, the cached database emulation system comprising a database shaping computer operating a database shaping application communicatively connected to an update database, a shaper rule set storage device storing a rule set, a third-party program which uses standard database protocols, and a host computer including a data storage device and operating an existing host software application that does not support standard database protocols, the method comprising the steps of:

transmitting from the third party program a request for data to the database shaping application;

determining by the database shaping application if the requested data is present in the update database, and if present proceeding immediately to the returning data step;

executing the rule set via the database shaping application to generate the requested data by accessing and exercising the existing host software application and data storage device;

adding the requested data to the update database;

returning the requested data to the third party program; and

determining if there are more requests for data to process.