While working with text is an AI strong point, Database Workbench adds additional integration with the AI Object Assistant, that offers some functionality in the Table Editor and View Editor.
The AI Object Assistant currently has 2 features:
1. Generate columns
When creating a new table in the Table Editor you can use the AI Object Assistant to generate columns based on your description of the purpose for this table.
For example, let's create a new EMPLOYEES table. We'll enter a description and click OK.
And there you are, the AI Object Assistant created columns for this table based on the description we entered and we can modify data types, defaults and so on before we save and create the new table.
2. Generate column descriptions
While many database system support object description stored in the database, not everyone has the time to use this for proper database documentation. When using AI, this is even more useful. The AI Assistant uses table names and descriptions to determine the table purpose. Having an extra description available helps when generating queries using normal language. Columns can have descriptions as well, if you didn't find the time to add these, you can use the AI Object Assistant do this for you.
In the Table Editor or View Editor, use the AI Assistant drop down button from the toolbar and select Generate column descriptions. This will open the AI Object Assistant purpose dialog, just as above. By default, this will contain the table or view description, if this isn't sufficient or not available, you can enter a new object purpose description. Close the dialog using the OK button and let the assistant generate column descriptions for you.
It's that easy.
