#SPARQL
@groms Rails ORM generate SQL to populate its models, i.e. there is SQL behind everything. Unified filters makes generating this (massive amount) of SQL feasible across tthe relative complexity of the models in TaxonWorks. Would love to know if there is a similar layer that makes #sparql possible while still serving app dev needs.
Woot!
Another update for the #VirtuosoRDBMS (Open Source Edition) is here! Keep in mind that all my live demonstrations, whether they use #SPARQL or #SQL to fine-tune #ChatGPT, are also compatible with this edition (for example, the 100 billion+ #Uniprot instance-related demos at: https://community.openlinksw.com/t/using-sparql-query-templates-to-fine-tune-chatgpts-large-language-model-llm/3842/5).
#RDF #GraphDatabase #SPARQL #LinkedData #SQL #GraphQL #SemanticWeb #KnowledgeGraph
**Problem:**
#LLM based #SmartAgent solutions like #ChatGPT are fantastic natural language processors, but challenged by unpredictable guessing.
**Solution:**
Fine-tune using #SPARQL query templates and a #LODCloud #KnowledgeGraph like @Uniprot.
#SemanticWeb #LinkedData #HowTo #LLMs #Uniprot #Bioinformatics #Genomics #MolecularBiology #LifeSciences

@jk the #SPARQL endpoint at https://vocabs-sparql.acdh.oeaw.ac.at is also down, seemingly after a re-install of their Apache HTTP server
Incase you missed it, Simon in our latest #TechTalk blog post talks about his experiences implementing a GraphQL API for a Graph Database using Kotlin and an RDF graph database like Fuseki.
https://www.epimorphics.com/implementing-graphql-api-for-graphdatabase/
#TechTalk #GraphQL #GraphDatabase #SPARQL #Kotlin #RDF #Fuseki.

On this #DayOfDH2023 we're delighted to announce the addition of over 2,000 editions to the #OpenScholarship and #DSE platform #PRISMS. Read more about the project here:
@DayofDH #DayofDH #SemanticWeb #LOD #RDF #SPARQL #ontologies #KnowledgeBase

#ChatGPT funktioniert sehr gut auch für #Wikidata #SPARQL-Queries. Das erleichtert den Einstieg schon sehr. Damit kann man sich aufs Verfeinern der Queries konzentrieren und muss selbst keine Queries from scratch schreiben oder sich in den QueryBuilder einfuchsen. Hier z.B. ein Query, der Skulpturen in deutschen Museen ohne Inventarnummer ausgibt, gruppiert nach Museen: https://w.wiki/6mey
@anyaso This week’s highlights include “project closure” on #RMFI (we speak in acronyms in these parts), all the latest news on our parliamentary search replacement, #generalelection preparations in general (and #boundarychanges in particular), #treaty procedure updates, some #SPARQL snaggles, egg timer integration (if you don’t know now, you never will), late breaking bishopric news and some trouble we’ve been having with twitter’s new owner.
Claus Stadler is presenting their work behind SANSA: 'Scaling RML and SPARQL-based Knowledge Graph Construction with Apache Spark' now at the Knowledge Graph Construction Workshop!
#ESWC2023 #KGCW2023 #RML #SPARQL #ApacheSpark @eswc_conf @aksw

Towards a Mapping Framework for the Tenders Electronic Daily Standard Forms by Alexandros Vassiliades is now live at the Knowledge Graph Construction Workshop!
#ESWC2023 #KnowledgeGraph #RDF #SemanticWeb #RML #R2RML #SPARQL #SHACL @eswc_conf

I will be at @eswc_conf 2023 as part of the organizing committee of the #KnowledgeGraph #Construction #Workshop!
However, I'm not alone! Check out the papers of #KNoWS at #ESWC2023: https://knows.idlab.ugent.be/news/eswc2023/
#RDF #RML #SPARQL #reasoning #streaming #querying
@hochstenbach
#PerplexityAI provides a cool productivity tool for interacting with the #GPT4 #LLM that enables me share my session using hyperlinks.
Courtesy of the service provided by perplexity.ai, the process is now reduced to:
1. Write prompt and execute
2. Share session link.
Example covering LLM fine-tuning examples using #SPARQL templates.
[1] https://www.perplexity.ai/search/6543ca49-14c6-4b44-89b3-61f0abf7b1f9?s=c -- exploring Recipes collated in our #URIBurner Knowledge Graph

