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]>: > 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. > > > > -- > -- Atenciosamente, Vinicios Adonis Binsfeld *E-mail / Google Talk : [email protected] <[email protected]>*
