The DBMS.AI_SERVICE system package is used to manage AI services, including AI model objects and AI model service endpoint objects from the legacy API, as well as vendor configurations, model parameters, and gateway configurations from the new API.
Note
New subprograms related to vendor configuration, model parameters, and gateway configuration are available starting from V4.6.2.1. The legacy interfaces CREATE_AI_MODEL, DROP.AI_MODEL, CREATE_AI_MODEL_ENDPOINT, ALTER_AI_MODEL_ENDPOINT, and DROP_AI_MODEL_ENDPOINT are fully retained, so existing usage can continue without interruption.
Configuration object description
Object |
Note |
Management Subprograms |
|---|---|---|
| AI Model/Endpoint (Legacy) | Manage remote model access by using model names and endpoint URLs | CREATE_AI_MODEL, DROP_AI_MODEL, CREATE_AI_MODEL_ENDPOINT, ALTER_AI_MODEL_ENDPOINT, and DROP_AI_MODEL_ENDPOINT |
| Vendor Configuration (New) | Manage vendor connection information and access credentials | REGISTER_PROVIDER, ALTER_PROVIDER, and UNREGISTER_PROVIDER |
| Model Parameter (New) | Set and manage parameters for each model, such as the maximum number of tokens and temperature, to customize model behavior. | ALTER_MODEL_PROFILE(Creating or modifying parameters), DROP_MODEL_PROFILE>Delete Parameter Configuration) |
| Gateway Configuration (New) | Manage weighted routing and circuit breaking disaster recovery for multiple endpoints | CREATE_AI_GATEWAY, ALTER_AI_GATEWAY, and DROP_AI_GATEWAY |
Overview of DBMS.AI_SERVICE Subprograms
The following table lists the DBMS.AI_SERVICE subprograms supported by the current version of OceanBase AI Database and provides brief descriptions.
Subprogram |
Description |
|---|---|
| CREATE_AI_MODEL | Creates an AI model object. |
| DROP_AI_MODEL | Deletes 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 | Deletes an AI model endpoint object. |
| REGISTER_PROVIDER | Create an AI vendor configuration within the tenant. |
| ALTER_PROVIDER | Modify the AI vendor configuration within a tenant. |
| UNREGISTER_PROVIDER | Delete the AI vendor configuration within the tenant. |
| ALTER_MODEL_PROFILE | Create or Update provider/model Level model parameters. |
| DROP_MODEL_PROFILE | delete provider/model Level model parameters. |
| CREATE_AI_GATEWAY | Create a gateway configuration. |
| ALTER_AI_GATEWAY | Fully replace the existing gateway configuration. |
| DROP_AI_GATEWAY | Delete the gateway configuration. |