Tuesday, December 31, 2024

Oracle Select AI and DBMS_CLOUD_AI in Simple Words

Oracle Select AI enables you to elevate your productivity and develop innovative AI-based applications by interacting with your database and Large Language Models (LLMs) using natural language through SQL.

Select AI leverages generative AI to automate and simplify various tasks, including:

  • Generating, running, and explaining SQL queries from natural language prompts
  • Retrieval augmented generation using vector stores
  • Synthetic data generation
  • Conversing with LLMs
  • Seamless Natural Language Interaction

With Select AI, Autonomous Database effortlessly converts natural language into SQL. This enables you to interact with your data using natural language prompts instead of SQL code.

Select AI serves as a productivity tool for both expert and non-expert SQL users, enabling them to:

  • Derive valuable insights from data without requiring extensive technical knowledge
  • Automate the retrieval augmented generation process
  • Utilize features like synthetic data generation, chat history support, and more from a SQL interface

The DBMS_CLOUD_AI package facilitates integration with user-specified LLMs, enabling natural language to SQL generation. This package provides an augmented prompt to the LLM, containing relevant database schema metadata, to generate, run, and explain SQL queries based on natural language prompts.

At the moment, following models are supported by Select AI:

  • meta.llama-3.1-70b-instruct (default)
  • meta.llama-3.1-405b-instruct
  • meta.llama-3.2-90b-vision-instruct
  • cohere.command-r-16k (deprecated)
  • cohere.command–r-plus (deprecated)
  • cohere.command-r-08-2024
  • cohere.command-r-plus-08-2024
  • GPT-4o
  • GPT-4
  • GPT-4 Turbo with Vision
  • GPT-3.5-Turbo
  • command (default)
  • command-nightly (experimental)
  • command-r
  • command-r-plus
  • command-light
  • Mixtral-8x7B-Instruct-v0.1 (default)
  • Meta-Llama-3-70B-Instruct
  • Qwen1.5-1.8B
  • claude-3-5-sonnet-20240620 (default)
  • claude-3-opus-20240229
  • claude-3-sonnet-20240229
  • gpt-3.5-turbo (default)
  • gpt-4o
  • gpt-4o-mini

No comments: