| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| |
| maker
| |
| Title
| |
| isDescribedUsing
| |
| has creator
| |
| attachment
| |
| content
| - %META:TOPICPARENT{name="VirtInstallationEC2"}%
---+ Installing the DBpedia data set on a Virtuoso EC2 AMI instance
OpenLink Software provides a backup of the current DBpedia Database as hosted on the live service at
http://dbpedia.org/, that users can restore into a Virtuoso EC2 AMI instance in the
cloud, giving them an instance of DBpedia for their own use.
%TOC%
---++ Prerequisites
* A [[VirtInstallationEC2][Virtuoso EC2 AMI instance]].
%BR%%BR% %BR%%BR%
* Note that a Virtuoso Release 5 AMI instance (ami-id ami-59628630 or ami-c46084ad) must be used with this backup.
* The live DBpedia instance is an m1.large EC2 instance type, and we recommend a 64-bit large image AMI instance with at least 8GB of memory for best performance.
---+++ Safeguarding Your SPARQL End-point
*Important* — The following section should be added to the Virtuoso configuration file
(/opt/virtuoso/database/virtuoso.ini) to control and safeguard your SPARQL
end-point against overzealous usage:
[SPARQL]
MaxCacheExpiration = 1 ; Cache Expiration time in seconds that overrides Sponger's default cache invalidation scheme
ExternalQuerySource = 1
ExternalXsltSource = 1
ResultSetMaxRows = 100000
;DefaultGraph = http://demo.openlinksw.com/dataspace/person/demo
MaxQueryCostEstimationTime = 10000 ; in seconds
MaxQueryExecutionTime = 30 ; in seconds
;ImmutableGraphs = http://unknown:8890/dataspace
;PingService = http://rpc.pingthesemanticweb.com/
DefaultQuery = select distinct ?URI ?ObjectType where {?URI a ?ObjectType} limit 50
DeferInferenceRulesInit = 0 ; Defer Loading of inference rules at start up
Details about these settings can be found in the [[http://docs.openlinksw.com/virtuoso/][Virtuoso Online Documentation]] in the
[[http://docs.openlinksw.com/virtuoso/dbadm.html#ini_SPARQL][SPARQL Configuration File section]]. The
"DeferInferenceRulesInit = 1" setting is important when hosting large RDF data sets like DBpedia,
as it defers the load of the inference rules which can take quite some time (up to an hour) during server startup.
OAuth support can be used to secure the SPARQL endpoint by installing the conductor_dav.vad VAD package. This allows the /sparql endpoint to be disabled or mapped to the Virtuoso OAuth SPARQL service thereby requiring an API key to use the endpoint as detailed in the [[VirtOAuthSPARQL][Virtuoso OAuth]] documentation.
Virtuoso [[http://docs.openlinksw.com/virtuoso/wsacl.html][Web Services ACLs]] can be used to control (limit) access to the SPARQL endpoint as detailed in the documentation link.
---+++ DBpedia VAD Application Package
If you are running a Virtuoso EC2 AMI instance created before December 2, 2008, you will need to update your DBpedia VAD Application package to obtain the latest enhancements, by taking the following steps --
1 Download the DBpedia VAD Application
(dbpedia_dav.vad) package.
1 Navigate to the "System Admin" -> "Packages" tab of the Virtuoso Conductor.
%BR%%BR% %BR%%BR%
1 Scroll down to the "Install Package" section of the tab, use the "Upload Package" option "browse" button.
%BR%%BR% %BR%%BR%
1 Navigate to the location of the downloaded dbpedia_dav.vad file and click the "open"
button to select it.
%BR%%BR% %BR%%BR%
1 Click the "Proceed" button to begin the installation process.
%BR%%BR% %BR%%BR%
---++ Steps
1 Load the Virtuoso Conductor Administration interface of the running EC2 AMI instance with a URL of the form
http://your-ec2-instance-cname/conductor.
%BR%%BR% %BR%%BR%
1 From the Virtuoso Conductor, navigate to the "System Admin" -> "Packages" tab to obtain a list of available
Virtuoso packages (VADs) to install.
%BR%%BR%%BR%%BR%
1 Click the "Install" button to initiate installation of the "EC2 Extensions" VAD package for use in performing backup
and restore tasks.
%BR%%BR% %BR%%BR%
1 Click the "Proceed" button to install the "EC2 Extensions" VAD package.
1 Go to the URL http://your-ec2-instance-cname/ec2exts to load the Virtuoso
Extensions for Amazon EC2 Images login page and log in as the "dba" user.
%BR%%BR% %BR%%BR%
1 From the Virtuoso Extensions for Amazon EC2 Images main page, click the "Restore a Remote Backup" link.
%BR%%BR% %BR%%BR%
1 On the "Restore a Remote Backup" page, set the follow options.
Protocol: WebDAV/HTTP
Host: s3.amazonaws.com
Path or Bucket: dbpedia-version-32-bundle
Backup File Prefix: dbpedia-version-32
%BR%%BR%
1 Click the "Restore" button to begin the restoration of the DBpedia database from backup.
%BR%%BR% %BR%
.
%BR%
.
%BR%
.
%BR% %BR%%BR%
1 Click on the "Continue" button to begin the re-assembly of the database from the restored backup files. Output
similar to the following will be displayed when the re-assembly of the database is complete.
%BR% %BR%
Note that server restart may take a while as there are some initialization procedures that take some time to complete. Once these are complete, the restored DBpedia database is ready for use.
---++ Usage Examples
You can then access pages such as these on your DBpedia server:
* *DBpedia About page* — http://your-ec2-instance-cname/About
%BR%%BR% %BR%%BR%
* *SPARQL end-point* — http://your-ec2-instance-cname/sparql
%BR%%BR% %BR%%BR%
* *DBPedia resource* — http://your-ec2-instance-cname/resource/OpenLink_Software
%BR%%BR% %BR%%BR%
---++ Related
* The DBpedia SPARQL endpoint can be accessed on http://your-ec2-instance-cname/sparql
* The OpenLink [[http://wikis.openlinksw.com/dataspace/owiki/wiki/OATWikiWeb/InteractiveSparqlQueryBuilder][Interactive SPARQL Query Builder]] can be accessed on http://your-ec2-instance-cname/isparql, enabling the visual construction of queries (Graph Patterns).
* OAuth support can be used to secure the SPARQL endpoint by installing the conductor_dav.vad VAD package. This allows the /sparql endpoint to be disabled or mapped to the Virtuoso OAuth SPARQL service thereby requiring an API key to use the endpoint as detailed in the [[VirtOAuthSPARQL][Virtuoso OAuth]] documentation. |
| id
| - cbab2ebe4413bbeff216225000d3d7f8
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| |
| links to
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)