Here is a query that I wanted to evaluate:

SELECT ?sub ?super WHERE {
  ?sub wdt:P279+ ?super .
}

Fine on QLever, fails immediately on Virtuoso, times out in Blazegraph.


It would be a good idea to collect wanted but difficult queries to help inform the WDQS team when they finally replace Blazegraph. I have over 60 queries that I ran during investigations of the Wikidata ontology. Some of them were too tough for QLever and quite a few were pieces of the too-tough queries that I then combined the results of.

peter


On 10/9/24 10:43, Kingsley Idehen via Wikidata wrote:
Denny and others,

Here’s my basic goto query for SPARQL.

|SELECT (SAMPLE(?s) as ?sample) (count(*) as ?count) ?o WHERE {?s a ?o} GROUP BY ?o ORDER BY DESC (?count) LIMIT 20 |

SPARQL Results Links:

 1.

    Solution from Our Wikidata Endpoint
    
<https://wikidata.demo.openlinksw.com/sparql?default-graph-uri=http%3A%2F%2Fwww.wikidata.org%2F&query=SELECT+%28SAMPLE%28%3Fs%29+as+%3Fsample%29+%28count%28*%29+as+%3Fcount%29+%3Fo%0D%0AWHERE+%7B%3Fs+a+%3Fo%7D%0D%0AGROUP+BY+%3Fo%0D%0AORDER+BY+DESC+%28%3Fcount%29%0D%0ALIMIT+20&format=text%2Fx-html%2Btr&timeout=30000&signal_void=on>

 2.

    QLever’s Endpoint doesn’t handling this, assuming
    https://qlever.cs.uni-freiburg.de/wikidata/sk8I2D is the correct one.

What am I missing here?

Kingsley

On 10/9/24 10:31 AM, Kingsley Idehen via Wikidata wrote:

HI Denny,

On 10/2/24 5:05 AM, Denny Vrandečić wrote:
The most promising show of "we are ready" for the Virtuoso Open Source edition would be what QLever has been doing for a while: to provide a public endpoint with the data loaded, and kept up to date using the public edit stream. That would be an undeniably strong argument for "just use this!"

Aren't you aware of the public endpoints we've provided for years?

[1] https://wikidata.demo.openlinksw.com/sparql

[2] https://wikidata.demo.openlinksw.com/fct

That's VOS based.

Is there something that's missing etc?

Kingsley



On Thu, Sep 26, 2024 at 4:32 PM Samuel Klein <[email protected]> wrote:


    An updated benchmark eval (or self-evals) for the top db candidates
    seems called for :)  we would all love to see it.

    Ideally with a canonical hardware or vm spec that all can use...

    I don't know if the QLever self-eval from the spring is the right place
    to start, but I believe these
    <https://ad-research.cs.uni-freiburg.de/benchmarks/wdqs-queries/> are
    the ~300 queries they used for a Wikidata benchmark.

    🌍🌏🌎🌑
    _______________________________________________
    Wikidata mailing list -- [email protected]
    Public archives at
    
https://lists.wikimedia.org/hyperkitty/list/[email protected]/message/YJOUPRZPOIS6QMAPUJVYM65IQOM3DKIP/
    To unsubscribe send an email to [email protected]


_______________________________________________
Wikidata mailing list [email protected]
Public archives 
athttps://lists.wikimedia.org/hyperkitty/list/[email protected]/message/E4POSDWVJ27GSOFTRWDKS3HAQOG6FO3Y/
To unsubscribe send an email [email protected]


--
Regards,

Kingsley Idehen 
Founder & CEO
OpenLink Software
Home Page:http://www.openlinksw.com
Community Support:https://community.openlinksw.com
Weblogs (Blogs):
Company Blog:https://medium.com/openlink-software-blog
Virtuoso Blog:https://medium.com/virtuoso-blog
Data Access Drivers 
Blog:https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers

Personal Weblogs (Blogs):
Medium Blog:https://medium.com/@kidehen
Legacy Blogs:http://www.openlinksw.com/blog/~kidehen/
http://kidehen.blogspot.com

Profile Pages:
Pinterest:https://www.pinterest.com/kidehen/
Quora:https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter:https://twitter.com/kidehen
Google+:https://plus.google.com/+KingsleyIdehen/about
LinkedIn:http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal:http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
:http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this


_______________________________________________
Wikidata mailing list [email protected]
Public archives 
athttps://lists.wikimedia.org/hyperkitty/list/[email protected]/message/LWQSVDOOG3ABNQM7QMGIFKT6SWZBOIPT/
To unsubscribe send an email [email protected]

​

--
Regards,

Kingsley Idehen 
Founder & CEO
OpenLink Software
Home Page:http://www.openlinksw.com
Community Support:https://community.openlinksw.com
Weblogs (Blogs):
Company Blog:https://medium.com/openlink-software-blog
Virtuoso Blog:https://medium.com/virtuoso-blog
Data Access Drivers 
Blog:https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers

Personal Weblogs (Blogs):
Medium Blog:https://medium.com/@kidehen
Legacy Blogs:http://www.openlinksw.com/blog/~kidehen/
               http://kidehen.blogspot.com

Profile Pages:
Pinterest:https://www.pinterest.com/kidehen/
Quora:https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter:https://twitter.com/kidehen
Google+:https://plus.google.com/+KingsleyIdehen/about
LinkedIn:http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal:http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
         
:http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this


_______________________________________________
Wikidata mailing list -- [email protected]
Public archives at 
https://lists.wikimedia.org/hyperkitty/list/[email protected]/message/VFIPOQWJ3KVE76HHMV3J7BWKYAP5YT4A/
To unsubscribe send an email to [email protected]
_______________________________________________
Wikidata mailing list -- [email protected]
Public archives at 
https://lists.wikimedia.org/hyperkitty/list/[email protected]/message/T4X7BKZM3D6CKKKDLHMZR3LRCYPFVPN4/
To unsubscribe send an email to [email protected]

Reply via email to