Oracle Vector Store

Oracle Vector Store uses Oracle Database 23ai's native vector storage and similarity search capabilities to store and query document embeddings.

Categories: Artificial Intelligence

Type: oracleVectorStore/v1

Connections

Version: 1

custom

Properties

Name	Label	Type	Description	Required
url	JDBC URL	STRING	Oracle JDBC connection URL (e.g., jdbc:oracle:thin:@localhost:1521/FREEPDB1).	true
username	Username	STRING	Oracle database username.	true
password	Password	STRING	Oracle database password.	true
tableName	Table Name	STRING	Name of the database table used to store vector embeddings.	false
indexType	Index Type	STRING Options NONE, HNSW, IVF	Vector index type to use for similarity search.	false
distanceType	Distance Type	STRING Options COSINE, DOT, EUCLIDEAN, EUCLIDEAN_SQUARED, MANHATTAN	Distance function used for vector similarity comparison.	false
dimensions	Dimensions	INTEGER	Number of dimensions for the vector embeddings. Use -1 to infer from the embedding model.	false
initializeSchema	Initialize Schema	BOOLEAN Options true, false	Whether to create the vector store table automatically if it does not exist.	false

Actions

Load Data

Name: load

Loads data into the vector store using LLM embeddings.

Example JSON Structure

{
  "label" : "Load Data",
  "name" : "load",
  "type" : "oracleVectorStore/v1/load"
}

Output

This action does not produce any output.

Search Data

Name: search

Query data from the vector store using LLM embeddings.

Properties

Name	Label	Type	Description	Required
query	Query	STRING	The query to be executed.	true
topK	Top K	INTEGER	The top 'k' similar results to return.	false
similarityThreshold	Similarity Threshold	NUMBER	Similarity threshold score to filter the search response by. Only documents with similarity score equal or greater than the threshold will be returned. A threshold value of 0 means any similarity is accepted. A threshold value of 1 means an exact match is required.	false

Example JSON Structure

{
  "label" : "Search Data",
  "name" : "search",
  "parameters" : {
    "query" : "",
    "topK" : 1,
    "similarityThreshold" : 0.0
  },
  "type" : "oracleVectorStore/v1/search"
}

Output

The output for this action is dynamic and may vary depending on the input parameters. To determine the exact structure of the output, you need to execute the action.

Oracle Vector Store

On this page