System and method for automatic analysis of data bases and for user-controlled dynamic querying
First Claim
1. A method for processing and visualizing data from a data base, in which the data base contains a plurality of records, each record includes a plurality of data fields, each field contains field data, has a field name and one of a plurality of data types, the method comprising the following steps:
- accessing the data base and reading the records;
automatically determining a range of the field data in each of the data fields;
for each data field, selecting and calculating a relevance measure, the relevance measure being a predetermined, data type-dependent function indicating, for interdependent data fields, a predefined measure of relational closeness to at least one other of the data fields and, for non-interdependent data fields, a predefined measure of a data type-dependent characteristic solely of the field data in each non-interdependent data field;
automatically detecting a relational structure between the fields by calculating the respective relevance measure for each of the fields;
for each of the data fields, automatically selecting an initial, adjustable, graphical query device as a predetermined function of and adapted to the type and range of the corresponding field data;
anddisplaying for viewing by a user graphical representations of the relational structures of selected ones of the fields and their corresponding initial query devices in an order determined as a predetermined function of their respective relevance measures;
sensing adjustment by the user of any of the displayed, adjustable, graphical query devices; and
updating the graphical representations of the relational structures corresponding to the sensed adjustments of any of the query devices, thereby enabling interactive visualization of the relational structures of the data fields.
4 Assignments
0 Petitions
Accused Products
Abstract
A main processing system accesses a data base, which contains data records, each of which is divided into data fields. The system preferably automatically determine the type of data in each field, as well as its range of values. It then preferably determines one or more relational structures of the field data using a corresponding number of relevance measures. For each field, a preferably user-adjustable, software-generated query device is displayed, preferably in the order of the relevance measures of the respective fields. The plot of one or more fields'"'"' data relative to that of another field is initially generated using the fields in order of relevance. The relevance measure forming the basis of the field ordering, the order of fields, and the ranges of the plotted, displayed fields may be adjusted interactively by the user by moving and adjusting the various query devices.
209 Citations
9 Claims
-
1. A method for processing and visualizing data from a data base, in which the data base contains a plurality of records, each record includes a plurality of data fields, each field contains field data, has a field name and one of a plurality of data types, the method comprising the following steps:
-
accessing the data base and reading the records; automatically determining a range of the field data in each of the data fields; for each data field, selecting and calculating a relevance measure, the relevance measure being a predetermined, data type-dependent function indicating, for interdependent data fields, a predefined measure of relational closeness to at least one other of the data fields and, for non-interdependent data fields, a predefined measure of a data type-dependent characteristic solely of the field data in each non-interdependent data field; automatically detecting a relational structure between the fields by calculating the respective relevance measure for each of the fields; for each of the data fields, automatically selecting an initial, adjustable, graphical query device as a predetermined function of and adapted to the type and range of the corresponding field data; and displaying for viewing by a user graphical representations of the relational structures of selected ones of the fields and their corresponding initial query devices in an order determined as a predetermined function of their respective relevance measures; sensing adjustment by the user of any of the displayed, adjustable, graphical query devices; and updating the graphical representations of the relational structures corresponding to the sensed adjustments of any of the query devices, thereby enabling interactive visualization of the relational structures of the data fields. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A method for processing and visualizing data from a data base, in which the data base contains a plurality of records, each record includes a plurality of a field, each field contains field data, has a field name and one of a plurality of data types, the method comprising the following steps:
-
accessing the data base and sequentially reading the records; designating one of the fields as a primary field and the remaining fields as secondary fields; selecting a plurality of relevance measures relating each secondary field, respectively, to the primary field; automatically detecting a plurality of relational structures between the secondary fields and the primary field for each of the plurality of relevance measures by calculating each relevance measure for each of the secondary fields relative to the primary field; automatically designating as a primary relevance measure the one of the plurality of relevance measures having a greatest validity value; ordering the secondary fields according to respective degrees of relevance according to the primary relevance measure; displaying the field names for viewing by the user in order of the degrees of relevance of their corresponding fields; displaying initially a graphical representation of at least the secondary field having the highest-order degree of relevance as the function of the primary field'"'"'s field data; and sensing user selection of one of the displayed field names and displaying for user viewing a graphical representation of the secondary field'"'"'s field data corresponding to the selected field name as the function of the primary data field'"'"'s field data.
-
-
8. A system for processing and visualizing data from a data base, the system comprising:
-
a relational data base storing a plurality of records, each record including a plurality of data fields, each field containing field data, having a field name and one of a plurality of data types; a main processing system; a user input device that is connected to the main processing system; a display that is connected to the main processing system; connection means for connecting the main processing system to the data base; the main processing system comprising processing means; for accessing the data base and reading the records; for automatically determining a range of the field data in each of the data fields; for each data field, for selecting and calculating a relevance measure, the relevance measure being a predetermined, data type-dependent function indicating, for interdependent data fields, a predefined measure of relational closeness to at least one other of the data fields and, for non-interdependent data fields, a predefined measure of a data type-dependent characteristic solely of the field data in each non-interdependent data field; for automatically detecting a relational structure between the fields by calculating the respective relevance measure for each of the fields; for each of the data fields, for automatically selecting an initial, adjustable, graphical query device as a predetermined function of and adapted to the type and range of the corresponding field data; for displaying for viewing by a user graphical representations of the relational structures of selected ones of the fields and their corresponding initial query devices in an order determined as a predetermined function of their respective relevance measures; for sensing adjustment by the user of any of the displayed, adjustable, graphical query devices; and for updating the graphical representations of the relational structures corresponding to the sensed adjustments of any of the query devices, thereby enabling interactive visualization of the relational structures of the data fields. - View Dependent Claims (9)
-
Specification