Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1997-10-07
2001-07-24
Kulik, Paul V. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C705S003000
Reexamination Certificate
active
06266675
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates to relational databases and database engines, and more particularly provides a system and method for using a relational database to enable the dynamic configuration of an application program, and even more particularly as it relates to the health care industry.
2. Description of the Related Art
Relational databases store information in tables which are linked together using key fields. Accordingly, a first table may contain a list of available menu items, for example, Item A, Item B and Item C. Additional tables, which correspond to the first table using the menu items as key fields, may contain lists of menu item fields. That is, Item A may correspond to a second table which contains Field A and Field B, Item B may correspond to a third table which contains Field C and Field D, and Item C may correspond to a fourth table which contains Field E and Field F. The purpose of menu Item A may relate to maintaining information on individual patients, the purpose of Field A may relate to maintaining the individual patient's name, and the purpose of Field B may relate to maintaining the individual client's social security number. It will be appreciated that the second table may include other fields relating to Item A, such as birth date, birth location, height, weight, etc. The patient information entered related to each of the fields for a particular menu item is referred to as a “record.” For example, the information such as name, social security number, etc. relating to the individual patient is collectively a first record.
A database engine enables a user to peruse through the relational database and enables a user to apply search parameters or indexes to locate desired information in the relational database. Using the perusal search technique, the database engine retrieves the menu items and based upon its configuration specifies, for example, the appearance of the user interface, i.e., the font, color, size and location, the technique for selecting a menu item such as Item A, etc. Upon selection of a menu item, the database engine enables a user to view, select and modify each of the fields contained in the second table, namely, Field A and Field B, as specified by its particular configuration. For simplicity, each of viewing, adding, selecting, editing, etc. is referred to as “manipulating.”
Using the parametric search technique, the database engine uses its particular configuration to prompt the user for parameters indicating a desired group of menu items (such as the menu items created after a particular date). The database engine compares the menu items and the fields of each menu item contained in the relational database against the selected parameters and generates the search results. Similar to the perusal technique, the database engine displays the results to the user also based on its particular configuration.
Using the indexing technique, the database engine need not perform a search, but need only locate the proper index identifying the grouping of menu items and fields desired. Again, the database engine enables the manipulation of items, fields and records according to the particular configuration of the database engine.
Regardless of the technique being used, the database engine manipulates records according to the predetermined configuration of the database engine. That is, the database engine is preset to display the data onto the display according to the font, color, organization, etc. as indicated by the database engine program. In order to modify the configuration characteristics of the database engine, the programmer must modify the database engine program itself. However, this is quite cumbersome process and takes a significant amount of time. Thus, manufacturers have avoided customizing application programs and in particular database engines. Therefore, a system and method are needed for using relational databases to dynamically configure an application program easily.
SUMMARY OF THE INVENTION
The present invention provides a system and method for using relational database structures to dynamically configure an application program. The system comprises first retrieving means such as an activities engine, a list view engine or a search engine for retrieving configuration data. The system further comprises second retrieving means such as the activities engine, the list view engine or the search engine for retrieving desired data such as patient or transaction records. The first retrieving means and the second retrieving means may each include the same engine. The system further comprises manipulation means such as the activities engine, the list view engine or the search engine for manipulating the desired data according to the configuration data.
For example, the list view engine may retrieve the column header information specifying the information that should be presented in the patient record window. The list view engine may then retrieve the desired records, possibly based on the results of a search by the search engine, and then present the patient record window including the desired records based on the configuration information retrieved.
The configuration information may be contained in a relational database. More particularly, first table means in the relational database may contain the desired data and second table means in the relational database may contain the configuration data. Accordingly, a database engine may more easily retrieve the data, and customization of the database may be a less cumbersome process.
Another system embodying the present invention comprises a relational database containing services for identifying a case manager, a first table for containing a menu item corresponding to the case manager, a second table coupled to the first table for containing patient data corresponding to the menu item, and a third table coupled to the first table and to the second table for containing configuration data corresponding to the menu item and to the patient data. The system further comprises an engine coupled to the relational database for using the configuration data to enable a user to manipulate the menu item and the patient data.
The method comprises the steps of retrieving configuration data, retrieving desired data, and manipulating the desired data according to the configuration data. The configuration information and the desired data may be contained in a relational database.
The system and method advantageously enable easy customization of a database. Instead of forcing a particular configuration based on the configuration of the application program accessing the data in the database, the configuration data is contained separately in the database. Accordingly, a application program common to all case managers can extract configuration data from the database and can use the extracted data to configure itself, thereby facilitating the customization of the application program.
REFERENCES:
patent: 5369778 (1994-11-01), San Soucie et al.
patent: 5432931 (1995-07-01), Woess et al.
patent: 5434971 (1995-07-01), Lysakowski, Jr.
patent: 5446575 (1995-08-01), Lysakowski, Jr.
patent: 5566330 (1996-10-01), Sheffield
patent: 5583758 (1996-12-01), McIlroy et al.
patent: 5621884 (1997-04-01), Beshears et al.
patent: 5727158 (1998-03-01), Bouziane et al.
patent: 5784635 (1998-07-01), McCallum
patent: 5802511 (1998-09-01), Kouchi et al.
patent: 5809266 (1998-09-01), Touma et al.
patent: 5900870 (1999-05-01), Malone et al.
patent: 5950190 (1999-09-01), Yeager et al.
Barker Dwight John
Barnum William Goodell
Chu-hu Jennifer
Cordero Joseph Rommel
Evans Arnold Kerry
Kulik Paul V.
PhyCom Corporation
Squire Sanders & Dempsey L.L.P.
LandOfFree
System and method for using a relational database to enable... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for using a relational database to enable..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for using a relational database to enable... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2434800