Dynamic synchronization of tables

A computer-readable medium having computer-executable instructions to a cause a source computer on a network to perform a method providing a synchronization stream comprising:

• obtaining static data from a table in key order;
• transmitting the static data in the synchronization stream;
• identifying changes to the table that are uncommitted after transmitting the static data;
• transmitting the uncommitted changes in the synchronization stream;
• determining when an uncommitted change commits after transmitting the uncommitted change in the synchronization stream;
• transmitting information regarding the commit of the uncommitted change on the network;
• and
• transmitting an message to initiate active transactions.

A computer-readable medium having computer-executable instructions to a cause a destination computer on a network to perform a method of applying data received in a synchronization stream to a table comprising:

• receiving static table data in the synchronization stream;
• creating the table from the static data;
• receiving uncommitted changes in the synchronization stream;
• queuing the uncommitted changes;
• receiving information on the network regarding an uncommitted change in the queue that commits;
• deleting the uncommitted change that committed from the queue;
• receiving an message to initiate active transactions;
• identifying active transactions;
• and
• initiating the identified active transactions.

A computer-readable medium having stored thereon a data stream for synchronizing a table comprising:

• static data for the table;
• a first end-of-stream message;
• snapshot data for the table;
• an end-of-snapshot message;
• and
• a second end-of stream message.

A computer-readable medium having stored thereon a control stream for synchronizing a table comprising:

• an end-of-snapshot-response message;
• an initialize-remote-transaction message;
• and
• an initialize-remote-transaction-response message.

A network comprising:

• a source node computer comprising:
• a processing unit coupled to the network through a system bus;
• a system memory coupled to the processing unit through a system bus, wherein a table shared among computers on the network is cached in the system memory;
• a computer-readable medium coupled to the processing unit through a system bus;
• and
• a synchronization source process executed from the computer-readable medium of the source by the processing unit of the source node, wherein the synchronization source process causes the processing unit of the source node to create an synchronization stream from data for the shared table and to transmit the synchronization stream on the network;
• and
• a destination node computer comprising:
• a processing unit coupled to the network through a system bus;
• a system memory coupled to the processing unit through a system bus;
• a computer-readable medium coupled to the processing unit through a system bus;
• and
• a synchronization destination process executed from the computer-readable medium of the destination node by the processing unit of the destination node, wherein the synchronization destination process causes the processing unit of the destination node to receive then synchronization stream from the network and to create the shared table in the system memory.