Workflows

Choose integrated embedding or bring-your-own vectors to create, load, and search vector data.

Oracle VecDB supports two workflows: integrated embedding and bring-your-own vectors.

Integrated Embedding

The integrated embedding workflow includes the following steps:

• Create a vector table that uses an ONNX embedding model loaded in Oracle AI Database.
• Upsert a record that contains content to convert automatically to a vector.
• Search the vector table, specifying the number of results to return and any metadata filters.

Bring Your Own Vectors

In this workflow, vectors are generated externally:

• Create a vector table with a dense vector type.
• Generate vectors with an external embedding model.
• Upsert records that include vector values and optional metadata filters.
• Search the vector table, specifying the number of results to return and any metadata filters.

Each workflow can include an optional final reranking step that uses an external reranking model or an ONNX reranking model loaded in Oracle AI Database.

Parent topic: How Oracle VecDB Works