Commit processing system which provides a list of sites to each site to allow for direct communication between participation sites and the transaction generation site

A distributed database system, comprising:

• a plurality of sites, each having a computer and a database;
• communication means for interconnecting the plurality of sites to receive a received transaction and transmit a transmitted transaction between the sites, wherein the site which transmits a transmitted transaction is a transaction generation site;
• wherein the databases store data for processing, and in at least one of the plurality of sites the computer includes:
• transaction generation means for generating a transaction;
• communication management means for managing communication through the communication means;
• transaction execution means for executing data processing of the transaction generated by the transaction generation means and the received transaction communicated by another site through and communication management means on the data stored in the database;
• list creation means for creating a list of sites, which must execute data processing in response to the transaction generated by the transaction generation means, the sites other than the transaction generation site being participation sites wherein at least one of said participation sites must forward a processing request to another one of said participation sites for the completion of the transaction, and for sending the list to all participation sites through the communication management means wherein said list identifies said transaction generation site.
• commit preparation process means for commit preparation processing of the transaction when the transaction execution means finishes executing data processing of the transaction, and for directly sending a commit preparation message to said transaction generation site based upon said list through the communication management means;
• and
• commit process means for executing commit processing of the transaction with no delay after preparation for commit processing by the commit preparation process means, if the communication management means receives the commit preparation completion messages, generated by each participation site when the participation site finishes its respective data processing of the transaction, from all participation sites before the transaction execution means finishes executing data processing of the transaction.

A distributed database system, comprising:

• a plurality of sites, each having a computer and a database;
• communication means for interconnecting the plurality of sites to receive a received transaction and transmit a transmitted transaction between the sites, wherein the site which transmits a transmitted transaction is a transaction generation site;
• wherein the databases store data for processing, and in at least one of the plurality of sites the computer includes:
• transaction generation means for generating a transaction;
• communication management means for managing communication through the communication means;
• transaction execution means for executing data processing of the transaction generated by the transaction generation means and the received transaction communicated by other site through the communication management means, on the data stored in the database;
• list creation means for creating a list of sites which must execute data processing in response to the transaction generated by the transition generation means, the sites other than the transaction generation site being participation sites wherein at least one of said participation sites must forward a processing request to another one of said participation sites for the completion of the transaction and for sending the list to all participation site through the communication management means wherein said list identifies said transaction generation site;
• commit preparation process means for commit preparation processing of the transaction when the transaction execution means finishes executing data processing of the transaction, and for directly sending a commit preparation completion message to said transaction generation site based upon said list through the communication management means;
• and
• commit process means for executing an abort processing of the transaction when the communication management means does not receive a commit preparation completion message, generated by each participation site when the participation site finishes its respective data processing of the transaction, from all participation sites within a predetermined period after the commit preparation process means has sent the commit preparation completion message.