Vector search • SQL • RAG-ready

Can your database do this?

AI‑Powered Vector Database Implementation on Popular RDBMSs (Patent Pending)

Overview

Relational database management systems (RDBMSs) traditionally rely on exact-match queries, keyword searches, or manually defined indexes to retrieve records. These approaches require users to know the precise structure, wording, or schema of stored data and are entirely ineffective when queries are expressed in natural language or when semantic equivalence is required. For example, a query for "force equals mass times acceleration" cannot retrieve a record containing "Isaac Newton" using conventional SQL alone. We have developed semantic search query capability that can run on

  • PostgreSQL (with pgvector)
  • Oracle 23ai/26ai or later
  • SQL Server 2025 or later
  • MariaDB (11.4 or 11.7 or later)

Demo with MariaDB 12.1.2

Table Schema & Indexing:


CREATE DATABASE salesdb;

USE salesdb;


CREATE TABLE IF NOT EXISTS thing (
id  INT PRIMARY KEY auto_increment,
content TEXT,
content_vec    VECTOR(1024) NOT NULL,
VECTOR INDEX (content_vec)
);




  call load_thing_row('Isaac Newton','EN',0);
  call load_thing_row('Jane Austen','EN',0);
  call load_thing_row('Wolfgang Amadeus Mozart','EN',0);
  call load_thing_row('Ludwig van Beethoven','EN',0);
  call load_thing_row('Albert Einstein','EN',0);
  call load_thing_row('Charles Dickens','EN',0);
  call load_thing_row('William Shakespeare','EN',0);
  call load_thing_row('Mark Twain','EN',0);
  call load_thing_row('Leo Tolstoy','EN',0);
  call load_thing_row('Fyodor Dostoevsky','EN',0);
  call load_thing_row('J.K. Rowling','EN',0);
  call load_thing_row('George Orwell','EN',0);
  call load_thing_row('Ernest Hemingway','EN',0);
  call load_thing_row('F. Scott Fitzgerald','EN',0);
  call load_thing_row('Homer','EN',0);
  call load_thing_row('Dante Alighieri','EN',0);
  call load_thing_row('Miguel de Cervantes','EN',0);
  call load_thing_row('Victor Hugo','EN',0);
  call load_thing_row('Mary Shelley','EN',0);
  call load_thing_row('Agatha Christie','EN',0);
  call load_thing_row('Arthur Conan Doyle','EN',0);
  call load_thing_row('J.R.R. Tolkien','EN',0);
  call load_thing_row('C.S. Lewis','EN',0);
  call load_thing_row('H.G. Wells','EN',0);
  call load_thing_row('Jules Verne','EN',0);
  call load_thing_row('Emily Bronte','EN',0);
  call load_thing_row('Charlotte Bronte','EN',0);
  call load_thing_row('Virginia Woolf','EN',0);
  call load_thing_row('Franz Kafka','EN',0);
  call load_thing_row('Sun Tzu','EN',0);
  call load_thing_row('Confucius','EN',0);
  call load_thing_row('Plato','EN',0);
  call load_thing_row('Aristotle','EN',0);
  call load_thing_row('Niccolo Machiavelli','EN',0);
  call load_thing_row('Galileo Galilei','EN',0);
  call load_thing_row('Nicolaus Copernicus','EN',0);
  call load_thing_row('Johannes Kepler','EN',0);
  call load_thing_row('Marie Curie','EN',0);
  call load_thing_row('Niels Bohr','EN',0);
  call load_thing_row('Michael Faraday','EN',0);
  call load_thing_row('James Clerk Maxwell','EN',0);
  call load_thing_row('Alan Turing','EN',0);
  call load_thing_row('Ada Lovelace','EN',0);
  call load_thing_row('Grace Hopper','EN',0);
  call load_thing_row('Tim Berners-Lee','EN',0);
  call load_thing_row('Linus Torvalds','EN',0);
  call load_thing_row('Steve Jobs','EN',0);
  call load_thing_row('Pablo Picasso','EN',0);
  call load_thing_row('Leonardo da Vinci','EN',0);
  call load_thing_row('Vincent van Gogh','EN',0);
  call load_thing_row('Michelangelo','EN',0);
  call load_thing_row('Raphael','EN',0);
  call load_thing_row('Salvador Dali','EN',0);
  call load_thing_row('Claude Monet','EN',0);
  call load_thing_row('Rembrandt','EN',0);
  call load_thing_row('Johann Sebastian Bach','EN',0);
  call load_thing_row('Pyotr Ilyich Tchaikovsky','EN',0);
  call load_thing_row('Antonio Vivaldi','EN',0);
  call load_thing_row('Chopin','EN',0);
  call load_thing_row('Richard Wagner','EN',0);
  call load_thing_row('Igor Stravinsky','EN',0);
  call load_thing_row('Miles Davis','EN',0);
  call load_thing_row('Louis Armstrong','EN',0);
  call load_thing_row('The Beatles','EN',0);
  call load_thing_row('Bob Dylan','EN',0);
  call load_thing_row('Michael Jackson','EN',0);
  call load_thing_row('Elvis Presley','EN',0);
  call load_thing_row('William Wordsworth','EN',0);
  call load_thing_row('T.S. Eliot','EN',0);
  call load_thing_row('Robert Frost','EN',0);
  call load_thing_row('Pablo Neruda','EN',0);
  call load_thing_row('Gabriel Garcia Marquez','EN',0);
  call load_thing_row('Haruki Murakami','EN',0);
  call load_thing_row('Chinua Achebe','EN',0);
  call load_thing_row('Khaled Hosseini','EN',0);
  call load_thing_row('Stephen King','EN',0);
  call load_thing_row('Dan Brown','EN',0);
  call load_thing_row('Suzanne Collins','EN',0);
  call load_thing_row('George R.R. Martin','EN',0);
  call load_thing_row('Neil Gaiman','EN',0);
  call load_thing_row('Margaret Atwood','EN',0);
  call load_thing_row('Yuval Noah Harari','EN',0);
  call load_thing_row('Malala Yousafzai','EN',0);
  call load_thing_row('Nelson Mandela','EN',0);
  call load_thing_row('Martin Luther King Jr.','EN',0);
  call load_thing_row('Mahatma Gandhi','EN',0);
  call load_thing_row('Winston Churchill','EN',0);
  call load_thing_row('Sigmund Freud','EN',0);
  call load_thing_row('Carl Jung','EN',0);
  call load_thing_row('Jean-Paul Sartre','EN',0);
  call load_thing_row('Simone de Beauvoir','EN',0);
  
  commit;

Semantic Query:

/* Table entries */
  select id, content from thing; 

  MariaDB [salesdb]> select id, content from thing;
  +----+--------------------------+
  | id | content                  |
  +----+--------------------------+
  |  1 | Isaac Newton             |
  |  2 | Jane Austen              |
  |  3 | Wolfgang Amadeus Mozart  |
  |  4 | Ludwig van Beethoven     |
  |  5 | Albert Einstein          |
  |  6 | Charles Dickens          |
  |  7 | William Shakespeare      |
  |  8 | Mark Twain               |
  |  9 | Leo Tolstoy              |
  | 10 | Fyodor Dostoevsky        |
  | 11 | J.K. Rowling             |
  | 12 | George Orwell            |
  | 13 | Ernest Hemingway         |
  | 14 | F. Scott Fitzgerald      |
  | 15 | Homer                    |
  | 16 | Dante Alighieri          |
  | 17 | Miguel de Cervantes      |
  | 18 | Victor Hugo              |
  | 19 | Mary Shelley             |
  | 20 | Agatha Christie          |
  | 21 | Arthur Conan Doyle       |
  | 22 | J.R.R. Tolkien           |
  | 23 | C.S. Lewis               |
  | 24 | H.G. Wells               |
  | 25 | Jules Verne              |
  | 26 | Emily Bronte             |
  | 27 | Charlotte Bronte         |
  | 28 | Virginia Woolf           |
  | 29 | Franz Kafka              |
  | 30 | Sun Tzu                  |
  | 31 | Confucius                |
  | 32 | Plato                    |
  | 33 | Aristotle                |
  | 34 | Niccolo Machiavelli      |
  | 35 | Galileo Galilei          |
  | 36 | Nicolaus Copernicus      |
  | 37 | Johannes Kepler          |
  | 38 | Marie Curie              |
  | 39 | Niels Bohr               |
  | 40 | Michael Faraday          |
  | 41 | James Clerk Maxwell      |
  | 42 | Alan Turing              |
  | 43 | Ada Lovelace             |
  | 44 | Grace Hopper             |
  | 45 | Tim Berners-Lee          |
  | 46 | Linus Torvalds           |
  | 47 | Steve Jobs               |
  | 48 | Pablo Picasso            |
  | 49 | Leonardo da Vinci        |
  | 50 | Vincent van Gogh         |
  | 51 | Michelangelo             |
  | 52 | Raphael                  |
  | 53 | Salvador Dali            |
  | 54 | Claude Monet             |
  | 55 | Rembrandt                |
  | 56 | Johann Sebastian Bach    |
  | 57 | Pyotr Ilyich Tchaikovsky |
  | 58 | Antonio Vivaldi          |
  | 59 | Chopin                   |
  | 60 | Richard Wagner           |
  | 61 | Igor Stravinsky          |
  | 62 | Miles Davis              |
  | 63 | Louis Armstrong          |
  | 64 | The Beatles              |
  | 65 | Bob Dylan                |
  | 66 | Michael Jackson          |
  | 67 | Elvis Presley            |
  | 68 | William Wordsworth       |
  | 69 | T.S. Eliot               |
  | 70 | Robert Frost             |
  | 71 | Pablo Neruda             |
  | 72 | Gabriel Garcia Marquez   |
  | 73 | Haruki Murakami          |
  | 74 | Chinua Achebe            |
  | 75 | Khaled Hosseini          |
  | 76 | Stephen King             |
  | 77 | Dan Brown                |
  | 78 | Suzanne Collins          |
  | 79 | George R.R. Martin       |
  | 80 | Neil Gaiman              |
  | 81 | Margaret Atwood          |
  | 82 | Yuval Noah Harari        |
  | 83 | Malala Yousafzai         |
  | 84 | Nelson Mandela           |
  | 85 | Martin Luther King Jr.   |
  | 86 | Mahatma Gandhi           |
  | 87 | Winston Churchill        |
  | 88 | Sigmund Freud            |
  | 89 | Carl Jung                |
  | 90 | Jean-Paul Sartre         |
  | 91 | Simone de Beauvoir       |
  +----+--------------------------+

