search

DDMAL / linkedmusic-queries

Various methods to query our data lake, e.g., Virtuoso graphs
MIT License
0 stars 0 forks source link

We lack another comprehensive context for several queries to generate SPARQL(TheSession) #14

Closed candlecao closed 1 month ago

candlecao commented 1 month ago

Following https://github.com/DDMAL/linkedmusic-queries/issues/10

  1. Queries only Executable Using SPARQL on Virtuoso but not on TheSession Webpage The 4 queries: Q2-1: Find a session named "Hurley’s Irish Pub" Q2-2: What genres appear in the recording whose artist is "Adam Agee & Jon Sousa"? Q2-3: Find the session that took place within a 20-kilometer radius centered on the session "Hurley’s Irish Pub" Q2-4: 找到在希腊的演奏会(mandarin, translated as Find sessions in Greece)
candlecao commented 1 month ago

I figured out the comprehensive context and followed by 4 queries:

Given an RDF database with properties reconciled with Wikidata, and @PREFIX thesession: https://thesession.org/ . thesession:sessions a owl:Class . thesession:tunes rdfs:domain wd:Q482994 ; rdfs:range wd:Q170412 ; rdfs:comment "For albums have tunes" . wd:Q170412 rdfs:label “tune” . wd:Q482994 rdfs:label “album” . wd:Q483394 rdfs:label “genre” . wdt:P17 rdfs:domain thesession:sessions . wdt:P175 rdf:type owl:DatatypeProperty . wdt:P136 rdfs:domain wd:Q170412 ; rdfs:range wd:Q483394 . wdt:P625 rdfs:domain thesession:sessions .
wdt:P2561 rdfs:label “sessionName” ; rdfs:domain thesession:sessions . Before generating SPARQL, note: No need to return the label of an entity Use bif:st_distance(), the unit in which is kilometer and bif: is not a namespace prefix Remember to confine the type for entities Don't forget the namespace prefix for each SPARQL query Don't use property that's not provided above Albums don't relate genres directly, but Albums have tunes which relate genres

Generate correct SPARQL for the following question: Q2-1: Find a session named "Hurley's Irish Pub" Q2-2: What genres appear in the album whose artist is "Adam Agee & Jon Sousa"? Q2-3: Find other sessions that took place within a 20-kilometer radius centered on the session "Hurley's Irish Pub" Q2-4: 找到在希腊的演奏会

@fujinaga Hi Ich, please have a look. The bold part is worth notice. It's best not to use ChatGPT 4o-mini, but to use the typical 4o.