Data storage and retrieval system with improved data base structure

• US 5,369,763 A
• Filed: 05/26/1992
• Issued: 11/29/1994
• Est. Priority Date: 02/01/1989
• Status: Expired due to Fees

• Current Assignee: Kansas State University Research Foundation
• Original Assignee: Kansas State University Research Foundation
• Inventors: Biles, Bertram R.
• Primary Examiner(s): Shaw, Gareth D.
• Assistant Examiner(s): Chavis, John Q.
• Application Number:
  US07/888,331
• Time in Patent Office: 917 Days
• Field of Search: 395/600, 395/650, 395/700
• US Class Current: 1/1
• CPC Class Codes: G06F 16/35 Clustering; Classification
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A data storage and retrieval system separates information regarding the expertise of individuals into four files which can be independently and separately accessed. The records in the various files include fields for indicating the beginning and end of a range of topics within a hierarchical classification system, the level of the topic within the classification system and a field for facilitating alphabetic sorting of topics independently of hierarchical level, and a novel code format for the beginning and end of range indicators permits a small computer to effectively manipulate data in a hierarchical classification system.

Claims

1. A method of operating a computer system having memory for storing and retrieving information concerning a subject, said method comprising steps of:

(a) in the computer system memory, storing subject data concerning a plurality of subjects wherein said data includes descriptor phrases regarding various matters with which said subjects are concerned and wherein said data includes identifying information for identifying the subjects associated with said descriptor phrases;

(b) assigning selected designation numbers to said descriptor phrases and storing said selected designation numbers in the computer system memory in association with the corresponding descriptor phrases and with the identifying information wherein said designation numbers correspond to a respective plurality of topics;

(c) in the computer system memory, storing a plurality of topic headings with each heading being designated to include a specified range of designation numbers;

(d) in the computer system, for each designation number assigned to a descriptor phrase, determining which of said topic heading ranges includes said designation number and storing that designation number and corresponding descriptor phrase in association with the associated topic heading;

(e) searching the computer system memory for one of a descriptor phrase descriptive of a selected matter of interest, a range of designation numbers, and a designation number, and if a descriptor phrase is identified, determining the designation number thereof; and

(f) using one of said range and designation number determined in step (e) to retrieve from the computer system memory the corresponding identifying information concerning the associated subject.

2. The method as set forth in claim 1 further including the steps of storing said subject data in a subject database, storing said topic headings, designation numbers and corresponding descriptor phrases in a composite catalog database separate from said subject database, storing said descriptor phrases and assigned designation numbers with said identifying information in a topics database, step (e) including the step of searching said composite catalog database, and step (f) including the steps of searching said topics database for said identifying information and of searching said subject database using said identifying information.

3. The method as set forth in claim 1, step (a) further including the step of storing said subject data wherein said subjects are individuals.

4. The method as set forth in claim 3, storing an identification number of the individuals as said identifying information.

5. The method as set forth in claim 4, storing the social security number of the individuals as said identifying information.

6. The method as set forth in claim 3, further including the step of storing said descriptor phrases regarding matters of interest to the individuals as said various matters.

7. The method as set forth in claim 3, further including the steps of storing said subject data to include levels of skill and levels of interest regarding said various matters, step further including the step of using one of said levels of skill and, interest to determine said identifying information.

8. The method as set forth in claim 1, step (b) further including the step of assigning and storing typology numbers as said designation numbers.

9. The method as set forth in claim 8, further including the step of storing a set of typology numbers in association with said descriptor phrases in a topics database.

10. The method as set forth in claim 1, step (c) including the step of creating a basic outline database consisting of a set of descriptor phrases, typology numbers, and end-of-range numbers, such that the set of descriptor phrases, typology numbers, and end-of-range numbers creates a hierarchical classification scheme.

11. The method as set forth in claim 1, step (e) further including the step of determining the range of designation numbers inclusive of said designation number, step (f) further including the step of using said range of designation numbers to retrieve identifying information concerning a plurality of associated subjects.

12. The method as set forth in claim 1, step (d) further including the step of determining the last designation number stored in association with each topic heading, designating and storing said last number as the end of range number of said topic heading.

13. The method as set forth in claim 12, further including the steps of configuring said topic headings as a hierarchical classification scheme, using respective typology numbers as said designation numbers and designating the last typology number in the range associated with each of said topic headings as an end-of-range number, and using the typology number assigned to a particular descriptor phrase and the end-of-range number of the associated topic heading as numerical range associated with said particular descriptor phrase, such that said numerical range represents a particular segment of the hierarchical classification scheme at a particular hierarchical level therewithin.

14. The method as set forth in claim 13, further including the steps of configuring the typology number and end-of-range number associated with each descriptor phrase as a record within the hierarchical classification scheme so that the group of said records constitutes the classification scheme for the system, and storing said records in a basic outline database.

15. A method of operating a computer system having memory for identifying individuals having particular interests concerning various matters, said method comprising steps of:

(a) in the computer system memory, storing, in a subject database, subject data concerning a plurality of individuals wherein said data includes descriptor phrases regarding various matters of interest to the individuals and wherein said data includes identifying information for identifying the individuals associated with said descriptor phrases;

(b) assigning selected typology numbers to said descriptor phrases and storing said selected typology numbers in the computer system memory in association with the corresponding descriptor phrases and with the identifying information wherein said typology numbers correspond to a respective plurality of topics;

(c) in the computer system memory, storing in a composite catalog database separate from said subject database, a plurality of topic headings with each heading being designated to include a specified range of typology numbers;

(d) in the computer system, for each typology number assigned to a descriptor phrase, determining which of said topic heading ranges includes said typology number and storing that typology number and corresponding descriptor phrase in association with the associated topic heading;

(e) searching said catalog database for one of a descriptor phrase descriptive of a selected matter of interest and a typology number, and if a descriptor phrase is searched, determining the typology number thereof; and

(f) using said typology number determined in step (e) for searching and retrieving from said subject database the corresponding identifying information concerning the associated individual.