/* Search “author of fur elise”, database returns table entry “ludwig van beethoven”. */


  call semantic_search_thing('author of fur elise','EN',1);
  


  MariaDB [salesdb]> call semantic_search_thing('author of fur elise','EN',1);
  +----------------------+----------------------+-------+
  | content              | qry                  | score |
  +----------------------+----------------------+-------+
  | Ludwig van Beethoven | ludwig van beethoven |     3 |
  +----------------------+----------------------+-------+

/* Search “author of turkish march”, database returns table entry “wolfgang amadeus mozart”. */


call semantic_search_thing('author of turkish march','EN',1);  


  MariaDB [salesdb]> call semantic_search_thing('author of turkish march','EN',1);
  +-------------------------+-------------------------+-------+
  | content                 | qry                     | score |
  +-------------------------+-------------------------+-------+
  | Wolfgang Amadeus Mozart | wolfgang amadeus mozart |     3 |
  +-------------------------+-------------------------+-------+

/* Search “author of to be or not to be, that is the question”, database returns table entry “William Shakespeare”. */


  MariaDB [salesdb]> call semantic_search_thing('author of to be or not to be, that is the question','EN',1);
  +---------------------+---------------------+-------+
  | content             | qry                 | score |
  +---------------------+---------------------+-------+
  | William Shakespeare | William Shakespeare |     3 |
  +---------------------+---------------------+-------+

/* Search “force equals mass times acceleration”, database returns table entry “Isaac Newton” */


call semantic_search_thing('force equals mass times acceleration','EN',1); 


  MariaDB [salesdb]> call semantic_search_thing('force equals mass times acceleration','EN',1);
  +--------------+--------------+-------+
  | content      | qry          | score |
  +--------------+--------------+-------+
  | Isaac Newton | Isaac Newton |     3 |
  +--------------+--------------+-------+

/* Search “energy equals mass times speed of light squared”, database returns table entry “Albert Einstein”. */


call semantic_search_thing('energy equals mass times speed of light squared','EN',1);  


  MariaDB [salesdb]> call semantic_search_thing('energy equals mass times speed of light squared','EN',1);
  +-----------------+-----------------+-------+
  | content         | qry             | score |
  +-----------------+-----------------+-------+
  | Albert Einstein | Albert Einstein |     3 |
  +-----------------+-----------------+-------+

/* Search “author of David Copperfield”, database returns table entry “Charles Dickens”. */


  call semantic_search_thing('author of David Copperfield','EN',1);


  +-----------------+-----------------+-------+
  | content         | qry             | score |
  +-----------------+-----------------+-------+
  | Charles Dickens | Charles Dickens |     3 |
  +-----------------+-----------------+-------+

/* Search “author of war and peace”, database returns table entry “Leo Tolstoy”. */


  call semantic_search_thing('author of war and peace','EN',1);


  MariaDB [salesdb]> call semantic_search_thing('author of war and peace','EN',1);
  +-------------+-------------+-------+
  | content     | qry         | score |
  +-------------+-------------+-------+
  | Leo Tolstoy | Leo Tolstoy |     3 |
  +-------------+-------------+-------+

/* Search “composer of swan lake”, database returns table entry “Pyotr Ilyich Tchaikovsky”. */


  call semantic_search_thing('composer of swan lake','EN',1);


  MariaDB [salesdb]> call semantic_search_thing('composer of swan lake','EN',1);
  +--------------------------+--------------------------+-------+
  | content                  | qry                      | score |
  +--------------------------+--------------------------+-------+
  | Pyotr Ilyich Tchaikovsky | Pyotr Ilyich Tchaikovsky |     3 |
  +--------------------------+--------------------------+-------+

Contact

Interested in a demo or integration help? Email info@jentekco.com

Jen Tek LLC

We can perform semantic query to use SQL queries to search from tables based on semantic meaning. We currently support

PostgreSQL (with pgvector )

Oracle 23ai or better

Microsoft SQL Server 2025 or better

MariaDB 11.4/11.7+

We continue to expand semantic query capabilities with other relational database management system and NoSQL

If you are interested in, please contact us at: info@jentekco.com

Jen Tek LLC

Fremont, California