#rdf #sparql #turtle #rdflib #python #elixir #rust
How to use #SQL query templates to fine-tune #ChatGPT.
https://community.openlinksw.com/t/howto-fine-tuning-chatgpt-using-sql/3862
All possible because of the underlying architecture of our multi-model #VirtuosoRDBMS equipped with native #HTTP support.
#SemanticWeb #SPARQL #DBMS #RDBMS #LinkedData #CDO #CIO #CTO #AGI


@simon_lucy I purposely display the content of the FAQ page in two different screenshots, showing a total of 10 questions. The objective of this exercise was to demonstrate that in an aspect of a #Web that manifests a Giant Global Entity Relationship Graph constructed from hyperlinks (a/k/a a Semantic Web), you can leverage the combined prowess of #ChatGPT and the #SPARQL query language (an HTTP-based query language, wire protocols, and serialization formats combo) for precise discovery😀
However, when #Wikidata emerged, I wanted to connect my database with it. Before two years, I tried to store SMW in #Blazegraph but I made a bad experience with it. When the power went off, it led to fatal error and problem to boot.
Two months ago, I tried a second attempt, with #Virtuoso for this time. It runs without problems.
Now, I can make #sparql queries, however it is quite complicated, e.g. to query properties and pages with longer string names.
Comparative web page crawling exercise, taking into account the following factors:
[1] The emergence of a #SemanticWeb where web pages increasingly embed RDF-based structured data islands as enhanced metadata.
[2] The web crawling functionality provided by #ChatGPT, #Bing, and #Bard.



There's a powerful symbiosis between #ChatGPT a #SemanticWeb (public or private) that is not immediately apparent. This symbiosis exists because ChatGPT is inherently data-dependent, while a Semantic Web consists of boundless structured data constructed using machine-computable entity relationship types that are constructed from hyperlinks.
Here's a new #HowTo and live demos centric post about this issue.
Q: Can I fine-tune #ChatGPT using #SPARQL such that it basically becomes a #SmartAgent capable of querying across the massive #LODCloud #KnowledgeGraph, using natural language?
Yes!
Read: https://community.openlinksw.com/t/howto-chat-gpt-and-dbpedia-sparql-query-generation-from-natural-language-prompts/3823 -- which covers a basic example using #DBpedia (#Wikidata content in machine-computable and queryable form).
#SemanticWeb #LinkedData #JSONL #RDF #LLMs #DBpedia #VirtuosoRDBMS #JSONL
Another #SemanticWeb + #ChatGPT showcase:
Executing a #SPARQL query (informed by a template) without a plugin across the #LODCloud, courtesy of #LinkedData principles.

