{"id":2137,"date":"2016-11-15T16:53:03","date_gmt":"2016-11-15T15:53:03","guid":{"rendered":"https:\/\/wordlift.io\/entity\/sparql\/"},"modified":"2020-10-13T22:17:08","modified_gmt":"2020-10-13T20:17:08","slug":"sparql","status":"publish","type":"entity","link":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/","title":{"rendered":"SPARQL"},"content":{"rendered":"

Querying Semantic Data<\/h3>\n

SPARQL (pronounced “sparkle”, a recursive acronym for SPARQL Protocol and RDF Query Language) is an RDF query language, that is, a query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format. RDF\u00a0is commonly used for modeling information in the web of linked data<\/a>.<\/p>\n

It was made a standard by the RDF Data Access Working Group (DAWG) of the World Wide Web Consortium, and is considered as one of the key technologies of the semantic web. On 15 January 2008, SPARQL 1.0 became an official W3C Recommendation.<\/p>\n

Querying WordLift’s Data with SPARQL – a Cheat Sheet <\/span><\/h3>\n

Here we have listed few queries in\u00a0SPARQL created to extract\u00a0metadata being shared as linked data by semantic websites that use WordLift.<\/span><\/p>\n

1. What are the most recurring concepts used on the site to mark up the articles?<\/strong><\/p>\n

PREFIX dct: <http:\/\/purl.org\/dc\/terms\/>
\nSELECT * WHERE {
\nSELECT ?o (COUNT() as ?count) WHERE { [] dct:references ?o }
\nGROUP BY<\/span> ?o
\n} ORDER BY DESC(?count) LIMIT 10<\/p>\n

2. What are the most recurring concepts taking into account the relationships created among concepts?<\/b><\/p>\n

PREFIX dct: <http:\/\/purl.org\/dc\/terms\/>
\nSELECT * WHERE {
\nSELECT ?o (COUNT() as ?count) WHERE { [] dct:relation ?o }
\nGROUP BY<\/span> ?o
\n} ORDER BY DESC(?count) LIMIT 10<\/p>\n

3. What are the most recurring concepts combining the relationships with articles and the relationships among entities?<\/strong><\/p>\n

PREFIX dct: <http:\/\/purl.org\/dc\/terms\/>
\nSELECT * WHERE {
\nSELECT ?o (COUNT() as ?count) WHERE { { [] dct:references ?o } UNION { [] dct:relation ?o } }
\nGROUP BY<\/span> ?o
\n} ORDER BY DESC(?count) LIMIT 10<\/p>\n

4. How many triples have been created on the site?<\/b><\/p>\n

SELECT (COUNT() AS ?no) { ?s ?p ?o }<\/p>\n

5. How many entities have been created on the site? <\/strong><\/p>\n

SELECT (COUNT(distinct ?s) AS ?no) { ?s a [] }<\/p>\n

6. How many articles have been annotated with WordLift?<\/strong><\/p>\n

SELECT (COUNT(distinct ?s) AS ?no) WHERE {?s a <http:\/\/schema.org\/BlogPosting> . }<\/p>\n\n

\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"

Querying Semantic Data SPARQL (pronounced “sparkle”, a recursive acronym for SPARQL Protocol and RDF Query Language) is an RDF query language, that is, a query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format. RDF\u00a0is commonly used for modeling information in the web of linked data. It was made … Continued<\/a><\/p>\n","protected":false},"author":6,"featured_media":4343,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false,"wl_entities_gutenberg":"","_wlpage_enable":"","footnotes":""},"categories":[612],"wl_entity_type":[12],"coauthors":[],"class_list":["post-2137","entity","type-entity","status-publish","has-post-thumbnail","hentry","category-semantic-seo","wl_entity_type-thing"],"acf":[],"yoast_head":"\nSPARQL SPARQL -<\/title>\n<meta name=\"description\" content=\"SPARQL is an RDF query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SPARQL SPARQL -\" \/>\n<meta property=\"og:description\" content=\"SPARQL is an RDF query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/\" \/>\n<meta property=\"og:site_name\" content=\"WordLift Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-13T20:17:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1181\" \/>\n\t<meta property=\"og:image:height\" content=\"762\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Andrea Volpini\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/\",\"url\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/\",\"name\":\"SPARQL SPARQL -\",\"isPartOf\":{\"@id\":\"https:\/\/wordlift.io\/blog\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png\",\"datePublished\":\"2016-11-15T15:53:03+00:00\",\"dateModified\":\"2020-10-13T20:17:08+00:00\",\"description\":\"SPARQL is an RDF query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format.\",\"breadcrumb\":{\"@id\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#primaryimage\",\"url\":\"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png\",\"contentUrl\":\"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png\",\"width\":1181,\"height\":762,\"caption\":\"SPARQL | WordLift\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/wordlift.io\/blog\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SPARQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wordlift.io\/blog\/en\/#website\",\"url\":\"https:\/\/wordlift.io\/blog\/en\/\",\"name\":\"WordLift Blog\",\"description\":\"AI-Powered SEO\",\"publisher\":{\"@id\":\"https:\/\/wordlift.io\/blog\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wordlift.io\/blog\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wordlift.io\/blog\/en\/#organization\",\"name\":\"WordLift\",\"url\":\"https:\/\/wordlift.io\/blog\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wordlift.io\/blog\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/mk0wordliftblog7j5te.kinstacdn.com\/wp-content\/uploads\/sites\/3\/2017\/04\/logo-1.png\",\"contentUrl\":\"https:\/\/mk0wordliftblog7j5te.kinstacdn.com\/wp-content\/uploads\/sites\/3\/2017\/04\/logo-1.png\",\"width\":152,\"height\":40,\"caption\":\"WordLift\"},\"image\":{\"@id\":\"https:\/\/wordlift.io\/blog\/en\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SPARQL SPARQL -","description":"SPARQL is an RDF query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/","og_locale":"en_US","og_type":"article","og_title":"SPARQL SPARQL -","og_description":"SPARQL is an RDF query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format.","og_url":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/","og_site_name":"WordLift Blog","article_modified_time":"2020-10-13T20:17:08+00:00","og_image":[{"width":1181,"height":762,"url":"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes","Written by":"Andrea Volpini"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/","url":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/","name":"SPARQL SPARQL -","isPartOf":{"@id":"https:\/\/wordlift.io\/blog\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#primaryimage"},"image":{"@id":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#primaryimage"},"thumbnailUrl":"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png","datePublished":"2016-11-15T15:53:03+00:00","dateModified":"2020-10-13T20:17:08+00:00","description":"SPARQL is an RDF query language for databases, able to retrieve and manipulate data stored in Resource Description Framework format.","breadcrumb":{"@id":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#primaryimage","url":"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png","contentUrl":"https:\/\/wordlift.io\/blog\/en\/wp-content\/uploads\/sites\/3\/2016\/11\/SPARQL-WordLift.png","width":1181,"height":762,"caption":"SPARQL | WordLift"},{"@type":"BreadcrumbList","@id":"https:\/\/wordlift.io\/blog\/en\/entity\/sparql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/wordlift.io\/blog\/en\/"},{"@type":"ListItem","position":2,"name":"SPARQL"}]},{"@type":"WebSite","@id":"https:\/\/wordlift.io\/blog\/en\/#website","url":"https:\/\/wordlift.io\/blog\/en\/","name":"WordLift Blog","description":"AI-Powered SEO","publisher":{"@id":"https:\/\/wordlift.io\/blog\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wordlift.io\/blog\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wordlift.io\/blog\/en\/#organization","name":"WordLift","url":"https:\/\/wordlift.io\/blog\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wordlift.io\/blog\/en\/#\/schema\/logo\/image\/","url":"https:\/\/mk0wordliftblog7j5te.kinstacdn.com\/wp-content\/uploads\/sites\/3\/2017\/04\/logo-1.png","contentUrl":"https:\/\/mk0wordliftblog7j5te.kinstacdn.com\/wp-content\/uploads\/sites\/3\/2017\/04\/logo-1.png","width":152,"height":40,"caption":"WordLift"},"image":{"@id":"https:\/\/wordlift.io\/blog\/en\/#\/schema\/logo\/image\/"}}]}},"_wl_alt_label":[],"wl:entity_url":"http:\/\/data.wordlift.io\/wl0216\/entity\/sparql","_links":{"self":[{"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/entities\/2137"}],"collection":[{"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/entities"}],"about":[{"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/types\/entity"}],"author":[{"embeddable":true,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/comments?post=2137"}],"version-history":[{"count":0,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/entities\/2137\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/media\/4343"}],"wp:attachment":[{"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/media?parent=2137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/categories?post=2137"},{"taxonomy":"wl_entity_type","embeddable":true,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/wl_entity_type?post=2137"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/wordlift.io\/blog\/en\/wp-json\/wp\/v2\/coauthors?post=2137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}