System for storing and manipulating information in an information base

• US 5,237,678 A
• Filed: 03/02/1989
• Issued: 08/17/1993
• Est. Priority Date: 05/08/1987
• Status: Expired due to Fees

• Current Assignee: David W. Kuechler, William L. Kuechler
• Original Assignee: David W. Kuechler, William L. Kuechler
• Inventors: Kuechler, William L., Kuechler, David W.
• Primary Examiner(s): Kriess, Kevin A.
• Assistant Examiner(s): Chavis, John Q.
• Application Number:
  US07/317,993
• Time in Patent Office: 1,629 Days
• Field of Search: 364/200 MS File, 364/900 MS File, 364/300
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/9017 using directory or table look-up use of a directory or look-up table in file systems G06F16/13
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

The present invention provides a system for the input, retrieval, manipulation and analysis of stored information in an information base. The system comprises an input device, a storage device, and an output device each capable of handling information base records. Each of the fields of the records is processed to produce a compact symbol or code corresponding to predefined ranges of values of an field. These codes are then stored in correspondence with the records which gave rise to them. The result of this processing is a topological map of the fields of the information base records. These topological maps may be retrieved and later processed to efficiently retrieve stored records, given any general unpreprogrammed query as input to the system. These topological maps may also be utilized in a process to determine correlations among the various fields of the records.

Claims

1. An information base system comprising:

(a) an information storage device;

(b) a file comprising a plurality of information records stored in said storage device, each record having at least one attribute with an orderable value;

(c) a topological map stored in said storage device for at least certain ones of said attributes, said map comprising a plurality of predetermined range codes representing a predetermined number of ranges of attribute values, said ranges collectively including the attribute values for all information records in the information base, and wherein said plurality of range codes are arranged in an array which defines a correspondence between each of said information records and the ranges to which they map;

(d) input means, cooperating with said information storage device, for receiving a query having specifications based upon specified parameters related to an attribute of the stored information records;

(e) means, responsive to the query received by said input means, for accessing the topological map based upon said query and for identifying from said map, without inspection of the information records, information records in the information base based upon the specifications of the query and for indicating whether each respective information record does, does not, or may meet the specifications of the query;

(f) means, responsive to the identifying means, for generating an output map and storing in said output map the identification of the information records in the information base based upon the specifications of the query; and

(g) output means, responsive to said output map generating means, for accessing the information records identified by the output map based upon the specifications of the query, and for displaying said information records identified by the output map.

2. A system as defined in claim 1 wherein said topological map includes means defining sub-ranges for each of said range codes.

3. A system as defined in claim 1 wherein said topological map comprises a series of two byte fields, with each one of said fields corresponding to one of said records in the file, and wherein said first byte of each of said fields contains said range codes and said second byte of each of said fields contains sequential sub-ranges of the range code assigned to the first byte, whereby a significantly greater number of ranges are defined by combining the range codes of the first byte with the sub-ranges of the second byte.

4. A system as defined in claim 1 wherein partition values define the limits of the respective ranges of said topological map, and said topological map further comprises means for indicating when an attribute value of a record is equal to the partition value.

5. A system as defined in claim 4 wherein said topological map comprises a series of two byte fields, with each of said two byte fields corresponding to one of said records in the file, and wherein said first byte of each of said two byte fields contains said range codes and wherein a zero value in said second byte of said two byte fields indicates that the attribute value of a record is equal to the partition value.

6. A system as defined in claim 1 wherein said topological map further comprises a status map stored in said information storage device, said status map comprising a means for indicating for each of said records whether the record is valid, deleted, or replaced.

7. A system as defined in claim 6 wherein said indicating means comprises a series of two bit fields, with each of said two bit fields corresponding to one of said records in the file, and wherein the number of bits set in the two bit field indicates whether the record is valid, deleted or replaced.

8. A system as defined in claim 6 including an input device for receiving operator input of updated information about an existing record in said file, means for adding to the end of said file an additional record containing said updated information and means for setting the indicating means for said existing record in said status map to indicate that the record has been replaced.

