The DBMS_AI_SERVICE package is used to manage AI services, including AI model objects and AI model endpoint objects from the legacy API, as well as provider and model parameter configurations from the new API.
Note
The new subprograms related to providers and model parameters are available starting with V4.6.0 BP1. The legacy subprograms CREATE_AI_MODEL, DROP_AI_MODEL, CREATE_AI_MODEL_ENDPOINT, ALTER_AI_MODEL_ENDPOINT, and DROP_AI_MODEL_ENDPOINT are fully retained, and existing usage can continue.
Description of configuration objects
Object |
Description |
Management subprogram |
|---|---|---|
| AI Model/Endpoint (Old) | Manages remote model access via model name and endpoint URL | CREATE_AI_MODEL, DROP_AI_MODEL, CREATE_AI_MODEL_ENDPOINT, ALTER_AI_MODEL_ENDPOINT, DROP_AI_MODEL_ENDPOINT |
| Provider Configuration (New) | Manages model service connection information and access credentials | REGISTER_PROVIDER, ALTER_PROVIDER, UNREGISTER_PROVIDER |
| Model Parameters (New) | Sets and manages parameters for each model, such as the maximum number of tokens or temperature, to customize model behavior | ALTER_MODEL_PROFILE (create or modify parameters), DROP_MODEL_PROFILE (delete parameter configurations) |
Overview of DBMS_AI_SERVICE subprograms
The following table lists the DBMS_AI_SERVICE subprograms supported in the current version of OceanBase Database and their brief descriptions.
Subprogram |
Description |
|---|---|
| CREATE_AI_MODEL | Creates an AI model object. |
| DROP_AI_MODEL | Drops an AI model object. |
| CREATE_AI_MODEL_ENDPOINT | Creates an AI model endpoint object. |
| ALTER_AI_MODEL_ENDPOINT | Modifies an AI model endpoint object. |
| DROP_AI_MODEL_ENDPOINT | Drops an AI model endpoint object. |
| REGISTER_PROVIDER | Creates an AI provider configuration within a tenant. |
| ALTER_PROVIDER | Modifies an AI provider configuration within a tenant. |
| UNREGISTER_PROVIDER | Drops an AI provider configuration within a tenant. |
| ALTER_MODEL_PROFILE | Creates or updates model parameters at the provider/model level. |
| DROP_MODEL_PROFILE | Drops model parameters at the provider/model level. |