US4714995A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Computer integration system
Assignee: Northrop Grumman Corp
•
Filing: 1985-09-13
•
Granted: 1987-12-22
•
Expires: 2005-09-13
Abstract
Abstract Apparatus for integrating independent computer systems with associated heterogeneous data bases having some common or shared data entities. The apparatus includes an update capturing module installed at each of the computer systems, for capturing update transactions involving shared data entities, and a central data translator, which receives the updates from the update capturing modules, translates the updates into appropriate record formats and data base schemas, and transmits the translated replicas to the appropriate separate computer systems, where the updates are directly or indirectly entered into the corresponding data bases, thereby ensuring consistency among the separate but related data bases.
Inventors
- 👤 Anthony T. Materna
- 👤 Roger A. Vossler
- 👤 Frank M. Stepczyk
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-27 22:21
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/12; G06F40/151; G06F16/00; G06F16/20; G06F16/25; G06F16/258; G06F16/27; H; H04; H04L; H04L69/00; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 12
Claim 1
Independent Claim
274 words
In a system for integrating a plurality of host computer systems having separate and local data bases having different organization and record formats with at least some items of data being included in more than one of the local data bases, said data items being designated "shared data items", and integrating system for ensuring that the values of the shared data items in the different local data bases are maintained consistent with each other, the integrating system comprising: data translator means for translating data items received from any one of the local data bases for use in any other of the local data bases; a communications network connecting the computer systems and the data translator means; a plurality of update managers, each update manager being in communication with one of the host computer systems having a local data base, and each update manager including update capture means for transmitting to the data translator means over the communications network the values of any changes made by the update manager associated with the host computer to shared data in that computer's local data base, and update receiver means for receiving translated data base changes from the data translator over the communications network; wherein the data translator means translates data base changes from the data base organizaiton and record format in which they are received into one or more other data base organizations and record formats, and transmits the translated changes over the communications network to each of the host computer local data bases, thereby ensuring consistency of the separate local data bases without imposing on any of them a particular data base organization or record format.
Claim 2
Dependent Claim
274 words
In a system for integrating a plurality of host computer systems having separate and local data bases having different organization and record formats with at least some items of data being included in more than one of the local data bases, said data items being designated "shared data items", and integrating system for ensuring that the values of the shared data items in the different local data bases are maintained consistent with each other, the integrating system comprising: data translator means for translating data items received from any one of the local data bases for use in any other of the local data bases; a communications network connecting the computer systems and the data translator means; a plurality of update managers, each update manager being in communication with one of the host computer systems having a local data base, and each update manager including update capture means for transmitting to the data translator means over the communications network the values of any changes made by the update manager associated with the host computer to shared data in that computer's local data base, and update receiver means for receiving translated data base changes from the data translator over the communications network; wherein the data translator means translates data base changes from the data base organizaiton and record format in which they are received into one or more other data base organizations and record formats, and transmits the translated changes over the communications network to each of the host computer local data bases, thereby ensuring consistency of the separate local data bases without imposing on any of them a particular data base organization or record format.
Claim 3
Dependent Claim
36 words
A system as defined in claim 1, in which: the data translator means includes a dictionary module for storing the record formats and data base organizations of the data bases associated with the separate computer systems.
Claim 4
Dependent Claim
63 words
An integrating system as defined in claim 1, and further comprising: query data base means connected to the data translator means for receiving from data translator an additional replica of common data base items and for storing said common data; and query processing means, coupled to the query data base, for receiving and responding to requests for information from the query data base.
Claim 5
Dependent Claim
84 words
An integrating system as defined in claim 1, in which the data translator means includes: a communications module for controlling transmission of data over the communications network; a dictionary module containing data base organizations and record formats of the separate data bases; and one or more transform modules for performing said translations of data base changes using the information in the dictionary module on the organization and record format of each of said host computers which is to receive the translated data base changes;
Claim 6
Dependent Claim
45 words
An integrating system as defined in claim 4, in which the data translator further includes: an authorization and security module to ensure the integrity of the data bases; and a recovery module to ensure consistency of the data bases following an inadvertent disruption of processing.
Claim 7
Dependent Claim
41 words
An integrating system as defined in claim 1, in which the update capture means includes: a data server to identify data base updates relating to items of common data; and storage means for temporarily storing updates provided by the data server.
Claim 8
Dependent Claim
42 words
An integrating system as defined in claim 6, in which: the data server is interposed between an application program and an associated data base management system, to identify commands issued to the data base management system that relate to common data updates.
Claim 9
Dependent Claim
30 words
An integrating system as defined in claim 6, in which: the data server is activated by an application program each time an update function is performed by the application program.
Claim 10
Dependent Claim
40 words
An integrating system as defined in claim 6, in which: the data server derives update information from a data base management system associated with an application program that performs updates from time to time through the data base management system.
Claim 11
Dependent Claim
28 words
An integrating system as defined in claim 1, in which: the update manager transmits updates received from the data translator means directly to a data base management system.
Claim 12
Dependent Claim
43 words
An integrating system as defined in claim 1, in which: the update manger transmits updates received from the data translator means into an input queue for an applicaiton, which is then responsible for transmitting the updates to an associated data base management system.
References Cited (Backward Citations)
US4604686A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1990-12-21 | 1991-06-22 | 1991-12-22 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 1994-12-21 | 1995-06-22 | 1995-12-22 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 1998-12-21 | 1999-06-22 | 1999-12-22 | $7700.00 | Window Closed / Lapsed |