Presentation Title: SQL Assertions: Implementation Thoughts
Speaker: Mr Toon Koppelaars OakTable
Company: Oracle
Presentation abstract: Since SQL assertions were first formalized in the SQL-92 standard, it has been claimed that a practical, and efficient, implementation in Oracle Database is not feasible. This session shows you that this claim is false by describing the contours of an algorithm with these properties: it accepts any assertion that the standardized SQL can express; it derives a specification of all the DML statements that might violate the assertion; it derives queries to test, in an incremental fashion when this is possible, that the assertion holds following such a DML; and it derives an appropriate locking scheme. We will demonstrate the algorithm using a few example assertions.
Presentation begins: 04/12/2016 17:10
Presentation duration: 50
Presentation content level: 1 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced/Expert
Audience function: Product Expert, Systems Architect
Speaker biography: Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use (or rather, abuse) the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modelling. He is a long-time champion of the Thick Database paradigm.
Related topics: Database: SQL & PL/SQL
Hall: Media Suite