Analysis system for database fusion, graphic display, and disaggregation

• US 5,319,560 A
• Filed: 09/11/1991
• Issued: 06/07/1994
• Est. Priority Date: 09/11/1991
• Status: Expired due to Term

• Current Assignee: Rockwell International Corporation
• Original Assignee: Rockwell International Corporation
• Inventors: Adams, Mark S., Zentner, Joseph J., Heyman, William
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): WALDER, STEPHEN JOSEPH
• Application Number:
  US07/760,024
• Time in Patent Office: 1,000 Days
• Field of Search: 364/437, 364/436, 364/444, 364/449, 364/443, 364/478, 364/439, 340/991, 340/993, 340/905, 395/600
• US Class Current: 701/120
• CPC Class Codes: G06Q 99/00 Subject matter not provided for in other groups of this subclass
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

An analysis system fuzes original data according to system and/or operator imposed rules, displays a graphic abstraction representing fuzed data, and provides, merely at the operator'"'"'s request, details of the fuzed data and/or of the original data.

Claims

1. In a computer system, including a display device, and to which is available a database of data comprising a plurality of records of transportings of various items, each record having a plurality of fields including fields for destination, origin, quantity of item, and name of item, each field containing an entry that is one of one or more possible entries in such field, each record therefore comprising a plurality of entries, each entry in each field being a member of a corresponding one of a plurality of different classes, a method of aiding a computer operator in visually ascertaining patterns of transporting, the method comprising:

translating the name of item entry in each field into one of the classes in said field;

creating from the available database a fused database of fused records, each fused record including fields for origin, destination, quantity and class, said fused database containing sufficient information for displaying an abstraction on said display device; and

displaying on said display device a graphic abstraction representing fused data which meet criteria selected by the operator, said abstraction comprising (i) a geographic map, (ii) a network of nodes and arcs representing origin-destination pairs in the database whose associated entries meet the selected criteria, at least one of said displayed origin-destination paris having an indication of item quantity total for transportings therebetween which meet said selected criteria.

2. The method as defined in claim 1 including the step of displaying, upon operator request, the quantities of items, according to class, which make up the total for a displayed origin-destination pair about which the operator wishes to know more.

3. The method as defined in claim 2 including the step of displaying, upon operator request, all records, in the available database, which contribute to a displayed origin-destination pair about which the operator wishes to know more.

4. The method as defined in claim 1 including the step of displaying, upon operator request, the quantities of items, according to class, which make up the total for a displayed origin-destination pair about which the operator wishes to know more.

5. The method as defined in claim 4 including the step of displaying, upon operator request, all records, in the available database, which contribute to a displayed origin-destination pair about which the operator wishes to know more. 1

6. The method as defined in claim 1 including the step of displaying, upon operator request, all records, in the available database, which contribute to a displayed origin-destination pair about which the operator wishes to know more.

7. The method as defined in claim 1 including the step of displaying, upon operator request, all records, in the available database, which contribute to a displayed origin-destination pair about which the operator wishes to know more.

8. The method as defined in claim 1 further including a field for times of transporting.

9. The method as defined in claim 1 wherein, as a result of clustering, the number of different origins and destinations in the fuzed database is less than the number of different origins and destinations in the available database.

10. The method as defined in claim 1 wherein, as a result of clustering, the number of different origins and destinations in the fuzed database is less than the number of different origins and destinations in the available database.

11. Method for visually presenting patterns in data representing past transportings of various items among multiple locations, comprising the steps of:

gathering a multiplicity of alphanumeric data elements in categories relating to the origin, destination, and at least one other descriptor for each item transported;

processing said data elements by fusing a plurality thereof in at least one of the categories into one or more general data classes according to selectable affinity criteria; and

displaying a geographic representation of said processed data classes, whereby patterns in movement of said items may be discerned.

12. Method for visually presenting patterns in data representing transportation of items among multiple locations as described in claim 11 wherein said displaying step comprises the steps of:

displaying nodes representative of origins and destinations of transportings;

displaying an arc connecting the origins and destinations to represent such transportings; and

displaying adjacent the arc information representative of data classes formed from said at least one other descriptor.

13. Method for visually presenting patterns in data representing transportation of items among multiple locations as described in claim 12 further including the step of displaying the aggregate data associated with each node-arc pair when a particular node-arc pair is designated.

14. Method for visually presenting patterns in data representing transportation of items among multiple locations as described in claim 13 wherein said categories representing at least one other descriptor includes identity of said item.

15. Method for visually presenting patterns in data representing transportation of items among multiple locations as described in claim 14 wherein said categories of data elements further include time of said transporting of said item.

16. Method for visually presenting patterns in data representing transportation of items among multiple locations as described in claim 15 wherein said categories of data elements further include mode of said transporting of said item.

17. Method for visually presenting patterns in data representing transportation of items among multiple locations as described in claim 11 further including changing at least one of said affinity criteria and repeating the processing and displaying steps.