Apparatus for applying analysis rules to data sets in a relational database to generate a database of diagnostic records linked to the data sets
DCFirst Claim
1. An apparatus for analyzing an array of data stored in a quantitative database, comprising:
- a memory for storing said data of said quantitative database as a table in a relational database;
a computer coupled to said relational database and having a display and having an input device for receiving user input, said computer for execution of one or more programs so as to process data from said quantitative database;
a first program in execution on said computer for controlling said computer to receive user input defining one or more analysis rules to be performed on a subset of data, also specified by said user input, from said array of data stored in said quantitative database and for controlling said computer so as to analyze selected ones of said user specified subset of data items in accordance with selected ones of said one or more user specified analysis rules so as to generate one or more diagnostic records the text of which is also defined by said user input, each diagnostic record corresponding to a possible result of the application of a particular user specified analysis rule to the corresponding user selected subset of items of data from said array of data in said quantitative database, and wherein said first computer program controls said computer so as to automatically generate one or more link pointers for each said diagnostic record, each said link pointer linking a diagnostic record to the corresponding user selected subset of items of data from said quantitative database from which said diagnostic record was generated; and
a second program in execution on said computer for controlling said computer so as to store each said diagnostic record in a diagnostic database in said memoryand wherein said link pointer associated with each diagnostic record is programmable by said user, and wherein said first program includes one or more routines for controlling said computer to display at least first and second windows on said display, and for controlling said computer to display in said first window at least some of said items of data from said quantitative database and for controlling said computer to display in said second window at least some of said diagnostic records, and further comprising one or more routines in said first computer program for controlling said computer to display a pointer in said second window and to receive and process user data controlling the position in said second window of said pointer such that any diagnostic record displayed in said second window may be selected by said user using said pointer, and when any said displayed diagnostic record in said second window is so selected, for controlling said computer to display in said first window the corresponding subset of data items from said quantitative database associated by one or more of said link pointers with the selected diagnostic record.
3 Assignments
Litigations
0 Petitions
Accused Products
Abstract
This invention addresses the need to map information from databases and reports to a new dimension of structured, intelligent interpretations or diagnostics of that information, and then querying in a coordinated manner both the original information and the resultant diagnostics databases. The invention combines elements currently available in decision support tools, programming languages and expert system building tools. First, querying mechanisms for the information in reports and databases is provided. Second, both a test processing engine and an Expert System run a set of if-then-else tests and expert rules on said information, and the resulting coded diagnostics are stored in a diagnostics database. In a simple implementation, first, the information database contains a single flat database file, second each if-then-else test compares particular data items in this file against other data items or against absolute values and, if true, generates one or more data pairs containing the test identifier and each one of the data item identifiers involved in the test. The invention is completed, third, by a querying engine and a EIS-like reporting system, both capable of structuring, filtering, linking and querying in a coordinated manner both the original information and the resultant diagnostics databases, and capable of building reports.
308 Citations
8 Claims
-
1. An apparatus for analyzing an array of data stored in a quantitative database, comprising:
-
a memory for storing said data of said quantitative database as a table in a relational database; a computer coupled to said relational database and having a display and having an input device for receiving user input, said computer for execution of one or more programs so as to process data from said quantitative database; a first program in execution on said computer for controlling said computer to receive user input defining one or more analysis rules to be performed on a subset of data, also specified by said user input, from said array of data stored in said quantitative database and for controlling said computer so as to analyze selected ones of said user specified subset of data items in accordance with selected ones of said one or more user specified analysis rules so as to generate one or more diagnostic records the text of which is also defined by said user input, each diagnostic record corresponding to a possible result of the application of a particular user specified analysis rule to the corresponding user selected subset of items of data from said array of data in said quantitative database, and wherein said first computer program controls said computer so as to automatically generate one or more link pointers for each said diagnostic record, each said link pointer linking a diagnostic record to the corresponding user selected subset of items of data from said quantitative database from which said diagnostic record was generated; and a second program in execution on said computer for controlling said computer so as to store each said diagnostic record in a diagnostic database in said memory and wherein said link pointer associated with each diagnostic record is programmable by said user, and wherein said first program includes one or more routines for controlling said computer to display at least first and second windows on said display, and for controlling said computer to display in said first window at least some of said items of data from said quantitative database and for controlling said computer to display in said second window at least some of said diagnostic records, and further comprising one or more routines in said first computer program for controlling said computer to display a pointer in said second window and to receive and process user data controlling the position in said second window of said pointer such that any diagnostic record displayed in said second window may be selected by said user using said pointer, and when any said displayed diagnostic record in said second window is so selected, for controlling said computer to display in said first window the corresponding subset of data items from said quantitative database associated by one or more of said link pointers with the selected diagnostic record. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. An apparatus for analyzing an array of data stored in a quantitative database, comprising:
-
a memory for storing said quantitative database data as a table in a relational database; a computer coupled to said relational database and having a display and having an input device for receiving user input, said computer for execution of one or more programs so as to process data from said quantitative database; a first program means for execution by said computer for controlling said computer to receive user input defining one or more analysis rules to be performed on one or more subsets of data items, also specified by said user input, from said array of data stored in said quantitative database] and for controlling said computer so as to analyze selected ones of said subsets of user specified data items in accordance with selected ones of said one or more user specified analysis rules so as to generate one or more diagnostic records the text of which is also defined by said user input, each diagnostic record corresponding to the application of a particular user specified analysis rule to the corresponding user selected subset of data items from said array of data in said quantitative database, and wherein said first computer program means includes means for controlling said computer so as to automatically generate one or more link pointers for each said diagnostic record, each said link pointer linking a diagnostic record to the corresponding user selected subset of data items from said quantitative database from which said diagnostic record was generated using the associated analysis rule; and a second program means for execution by said computer for controlling said computer so as to display on said display all diagnostic records resulting from carrying out said analysis rules selected by said user on the user selected subset of data items from the quantitative database and for controlling said computer to store said link pointers in an index pointer table in said memory, and for storing each said diagnostic record in a diagnostic database in said memory; and wherein said first program means includes means for controlling said computer to receive and process user input data which defines the linkage between any particular analysis rule and the subset of data items from said quantitative database upon which said analysis rule is to be executed, said linkage being embodied in link definition data which is stored with the analysis rule defined by the user and which defines how said computer later generates a link pointer for any diagnostic record which resulted upon return by an analysis rule of a predetermined result and which defines which subset of data from said quantitative database is linked to said particular diagnostic record, and wherein said first program means includes means for controlling said computer to display at least first and second windows on said display, and for controlling said computer to display in said first window at least some of said subsets of data items from said quantitative database and for controlling said computer to display in said second window at least some of said diagnostic records, and further comprising means in said first computer program for controlling said computer to display a pointer in said second window and to receive and process user data controlling the position in said second window of said pointer such that any diagnostic record displayed in said second window may be selected by said user using said pointer, and when any said displayed diagnostic record in said second window is so selected, for controlling said computer to display in said first window the corresponding subset of data items from said quantitative database associated by one or more of said link pointers with the selected diagnostic record.
-
Specification