Practical PL/SQL

Vectors

  • 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. read more

  • 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. read more

  • 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. read more

  • OML4PY 2.1 Quickstart

    Quickstart guide to installing OML4PY and exporting augmented embedding models using VirtualBox appliance for 23.7. read more

  • Vector Math: Semantic Arithmetic

    An exploration of some simple examples of vector arithmetic using vector embeddings generated within the Oracle database. read more

  • 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. read more

  • 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… read more

  • VirtualBox23ai QuickStart for OML4PY

    Are you excited about the new AI Vector Search in Oracle 23ai! Have you been able to do a vector search in the new database without calling external APIs to do vector embeddings? Unless you are skilled in Python and Linux, this… read more

Recent
Categories
Archives
Topics

AI (3) AI Vector Search (7) artificial-intelligence (3) Best Practices (2) Binary Vectors (1) Binary Vector Searches (1) Ceil (1) Comparing Table Data (1) Cursor For Loop (2) Cursors (3) Cursor Variables (2) data-science (1) Database Compatible Parameter (1) Dynamic SQL (2) IDE (1) Inline CTE Functions (2) LLM (3) machine-learning (1) OCI Autonomous Database (1) OML4PY 2.1 (1) ONNX (2) Oracle 19c (3) Oracle 21c (4) Oracle 23ai (12) Oracle AI Database 26.1 (4) Oracle Database 23.7 (2) Polymorhic Table Functions (1) pragma UDF (1) Ref Cursors (2) Reranking Similarity Searches (1) Round (1) Sparse Vector Storage Format (1) Sql Assertions (4) Sql Macros (6) Sql Transpiler (1) technology (3) Trunc (1) vector (1) Vector Arithmetic (2) Vector Data Type (2) Vector Math (2) Vector Similarity (1)