La requête #SPARQL du jour : les pays pour lesquels le titre de l'article Wikipédia en français comporte des parenthèses
(Si j'ai l'énergie dimanche j'en fais un billet #SundayQuery, ça fait longtemps)

#SPASQL is how our #VirtuosoRDBMS enables declarative operations on data organized as tables or graphs via #SPARQL inside #SQL.
What are the benefits?
[1] Ubiquitous Data Source Names (#DSNs), courtesy of #HTTP
[2] Fine-grained entity relationship graph comprising clickable edges and nodes that function as #SuperKeys
#ChatGPT knows SPASQL too!
#SemanticWeb #LinkedData #GraphDatabase #DBMS #RDBMS #CDO #CIO #CTO #DataOps #DBpedia #LODCloud #KnowledgeGraph #HowTo

@yokofakun You can try the #LODCloud cache we host via its #SPARQL endpoint at:
http://lod.openlinksw.com/sparql .
Mondo is loaded there, as per:
https://tinyurl.com/3tfshk6z

Don't you have a live #SPARQL endpoint to test against?
#ChatGPT is a powerful tool for acquiring new skills productively while also reinforcing what exists.
In a new post, I provide a ChatGPT transcript comprising prompts that generate #SQL and #SPARQL #Cheatsheets enhanced using hyperlinks.
#DBMS #Database #HowTo #LinkedData #DBpedia #Northwind #VirtuosoRDBMS


answer from #chatgpt (not tested) #sparql
=====================
SELECT DISTINCT ?diseaseLabel ?geneLabel ?relationLabel
WHERE {
?diseaseSubClass rdfs:subClassOf* mondo:0004995 .
?diseaseSubClass rdfs:label ?diseaseLabel .
?diseaseSubClass ?relation ?gene .
?gene rdfs:label ?geneLabel .
?relation rdfs:label ?relationLabel .
FILTER (?relation = obo:RO_0003302 || ?relation = obo:BFO_0000051)
}
ORDER BY ?geneLabel
I'm playing with mondo https://github.com/monarch-initiative/mondo/ . Is there any example of #sparql queries somewhere ? I'm looking for "find all the ?GENE linked to ?DISEASE" (and the subClasses of that disease).
Say; "I want all the genes linked to cardiac diseases"
After all those years, WHY didn't you tell me about recursive queries in #SPARQL that find all the descendants of a term in an ontology? https://gist.github.com/lindenb/2b0239f2237ce835fe2d2ddfc9ebeb02
And this is an excellent set of libraries to deal with RDF/SPARQL in Elixir https://rdf-elixir.dev/
#devlife #elixir #sparql #rdf #turtle #dles
@JanWillemTulp When I still followed it more closely, I always thought the #SPARQL language spec itself did a pretty good job explaining the basics:
https://www.w3.org/TR/sparql11-query/
The O'Reilly book is great (by @bobdc), I think there was a free version too (though couldn't find it now):
https://www.oreilly.com/library/view/learning-sparql-2nd/9781449371449/
Other online tutorials:
https://docs.data.world/tutorials/sparql/primer_intro.html
https://docs.stardog.com/getting-started-series/getting-started-1#introduction-to-sparql
https://medium.com/virtuoso-blog/dbpedia-basic-queries-bc1ac172cc09
Albeit not really SPARQL (but _very_ closely related, only with "Clojurified" syntax & semantics), some of my older linked data projects have some related examples too (also showing to rule-based inference to synthesize additional indirect relationships):
https://github.com/thi-ng/trio/blob/master/src/query.org
https://github.com/thi-ng/fabric/blob/master/fabric-facts/src/dsl.org
Hth!
Wikidata Queries can generate timelines of when artworks owned by someone with some kind of link to a claim for restitution entered museum collections.
This query is filtered for after 1932 and for six museums only.
Try it!
https://w.wiki/6d48
#wikidata #histodon #digitalhumanities #linkeddata #museum #provenance #Sparql #timeline #art #arthistory #dataviz #jewish #history
It's actually pretty easy to flag Art Looting #RedFlag Names in the provenances and references for artworks held in museums.
Odd, really, that #museums haven't done so.
#Gallery
Any #learning #course on #provenance #research should detail what could be done that has not been done.
Here's a #Sparql #Query in #Wikidata that shows some of the paintings once owned by Red Flag Names
link to query
https://w.wiki/6cWZ
First time putting #ChatGPT to actual use. I needed #SPARQL to create an #URL slug, but was to lazy to think. It was incomplete at first, but after asking to add more chars, it turned out to be a huge time saver. #rdf #knowledgegraph
New preprint, where we discuss various approaches to knowledgebase interoperability based on our experience at @bgeedb:
Boosting interoperability: towards an increasingly reusable bioinformatics knowledge base
https://arxiv.org/abs/2303.12329
#bioinformatics #knowledgebase #interoperability #ontology #SQL #SPARQL #SIB @monarch_initiative @wikidata
Active #SPARQL Query Services across the #LODCloud, courtesy of a #Wikibase query:
[1] https://tinyurl.com/2h7dze9u -- Tables
[2] https://tinyurl.com/2h7dze9u -- Bubble Chart
A SPARQL Query Service endpoint provides access to an #HTTP-based Query Language, Wire Protocol, and Negotiable Serialization Format combo that's fully understood by #ChatGPT.

Woot!
A brand new cut of #DBpedia that places #HTTP client apps and services right at the core of the massive #LODCloud #KnowledgeGraph.
Also note, in this revitalized #SemanticWeb era, #ChatGPT understand DBpedia -- pretty well :)
Does anyone out there in Masto-land know a enterprise resource planning (#ERP) or inventory management system where the types of the inventoried items can be defined by #SPARQL queries to #Wikidata?
Long story short, what I'm looking to do is have #laboratory inventory management via a web/mobile/desktop app, but define/ingest the characteristics of the individuals in the inventory via Wikidata, using individuals like this:
https://www.wikidata.org/wiki/Q117161609
Any ideas? Plz boost if it could help!
#RDFLob version 6.3.0 is out. We use it a lot in #python #jupyternotebook for analyzing data in the different #SwissProt #SPARQL #graph #databases. https://pypi.org/project/rdflib/6.3.0/
@jackgilmore Great!
Here's a query results page reusing your query (using generic #SPARQL) against our #VirtuosoRDBMS hosted #Wikidata instance.
Note, @datasniff is the tool used for query editing directly from the current query results page.
Nice #Wikidata use-case demo.
SeeAlso, using our #VirtuosoRDBMS hosted edition of Wikidata.
Bin ganz begeistert vom #SPARQL - #Workshop auf der #DHd2023 Ein paar Sachen haben sogar geklappt (yeah!). Ich bin begeistert von den Möglichkeiten und überlege, wie ich das in der Lehre einsetzen kann.
Großen Dank an das #MiMoText Workshop Team 👏👏👏
@MariaHinzmann @christof @naudgnit et al (habe nicht alle gefunden) für einen wahrlich erhellenden Auftakt zur @DHdKonferenz
Nur noch 3 Tage bis zum Start der #DHd2023! 🤩
Am Mo gibt das #MiMoText-Team des @tcdh in Belval den Workshop "SPARQL für (digitale) Geisteswissenschaftler:innen". Wir haben auch ein online-#SPARQL-Tutorial erstellt, in das man bereits hineinschauen kann: https://docs.mimotext.uni-trier.de. 🙂
The new release of Ontop 5.0.2 adds
- six more data sources (Trino, PrestoDB, AWS Athena, AWS RedShift, Google BigQuery, DuckDB)
- an option for accelerating the materialization into triples
- better support for developing new connectors.
More details on https://ontop-vkg.org/guide/releases.html#_5-0-2-march-9-2023
I shared several links that will take you into a #SPARQL endpoint (https://linkeddata.uriburner.com/sparql) scoped to a live #KnowledgeGraph that can be populated progressively.
Why not use that to create an actual sample query?
/cc @J12t @datasniff
@bobwyman @J12t @datasniff Bearing in mind the abundance of publicly accessible #SPARQL Query Service endpoints, you can craft a query that satisfies the conditions of interest to you. In addition, you can just share a query URL for discussion, evaluation, and revision.
[1] https://linkeddata.uriburner.com -- 666,964,325 Triples (right now)
[2] http://lod.openlinksw.com/sparql -- 45 Billion Triples
[3] https://sparql.uniprot.org -- 100 Billion+ Triples
SPARQL Query Example: https://tinyurl.com/4kanhcd9
There is a complete provenance trail for all the data in my #SemanticWeb example.
Examples plus associated screenshot.
[2] https://linkeddata.uriburner.com/fct/facet.vsp?qxml=%3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22UTF-8%22%20%3F%3E%3Cquery%20inference%3D%22%22%20invfp%3D%22IFP_OFF%22%20same-as%3D%22SAME_AS_OFF%22%20view3%3D%22%22%20s-term%3D%22e%22%20c-term%3D%22type%22%20agg%3D%22%22%20limit%3D%2250%22%3E%3Ctext%3E%23SemanticWeb%3C%2Ftext%3E%3Cview%20type%3D%22text-d%22%20limit%3D%2250%22%20offset%3D%22%22%20%2F%3E%3C%2Fquery%3E&timeout=16000 -- 2,765 pages comprising items and Named Graphs (data sources) for "#SemanticWeb" text pattern
That's also obtainable via a #SPARQL query that includes Named Graph Identifiers in the solution output.
/cc @J12t @datasniff
@bobwyman @J12t Yes, a #SemanticWeb user-agent can handle that.
For example, the sponger #middleware module of our #VirtuosoRDBMS can do that.
Re Prospective Search, the focal point is variables in the body of a #SPARQL query that satisfy conditions expressed in relations.
A query solution can always optionally include document identifiers (a/k/a named graphs).
Example: https://tinyurl.com/4kwzvu28
#DEXPI the 😎 -est about this open standard for data exchange is, #rdf is already integrated and shipped with, so #KnowledgeGraph #SPARQL already here 🥰
@KevinMarks @anildash @atomicpoet That's but one interpretation, for a specific purpose.
I just posted a #SPARQL that just deals with the raw #JSONLD (the content format of #ActivityStreams docs).
@tanepiper @GiorgiaLodi @pietervaneverdingen Wonderful!
Courtesy of our @datasniff browser extension, I can see how your #KnowledgeGraph is being integrated into #HTML docs published to your website.
Example page:
https://www.ikea.com/us/en/p/rengjord-built-in-dishwasher-90504572/
#SPARQL Query using that page as the Data Source Name (#DSN).
https://tinyurl.com/5bz5hxs4
#DataConnectivity #LinkedData #SemanticWeb #Web30 #UseCase #eCommerce
We (@openlink) are working on stuff from the #LinkedData and #SPARQL perspectives that include hooks into voice and text via CHAT-GPT shortcuts.
alright I'm about to start working on some #LinkedData / #Graph-based p2p stuff, I am gonna spend some time digging deeper into #SPARQL, and I'm wondering if anyone can point me to any writing (blogs, papers, posts all good) on the good and bad from both a design and implementation POV. I can read the docs, but would like to learn the meta surrounding it from starry-eyed idealists and cranky engineers alike. Boosts for visibility welcome :)
There are eight glaciers named after characters in Moby-Dick.
Wikidata query: https://w.wiki/6EJ5
Cheeses named after towns according to @wikidata: https://w.wiki/6CBD
Here's a #screencast demonstrating how #gptChat generated accurate #RDF from a text snippet in a blog post about how to use the @openlink #ODBC Driver for #PostgreSQL on #macOS.
Note, GPT-Chat is integrated into a soon to be released edition of our @datasniff browser extension.
/cc @Mastodon
#SemanticWeb #UseCase #SmartAgent #Web30 #SPARQL #DataConnectivity #LinkedData
What is this demonstrating, utility wise?
The fact that I can use a #SmartAgent like #gptChat to generate machine-computable structured data for upload to a knowledgebase (or #KnowledgeGraph).
Naturally, I can query said Knowledge Graph declaratively using #SQL, #SPARQL, or #GraphQL where query solutions also manifest in easy-to-reuse form e.g., #JSON, #CSV, etc..
We are now in the Smart Agent stage re notion of a #SemanticWeb!
I would hope an ability to query your #RSS and #OPML feeds directly using Text Search, #SQL, #GraphSQL, or #SPARQL would fit that bill re data flow and connectivity :)
Audience?
End-users, power-users, and developers who are happy to work with a #Hyperlink as a Data Source Name (#DSN).
App Examples?
1. Spreadsheets (#GoogleSpreadsheet, #Excel, #Airtable)
2. Various notebooks (#Jupyter, #Observablehq etc..)
3. Data Visualization Tools
4. Content Management
5. etc
/cc @judell
What do you seek, interop wise, from a solution that supports #RSS or #OPML?
For instance, our products are able to achieve the following with OPML:
1. Generate a knowledgebase (or #KnowledgeGraph these days) "on the fly" using query languages such as #SQL, #SPARQL, #GraphQL
2. Content Subscription
Regarding RSS, it can do all of the above plus:
1. Publish query solutions in that format
2. Publish folder content
/cc @judell
Here's yet another angle:
#RSS solves for publication and syndication of posts.
See: https://tinyurl.com/bdex5wys
#ActivityPub solves for Activity Streams which goes beyond posts.
See: https://tinyurl.com/2mxk3rjh
Ultimately, #HTTP software agents will be able to process structured data consuming either.
In my case, it all ends up in a #KnowledgeGraph (using a bookmarking-like interaction pattern). All the data is accessible via #SQL, #SPARQL, #GraphQL, etc..
/cc @AlexGizis @judell
The #JSON file represents an accounts #ActivityStream covering a variety of activities.
This makes @Mastodon content highly accessible and interoperable with other productivity tools.
In my case, the JSON and #RSS data ends up in a #DataSpace that can be queried using full-text search patterns, #FacetedSearch, #SQL, #SPARQL, and #GraphQL.
/cc @judell
Do I reach anyone who has experience using #SPARQL with #SemanticMediaWiki #MediaWiki ? I have an endpoint set up but I truly do not know how to secure it or what best practices are at all. documentation seems very very slim.
Working title of my habilitation thesis 📗:
"Formal Representaion of Engineering Knowledge – the Example of Control Theory"
studied technologies: #OWL, #SPARQL, #WikiData, #ExistentialRules etc.
maintained projects: https://pysemtec.org/ (:python: #Python-related semantic technologies) and https://ackrep.org/ (automatic control knowledge repository :git:)
Also active @ @bits_und_baeume and related activities on 🌍
2/2
Find Semantic Web+ researchers on Mastodon! :BlobCatCoffee:
Follow the listing here:
https://semantisch.github.io/SemanticWeb//
Join the listing here as a researcher:
https://forms.gle/pjNmNG6xwzU28Y3o6
#SemanticWeb #KnowledgeGraph #LinkedData #LinkedOpenData #Ontology #KnowledgeRepresentation #Reasoning #RDF #SPARQL #OWL #SHACL #Wikidata #DBPedia #Solid
Other academics on Mastodon:
https://github.com/nathanlesage/academics-on-mastodon
#introductionfr en mode réactivation du compte framapiaf ouvert lors de la précédente vague...
#Archiviste #servicepublic très portée #GLAM #opendata #opencontent et #LOD .
Totalement addict à #wikidata et #openrefine (en lien avec #patrimoine, #histoire #histoiredesfemmes).
J'aime modifier les super requêtes #sparql de @belett ❤️ et faire des traductions (enrichies) pour #Wikipedia #LesSansPages