9 Select AI Features

Select AI enables conversations for intuitive way to work with your data, enhances response accuracy with Retrieval Augmented Generation (RAG), and generates realistic synthetic data for testing, development, and training.

Note:

To use the Select AI feature, you need to have Oracle Text and Vector Search enabled for your database.

• Select AI Conversations
  Conversations in Select AI refer to the interactive dialogue between the user and the system, where a sequence of user-provided natural language prompts are stored and managed to support long-term memory for LLM interactions.
• Select AI with Retrieval Augmented Generation (RAG)
  Select AI with RAG augments your natural language prompt by retrieving content from your specified vector store using semantic similarity search. This reduces hallucinations by using your specific and up-to-date content and provides more relevant natural language responses to your prompts.
• Use an AI Data Gateway for Select AI NL2SQL
  Select AI runs natively inside Oracle Autonomous AI Database and Oracle AI Database, both of which can operate as an AI Data Gateway, formerly called AI Proxy Database, and also referred to as "sidecar". An AI Data Gateway can support both local and external data sources (on-premises, cloud, or third-party). Using standard Oracle federation mechanisms such as Database Links, Cloud Links, Table Hyperlinks, and Federated Tables, Select AI generates federated SQL from natural language prompts using metadata across Oracle and non-Oracle systems.
• Synthetic Data Generation
  Generate synthetic data using random generators, algorithms, statistical models, and Large Language Models (LLMs) to simulate real data for developing and testing solutions effectively.
• Feedback
  Select AI enables you to provide feedback to help improve your selected LLM's ability to generate more accurate SQL queries.
• Generate a Summary with Select AI
  Select AI enables you to generate a summary of your text, especially large texts, generally supporting up to 1 GB using AI providers. You can extract key insights from texts or large files as per your specific needs. This feature uses the LLM specified in your AI profile to generate a summary for a given text.
• Translate
  With Select AI, you can use generative AI from supported translation providers to translate your text into the language of your choice. This feature supports OCI, Google, AWS, and Azure as providers.
• Private Endpoint Access for Select AI Models
  You can enable secure, private access to generative AI models by deploying Ollama or Llama.cpp behind a private endpoint within your Virtual Cloud Network (VCN). This architecture is designed for organizations that need to keep AI processing fully private. The setup isolates both the Autonomous AI Database Serverless and your AI model servers from the public internet using private subnets, security lists, and controlled routing.
• Select AI for Property Graphs
  Select AI generates Property Graph Query (PGQ) on Oracle Property Graphs using natural language. It enables users to query graph data through the GRAPH_TABLE operator with minimal SQL knowledge.