System and Method for Performing a Transaction in a Massively Parallel Processing Database

A method for transaction processing in an MPP database, the method comprising:

• transmitting, by a first resource manager, to a transaction manager, a first snapshot of the first resource manager;
• receiving, by the resource manager, from the transaction manager, a reconciled snapshot in accordance with the first snapshot of the first resource manager and a second snapshot of a second resource manager;
• and
• performing a first transaction using the reconciled snapshot.

A transaction manager of an MPP database comprising:

• a processor;
• and
• a computer readable storage medium storing programming for execution by the processor, the programming including instructions to
• receive, by the transaction manager, from a first resource manager, a first snapshot of the first resource manager,
• receive, by the transaction manager, from a second resource manager, a second snapshot of the second resource manager,
• reconcile the first snapshot of the first resource manager and the second snapshot of the second resource manager,
• transmit, by the transaction manager, to the first resource manager and the second resource manager, the reconciled snapshot, and
• perform a transaction using the reconciled snapshot.

A first resource manager of an MPP database comprising:

• a processor;
• and
• a computer readable storage medium storing programming for execution by the processor, the programming including instructions to
• transmit, by the first resource manager, to a transaction manager, a first snapshot of the first resource manager,
• receive, by the first resource manager, a reconciled snapshot and a second snapshot of a second resource manager, and
• perform a transaction using the reconciled snapshot.