Replicated database synchronization method whereby primary database is selected queries to secondary databases are referred to primary database, primary database is updated, then secondary databases are updated

Claim 3

The method of claim 1 , further comprising the step of receiving a ready-to-commit acknowledgment from each of said non-selected databases indicating receipt of said update data and said pointer data prior to said step of transmitting to said selected database said update data for updating said at least one record.

Claim 4

The method of claim 1 , wherein said step of transmitting to each of said non-selected databases update data for updating said at least one record and pointer data identifying said selected database comprises the step of holding said update data in a queue.

Claim 5

The method of claim 3 , wherein said queue forms a portion of each of said non-selected databases.

Claim 6

The method of claim 1 , wherein said step of transmitting to each of said non-selected databases update data for updating said record and pointer data identifying said selected database comprises the step of updating a pointer field in each of said plurality of non-selected databases with said pointer data.

Claim 7

The method of claim 1 , wherein said step of transmitting to said selected database said update data for updating said at least one record in said selected database further comprises the step of updating a pointer field in said selected database indicating that the database has been selected.

Claim 8

The method of claim 1 , further comprising the step of receiving a commit response from said selected database indicating that said at least one record has been updated prior to said step of instructing said non-selected databases to update said at least one record with said update data.

Claim 9

The method of claim 1 , wherein said method is performed for a plurality of records.

Claim 12

A database system comprising; a plurality of replicated databases, each of said plurality of replicated databases comprising a plurality of records; and a database provisioning system having a provisioning system processor configured to control said plurality of replicated databases so as to update at least one record of said plurality of records in each of said plurality of replicated databases, as necessary, said provisioning system processor being programmed to: select one of said plurality of replicated databases as a selected database with the remaining databases being non-selected databases; transmit to each of said non-selected databases update data for updating said at least one record and pointer data identifying said selected database; redirect queries regarding said at least one record made to said non-selected databases to said selected database in accordance with said pointer data; transmit to said selected database said update data for updating said at least one record in said selected database, said at least one record in said selected database being updated with said update data; instruct said non-selected databases to update said at least one record with said update data; and instruct said non-selected databases to clear said pointer data so that queries regarding said at least one record are once again handled by said non-selected databases.

Claim 13

A database system comprising; a plurality of replicated databases, each of said plurality of replicated databases comprising a plurality of records; and a database provisioning system having a provisioning system processor configured to control said plurality of replicated databases so as to update at least one record of said plurality of records in each of said plurality of replicated databases, as necessary, said provisioning system processor being programmed to: select one of said plurality of replicated databases as a selected database with the remaining databases being non-selected databases; transmit to each of said non-selected databases update data for updating said at least one record and pointer data identifying said selected database; redirect queries regarding said at least one record made to said non-selected databases to said selected database in accordance with said pointer data; transmit to said selected database said update data for updating said at least one record in said selected database, said at least one record in said selected database being updated with said update data; instruct said non-selected databases to update said at least one record with said update data; and instruct said non-selected databases to clear said pointer data so that queries regarding said at least one record are once again handled by said non-selected databases.

Claim 14

The system of claim 10 , wherein said provisioning system processor is programmed to receive a ready-to-commit acknowledgment from each of said non-selected databases indicating receipt of said update data and said pointer data prior to said provisioning system processor transmitting to said selected database said update data for updating said at least one record in said selected database.

Claim 15

The system of claim 10 , wherein each of said plurality of non-selected databases comprises a memory queue for storing said update data for updating said at least one record.

Claim 16

The system of claim 10 , wherein each of said plurality of records in each of said plurality of replicated databases includes a pointer field, said processor being programmed to cause each of said non-selected databases to write said pointer data into each respective pointer field.

Claim 17

The system of claim 10 , wherein each of said of plurality of records in each of said plurality of replicated databases includes a pointer field, said processor being programmed to cause said selected database to indicate in said pointer field of said at least one record being updated that the database has been selected.

Claim 18

The system of claim 14 , wherein said pointer field of said at least one record being updated in said selected database is set to a predetermined value which indicates that the database has been selected.

Claim 19

The system of claim 15 , wherein said predetermined value is zero.

Claim 20

The system of claim 10 , wherein said provisioning system processor is further programmed to receive a commit response from said selected database indicating that said at least one record has been updated prior to said provisioning system processor instructing said non-selected databases to update said at least one record with said update data.

Claim 21

A database system comprising: a plurality of replicated databases, each of said plurality of replicated databases comprising a memory queue and a plurality of records each including a pointer field; and a database provisioning system having a provisioning system processor configured to control said plurality of replicated databases so as to update at least one record of said plurality of records in each of said plurality of replicated databases, as necessary, said provisioning system processor being programmed to: select one of said plurality of replicated databases as a selected database with the remaining databases being non-selected databases; transmit to each of said non-selected databases update data for updating said at least one record and pointer data identifying said selected database, said update data being stored in said memory queue in each of said non-selected databases and said pointer field in said at least one record in each of said non-selected databases being updated with said pointer data; redirect queries regarding said at least one record made to said non-selected databases to said selected database in accordance with said pointer data; transmit to said selected database said update data to update said at least one record in said selected database with said update data once a ready-to-commit acknowledgment signal is received from each of said non-selected databases in a first predetermined amount of time indicating receipt of said update data and said pointer data, if said ready-to-commit acknowledgment signal is not received from each of said non-selected databases within said first predetermined period of time, then said provisioning system processor is programmed to: instruct each of said non-selected databases to delete said update data from each respective memory queue; and instruct each of said non-selected databases to clear said pointer data from each respective pointer field so that queries regarding said at least one record are once again handled by said non-selected databases; otherwise, said provisioning system processor is programmed to: instruct said non-selected databases to update each respective said at least one record with said update data and to clear said pointer data from each respective pointer field so that queries regarding said at least one record are once again handled by said non-selected databases once a commit acknowledgment signal is received from said selected database in a second predetermined period of time indicating that said at least one record has been updated in said selected database, if said commit acknowledgment signal is not received from said selected database within said second predetermined period of time, then said provisioning system processor is programmed to: instruct each of said non-selected databases to delete said update data from each respective memory queue; and instruct each of said non-selected databases to clear said pointer data from each respective pointer field so that queries regarding said at least one record are once again handled by said non-selected databases.

Claim 22

A database system comprising: a plurality of replicated databases, each of said plurality of replicated databases comprising a memory queue and a plurality of records each including a pointer field; and a database provisioning system having a provisioning system processor configured to control said plurality of replicated databases so as to update at least one record of said plurality of records in each of said plurality of replicated databases, as necessary, said provisioning system processor being programmed to: select one of said plurality of replicated databases as a selected database with the remaining databases being non-selected databases; transmit to each of said non-selected databases update data for updating said at least one record and pointer data identifying said selected database, said update data being stored in said memory queue in each of said non-selected databases and said pointer field in said at least one record in each of said non-selected databases being updated with said pointer data; redirect queries regarding said at least one record made to said non-selected databases to said selected database in accordance with said pointer data; transmit to said selected database said update data to update said at least one record in said selected database with said update data once a ready-to-commit acknowledgment signal is received from each of said non-selected databases in a first predetermined amount of time indicating receipt of said update data and said pointer data, if said ready-to-commit acknowledgment signal is not received from each of said non-selected databases within said first predetermined period of time, then said provisioning system processor is programmed to: instruct each of said non-selected databases to delete said update data from each respective memory queue; and instruct each of said non-selected databases to clear said pointer data from each respective pointer field so that queries regarding said at least one record are once again handled by said non-selected databases; otherwise, said provisioning system processor is programmed to: instruct said non-selected databases to update each respective said at least one record with said update data and to clear said pointer data from each respective pointer field so that queries regarding said at least one record are once again handled by said non-selected databases once a commit acknowledgment signal is received from said selected database in a second predetermined period of time indicating that said at least one record has been updated in said selected database, if said commit acknowledgment signal is not received from said selected database within said second predetermined period of time, then said provisioning system processor is programmed to: instruct each of said non-selected databases to delete said update data from each respective memory queue; and instruct each of said non-selected databases to clear said pointer data from each respective pointer field so that queries regarding said at least one record are once again handled by said non-selected databases.