Indexing/compression scheme for supporting graphics and data selection

• US 5,481,704 A
• Filed: 03/10/1994
• Issued: 01/02/1996
• Est. Priority Date: 09/27/1991
• Status: Expired due to Fees

• Current Assignee: Computer Concepts Corp. (Alphabet Inc.)
• Original Assignee: Computer Concepts Corp. (Alphabet Inc.)
• Inventors: Pellicano, Russell A.
• Primary Examiner(s): Kulik, Paul V.
• Application Number:
  US08/209,385
• Time in Patent Office: 663 Days
• Field of Search: 395/600, 395/147, 395/161, 364/554, 364/555, 364/715.02
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A method for interactively selecting and displaying a distribution of all data fields in a selected database. The primary function of the methodology is to allow a user to view the data contained within a selected database in a graphical format. Additionally, the user has the capability of selecting specific sets of data for more detailed display as well as determining the effect of the selection on all remaining data fields which comprise the selected database. The first step in the process is the accessing of the particular database from the host system. Once the selected database has been accessed, a distribution matrix for each field in the selected database is constructed from the data contained within the selected database. The distribution matrix is then graphically displayed on any type of graphical display unit. From this initial graphic display, the user can make various selections for detailed graphical display and study and analyze the data structure and data content of the database.

Claims

1. An interactive method for selecting and displaying data and information about said data in a selected data structure, said selected data structure having a particular file structure associated therewith and comprising at least a plurality of data records, and a plurality of data fields having data therein, said method comprising the steps of:

(a) accessing said selected data structure resident on a host system and reading the data therein to determine selected parameters of the distribution of said data;

(b) building a plurality of distribution matrices from data contained within said selected data structure with each matrix having at least one data summary associated therewith; and

(c) interactively generating at least one display from said plurality of distribution matrices for said selected data structure to provide a graphical representation of the distribution of data contained within said selected data structure.

2. The method for selecting and displaying data according to claim 1 which further includes the step of selecting a set of data from said selected data structure and then generating a display representative of said set.

3. The method for selecting and displaying data according to claim 1, wherein said step of accessing said selected data structure comprises the steps of:

(a) retrieving each of said plurality of data records within said selected data structure;

(b) reading each data field in one of said plurality of data records, and converting the data in said data field to a distribution data file; and

(c) repeating step (b) for each of said plurality of data records to form a master distribution data file for said selected data structure.

4. The method for selecting and displaying according to claim 1, wherein said step of building a plurality of distribution matrices further comprises the step of compressing all information contained in said plurality of distribution matrices into a master distribution matrix.

5. The method of selecting and displaying according to claim 4, wherein said step of generating a display from said plurality of distribution matrices for said selected data structure comprises the steps of:

(a) opening at least said master distribution matrix to be displayed; and

(b) displaying the distribution of data contained in said mater distribution matrix in a graphical format.

6. The method of selecting and displaying according to claim 5, wherein said step of generating a display from said plurality of distribution matrices for said selected data structure further comprises the step of expanding the compressed information contained in said master distribution matrix.

7. An interactive method for selecting and displaying a distribution of data in a selected data structure, said selected data structure having a particular file structure associated therewith and comprising at least a plurality of data records and data fields having data therein, said method comprising the steps of:

(a) accessing said selected data structure resident on a host system and reading the data therein to determine selected parameters of the distribution of said data;

(b) building a plurality of distribution matrices from data contained within said selected data structure with each matrix having a plurality of data bins and data summaries associated therewith to form a master distribution matrix;

(c) generating a first display from said master distribution matrix for said selected data structure to provide a graphical representation of the distribution of data contained within said selected data structure, said first display providing a range of data values for each selected field; and

(d) interactively modifying a specific range of data values for a selected data field in said first display, and thereafter generating a second display to determine the representative effect of said modification upon the master distribution matrix.

9. The method of selecting and displaying according to claim 7, wherein said method further comprises the step of generating a third display of a detailed distribution for a selected range of said master distribution matrix to provide a detailed graphical representation of the data contained within the selected range of said master distribution matrix.

10. The method for selecting and displaying according to claim 9, wherein said step of accessing said selected data structure comprises the steps of:

(a) retrieving each of said plurality of data records within said selected data structure;

(b) reading each data field in one of said plurality of data records, and converting the data in said data field to a distribution data file; and

(c) repeating step (b) for each of said plurality of data records to form a master distribution data file for said selected data structure.

8. An interactive method for selecting and displaying a distribution of data in a selected data structure, said selected data structure having a particular file structure associated therewith and comprising at least a plurality of data records and data fields having data therein, said method comprising the steps of:

(a) accessing said selected data structure resident on a host system and reading the data therein to determine selected parameters of the distribution of said data;

(b) building a plurality of distribution matrices from data contained within said selected data structure with each matrix having a plurality of data bins and data summaries associated therewith to form a master distribution matrix;

(c) selecting a set of data fields from said plurality of fields to form a selected set of data fields; and

(d) interactively generating at least a first display from said master distribution matrix for said selected set of data fields to provide a graphical representation of the distribution of data contained within said selected set of data fields, said first display providing a range of data values for each selected field.