It's not clear to me what you're trying to do. Is the MySQL database you mention the database that sits behind the Jena SDB triple store. That database would have four tables (nodes, prefixes, quads, triples) and wouldn't be a database that you would access directly using SQL queries.
If, however, you're talking about a separate MySQL database that contains the data, in tabular format that you want map to your ontology you have several options. As Andy mentioned in an earlier thread the D2RQ project (http://d2rq.org/jena) can map tabular data in a database into RDF that can be loaded into a SDB. Another project that a lot of people are finding useful is Karma (http://isi.edu/integration/karma/) I has a GUI which allows you to load in an ontology, then import data from a variety of formats (including establishing a MySQL database connection and executing SQL to grab data). Then it uses a nice UI which can map the data in each column to the appropriate classes and properties in your ontology. Then once you're done it can "publish" your data to a Jena SDB instance. Another project, for which I recently became the maintainer is something called VIVO-Harvester (https://github.com/vivo-project/VIVO-Harvester). Although it's intended to be used with VIVO (a semantic web application: http://www.vivoweb.org/) it is basically a suite of tools that will take data from a variety of datasources (including a MySql database), transformed that data to RDF, then load it into a triple store. Finally, the VIVO software is actually built on top of something called Vitro (https://github.com/vivo-project/Vitro) , which is basically a copy of VIVO without the VIVO (and associated ontologies) built in. Using Vitro you could load in your own ontology and then use the available ingest tools (or the VIVO-Harvester) to load in your data. -----Original Message----- From: Vinicios Binsfeld [mailto:[email protected]] Sent: Monday, September 01, 2014 8:06 AM To: dev; users Subject: SDB with MySQL and Java Hello. Someone has any examples of how popular one with OWL ontology data using SDB? I'm using MySQL and SDB data. The connection with the database is working well. Now I need an example of how populate the ontology and how to manipulate, fetch data, update data, and create new records. --
