US5581749A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for maintaining codes among distributed databases using a global database
Assignee: Dow Chemical Co
•
Filing: 1992-12-21
•
Granted: 1996-12-03
•
Expires: 2012-12-21
Abstract
Abstract A global code system maintains reference records for multiple transaction processing systems on a central database (called a global code database). A client (i.e., a user or an external application) cannot directly create reference records on a transaction processing system. Instead, the client must request the global codes system to create a reference record. The global code system responds, in real time, by adding the record to the global codes database and by distributing the record to one or more transaction processing systems in real time. Similarly, the client cannot directly update or delete reference records on the transaction processing system. Instead, the client must request the global code system to update or delete the reference record. The global code system responds, in real time, by updating or deleting the reference record on the global codes database and by distributing the update or deletion to the transaction processing systems which had been instructed to create the record. In addition to distributing record creations, updates and deletions to the transaction processing systems, the global code system distributes these operations to one or more shadow code systems. Each shadow code system provides a copy of a subset of the reference records for read-only access by remote application programs.
Inventors
- 👤 K. Omar Hossain
- 👤 James J. Whyte
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 06:56
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/08; G06F; G06F16/00; G06F16/20; G06F16/27; G06Q10/087
Claims Analysis
Total Claims: 53
Claim 1
Independent Claim
306 words
A computer-based method which enables a client to maintain reference codes on multiple transaction processing systems in a transaction processing environment, the method comprising the steps of: (1) receiving from the client a code maintenance request to carry out a code maintenance operation; (2) if said request is a request to create a record, then receiving a field value of said record from said request, creating said record with said field value on a global code database of a global code system, and distributing a create message to a distribution target, wherein said create message instructs said distribution target to create a copy of said record with said field value on an associated target database; (3) if said request is a request to read said record, then receiving a query, retrieving, from said global code database, said record identified by said query, and presenting values of said record to the client; (4) if said request is a request to update said field value of said record, then receiving an updated field value of said record, updating said field value in said global code database with said updated field value, and distributing an update message to said distribution target, wherein said update message instructs said distribution target to update said copy of said record on said associated target database; and (5) if said request is a request to delete said record, then deleting said recoil from said global code database, and distributing a delete message to said distribution target, wherein said delete message instructs said associated target database to delete said copy of said record on said target database, wherein said code maintenance operation is carried out on said record in said global code database before being carried out on said copy of said record in any of said target databases of the multiple transaction processing systems.
Claim 2
Dependent Claim
306 words
A computer-based method which enables a client to maintain reference codes on multiple transaction processing systems in a transaction processing environment, the method comprising the steps of: (1) receiving from the client a code maintenance request to carry out a code maintenance operation; (2) if said request is a request to create a record, then receiving a field value of said record from said request, creating said record with said field value on a global code database of a global code system, and distributing a create message to a distribution target, wherein said create message instructs said distribution target to create a copy of said record with said field value on an associated target database; (3) if said request is a request to read said record, then receiving a query, retrieving, from said global code database, said record identified by said query, and presenting values of said record to the client; (4) if said request is a request to update said field value of said record, then receiving an updated field value of said record, updating said field value in said global code database with said updated field value, and distributing an update message to said distribution target, wherein said update message instructs said distribution target to update said copy of said record on said associated target database; and (5) if said request is a request to delete said record, then deleting said recoil from said global code database, and distributing a delete message to said distribution target, wherein said delete message instructs said associated target database to delete said copy of said record on said target database, wherein said code maintenance operation is carried out on said record in said global code database before being carried out on said copy of said record in any of said target databases of the multiple transaction processing systems.
Claim 3
Dependent Claim
37 words
The method of claim 1, wherein if said request is a request to discontinue said record, then marking said record on said global code database to indicate that said field values cannot be changed by said client.
Claim 4
Dependent Claim
60 words
The method of claim 1, wherein if said request is a request to outsee said record to a superseding record, then inserting in said record on said global codes database a pointer to said superseding record, and distributing an outsee message instructing said associated target database to insert said pointer in said copy of said record on said target database.
Claim 5
Dependent Claim
44 words
The method of claim 1, further comprising the steps of: receiving standardized input from a user; extracting said request from said standardized input; generating standardized output from said values of said record retrieved in step (3); and sending said standardized output to said user.
Claim 6
Dependent Claim
46 words
The method of claim 1, further comprising the steps of: receiving standardized input from an external application; extracting said request from said standardized input; generating standardized output from said values of said record retrieved in step (3); and sending said standardized output to said external application.
Claim 7
Dependent Claim
36 words
The method of claim 1, further comprising the steps of: determining a security profile of said client; and carrying out said code maintenance operation only if said code maintenance request is permitted by said security profile.
Claim 8
Dependent Claim
36 words
The method of claim 1, further comprising the steps of: determining a record profile of said record; and carrying out said code maintenance operation only if said code maintenance request is permitted by said record profile.
Claim 9
Dependent Claim
39 words
The method of claim 1, further comprising the steps of: determining a record profile of said record; and carrying out said code maintenance operation only if said field value received is within a range permitted by said record profile.
Claim 10
Dependent Claim
23 words
The method of claim 1, further comprising the step of logging said code maintenance operation on a logical code maintenance operation audit trail.
Claim 11
Dependent Claim
30 words
The method of claim 9, further comprising a step of logging each component physical code maintenance operation of said code maintenance operation on a physical code maintenance operation audit trail.
Claim 12
Dependent Claim
34 words
The method of claim 1, further comprising the steps of: generating an acknowledgement if said code maintenance operation terminates successfully, and generating an error code if said code maintenance operation does not terminate successfully.
Claim 13
Dependent Claim
45 words
The method of claim 1, wherein if said request is a request to perform said code maintenance operation in a background mode, then: asynchronously carrying out said code maintenance operation; and receiving any additional code maintenance request operation before completion of said code maintenance operation.
Claim 14
Dependent Claim
131 words
The method of claim 1, wherein said distributing step of steps (2), (4) and (5) comprises the steps of: generating a base message to instruct said distribution target to perform a distribution operation on said record; identifying any support record, wherein said support record either directly or indirectly supports said record; generating a support message to instruct said distribution target to perform said distribution operation on said support record; stacking said base message and each said support message in a distribution package so that no relative base message associated with a relative base record occurs in said distribution package before a relative support message associated with relative support record, wherein said relative support record is a support record of said base record; and sending said distribution package to said distribution target.
Claim 15
Dependent Claim
43 words
The method of claim 13, wherein said step of generating said support message comprises the step of determining whether a support message associated with a selected support record has been sent to said distribution target and, if not, then generating said support message.
Claim 16
Dependent Claim
59 words
The method of claim 1, wherein said distributing step of steps (2), (4) and (5) comprises the steps of: identifying a destination area of the transaction processing environment from which said request was issued; and selecting as said distribution target a transaction processing system in said destination area wherein said distribution target maintains a file associated with said record.
Claim 17
Dependent Claim
43 words
The method of claim 1, wherein said distributing step of steps (2), (4) and (5) comprises the steps of: identifying a destination area from which said request was made; and selecting as said distribution target a shadow code system in said destination area.
Claim 18
Dependent Claim
25 words
The method of claim 1, further comprising the step of logging said distributing step of steps (2), (4) and (5) on a distribution audit trail.
Claim 19
Dependent Claim
63 words
The method of claim 1, further comprising the steps of: receiving a distribution request to perform a distribution operation on said record; receiving a destination area; and distributing a distribution message to said distribution target in said destination area, wherein said distribution message instructs said distribution target to perform said distribution operation on said copy of said record on said associated target database.
Claim 20
Dependent Claim
63 words
The method of claim 1, wherein said distributing step of step(s) (2), (4) and (5) comprises the step of generating a distribution message, wherein said distribution message instructs said distribution target to perform a distribution operation on said record so that said field values of said copy of said record include any language variations that comply with language restrictions of said distribution target.
Claim 21
Dependent Claim
55 words
The method of claim 1, wherein said distributing step of step(s) (2), (4) and (5) comprises the step of generating a distribution message, wherein said distribution message instructs said distribution target to perform a distribution operation on said record and wherein said distribution message is formatted according to a release version of said distribution target.
Claim 22
Dependent Claim
40 words
The method of claim 1, further comprising the steps of: detecting an exceptional error during said code maintenance operation; capturing system-specific information; and writing an indication of said exceptional error and said system-specific information to an abnormal event audit trail.
Claim 23
Dependent Claim
63 words
The method of claim 21, further comprising the steps of: analyzing said exceptional error and said system-specific information to determine whether said exceptional error is potentially recoverable without human intervention, and, if it is, then attempting to recover from said error; determining whether said attempt was successful; and writing an indication of whether said attempt was successful to said abnormal event audit trail.
Claim 24
Dependent Claim
271 words
A computer-based system which maintains codes on multiple transaction processing systems in a transaction processing environment, comprising: a global code database; a distribution module which generates a message to instruct a distribution target in a destination area of one of the transaction processing systems to perform a distribution operation on a record; and a code maintenance module having: a create module having means for creating said record on said global code database and means for invoking said distribution module to instruct said distribution target to create a copy of said record on a target database associated with said distribution target, wherein a field value of said record is specified by a client, a read module having means for retrieving said record from said global code database using a query specified by said client, and means for presenting said record, an update module having means for updating said record in said global code database, and means for invoking said distribution module to instruct said distribution target to update said copy of said record in said target database, wherein said record and said field value am specified by said client, and a delete module having means for deleting said record from said global code database, and means far invoking said distribution module to instruct said distribution target to delete said copy of said record from said target database, wherein said record is specified by said client, wherein said code maintenance module operates on said record in said global code database before said distribution target operates on said copy of said record in any of said target databases of the multiple transaction processing systems.
Claim 25
Dependent Claim
271 words
A computer-based system which maintains codes on multiple transaction processing systems in a transaction processing environment, comprising: a global code database; a distribution module which generates a message to instruct a distribution target in a destination area of one of the transaction processing systems to perform a distribution operation on a record; and a code maintenance module having: a create module having means for creating said record on said global code database and means for invoking said distribution module to instruct said distribution target to create a copy of said record on a target database associated with said distribution target, wherein a field value of said record is specified by a client, a read module having means for retrieving said record from said global code database using a query specified by said client, and means for presenting said record, an update module having means for updating said record in said global code database, and means for invoking said distribution module to instruct said distribution target to update said copy of said record in said target database, wherein said record and said field value am specified by said client, and a delete module having means for deleting said record from said global code database, and means far invoking said distribution module to instruct said distribution target to delete said copy of said record from said target database, wherein said record is specified by said client, wherein said code maintenance module operates on said record in said global code database before said distribution target operates on said copy of said record in any of said target databases of the multiple transaction processing systems.
Claim 26
Dependent Claim
46 words
The system of claim 23, wherein said code maintenance module further comprises a discontinue module having means for marking said record on said global code database to indicate that said field value cannot be changed by said client, wherein said record is specified by a client.
Claim 27
Dependent Claim
68 words
The system of claim 23, wherein said code maintenance module further comprises an outsee module having means for inserting in said record on said global codes database a pointer to a superseding record, wherein said record and said superseding record are specified by said client, and means for invoking said distribution module to instruct said distribution target to insert said pointer in said record on said target database.
Claim 28
Dependent Claim
80 words
The system of claim 23, further comprising a front end which handles communication between said client and said code maintenance module, said front end having: receiving means for receiving input from said client; means for extracting a request from said input; invoking means for invoking a module of said code maintenance module, wherein said module is specified by of said request; means for receiving output from said code maintenance module, and presenting means for presenting said output to said client.
Claim 29
Dependent Claim
31 words
The system of claim 26, wherein said front end comprises a computer interface which receives standardized request messages from an external application and sends standardized output messages to said external applications.
Claim 30
Dependent Claim
27 words
The system of claim 26, wherein said front end comprises a user interface which receives standardized requests from a user and sends standardized presentations to said user.
Claim 31
Dependent Claim
57 words
The system of claim 26, further comprising a security module having a security profile table, means for consulting said security profile table to determine authorized code maintenance operations, wherein said client is authorized to invoke said authorized code maintenance operations, and means for enabling said invoking means if said client is authorized to invoke said requested module.
Claim 32
Dependent Claim
73 words
The system of claim 23, further comprising a security module having a security profile table that indicates a security profile for each client authorized to use the system, means for consulting said security profile table to determine whether said client is authorized to invoke a requested module of said code maintenance module, and means for preventing said requested module from being invoked if said client is not authorized to invoke said requested module.
Claim 33
Dependent Claim
67 words
The system of claim 23, further comprising a security module having a record profile table which has entries for records maintained in the system, means for consulting said record profile table to determine whether a requested module of said code maintenance module is permitted to carry out a requested action on said record, and, if not, then preventing said requested module from carrying out said requested action.
Claim 34
Dependent Claim
53 words
The system of claim 23, further comprising a code maintenance audit log module which is invoked by said code maintenance module with physical code maintenance data, said audit log module comprising: a physical code maintenance audit trail, and means for writing said physical code maintenance data to said physical code maintenance audit trail.
Claim 35
Dependent Claim
49 words
The system of claim 32, wherein said code maintenance audit log module further comprises: a logical code maintenance audit trail, means for extracting logical code maintenance data from said physical code maintenance data, and means for writing said logical code maintenance data to said logical code maintenance audit trail.
Claim 36
Dependent Claim
39 words
The system of claim 23, further comprising: means for generating an acknowledgement if a requested module of said code maintenance module terminates successfully, and means for generating an error code if said requested module generates or detects an error.
Claim 37
Dependent Claim
72 words
The system of claim 23, further comprising a background transaction manager which is invoked if said client requests performance of a code maintenance operation in a background mode, said background transaction manager having: means for receiving input data entered by said client; means for invoking a requested code maintenance module to carry out said code maintenance operation in the background; and means for asynchronously communicating said input data to said requested module.
Claim 38
Dependent Claim
135 words
The system of claim 23, wherein said distribution module comprises: message generating means for generating a base message to instruct said distribution target to perform a distribution operation on said record, and generating, for each support record that supports said record, a support message to instruct said distribution target to perform said distribution operation on said support record; synchronization means for stacking said base message and each said support message in a distribution package so that each relative base message follows each relative support message, where said relative base message is a message associated with a relative base record, said relative support message is a message associated with a relative support record, and said relative support record supports said relative base record; and destination server means for sending said distribution package to said distribution target.
Claim 39
Dependent Claim
70 words
The system of claim 36, wherein said distribution module further comprises: support record identifying means for consulting a base-support table to identify any support record, wherein said support record either directly or indirectly supports said record; a base-support table which identifies support records that support records in said global codes database; and support record identifying means for consulting said base-support table to identify said support records that support said record.
Claim 40
Dependent Claim
38 words
The system of claim 23, wherein said distribution module comprises: a system layout table which identifies a potential distribution target in each said destination area; and means for consulting said system layout table to identify said distribution target.
Claim 41
Dependent Claim
16 words
The system of claim 23, further comprising a distribution audit log which records said distribution operation.
Claim 42
Dependent Claim
80 words
The system of claim 39, wherein said distribution module further comprises: optimizing means for consulting said distribution audit log to determine whether support record that supports said record has been sent to said distribution target; and means for causing a support message to be generated and sent to said distribution target if said support record has not been sent to said distribution target, wherein said support message instructs said distribution target to perform said distribution operation on said support record.
Claim 43
Dependent Claim
56 words
The system of claim 23, wherein said distribution module comprises: a permitted languages table that indicates acceptable language variations for said distribution target; and message generating means for identifying any language variation in said field of said record, and including said language variation in said message if said language variation is acceptable for said distribution target.
Claim 44
Dependent Claim
46 words
The system of claim 23, wherein said distribution module comprises: a release version table which indicates a release version of said destination target, and message generating means for consulting said release version table and generating said message in a format that complies with said release version.
Claim 45
Dependent Claim
45 words
The system of claim 23, further comprising: means for detecting an exceptional error; means for capturing system-specific information associated with said exceptional error; an abnormal event log; means for writing an indication of said exceptional error and said system-specific information to said abnormal event log.
Claim 46
Dependent Claim
82 words
The system of claim 43, further comprising an error management module having: means for analyzing said exceptional error and said system-specific information to determine whether said exceptional error is potentially recoverable without human intervention; means for attempting to recover from said exceptional error if said exceptional error is recoverable without human intervention; means for determining whether said attempt to recover was successful; and means for writing an indication of whether said attempt to recover was successful to said abnormal event audit trail.
Claim 47
Dependent Claim
120 words
A computer-based system for maintaining codes across multiple transaction processing systems, comprising: a global code database for maintaining a master list of records; modification means for modifying a record in said global code database in response to a code maintenance request from one of the multiple transaction processing systems; and distribution means for distributing a local copy of said modified record from said global code database to said requesting one of the multiple transaction processing systems and to any other ones of the multiple transaction processing systems which use said modified record, wherein said record is modified in said global code database before said local copy of said modified record is distributed to any of the multiple transaction processing systems.
Claim 48
Dependent Claim
120 words
A computer-based system for maintaining codes across multiple transaction processing systems, comprising: a global code database for maintaining a master list of records; modification means for modifying a record in said global code database in response to a code maintenance request from one of the multiple transaction processing systems; and distribution means for distributing a local copy of said modified record from said global code database to said requesting one of the multiple transaction processing systems and to any other ones of the multiple transaction processing systems which use said modified record, wherein said record is modified in said global code database before said local copy of said modified record is distributed to any of the multiple transaction processing systems.
Claim 49
Dependent Claim
162 words
The computer-based system of claim 45, wherein said modification means comprises: a create module having means for creating a record in said global code database and means for invoking said distribution means to instruct a distribution target of a transaction processing system to create a local copy of said record on a target database associated with said distribution target; a read module bring means for retrieving a record from said global code database using a query specified by a client; an update module having means for updating a record in said global code database and means for invoking said distribution means to instruct a distribution target of a transaction processing system to update a local copy of said record in a target database; and a delete module having means for deleting a record from said global code database and means for invoking said distribution means to instruct said distribution target to delete a local copy of said record from said target database.
Claim 50
Dependent Claim
60 words
The computer-based system of claim 45, wherein said distribution means comprises: means for distributing a message to said transaction processing systems, said message including said modified record and instructions for a distribution target in a destination area of a transaction processing system to perform a modification operation on said modified record to modify said local copy of said modified record.
Claim 51
Dependent Claim
121 words
A computer-based method for maintaining codes across multiple transaction processing systems, comprising the steps of: maintaining a master list of record in a global code database; receiving a code maintenance request from one of the multiple transaction processing systems; modifying a record in said global code database in response to said code maintenance request; and distributing a local copy of said modified record from said global code database to said one of the multiple transaction processing systems and to any other ones of the multiple transaction processing systems which use said mixed record. wherein said record is modified in said global code database before said local copy of said modified record is distributed to any of the multiple transaction processing systems.
Claim 52
Dependent Claim
121 words
A computer-based method for maintaining codes across multiple transaction processing systems, comprising the steps of: maintaining a master list of record in a global code database; receiving a code maintenance request from one of the multiple transaction processing systems; modifying a record in said global code database in response to said code maintenance request; and distributing a local copy of said modified record from said global code database to said one of the multiple transaction processing systems and to any other ones of the multiple transaction processing systems which use said mixed record. wherein said record is modified in said global code database before said local copy of said modified record is distributed to any of the multiple transaction processing systems.
Claim 53
Dependent Claim
235 words
The computer-based of claim 48, wherein said steps of modifying and distributing comprise the steps of: if said request is to create a record, then receiving a field value of said record, creating said record with said field value in said global code database, and distributing a create message to a distribution target, wherein said create message instructs said distribution target to create a copy of said record with said field value in an associated target database; if said request is to read a record, then receiving a query form one of the multiple transaction processing systems, retrieving said record identified by said query, and presenting values of said record to said one of the multiple transaction processing systems; if said request is a request to update a field value of a record, then receiving an updated field value of said record, updating said field value with said updated field value in said global code database, and distributing an update message to a distribution target, wherein said update message instructs said distribution target to update a local copy of said record in an associated target database; and said request is a request to delete a record, then deleting said record from said global code database, and distributing a delete message to a distribution target, wherein said delete message instructs an associated target database to delete said local copy of said record from said target database.
References Cited (Backward Citations)
US4432057A
Cited
US4868866A
Cited
US4714992A
Cited
US5230073A
Cited
US5058000A
Cited
US4881166A
Cited
US4945474A
Cited
US5136707A
Cited
US5093911A
Cited
US5216612A
Cited
US5361199A
Cited
US5261102A
Cited
US5231566A
Cited
US5333316A
Cited
US5418945A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-12-03 | 2000-06-03 | 2000-12-03 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-12-03 | 2004-06-03 | 2004-12-03 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-12-03 | 2008-06-03 | 2008-12-03 | $7700.00 | Window Closed / Lapsed |