Data Integrity 2.0. The biggest advancement in data quality in 30 years!
Conference (INTERMEDIATE level)
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.
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.
Connor McDonald
Oracle Corporation
Ever being frustrated as a child by the single kilobyte of RAM in his ZX80 computer, Connor has loved the challenges that come with storing data, which ultimately led to a career in databases. When Y2K did not end the world as people thought, he started presenting on SQL and Databases, and since then he has spoken at over 200 conferences around the world. He has co-authored three books on database technology, and splits his time between helping developers via his YouTube channel, blog and podcast, and helping his rescue greyhound with treats, walks and cuddles.