Practical Pl/Sql: Explorations In Oracle Pl/Sql programming.
-
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 design patterns of literal group composition assertions are explored.
-
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 to be ‘Legacy’ and not in scope for validation efforts due to changes in circumstances. The merits of this approach were really…
-
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, but did not adapt to the requirements for customer loyalty status to be upgraded over time or loyalty discount minimums to be…
-
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 is more complex than it first appears to be. SQL assertions allow for complex cross table data integrity rules to be implemented…
-
Sparse Vectors
An exploration of support for sparse vectors in Oracle database 23ai. In this article I review the capabilities and limitations of working with sparse vectors in SQL and PL/SQL.
-
Binary Vectors: Semantic Searches
After using a variety of models to generate float32 vectors, we can convert these vectors to binary dimension formats using a macro. This allows us to explore and compare various approaches to vector similarity searches using binary vectors and float32 vectors.
-
Binary Vectors: Quantization
A step-by-step exploration into the details of creating a scalar sql macro function to quantize binary vectors from vectors in other dimension formats.
-
OML4PY 2.1 Quickstart
Quickstart guide to installing OML4PY and exporting augmented embedding models using VirtualBox appliance for 23.7.
-
Vector Math: Semantic Arithmetic
An exploration of some simple examples of vector arithmetic using vector embeddings generated within the Oracle database.
-
Vector Math: Basics
An exploration of the new vector arithmetic operations in Oracle 23ai Release 7. These operations currently support addition, subtraction and multiplication with vectors.
Got any topic recommendations or feedback?