Practical Pl/Sql

Tag: Oracle AI Database 26.1

  • Group Composition Assertions I: Literal Rules

    A series of posts exploring the use of assertions to enforce group composition rules. This first post uses literal rules to generate assertions, for example “a university department must have faculty members”. Several…

    read more

  • Temporal SQL Assertions III: Effective Periods

    In the previous post of this series (Temporal SQL Assertions II: Ignore Legacy Data) we took a typical enterprise approach to applying business rules only to current data in motion and considering older data…

    read more

  • Temporal SQL Assertions II: Ignore Legacy Data

    In the previous post (Temporal SQL Assertions I: Unconditional and Unvalidated) we explored a naive solution that used SQL assertions to validate customer discounts for a customer loyalty program. The basic idea was sound,…

    read more

  • Temporal SQL Assertions I: Unconditional and Unvalidated

    In this series of posts we will explore using assertions to enforce business rules in a changing data landscape. This first article explores the limitations of a simplistic approach to a problem that…

    read more

Recent

Categories

Archives