Posts

Oracle AI Vector Search - DML and Indexing Strategy

-
  The Architect’s Guide to Oracle AI Vector Search: DML & Indexing Strategy By: Rana Abdul Wahid Executive Summary As Generative AI moves from prototype to production, the bottleneck is often the efficient management of high-dimensional vector data. Oracle Database 23ai introduces native AI Vector Search , allowing organizations to manage embeddings with the same ACID-compliant rigor as traditional relational data. This article provides a technical blueprint for performing DML (Data Manipulation Language) operations and selecting the optimal indexing strategy HNSW vs. IVF to balance search precision with system performance.     I. Data Foundation: The VECTOR Data Type Oracle treats vectors as a native data type. This ensures that your embeddings are stored alongside your business metadata, eliminating the need for external specialized vector databases. Schema Definition SQL CREATE TABLE corporate_knowledge_base (     doc_id ...
Post a Comment
Read more

Understanding VECTOR Data Types

-
  Oracle AI Vector Search Understanding VECTOR Data Types A practical overview of vector data types, SQL usage, and similarity search concepts within Oracle Database. Introduction to Oracle AI Vector Search The release of Oracle Database 23ai marks a paradigm shift in how we handle enterprise data. No longer is Artificial Intelligence a "sidecar" process; with AI Vector Search , the database itself becomes the engine for semantic understanding. At the heart of this revolution is the new, native VECTOR data type. In this article, we will dive deep into the technical specifications, storage formats, and architectural advantages of the VECTOR data type.     1. What is the VECTOR Data Type? A vector is a mathematical representation of unstructured data (text, images, audio, or video) encoded as an array of numbers (dimensions). In Oracle 23ai, the VECTOR data type allows these embeddings to be stored, indexed, and queried using standard SQL. Basic Syntax:...
Post a Comment
Read more

How to Extend Swap space on LVM Disk Linux

-
Image
How to Extend Swap space on LVM Disk Linux   Applies to:             Oracle Database 12.2             Oracle Linux 7 Description:             Want to extend Swap space on LVM disk. Assumes that space is available in the volume group on which the current swap partition is located as logical volume. Solution:             To extend the amount of swap space in a LVM environment follow the below steps. To verify the swap space exists and is a logical volume issue the following command:              To view the swap volume using fdisk command: [root@ora12c ~]# fdisk -l We see that current swap space is 7.88GB and we want to extend 2GB to this swap volume. Stop or terminate all program/services which are using sw...
Post a Comment
Read more