Database system for facilitating comparison of related information stored in a distributed resource

• US 5,475,833 A
• Filed: 09/04/1991
• Issued: 12/12/1995
• Est. Priority Date: 09/04/1991
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kelley, Edward E., Dauerer, Norman J.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Loomis, John C.
• Application Number:
  US07/755,036
• Time in Patent Office: 1,560 Days
• Field of Search: 395/200, 395/600, 395/650, 395/700, 364/401, 364/403
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A database system and application for facilitating comparison of data between manufacturing lines or other business processes which are geographically separated or distributed includes a storage arrangement in which data from remote locations is shadowed and can be updated as necessary only from remote locations. The Intersite Line Comparison system (ILC) also controls the invoking of other applications in a manner which is transparent to the user and dynamically builds data comparisons in desired formats under user-friendly, menu-driven control. Automatic data conversion, including tables of equivalent groups of operations at different sites is provided to facilitate meaningful comparison of data from different sites.

Claims

1. A method of data retrieval from a virtual machine system including a distributed resource, said virtual machine system having a plurality of nodes, each said node including a plurality of applications and local storage for storing data items, said method comprising the steps of

storing selected data items from said distributed resource in said local storage including updating said local storage when one of a plurality of predetermined files of said distributed resource is altered,

displaying a menu of predetermined data reporting options,

selecting a data reporting option from said menu,

invoking at least one of said applications in response to said selecting of said data reporting option and selecting ones of said data items from said local storage in response to said step of selecting a data reporting option,

selecting further data from said local storage in response to said selecting of data items from said local storage based on a concordance of said data items and said selected data items from said distributed resource, and

reporting said data and said further data in a predetermined format corresponding to said step of selecting a data reporting option from said menu.

3. A system as recited in claim 1, wherein said means for invoking said at least one application includes means for converting said data reported from said means for storing said data and said shadow of data from one data format to another data format.

4. A system as recited in claim 1, wherein said means responsive to said selection invokes a plurality of said applications at said node.

5. A system as recited in claim 1, further including means for updating data from said at least one of said data sources in said means for storing said data and said shadow of data.

6. A system as recited in claim 1, further including means for updating said shadow of data from said another of said at least two data sources.

7. A system as recited in claim 6, wherein said means for updating said shadow of data from said another of said at least two data sources includes means for transmitting data from said another data source to said node.

8. A system as recited in claim 7, wherein said means for transmitting said data to said node includes encryption means.

9. A system as recited in claim 1, wherein said means for displaying a menu of functions and selecting a function therefrom includes means for displaying another menu at another level of a hierarchy of functions.

10. A system as recited in claim 1, wherein said means for displaying a menu of functions and selecting a function therefrom includes means for specifying selection of at least said data and said shadow of data in a selectable order.

11. A system as recited in claim 10, further including means for selectively establishing a display format for said display of said data reported through said application.

12. A system as recited in claim 1, further including means for grouping data returned from said means for storing said data and said shadow of data into predetermined groups.

13. A system as recited in claim 12, wherein said means for grouping data includes a look-up table.

2. A system for facilitating comparison of data from at least two data sources including

a node of a network receiving data from at least one of said data sources and a shadow of data from another of said at least two data sources including means for storing said data and said shadow of data,

means for displaying a menu of functions including at least one data reporting function and selecting a function therefrom,

means responsive to said selection from said menu of functions for invoking at least one application at said node, said application including means for reporting data from said means for storing said data and said shadow of data through said at least one application, and

means for selectively displaying said data reported through said at least one application.