Introduction
In this tutorial we are to see how to create an ontology and its relational database table associated.
Before start, we have to explain the two main concepts we will use:
Fields
Constraints
Ontology creation screen
To access:
In this screen you have to check the CREATE TABLE option. This will activate the create table options:
Then you must set required fields:
Concepts
To go deep in fields
They are the fields of the ontology, corresponding with table columns. They will be created in relational database.
You can add as many fields as you want. The ield type will be converted to corresponding database data type.
To go deep in constraints
They are the properties assigned to a column or the set of columns in a table that prevents certain types of inconsistent data values from being placed in the column.
They follow the database specifications, so you must known the database contraint caracteristics before add them.
If you want to delete a field used by a constraint, you have to delete constraint before.
Generate SQL code
Once fields and constraints are set, it is time to update the SQL code that will be executed in the table creation process.
You can modify this SQL code as desired in order to modify the default behaviour.
When the SQL code is ready, you can update the schema to save it.
Update schema
When you click on Update Schema, the SQL code will appear as a property in the schema. At this time, everything is ready to create the ontology and its associated table.
Finally
Press the NEW button and the ontology will be created. You can see the ontology in Control Panel and the table in the database.
