Offloading constraint enforcement in a hybrid DBMS

US10540346B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Daniel Martin · Stuttgart, DE
• Andreas Brodt · Gerlingen, DE
• Oliver Schiller · Seligenstadt, DE
• Felix Beier · Haigerloch, DE
• Knut Stolze · Jena, DE

Key dates

• Filing date: Aug 31, 2017
• Grant date: Jan 21, 2020
• Expiry date: Mar 30, 2038

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2379
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

The present disclosure relates to a method for enforcing constraints on data in a data processing system. The method comprises providing a set of constraints on the data. A first data update request may be received at the transactional engine and executes on the first dataset. A second data update request associated with the received data update request is determined and sent by the transactional engine to the analytical engine. The analytical engine executes the second data, resulting in a set of changes in the second dataset. The transactional engine commits the update of the first dataset before or after receiving the results of the checking of the set of constraints. The update on the first dataset is aborted by the transactional engine in response to receiving the results of the checking of the set of constraints, wherein the results indicate that the set of constraints are not met.