Data Integrity 2.0. The biggest advancement in data quality in 30 years! by Connor McDonald @DevoxxForever
Data Integrity 2.0. The biggest advancement in data quality in 30 years! by Connor McDonald  @DevoxxForever
Uploaded April 2026 | Updated September 2026, 2 weeks ago
#VDZ26
At various times over the past 30 years, most relational database platforms have implemented the core components of declarative data integrity - primary keys, uniqueness, check constraints and foreign keys. Whist these remain a critical part of the database, the real-life business rules about your data are much more complex. They can't be implemented with the simple data integrity rules that exist today, and hence modern applications are filled with code to enforce these rules at the application level.

The SQL standard always knew that business rules would be more complex and provided a mechanism called "SQL Assertions" to declaratively enforce complex, cross-table invariants directly in the database. But no database vendor has ever attempted to tackle an implementation of SQL Assertions...until now!

In this session we'll demonstrate a native SQL Assertions implementation. You'll be introduced to SQL assertions, how to manage them, and how they behave compared to the already (traditional) available constraints.
Data Integrity 2.0. The biggest advancement in data quality in 30 years! by Connor McDonaldThe Ultimate Guide to Browser-Based AI: Privacy-First, Offline-Ready and Future-Proof by M. SalnikovHow to trace a Java Memory Leak by Victor Rentea[VDBUH2026] Sander Hoogendoorn  - Keynote: Seven Habits of a (Mostly) Successful TeamSecure Java Applications against Quantum Threats by Ana-Maria Mihalceanu10 Things I Hate About Java by  Adele CarpenterWhat Sorcery is This? How software uses Dark Patterns to manipulate users by Rachel AppelModernising the Energy Transition by Mark Dirksma, Marthijs BerfeloWhy Bad Code Quality Is Not (Only) Your Fault by Annelore EggerStop Guessing, Start Trusting: The Power of Contract Testing by Ashish GhoshSecuring the Software Supply Chain by Default by Marco van VeldhuizenHigh-Speed Crypto Trading: JVM Techniques Behind Bitvavo’s µs Revolution - Oleg Lobanov, Marcos Maia
Devoxx |

Data Integrity 2.0. The biggest advancement in data quality in 30 years! by Connor McDonald

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER