This application demonstrates how to export the VIVO ontology in a Jena database to mysql and subsequently run a Rails application.
-
JRuby version 1.6.7.2 or higher.
-
Jena database API.
-
Mysql
-
VIVO 1.4.1 running MySQL Fuseki Endpoint.
At this time, the Rails application is read-only. That is, you cannot make changes to that database in the Rails application and have these changes propagate to the Jena database.
In future versions, updates may be possible through the Fuseki endpoint.
The Jena database is exported to a MySQL database according to the rules specified in [***]. The resulting MySQL model is used by the Rails application to display and index the resulting data.
-
Modify configuration file with SPARQL endpoint information
-
At the command prompt, run the database migration to generate tables:
rake db:create rake db:migrate
-
Be sure your ruby environment is running within jruby. JRuby calls the Jena api to populate the Rails MySQL database with Jena data.
-
Now run the jena export:
rake db:jenaexport
-
Start the development solr indexer
rake sunspot:solr:run
-
Reindex the database:
rake sunspot:reindex
-
Go to localhost:8080 to see the finished product.