Use of Virtuoso to combine both SQL and SPARQL -- demonstrated by the effects of Green (Local) and Blue (Universal) Hyperlinks

We recently discovered data (published in CSV form) from the Metropolitan Museum of Art that provides a great data source for demonstrating the power of blending query languages such as SQL and SPARQL courtesy the unique capabilities of Virtuoso.

Once you’ve downloaded the CSV document to a filesystem folder accessible to Virtuoso, follow the steps below with regards creating a Relational Table from a filesystem hosted data source (document).

  1. Attach a Virtuoso instance to the the CSV doc, and use SQL to query the data.

    • Live Demo Link – use vdb for both username and pwd

    • Green links seen here are local Super Keys.

  2. Click on a Green Link to get a description of the entity it denotes. The description is basically a selection of all properties associated with the denoted entity.

  3. SPARQL can be used to produce a SQL view that negates the challenge associated with producing an Entity Relationship Graph from an attached CSV table. This exploits the unique multi-model functionality of Virtuoso:

  4. We started off with Green Links that denoted entities represented by table rows. Now, we have Blue Links, which have the same denotational functionality while also providing de-reference (lookup) from any HTTP user agent. For example, this Blue Link denotes a sample object from the museum’s collection.

Related Links