Practical Pl/Sql: Explorations In Oracle Pl/Sql programming.
-
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.
-
Sparse Vector Storage: Setting Compatible Parameter on OCI Autonomous Database
You can’t always get what you want…. Sometimes new features that come with a release update require the compatible initialization parameter to be set to a specific release or greater. VirtualBox 23ai Setting this parameter from a privileged account in a pluggable database won’t work: If you are running a 23AI Free database on virtual…
Got any topic recommendations or feedback?
Practical Pl/Sql 