When adding multiple tables in the object list in the profile, will it understand the foreign key constraints so you can have questions based on descriptions on the lookup tables for example? Can you give an example of how to contract the create_profile?
Yes, adding multiple tables in the object list in the profile can enable AI models to understand foreign key constraints and allow you to ask questions based on descriptions in lookup tables. When you define the relationships and constraints properly, the AI can leverage these to provide more accurate and contextually relevant responses. To create a profile that includes multiple tables with foreign key constraints in Oracle APEX using the approach similar to the Select AI example, follow these steps: 1. Define the Tables and Relationships: Ensure your database tables are properly defined with foreign key constraints. E.g: CREATE TABLE departments ( department_id NUMBER PRIMARY KEY, department_name VARCHAR2(100) ); CREATE TABLE employees ( employee_id NUMBER PRIMARY KEY, employee_name VARCHAR2(100), department_id NUMBER, CONSTRAINT fk_department FOREIGN KEY (department_id) REFERENCES departments(department_id) ); 2. Create the Profile: Define a profile in your APEX application that includes these tables and their relationships. The profile configuration will help the AI understand the data context and relationships. You can create the profile with the code provided in the demo with a small modification for adding the foreign key relationships. E.g: BEGIN DBMS_CLOUD_AI.create_profile( profile_name => 'OPENAI_APEX', attributes => '{ "provider": "openai", "credential_name": "OPENAI_CRED_APEX", "object_list": [ { "owner": "", "name": "employees", "primary_key": "employee_id", "columns": ["employee_id", "employee_name", "department_id"] }, { "owner": "", "name": "departments", "primary_key": "department_id", "columns": ["department_id", "department_name"] } ], "foreign_keys": [ { "child_table": "employees", "child_column": "department_id", "parent_table": "departments", "parent_column": "department_id" } ] }' ); END; / For more info please visit this article: medium.com/@cristina.varas98/enhancing-data-analysis-with-select-ai-in-oracle-apex-9d00b070a073
Great! very useful information. Helped me deciding the business use cases
Fantastic video!
Great event thank you Violeta and Christina 🎉🎉🎉
very useful presentation to create the AI apex application in oracle
Genial
👍🏻
When adding multiple tables in the object list in the profile, will it understand the foreign key constraints so you can have questions based on descriptions on the lookup tables for example? Can you give an example of how to contract the create_profile?
Yes, adding multiple tables in the object list in the profile can enable AI models to understand foreign key constraints and allow you to ask questions based on descriptions in lookup tables. When you define the relationships and constraints properly, the AI can leverage these to provide more accurate and contextually relevant responses.
To create a profile that includes multiple tables with foreign key constraints in Oracle APEX using the approach similar to the Select AI example, follow these steps:
1. Define the Tables and Relationships:
Ensure your database tables are properly defined with foreign key constraints. E.g:
CREATE TABLE departments (
department_id NUMBER PRIMARY KEY,
department_name VARCHAR2(100)
);
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
employee_name VARCHAR2(100),
department_id NUMBER,
CONSTRAINT fk_department
FOREIGN KEY (department_id) REFERENCES departments(department_id)
);
2. Create the Profile:
Define a profile in your APEX application that includes these tables and their relationships. The profile configuration will help the AI understand the data context and relationships.
You can create the profile with the code provided in the demo with a small modification for adding the foreign key relationships. E.g:
BEGIN
DBMS_CLOUD_AI.create_profile(
profile_name => 'OPENAI_APEX',
attributes => '{
"provider": "openai",
"credential_name": "OPENAI_CRED_APEX",
"object_list": [
{
"owner": "",
"name": "employees",
"primary_key": "employee_id",
"columns": ["employee_id", "employee_name", "department_id"]
},
{
"owner": "",
"name": "departments",
"primary_key": "department_id",
"columns": ["department_id", "department_name"]
}
],
"foreign_keys": [
{
"child_table": "employees",
"child_column": "department_id",
"parent_table": "departments",
"parent_column": "department_id"
}
]
}'
);
END;
/
For more info please visit this article: medium.com/@cristina.varas98/enhancing-data-analysis-with-select-ai-in-oracle-apex-9d00b070a073
This video has better audio, sessions need to do AI audio processing.
Great video!