[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-12-03 Thread Igorkim78
Igorkim78 added a comment.


  We need statistics on how many triples use bnode as an object:
  {code}
  select ?p (count(*)as ?cnt) {
  
?s ?p ?o .
filter (isBlank(?o))
  
  }
  group by ?p
  {code}
  and as a subject (if any)
  {code}
  select ?p (count(*)as ?cnt) {
  
?s ?p ?o .
filter (isBlank(?s))
  
  }
  group by ?p
  {code}

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Igorkim78
Cc: Smalyshev, Lucas_Werkmeister_WMDE, Igorkim78, dcausse, Aklapper, 
darthmon_wmde, DannyS712, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-12-02 Thread gerritbot
gerritbot added a comment.


  Change 553757 **merged** by jenkins-bot:
  [wikidata/query/rdf@master] Increase the max allowed query timeout
  
  https://gerrit.wikimedia.org/r/553757

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: gerritbot
Cc: Smalyshev, Lucas_Werkmeister_WMDE, Igorkim78, dcausse, Aklapper, Hook696, 
Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, Meekrab2012, 
joker88john, DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, 
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, 
Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-12-02 Thread dcausse
dcausse added a comment.


  In T239414#5702018 , 
@Lucas_Werkmeister_WMDE wrote:
  
  >> But in general, are these triples interesting in wdqs? Since they're never 
used as subject there are no way to use them directly, it seems the only thing 
that we can do is to display them (T173248 
).
  >
  > I’m not sure what you mean, to be honest… but they’re used in some useful 
queries, e. g. heads of state and government 

 (“end time” qualifier absent or unknown) or anonymous paintings 

 (unknown creator). You can find more by searching for `isBlank` on Wikidata 
project pages (most results use `!isBlank` to filter out blank nodes, but there 
are some non-negated uses too).
  
  Thanks for the links, I was not aware of these usecases. As to what I meant 
when saying that these triples are not interesting, I did not think that they 
could be used as filters like that, what I understand about blank nodes is that 
they are useful to link triples using a resource that cannot be named. In this 
case they do not link anything and we seem to just use the fact that they are 
"blank" to determine/filter something. Perhaps an approach similar to wdno 
would have worked here? Anyways, this is certainly not worthwhile reconsidering 
this at this point and I'm certainly lacking a lot of context as to why such 
decisions were made.
  
  Also I realize that this ticket is lacking some context, I will amend it to 
mention the reasons why are investigating bnodes.

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: dcausse
Cc: Smalyshev, Lucas_Werkmeister_WMDE, Igorkim78, dcausse, Aklapper, Hook696, 
Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, Meekrab2012, 
joker88john, DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, 
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, 
Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-11-29 Thread Smalyshev
Smalyshev added a comment.


  Blanks are used as representation of "unknown value" in Wikibase. Also, they 
are used (completely unrelatedly) in implementation of OWL class that describes 
"no value" properties (as "no value" is not a value, it is implemented with `a` 
predicate and a class instead of usual property predicate). 
  The class definition itself is useful only for the tools that actually 
understand OWL semantics. Most tools that query WDQS do not.

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Smalyshev
Cc: Smalyshev, Lucas_Werkmeister_WMDE, Igorkim78, dcausse, Aklapper, Hook696, 
Daryl-TTMG, RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, Meekrab2012, 
joker88john, DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, 
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, 
Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-11-29 Thread Lucas_Werkmeister_WMDE
Lucas_Werkmeister_WMDE added a comment.


  > But in general, are these triples interesting in wdqs? Since they're never 
used as subject there are no way to use them directly, it seems the only thing 
that we can do is to display them (T173248 
).
  
  I’m not sure what you mean, to be honest… but they’re used in some useful 
queries, e. g. heads of state and government 

 (“end time” qualifier absent or unknown) or anonymous paintings 

 (unknown creator). You can find more by searching for `isBlank` on Wikidata 
project pages (most results use `!isBlank` to filter out blank nodes, but there 
are some non-negated uses too).

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Lucas_Werkmeister_WMDE, Igorkim78, dcausse, Aklapper, Hook696, Daryl-TTMG, 
RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, Meekrab2012, 
joker88john, DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, 
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, 
Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Smalyshev, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-11-29 Thread Lucas_Werkmeister_WMDE
Lucas_Werkmeister_WMDE added a comment.


  >   select ?p (count(*)as ?cnt) {
  > ?s ?p ?o .
  > filter ((!isLiteral(?o))&&(!isUri(?o)))
  >   }
  >   group by ?p
  
  This can be simplified using `isBlank`, I believe:
  
SELECT ?p (COUNT(*) AS ?cnt) WHERE {
  ?s ?p ?o.
  FILTER(isBlank(?o))
}
GROUP BY ?p

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Lucas_Werkmeister_WMDE, Igorkim78, dcausse, Aklapper, Hook696, Daryl-TTMG, 
RomaAmorRoma, 0010318400, E.S.A-Sheild, darthmon_wmde, Meekrab2012, 
joker88john, DannyS712, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, 
Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, 
Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, 
Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, WSH1906, Lewizho99, 
Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Smalyshev, 
Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs


[Wikidata-bugs] [Maniphest] [Commented On] T239414: Investigate how blank nodes are used and synced between wikibase and wdqs

2019-11-29 Thread gerritbot
gerritbot added a comment.


  Change 553757 had a related patch set uploaded (by DCausse; owner: DCausse):
  [wikidata/query/rdf@master] Increase the max allowed query timeout
  
  https://gerrit.wikimedia.org/r/553757

TASK DETAIL
  https://phabricator.wikimedia.org/T239414

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: gerritbot
Cc: Igorkim78, dcausse, Aklapper, darthmon_wmde, DannyS712, Nandana, Lahi, 
Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, 
LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, 
Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs