TL;DR: The One Script you will Ever Need to create an Oracle 26ai Database . And for you to configure, should you want to. After a remark fr...

A closer look at Oracle 26ai JOIN TO ONE: what the new syntax promises, how it works under the hood, and what it means for data warehouses.

Lo último en bases de datos: de almacenar información a comprenderla La evolución de las bases de datos está entrando en una nueva etapa. El objetivo ya no es únicamente almacenar grandes volúmenes d...

Las bases de datos están entrando en una nueva era impulsada por la inteligencia artificial Durante décadas, las bases de datos se diseñaron para almacenar, organizar y consultar información estructu...

Learn how to Securely Generate Vector Embeddings from within Oracle AI Database 26ai using a local Ollama server

Learn how to Securely Generate Vector Embeddings from within the Oracle AI Database 26ai using the Oracle Private AI Services Container

Learn how to Configure Oracle AI Database 26ai Access Control Lists (ACLs) and test connectivity to the Oracle Private AI Services Container

TL;DR: The DBCA showed me how to add catalog, catproc, and various components. We are Getting Somewhere. I'll try to make those scripts more...

TL;DR: I've got generated scripts from DBCA (see previous blogs) , and I experiment with them. First I morf the initial Create-statement an...

Learn how to configure and test secure certificate based access to the Oracle Private AI Services Container.

TL;DR: Still on my quest to Create an Oracle 26ai Database From Scripts. I'll examine some of the resulting scripts from DBCA. Image: Critic...

Learn how to install Oracle DBMS_CLOUD into an Oracle AI Database 26a database and test website access with the Oracle UTL_HTTP package

TL;DR: The scripts generated by DBCA work, although some tweaks and caveats apply. But in the end: Yes. They Work! image: Startup of the DBC...

TL;DR: My Minimalistic script to create a database Worked, sortof (link to previous blog) . Now let me Examine the first results and make so...

TL;DR: I want Scripts. Hence I am going to try and create an Oracle 26ai database purely using scripts. Specifically not recovering any temp...

How does the new Oracle 26ai REST API affect spatial data access? Developers can now use web tools to manage satellite images and maps without complex code.

What if you could start an Oracle 26ai multimodal vector search experiment with real image and text data, without building the dataset by hand? That is the idea behind Part 1 of my new blog series: U...

TL;DR: Some Very Simple tests of Assertions. Of course I want to know if it has any impact and maybe want to look a little bit closer or ev...

There is one main function to calculate the distance between vectors: VECTOR_DISTANCE. It takes two mandatory parameters, the two vectors to compare, and one optional paramenter, the metric. Let's start with some examples: SQL> CREATE TABLE vectotab(id NUMBER, vec_emb VECTOR); INSERT INTO vectotab VALUES(1,''); INSERT INTO vectotab VALUES(2,''); INSERT INTO vectotab VALUES(3,''); INSERT INTO vectotab VALUES(4,''); INSERT INTO vectotab VALUES(5,''); COMMIT; Table created.

There are several ways you can calculate distances to determine how similar, or not, two vectors are. I'll introduce you each metric available in Oracle 26ai. Euclidean and Euclidean Squared Distances Computed using straight-line distance between two vectors. This is calculated using the Pythagorean theorem (SQRT(SUM((xi-yi)2))). Euclidean Squared avoid the square-root calculation, so, it's faster to compute. Cosine Similarity Measures the cosine of the angle between two vectors.