Not logged in : Login

About: VOSTPCHLinkedData     Goto   Sponge   Distinct   Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

AttributesValues
type
Date Created
Date Modified
label
  • VOSTPCHLinkedData
maker
Title
  • VOSTPCHLinkedData
isDescribedUsing
has creator
attachment
content
  • %VOSWARNING% %VOSNAV% --+TPC H As Linked Data Bringing Linked Data to Analytics %TOC% --++Introduction This article takes the industry standard TPC-H decision support benchmark and shows how its data can be exposed as linked data from any relational database. Virtuoso can either host the data itself or attach the relevant tables from any other database. Here we will look at a miniature sample of the TPC-H benchmark database that comes with the demo database. Exposing this data consists of a mapping declaration which translates the contents of the tables into a virtual RDF graph. The triples involved are not physically stored but are created on demand as requested by SPARQL queries or dereferencing the URIs representing the logical entities in the database. --++Mapping See the attached SQL file: tpch.sql --++Queries See the attached SQL file: tpch.sql As of this writing, not all the queries are supported. Thus you will see some of them commented-out. The relevant optimizations and SPARQL extensions for running these are being developed at the time of this writing. --++Dereferenceable URIs See the attached SQL file: tpch.sql This file defines a virtual directory and URI-rewrite rules that capture references to the TPC-H entities. The URL rewrite rules in this file catch references to the the TPC-H entities and redirect these into a SPARQL describe queries on the URI in question. The redirect makes an HTTP 303 redirection reply that goes to the SPARQL endpoint with a `describe' query for the object in question. --++Running the Samples There is a live sample of this demo running at http://demo.openlinksw.com/DAV/home/demo/tpch/ Virtuoso Open Source Edition will come with an implementation of the TPC-H data and queries from version 5.0.6 onwards. Start the demo server and connect to http://localhost:8890/DAV/home/demo/tpch with a web browser. The host part of the URIs given to the TPC-H data is given by the DefaultHost entry in the URIQA section of the virtuoso.ini file. --++Running the Samples Against External Data With the commercial release of Virtuoso, the tables do not have to reside in Virtuoso itself. They can be attached from any supported database using the Virtual Database layer (VDB). These can then be mapped into a graph of their own by re-running the mapping statements with the graph and tables renamed. %VOSCOPY% CategoryWebSite CategoryVirtuoso CategoryOpenSource
id
  • b109c1bb5c31b2f13309cfebcae3baa6
link
has container
http://rdfs.org/si...ices#has_services
atom:title
  • VOSTPCHLinkedData
links to
atom:source
atom:author
atom:published
  • 2017-06-13T05:42:03Z
atom:updated
  • 2017-06-13T05:42:03Z
topic
is made of
is container of of
is link of
is http://rdfs.org/si...vices#services_of of
is links to of
is creator of of
is atom:entry of
is atom:contains of
Faceted Search & Find service v1.17_git150 as of Jan 20 2025


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3332 as of Sep 11 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 759 MB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2025 OpenLink Software