DataConference45min
Data Integrity 2.0. The biggest advancement in data quality in 30 years!
This session introduces the first native implementation of SQL Assertions, enabling enforcement of complex business rules directly in the database. It covers managing SQL Assertions, their behavior, and compares them to traditional constraints, bridging the gap between simple data integrity rules and real-world business requirements.
Connor McDonaldOracle Corporation
talkDetail.whenAndWhere
Tuesday, March 24, 15:00-15:45
Room 4
talks.roomOccupancytalks.noOccupancyInfo
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
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.
talkDetail.shareFeedback
talkDetail.feedbackNotYetAvailable
talkDetail.feedbackAvailableAfterStart
talkDetail.signInRequired
talkDetail.signInToFeedbackDescription
occupancy.title
occupancy.votingNotYetAvailable
occupancy.votingAvailableBeforeStart
talkDetail.signInRequired
occupancy.signInToVoteDescription
comments.speakerNotEnabledComments