Virtualized data sources

In addition to adding data files directly to data.world, you can also connect to and query remote relational databases using our virtualization technology. Even though the underlying databases are relational and speak SQL, you can use SPARQL to query them, and you can join in data from other data sources (almost) transparently.  Indeed, it is only slightly more difficult to query your virtualized relational databases with SPARQL than it is to query data you have uploaded as files. Instructions for setting up a virtualized connection can be found in our section on using the Connection Manager.Using Connection Manager

To query against the RDF triples from the virtualized source, you’ll need to use FROM or FROM NAMED in your SPARQL query, and use the :mapped IRI to specify that you want the virtualized triples.

Example - Virtualized

Important

All the links in the following examples open datasets in the data.world open data community. For best experience, make sure you are logged in to the application when you click these links.

Here is an example of a SPARQL query written against a live table in a relational database outside of data.world.

PREFIX : <https://ddw-doccorp.linked.data.world/d/sparql-virtualized/>

SELECT ?abbreviation ?runways
FROM NAMED :mapped 
{
    GRAPH :mapped {
        ?s :col-airports-abbreviation ?abbreviation.
        ?s :col-airports-runways      ?runways.
    }
}

Run the query

This is what the query looks like when run on data.world. Notice the mappings required for specifying the live table in the dataset: