Ontology generator for an H2 relational database

The contents of this web page are meant to test the application presented to the CACIC 2018 conference: Towards a Framework for Ontology-Based Data Access: Materialization of OWL Ontologies From Relational Databases.

This application has been tested on Windows only.

• Step 1: Download the database cacic database: cacic-mv.db and save the file into your user directory (usually c:\users\your-user-name), where your-user-name is your account name in Windows. Be careful that if you save the database file in the wrong folder, the application will create a new empty database and you will not be able to test it.
• Step 2:(optional) Download the H2 relational database management system as a standalone Java application and unzip it in any folder of your disk: h2-rdbms.zip (1.643.312 bytes).

  You have to see two files: h2.bat and h2-1.4.190.jar. After that execute the h2.bat file, a browser window with the options to name the database (e.g. cacic) and choosing an admin name (e.g. sa) and a password. Press Connect:

  

  You go to the following screen, where you can enter SQL commands and execute them:

  

  Press Disconnect and close the console window of the BAT file because the DB does not support concurrent access.

• Step 3: Download the executable Java JAR file of the ontology bootstrapper obda_v2-0.0.1-SNAPSHOT-shaded.jar (20.591.994 bytes) (Yes, it is heavy because it contains a lot of embedded libraries). Execute the this Jar file, to see this user interface:


Notice that you can execute the application directly by double-clicking in its icon or by using the console with the command java -jar obda_v2-0.0.1-SNAPSHOT-shaded.jar. In this case, you will see all of the many application messages to the console.

1. Go to option Configure, Database Management System..., type cacic as the database name, sa as the user name, and leave the password empty. Press "Test connection". If everything went well you will see this:


Then press Ok.

2. Go to File, Bootstrap ontology...
3. Press Fill... to get the tables from the database, Pick Car e.g.

4. Press See schema... to see the table's schema.

5. Press Generate Ontology.... You will be asked to prompt the file name. Choose Car

6. You should have two files: car.owl and car.n3 in your target folder, that you can edit with any text processor.

List of ontology files generated by the application

• AutoPart.owl
• AutoPart.n3
• Cacic.owl (this is the ontology for the entire database)
• Cacic.n3
• Car.owl
• Car.n3
• Drives.owl
• Drives.n3
• Measurement.owl
• Measurement.n3
• Person.owl
• Person.n3

Sergio Alejandro Gómez - July 10, 2018