Offloading constraint enforcement in a hybrid DBMS

A data processing system for enforcing constraints on data, the data processing system comprising a transactional engine maintaining a first dataset and an analytical engine maintaining a second dataset, the second dataset comprising at least part of the first dataset, the data processing system being configured for:

• providing a set of constraints on the data;
• receiving a first data update request at the transactional engine;
• executing the first data update request on the first dataset;
• determining a second data update request associated with the received data update request;
• sending, by the transactional engine, the second data update request to the analytical engine;
• checking, by the analytical engine, the set of constraints of the data on the second dataset;
• executing, by the analytical engine, the second data update request on the second dataset, resulting in a set of changes in the second dataset;
• committing, by the analytical engine, the set of changes in response to the set of constraints being met, otherwise aborting the set of changes;
• communicating, by the analytical engine, results of checking the set of constraints to the transactional engine;
• committing, by the transactional engine, the update of the first dataset before or after receiving the results of the checking of the set of constraints,
• wherein the committing of the update of the first dataset being performed before receiving the results of the checking of the set of constraints;
• and
• aborting the update on the first dataset, by the transactional engine, in response to receiving the results of the checking of the set of constraints and in case the results indicate that the set of constraints are not met,
• wherein the aborting comprises undoing the set of changes caused by the execution of the first data update request and indicating that the committed set of changes, by the transactional engine, do not fulfil the set of constraints.

A computer program product comprising a non-transitory computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to perform a method comprising:

• providing a set of constraints on the data;
• receiving a first data update request at the transactional engine;
• executing the first data update request on the first dataset;
• determining a second data update request associated with the received data update request;
• sending, by the transactional engine, the second data update request to the analytical engine;
• checking, by the analytical engine, the set of constraints of the data on the second dataset;
• executing, by the analytical engine, the second data update request on the second dataset, resulting in a set of changes in the second dataset;
• committing, by the analytical engine, the set of changes in response to the set of constraints being met, otherwise aborting the set of changes;
• communicating, by the analytical engine, results of checking the set of constraints to the transactional engine;
• committing, by the transactional engine, the update of the first dataset before or after receiving the results of the checking of the set of constraints,
• wherein the committing of the update of the first dataset being performed before receiving the results of the checking of the set of constraints;
• and
• aborting the update on the first dataset, by the transactional engine, in response to receiving the results of the checking of the set of constraints and in case the results indicate that the set of constraints are not met,
• wherein the aborting comprises undoing the set of changes caused by the execution of the first data update request and indicating that the committed set of changes, by the transactional engine, do not fulfil the set of constraints.