Re: [Dbpedia-discussion] extract all properties in DBpedia
Hello Mitko,
i think it is Curran's test-query and aims all properties, and not
only dbpedia-onto prop's which are defined in the dataset, but anyway
i think we take it only as a test-query to understand how the engine
works, would i say... Baran.
-
On Fri, 27 May 2011 09:10:25 +0200, Mitko Iliev imi...@gmail.com wrote:
Hi All,
Why not simply use the dbpedia ontology to get properties?
something like ?p a DatatypeProperty etc.
Regards,
Mitko
On May 27, 2011, at 12:35 AM, baran_H wrote:
On Thu, 26 May 2011 22:09:02 +0200, Kingsley Idehen
kide...@openlinksw.com wrote:
On 5/26/11 3:36 PM, baran_H wrote:
LIMIT doesn't simply the Distinct computation. It simply limits the
resultset size.
Dear K. Idehen,
i see above baran_H wrote, but i never wrote such a comment, it has
nothing to do with my previous posting, also your reply below is
for me not a reply to my posting, in my posting i wrote an algorithm,
where you can see that for LIMIT 1 DISTINCT should NEVER REQUIRE
computation time as you mentioned in your previous posting to
the question
Without 'distinct' it does work:
select ?property where {
?s ?property ?o.
} limit 1
Why might this be?
with: 'Because Distinct requires more work.'
If it is 'really' so, than I cannot accept such a brutally
irrational thing whatever someone argues instead of saying:
'We will correct it.'
Dear K. Idehen, please see my previous posting with my algorithm
IF you want to answer my posting directly with correct citing, if
not, it doesn't matter, it is not very unusual in this list to have
a not answered posting...
Thanks, Baran.
---
LIMIT doesn't *simplify* the Distinct computation per se.. It simply
limits the
resultset size of the query.
Virtuoso is a Quad Store, so you have duplicate data across Named
Graphs. This is part of the evaluation cost. If you scope your query to
a specific Named Graph it has less to evaluate. Ultimately there's
always overhead. Even in the case of DBpedia, we do have some linksets
placed in their own Named Graphs i.e, distinct from the Graph IRI:
http://dbpedia.org .
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
___
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
___
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] extract all properties in DBpedia
On Tue, 24 May 2011 19:16:13 +0200, Kingsley Idehen
kide...@openlinksw.com wrote:
On 5/24/11 1:08 PM, Curran Kelleher wrote:
Greetings,
The problem remains, the following query doesn't execute on the public
DBPedia endpoint
http://dbpedia.org/snorql/?query=select+distinct+%3Fproperty+where+%7B%0D%0A+%3Fs+%3Fproperty+%3Fo.%0D%0A%7D+limit+1,
even with a limit:
select distinct ?property where {
?s ?property ?o.
} limit 1
Without 'distinct' it does work:
select ?property where {
?s ?property ?o.
} limit 1
Why might this be?
Because Distinct requires more work.
Shouldn't the engine be able to work this one out quickly even with
'distinct', as it needs to only traverse a single triple to compute
the result?
Really? First encounter != distinct :-)
It seems the engine is doing some unnecessary computation to do with
'distinct' and is timing out because of it.
LIMIT doesn't simply the Distinct computation. It simply limits the
resultset size.
Kingsley
-
Don't know much about history,
don't know much biology,
don't know much about people 'very experienced with DBMS oriented data'
but I do know SOMETIHING LIKE this:
here again the same with a small correction of my algorithm
for general case:
a.) read SPARQL query
b.) set limit:= {1, ..., MAX}
c.) set distinct:= {true, false}
d.) set i:=1
e.) compute result item i, if none, set i:=i-1 and break
f.) if distinct is true and comparing i'th item with
previous result-items results true, goto e.)
g.) store i'th item to result-set
h.) if i == limit, then break
i.) set i:= i+1
j.) GOTO e.)
k.) send the result-set to Baran
And here i am, thanks.
This is a general(!) algorithm with the rationality of a tramp,
if LIMIT is 1, for DISTINCT the engine should require nothing,
but.. i know, you mean rationality is not elitist enough...
Baran
--
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
___
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] extract all properties in DBpedia
On Thu, 26 May 2011 22:09:02 +0200, Kingsley Idehen
kide...@openlinksw.com wrote:
On 5/26/11 3:36 PM, baran_H wrote:
LIMIT doesn't simply the Distinct computation. It simply limits the
resultset size.
Dear K. Idehen,
i see above baran_H wrote, but i never wrote such a comment, it has
nothing to do with my previous posting, also your reply below is
for me not a reply to my posting, in my posting i wrote an algorithm,
where you can see that for LIMIT 1 DISTINCT should NEVER REQUIRE
computation time as you mentioned in your previous posting to
the question
Without 'distinct' it does work:
select ?property where {
?s ?property ?o.
} limit 1
Why might this be?
with: 'Because Distinct requires more work.'
If it is 'really' so, than I cannot accept such a brutally
irrational thing whatever someone argues instead of saying:
'We will correct it.'
Dear K. Idehen, please see my previous posting with my algorithm
IF you want to answer my posting directly with correct citing, if
not, it doesn't matter, it is not very unusual in this list to have
a not answered posting...
Thanks, Baran.
---
LIMIT doesn't *simplify* the Distinct computation per se.. It simply
limits the
resultset size of the query.
Virtuoso is a Quad Store, so you have duplicate data across Named
Graphs. This is part of the evaluation cost. If you scope your query to
a specific Named Graph it has less to evaluate. Ultimately there's
always overhead. Even in the case of DBpedia, we do have some linksets
placed in their own Named Graphs i.e, distinct from the Graph IRI:
http://dbpedia.org .
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
___
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] German version of 3.6 download files broken/truncated?
On Tue, 03 May 2011 17:24:59 +0200, Max Jakob max.ja...@fu-berlin.de wrote: Hi Baran, sorry to disappoint you, but we will not be able to update the public SPARQL end point before the next release. All I will be able to offer is full dump files for the German data. Are you interested in those dump files? Best, Max Hello Max, yes i am interested in full dump files for the German data, i think, Neubert is also interested, he started this thread. Thank you for your in-time info, Baran. -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] German version of 3.6 download files broken/truncated?
On Fri, 29 Apr 2011 16:55:24 +0200, Max Jakob max.ja...@fu-berlin.de wrote: Hi Baran, sorry for the delayed answer. Of course your observation is correct. Those files are truncated for a reason I cannot explain at the moment. But I can see to uploading complete versions early next week. Is that ok for you? Cheers, Max Hello Max, yes, that is ok, next week, we say from Wednesday on, i will begin checking online http://dbpedia.org/sparql with my app. And when i get again problems i will report on them here. Thank you very much, also to Neubert and Anja, their contribution to this issue was essential, Baran -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] German version of 3.6 download files broken/truncated?
Hello Dimitris, can this be the same problem which i formulated in my posting from 2011-03-24 09:14 Subject: 3.6: Many German abstracts have no German labels: http://sourceforge.net/mailarchive/forum.php?thread_name=op.vsubykmi2seko0%40user-pcforum_name=dbpedia-discussion and couldn't get any answer since one month?? thanks, Baran. - On Thu, 21 Apr 2011 15:48:46 +0200, Neubert Joachim j.neub...@zbw.eu wrote: Hi Dimitris, the issue is exactly the striking difference in size between http://downloads.dbpedia.org/3.5.1/de/labels_de.nt.bz 8.0M http://downloads.dbpedia.org/3.6/de/labels_de.nt.bz2 134K (similar for wikipedia_links.nt, and maybe other files, which I haven't checked). To me, this looks heavily broken ... If you are in charge of the DBpedia datasets, please take a closer look. Cheers, Joachim Von: Dimitris Kontokostas [mailto:jimk...@gmail.com] Gesendet: Donnerstag, 21. April 2011 15:18 An: Neubert Joachim Betreff: Re: [Dbpedia-discussion] German version of 3.6 download files broken/truncated? sorry ;) http://downloads.dbpedia.org/3.6/ cheers, dimitris -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] German version of 3.6 download files broken/truncated?
On Tue, 26 Apr 2011 12:20:17 +0200, Pablo Mendes pablomen...@gmail.com wrote: Hi Joachim, Baran, The page at http://de.dbpedia.org/ indicates that Sebastian Krebs ( sebastian.kr...@fu-berlin.de) may be a good person to ask. Cheers, Pablo Hello Pablo, I know you only want to help, but i must say all the time i intuitionally thought that this issue is a 'Kafkaesque' one. It is for me ok to remember Kafka's novell 'The Castle' in the context of LinkedData-Cloud-Center DBpedia, i will try to achieve Sebastian Krebs... thanks, Baran. -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] German version of 3.6 download files broken/truncated?
On Tue, 26 Apr 2011 14:59:45 +0200, Pablo Mendes pablomen...@gmail.com wrote: | It is for me ok to remember Kafka's novell 'The Castle' Sure. :) But I feel forced to point out that this is an open source extraction framework that you could download and run yourself. The guys that run dbpedia.org were nice enough to spend computer cycles, storage and bandwidth to extract and store a copy of the data for our convenience. So it would be a bit rude to make a reference to them as the system against which a man hopelessly fights. Hello Pablo, whether downloding and running it local or trying against http://dbpedia.org/sparql ...the german labels don't work on MOST CASES, this is the theme of this thread and the theme of my since one month not answered posting http://sourceforge.net/mailarchive/forum.php?thread_name=op.vsubykmi2seko0%40user-pcforum_name=dbpedia-discussion Nobody fights against the system, K. also didn't it, K. tried to make the system work for his interests, and so we try it. But you say, i must first find Sebastian Krebs, well, ok, i will try it, whatewer it means... thanks, Baran. -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
Re: [Dbpedia-discussion] (no subject)
On Tue, 29 Mar 2011 17:49:47 +0200, Tania Farinella tanyatanya2...@hotmail.com wrote: given a dbpedia resource corresponding to a page of the english wikipedia , is it possible to retrieve the corresponding wikipedia page in an other language? Once i had also this problem and i couldn't find a way to retrieve directly the corresponding wikipedia page in an other language. But in your program you can construct it if you can get from the dbpedia resource the rdfs:label in your language, where you have to replace space with '_' and eventually other special chars with ESCAPED ONES. For example in German: from a rdfs:label - 'Semantisches Web' you make 'Semantisches_Web' and append it to http://de.wikipedia.org/wiki/ and get http://de.wikipedia.org/wiki/Semantisches_Web For me this has worked... Baran -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar ___ Dbpedia-discussion mailing list Dbpedia-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
[Dbpedia-discussion] 3.6: Many German abstracts have no German labels
Hello,
this is new in 3.6 querying
http://dbpedia/org/sparql
For lots of resources i miss the German label though there is a
German abstract. In previous versions those cases were minority.
But now in 3.6 most resources with a German abstract have no
German label and those with regular German label for the existing
German abstract are in minority.
A Test case as an example:
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
PREFIX dbpo: http://dbpedia.org/ontology/
PREFIX dbp: http://dbpedia.org/resource/
SELECT ?p ?y WHERE
{
dbp:Instability dbpo:abstract ?p .
FILTER (lang(?p) = 'de')
OPTIONAL {dbp:Instability rdfs:label ?y .
FILTER (lang(?y) = 'de')}
}
or some URI-examples of such resources:
-
http://dbpedia.org/resource/Instability
http://dbpedia.org/resource/Folksonomy
http://dbpedia.org/resource/Bang%E2%80%93bang_control
http://dbpedia.org/resource/Optimal_control
http://dbpedia.org/resource/RDF_Schema
http://dbpedia.org/resource/DNA_barcoding
http://dbpedia.org/resource/Simple_Knowledge_Organization_System
http://dbpedia.org/resource/Body_plan
http://dbpedia.org/resource/Identification_key
So an app which queries beside English labels also German labels
cannot run in most cases correctly any more...
Baran.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar
___
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
[Dbpedia-discussion] Test with DISTINCT and ORDER BY
Hello,
when i put the query
PREFIX dbpc: http://dbpedia.org/resource/Category:
PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
PREFIX skos: http://www.w3.org/2004/02/skos/core#
SELECT DISTINCT ?y
WHERE { ?x skos:broader dbpc:Logic .
?x rdfs:label ?y .
FILTER (lang(?y) = en) .
}
ORDER BY ?y
-
into
http://dbpedia.org/sparql
ORDER BY is ignored. (OpenLink Virtuoso version 06.02.3128)
To get the the result in expected order i have to remove DISTINCT.
Baran.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev
___
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