9. A system as defined in claim 6 including means for identifying by said status map, open spaces in said file occupied by replaced records, for moving the added information records at the end of the file into said open spaces, and for moving the corresponding range codes of each topological map into the positions corresponding to the new locations of the moved records in the file.

10. A system as defined in claim 1 including an input device for receiving operator input of additional records, means for adding the additional information records to the end of said file, and means for adding to the end of said topological map, the range codes for the attributes of the added information records.

11. A system as defined in claim 1 including a transaction log stored in the information storage device, said transaction log containing the identity of the information records affected by update processing.

12. A system as defined in claim 1 wherein said topological map further comprises a record locking map stored in the information storage device, said record locking map comprising a means for indicating for each of said records the locking status of each of said records.

13. A system as defined in claim 12 wherein said record locking map indicating means comprises a series of one byte fields, with each of said one byte fields corresponding to one of said records in the information base, and wherein the number of bits set in the one byte field indicates the locking status of each of said records.

14. A system as defined in claim 1 additionally including means for ordering said information records into segregated sets in correspondence to said range of attributes values for at least one of said attributes, wherein each said set includes only records having range codes corresponding to said records in said topological maps for said attributes which are included in a predetermined subset of range codes.

15. A system as defined in claim 1 wherein said topological map further comprises zone maps stored in said storage device in correspondence, to said range codes of at least one of said attributes, each said zone map comprising a string of zone codes in correspondence to sets of range codes in said topological map, and wherein each said zone code indicates the presence or absence within said corresponding set of range codes of said range code corresponding to said zone map.

16. A system as defined in claim 1 additionally including means for accessing said range values and topological maps for one or more of said record attributes and for dynamically generating therefrom, for one or more derived attributes, range values and topological maps which correspond to the exact derived attribute values calculable from the specific values of said record attributes for each said record.

17. A method for processing information in an information base system comprising

(a) storing in an information storage device a plurality of information records, each record having a plurality of attributes with an orderable value;

(b) also storing in the information storage device, for at least certain ones of said attributes of the records, a typographical map which includes a plurality of range codes representing a predetermined number of ranges of attribute values, which ranges collectively include the attribute values for all information records it he information base, and an array of said range codes which defines a correspondence between each of said information records and the ranges to which they map;

(c) receiving a query having specifications based upon specified parameters and logic related to one or more attributes of the stored information records;

(d) accessing the topological maps for each attribute specified in the query and generating therefrom an output map having records which correspond to each of the information records in the information base and which indicate whether each respective information record does, does not, or may meet the specifications of the query; and

(e) accessing the information records in the information base corresponding to the records in the output map and displaying at least one of the information records in the information base corresponding to the records in the output map in response to the query.

18. A method as defined in claim 17 wherein said ranges also include a status map comprising an indicator for indicating for each of said records whether the record is valid, deleted, or replaced.

19. A method as defined in claim 18 wherein said indicator comprises a series of two bit fields, with each of said two bit fields corresponding to one of said records in the file, and wherein the number of bits set in the two bit field indicates whether the record is valid, deleted or replaced.

20. A method as defined in claim 18 including the steps of adding additional information records to the end of said file, and adding to the end of said topological map, the range codes for the attributes of the added information records.

21. A method as defined in claim 18 including the steps of adding to the end of said file an additional record containing updated information about a record which has been changed, and setting the indicator for the changed record in said status map to indicate that the record has been replaced.

22. A method as defined in claim 18 including the step of identifying by said status map, open space in said file occupied by replaced records, moving the added information records at the end of the file into said open spaces, and moving the corresponding range codes of each topological map into the positions corresponding to the new locations of the moved records in the file.

23. A method as defined in claim 18 including the step of storing in the information storage device a transaction log containing the identity of the information records affected by update processing.

24. A method as defined in claim 18 wherein said topological map also includes a record locking map comprising an indicator for indicating for each of said records the locking status of each of said records.

25. A method as defined in claim 24 wherein said record locking map indicator comprises a series of one byte fields, with each of said one byte fields corresponding to one of said records in the information base, and wherein the number of bits set in the one byte field indicates the locking status of each of said records.