Year: 2026
-
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…
-
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,…
-
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…
Recent
- Temporal SQL Assertions III: Effective Periods
- Temporal SQL Assertions II: Ignore Legacy Data
- Temporal SQL Assertions I: Unconditional and Unvalidated
- Sparse Vectors
- Binary Vectors: Semantic Searches
Categories
Archives
- March 2026
- November 2025
- August 2025
- May 2025
- April 2025
- March 2025
- December 2024
- November 2024
- August 2024
- July 2024
- February 2024
- September 2023
- June 2023
- May 2023
Practical Pl/Sql 