I stumbled upon this post by Vulture, “All 147 Michael Jackson Songs, Ranked From Worst to Best”.
Step 1. Using the OpenLink Structured Data Sniffer (OSDS), I found the RDF embedded in the HTML was using terms from Schema.org, so I used the SPARQL
SAMPLE() aggregate function to produce an Entity Relationship Graph overview.
SPARQL Query Result Page
Results Page, including Query Definition via OSDS
Results Page with Query text display via OSDS
Entity Description page — as a result of clicking a Hyperlink from the SPARQL Query results page
Step 2: The RDF embedded in the Vulture document’s HTML isn’t scoped to each song, so I am going to use SPARQL to extract that information via the embedded YouTube hyperlinks.
- Here is the Result Page
Results Page Screenshots
Step 4: In situations where SQL is the preferred query language, our Virtuoso lets you use SPARQL nested in the
FROM clause (that is, SPASQL, or SPARQL-within-SQL).
Here is a Live Demo Link — Use
vdb for both username and password when challenged.
- OpenLink Structured Data Sniffer (OSDS) Browser Extension
- URIBurner Service Home Page
- Virtuoso Universal Server Product Home Page
- OSDS Super Links Feature Introduction Blog Post
- Using the super links feature of the OpenLink Structured Data Sniffer Browser Extension
- Exploiting HTML-hosted Knowledge Graphs – Using OpenLink Productivity Tools