System for ensuring transactional integrity thereof that includes a plurality of subsystems, one of which takes an action upon a loss of transactional integrity

A system that is configured to ensure transactional integrity thereof, the system comprising:

• (a) a parent node including a parent node processor;
• (b) a first subsystem that executes transactions, each transaction including a BEGIN step, and one or more data manipulation language (DML) or data definition language (DDL) operations, the first subsystem including:
• (i) a first hardware processor,
• (ii) a first application executing in the first hardware processor,
• (iii) a first indicia engine, and
• (iv) a first instance of a database used by the first application;
• and
• (c) a second subsystem that executes transactions, each transaction including a BEGIN step, and one or more data manipulation language (DML) or data definition language (DDL) operations, the second subsystem including:
• (i) a second hardware processor,
• (ii) a second application executing in the first hardware processor,
• (iii) a second indicia engine, and
• (iv) a second instance of a database used by the first application,
• wherein the first subsystem is configured to receive a request to process a transaction, and
• wherein the second subsystem is configured to receive the same request to process a transaction that was received at the first subsystem, and
• wherein the first application executing in the first hardware processor and the second application executing in the second hardware processor are each configured to execute the request to process a transaction in their respective first and second instances of the first and second subsystem's databases, and
• wherein the first and second indicia engines are configured to compute respective indicia of the outcome of the processing of the request, the indicia being dependent upon at least a subset of the DML or DDL operations, and
• wherein the first and second indicia engines are further configured to send their respective computed indicia to the parent node, and
• wherein the parent node processor is further configured to compare the computed indicia received from the first and second indicia engines, and
• wherein one of the first and second subsystems is further configured to complete an action when the comparison indicates that the computed indicia of the second subsystem does not match the computed indicia of the first subsystem, thereby indicating a lack of transactional integrity in one or both of the first and second subsystems, wherein the action completed at one of the first and second subsystems is one or more of:
• (A) issuing a database rollback on one of the first and second subsystems,
• (B) executing self-diagnostics on one of the first and second subsystems,
• (C) shutting down one of the first and second subsystems,
• (D) taking one of the first and second subsystems offline,
• (E) aborting the transaction executing on one of the first and second subsystems, and
• (F) generating an error indication for one of the first and second subsystems.

A system that is configured to ensure transactional integrity thereof, the system comprising a plurality of subsystems that execute transactions, each transaction including a BEGIN step, and one or more data manipulation language (DML) or data definition language (DDL) operations, each subsystem including:

• (a) a hardware processor,
• (b) an application executing in the hardware processor,
• (c) an indicia engine, and
• (d) an instance of a database used by the application,
• wherein each subsystem is configured to receive a request to process a transaction, the request received at each subsystem being the same request,
• wherein the application executing in the hardware processor at each subsystem is configured to process the request in the instance of the subsystem's database,
• wherein the indicia engine at each subsystem is configured to compute indicia of the outcome of the processing of the request, wherein the indicia is dependent upon at least a subset of the DML or DDL operations,
• wherein the indicia engine at one of the subsystems is further configured to compare the computed indicia from the plurality of subsystems, and identify a majority of the subsystems having the same computed indicia, and
• wherein one of the subsystems is further configured to complete an action when the comparison indicates that the computed indicia at the one subsystem does not match the computed indicia of the majority of the subsystems, thereby indicating a lack of transactional integrity in the one subsystem, wherein the action completed at one of the subsystems is one or more of:
• (a) issuing a database rollback on the one subsystem,
• (b) executing self-diagnostics on the one subsystem,
• (c) shutting down the one subsystem,
• (d) taking the one subsystem offline,
• (e) aborting the transaction executing on the one subsystem, and
• (f) generating an error indication for the one subsystem.