System and method for maintaining codes among distributed databases using a global database
First Claim
1. 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, thenreceiving 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, anddistributing 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, thenreceiving a query,retrieving, from said global code database, said record identified by said query, andpresenting values of said record to the client;
(4) if said request is a request to update said field value of said record, thenreceiving an updated field value of said record,updating said field value in said global code database with said updated field value, anddistributing 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, thendeleting said recoil from said global code database, anddistributing 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.
1 Assignment
0 Petitions
Accused Products
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.
285 Citations
49 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. 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. - View Dependent Claims (24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44)
-
-
45. 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. - View Dependent Claims (46, 47)
-
-
48. 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. - View Dependent Claims (49)
-
Specification