The DBMS.AI_SERVICE system package is used to manage AI services, including AI model objects and AI model service connection point objects from earlier interfaces, as well as vendor configurations, model parameters, and gateway configurations from the new interface.
Note
New subprograms related to vendor configuration, model parameters, and gateway configuration are available starting from V4.6.0 BP1. 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, allowing existing usage to 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、DROP_AI_MODEL_ENDPOINT |
| Vendor Configuration (New) | Manage vendor connection information and access credentials | REGISTER_PROVIDER、ALTER_PROVIDER、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、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 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 updateprovider/modelLevel model parameters. |
| DROP_MODEL_PROFILE | deleteprovider/modelLevel 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. |