I don’t know much about SWRL rules but the native four tables in the SQL database that sit behind the Jena SDB are just the storage mechanism that Jena is using and going through Jena to access that data rather direct queries the database would be preferred.
D2RQ would be used for mapping existing data in some other external relational database to your ontology and then Jena used to load the RDF into the triplestore. Once the data is in the triple store you wouldn’t need to use D2RQ again. From: Vinicios Binsfeld [mailto:[email protected]] Sent: Tuesday, September 02, 2014 10:07 PM To: users; John A. Fereira Cc: dev Subject: Re: SDB with MySQL and Java Hi John. I will need to create some SWRL rules on the data present in the ontology, then I need to use the native four tables of Jena SDB or could maybe use D2RQ or VITRO to do the queries using SWRL? 2014-09-02 10:44 GMT-03:00 John A. Fereira <[email protected]<mailto:[email protected]>>: 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]<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. -- -- Atenciosamente, Vinicios Adonis Binsfeld E-mail / Google Talk : [email protected]<mailto:[email protected]>
