date:20161106

Re: [DBpedia-discussion] Where is there a SCHEMA DIAGRAM and description of the database that I can access via SQL?

2016-11-06 Thread Paul Houle

I know.

But really,  SPARQL is not too different from SQL,  it's based on
the same math.  SPARQL query result sets are almost indistinguisable
from SQL result sets so you can take your whole bag of tricks from
SQL to SPARQL.

Any SQL <-> SPARQL translation runs into issues with cardinalities,
that is,  SQL aligns a single set of values for various properties
across a row,  so you have something like

[
:personId 8831 ;
:dateOfBirth "1972-04-24"^^xsd:date ;
:firstName "Sachin" ;
:lastName "Tendulkar" ;
]

and for many properties the 1-1 association makes sense,  but RDF
standards do not enforce it.  There might be multiple claims about any
of these things,   or maybe somebody changed their ::lastName from
"Lieber" to "Lee",  or their :gender from :Female to :Male,  whatever.

Then there are properties that are definitely multi-valued such as
:wroteBook,  :hadParent,  etc.

All of that can be modeled in SQL but the process of going from SPARQL
to SQL could be lossy if you don't take the time to deal with all the
problems that present themselves.  (Or unless you do some trivial
mapping such as as creating s,p,o columns)

With SPARQL you can get the original data with complete fidelity
without thinking about how the conversion works out.  People who are
comfortable with SQL might find that learning SPARQL is a shorter path
to getting the results they want.  (For one thing,  you can explore
with the public endpoint)

--
  Paul Houle
  paul.ho...@ontology2.com



On Sun, Nov 6, 2016, at 06:15 PM, Kingsley Idehen wrote:
> On 11/6/16 4:46 PM, Paul Houle wrote:
>> Also if you are interested in the schema it is easy to query it in
>> SPARQL.  These queries generally don't work the triple server hard so
>> they work just fine against the public SPARQL endpoint:
>>
>> http://dbpedia.org/sparql
>>
>> For instance,  this query will give you the types ordered by how many
>> occurences there are of the types:
>>
>> select ?p ?o {
>> ?p ?o .
>> }
>>
>> gives you all the statements where the type appears on the left and
>>
>> select ?s ?p {
>>?s ?p  .
>>FILTER(?p!=rdf:type)
>> }
>>
>> gives you all the statements on where the type appears on the right,
>> omitting statements of the form "?x a ?type."
>>
>> Diagraming the schema looks like a fun project,  but the raw material
>> to analyze the schema is all there.  Note most of the
>> predicates used for schema purposes are defined in
>>
>> https://www.w3.org/TR/rdf-schema/
>>
>>
>>
>> --
>>   Paul Houle
>>   paul.ho...@ontology2.com
>
> I was responding to a "where is the SQL comment".  Producing an
> Ontology or RDF Schema dump is achievable via SPARQL, that's how I
> actually generated the DBpedia ontology from instance data, initially.
>
>  As for the Schema question, in regards to RDF, its First-order logic.
>  Basically, that thing are related to other things, in a variety of
>  ways. All of that represented as a collection of RDF statements :)
>
>  Kingsley
>
>>
>>
>>
>> On Sat, Nov 5, 2016, at 09:21 PM, Kingsley Idehen wrote:
>>> On 11/4/16 4:06 PM, Alan Scotch wrote:
 Where is there a SCHEMA DIAGRAM and description of the database
 that I can access via SQL?
 Alan
>>>
>>> The SQL schema for Virtuoso is basically a Table ( RDF_QUAD) with
>>> the columns, S,P,O,G. You can query the same data using SPARQL or
>>> SQL, demonstrating the fact that SPARQL can be used to extend SQL,
>>> while SQL can be used to write an RDF application that scales
>>> massively etc..
>>>
>>> SELECT o,g
>>> FROM (SPARQL SELECT DISTINCT ?g ?o WHERE {GRAPH ?g {?s a ?o}})
>>> AS RDF ;
>>>
>>> Live example link, using a different Virtuoso instance:
>>> http://demo.openlinksw.com/spasqlqb/spasqlqb.html?permlink_e=%7B%22v%22%3A1%2C%22url%22%3A%22/XMLA%22%2C%22dsn%22%3A%22DSN%3DLocal_Instance%22%2C%22uid%22%3A%22%22%2C%22pwd%22%3A%22%22%2C%22path%22%3Anull%2C%22tab%22%3A%22exec%22%2C%22idx%22%3Anull%2C%22fkey%22%3Anull%2C%22ref%22%3Anull%2C%22exec%22%3A%7B%22sql%22%3A%22%5CnSELECT%20o%2Cg%5CnFROM%20%28SPARQL%20SELECT%20DISTINCT%20%3Fg%20%3Fo%20WHERE%20%7BGRAPH%20%3Fg%20%7B%3Fs%20a%20%3Fo%7D%7D%29%20AS%20RDF%22%7D%7D
>>>
>>> Log in as user "vdb" and pwd "vdb" .
>>>
>>> That will produce a list of all named graphs and objects of an
>>> rdf:type relation in a Virtuoso RDBMS , for instance.
>>>
>>> To answer your question: the restrictions of a conventional SQL
>>> schema have no real bearing when relations are represented as RDF-
>>> Language sentences rather than Records in a Table :)
>>>
>>> Kingsley
>>>

 **From:** Kingsley Idehen  **To:**
 baran...@gmail.com; dbpedia-discussion@lists.sourceforge.net
 **Sent:** Friday, November 4, 2016 12:39 PM **Subject:** Re: [DBpedia-
 discussion] Introducing the Ontology2 Edition of DBpedia 2016-04



 On 11/4/16 1:38 PM, baran...@gmail.com wrote:
>
>> I am saying:
>>
>>  A

Re: [DBpedia-discussion] Where is there a SCHEMA DIAGRAM and description of the database that I can access via SQL?

2016-11-06 Thread Kingsley Idehen

On 11/6/16 4:46 PM, Paul Houle wrote:
> Also if you are interested in the schema it is easy to query it in
> SPARQL.  These queries generally don't work the triple server hard so
> they work just fine against the public SPARQL endpoint:
>
> http://dbpedia.org/sparql
>
> For instance,  this query will give you the types ordered by how many
> occurences there are of the types:
>
> select ?p ?o {
> ?p ?o .
> }
>
> gives you all the statements where the type appears on the left and
>
> select ?s ?p {
>?s ?p  .
>FILTER(?p!=rdf:type)
> }
>
> gives you all the statements on where the type appears on the right,
>  omitting statements of the form "?x a ?type."
>
> Diagraming the schema looks like a fun project,  but the raw material
> to analyze the schema is all there.  Note most of the
> predicates used for schema purposes are defined in
>
> https://www.w3.org/TR/rdf-schema/
>
>
>
> --
>   Paul Houle
>   paul.ho...@ontology2.com

I was responding to a "where is the SQL comment".  Producing an Ontology
or RDF Schema dump is achievable via SPARQL, that's how I actually
generated the DBpedia ontology from instance data, initially.

As for the Schema question, in regards to RDF, its First-order logic.
Basically, that thing are related to other things, in a variety of ways.
All of that represented as a collection of RDF statements :)

Kingsley
>
>
>
> On Sat, Nov 5, 2016, at 09:21 PM, Kingsley Idehen wrote:
>> On 11/4/16 4:06 PM, Alan Scotch wrote:
>>> Where is there a SCHEMA DIAGRAM and description of the database that
>>> I can access via SQL?
>>> Alan
>>
>> The SQL schema for Virtuoso is basically a Table ( RDF_QUAD) with the
>> columns, S,P,O,G. You can query the same data using SPARQL or SQL,
>> demonstrating the fact that SPARQL can be used to extend SQL, while
>> SQL can be used to write an RDF application that scales massively etc..
>>
>> SELECT o,g
>> FROM (SPARQL SELECT DISTINCT ?g ?o WHERE {GRAPH ?g {?s a ?o}}) AS RDF ;
>>
>> Live example link, using a different Virtuoso instance:
>> http://demo.openlinksw.com/spasqlqb/spasqlqb.html?permlink_e=%7B%22v%22%3A1%2C%22url%22%3A%22/XMLA%22%2C%22dsn%22%3A%22DSN%3DLocal_Instance%22%2C%22uid%22%3A%22%22%2C%22pwd%22%3A%22%22%2C%22path%22%3Anull%2C%22tab%22%3A%22exec%22%2C%22idx%22%3Anull%2C%22fkey%22%3Anull%2C%22ref%22%3Anull%2C%22exec%22%3A%7B%22sql%22%3A%22%5CnSELECT%20o%2Cg%5CnFROM%20%28SPARQL%20SELECT%20DISTINCT%20%3Fg%20%3Fo%20WHERE%20%7BGRAPH%20%3Fg%20%7B%3Fs%20a%20%3Fo%7D%7D%29%20AS%20RDF%22%7D%7D
>>
>> Log in as user "vdb" and pwd "vdb" .
>>
>> That will produce a list of all named graphs and objects of an
>> rdf:type relation in a Virtuoso RDBMS , for instance.
>>
>> To answer your question: the restrictions of a conventional SQL
>> schema have no real bearing when relations are represented as
>> RDF-Language sentences rather than Records in a Table :)
>>
>> Kingsley
>>
>>>
>>> 
>>> **From:** Kingsley Idehen 
>>> 
>>> **To:** baran...@gmail.com ;
>>> dbpedia-discussion@lists.sourceforge.net
>>> 
>>> **Sent:** Friday, November 4, 2016 12:39 PM
>>> **Subject:** Re: [DBpedia-discussion] Introducing the Ontology2
>>> Edition of DBpedia 2016-04
>>>
>>>
>>>
>>> On 11/4/16 1:38 PM, baran...@gmail.com 
>>> wrote:

> I am saying:
>
> A personal or service-specific instance of DBpedia has less
> traffic and
> less volatile query mix. Once is serving the world the other a
> specific
> client application / service. 

 So, you say Pauls offering has nothing to do with a
 dbpedia-SPARQL-endpoint serving the world, its aim is serving 'a
 specific client application'.

 Although, it semms to be 'NICE'...

 I register this as yor your opinion to my origin posting to Paul...

 Thanks, baran

>>>
>>> Paul has a Virtuoso instance configured and deployed via an Amazon
>>> AMI in the AWS Cloud. Like the DBpedia SPARQL endpoint,***when the
>>> Virtuoso RDBMS is up and running you can query data via *SPARQL
>>> and/or*SQL. *
>>> You have a Virtuoso instance in an AMI vs a public Virtuoso instance
>>> that both provide access to the same DBpedia dataset.  Naturally,
>>> you could open up access to the public using the AMI variant too
>>> (and deal with the bill+++) .
>>>
>>> -- Regards, Kingsley Idehen Founder & CEO OpenLink Software (Home
>>> Page: http://www.openlinksw.com )
>>> Weblogs (Blogs): Legacy Blog:
>>> http://www.openlinksw.com/blog/~kidehen/
>>>  Blogspot Blog:
>>> http://kidehen.blogspot.com  Medium
>>> Blog: https://medium.com/@kidehen Profile Pages: Pinterest:
>>>

Re: [DBpedia-discussion] Where is there a SCHEMA DIAGRAM and description of the database that I can access via SQL?

2016-11-06 Thread Paul Houle

Also if you are interested in the schema it is easy to query it in
SPARQL.  These queries generally don't work the triple server hard so
they work just fine against the public SPARQL endpoint:

http://dbpedia.org/sparql

For instance,  this query will give you the types ordered by how many
occurences there are of the types:

select ?p ?o {
    ?p ?o .
}

gives you all the statements where the type appears on the left and

select ?s ?p {
   ?s ?p  .
   FILTER(?p!=rdf:type)
}

gives you all the statements on where the type appears on the right,
omitting statements of the form "?x a ?type."

Diagraming the schema looks like a fun project,  but the raw material to
analyze the schema is all there.  Note most of the
predicates used for schema purposes are defined in

https://www.w3.org/TR/rdf-schema/



--
  Paul Houle
  paul.ho...@ontology2.com



On Sat, Nov 5, 2016, at 09:21 PM, Kingsley Idehen wrote:
> On 11/4/16 4:06 PM, Alan Scotch wrote:
>> Where is there a SCHEMA DIAGRAM and description of the database that
>> I can access via SQL?
>> Alan
>
> The SQL schema for Virtuoso is basically a Table ( RDF_QUAD) with
> the columns, S,P,O,G. You can query the same data using SPARQL or
> SQL, demonstrating the fact that SPARQL can be used to extend SQL,
> while SQL can be used to write an RDF application that scales
> massively etc..
>
>  SELECT o,g
>  FROM (SPARQL SELECT DISTINCT ?g ?o WHERE {GRAPH ?g {?s a ?o}})
>  AS RDF ;
>
>  Live example link, using a different Virtuoso instance:
> http://demo.openlinksw.com/spasqlqb/spasqlqb.html?permlink_e=%7B%22v%22%3A1%2C%22url%22%3A%22/XMLA%22%2C%22dsn%22%3A%22DSN%3DLocal_Instance%22%2C%22uid%22%3A%22%22%2C%22pwd%22%3A%22%22%2C%22path%22%3Anull%2C%22tab%22%3A%22exec%22%2C%22idx%22%3Anull%2C%22fkey%22%3Anull%2C%22ref%22%3Anull%2C%22exec%22%3A%7B%22sql%22%3A%22%5CnSELECT%20o%2Cg%5CnFROM%20%28SPARQL%20SELECT%20DISTINCT%20%3Fg%20%3Fo%20WHERE%20%7BGRAPH%20%3Fg%20%7B%3Fs%20a%20%3Fo%7D%7D%29%20AS%20RDF%22%7D%7D
>
>  Log in as user "vdb" and pwd "vdb" .
>
>  That will produce a list of all named graphs and objects of an
>  rdf:type relation in a Virtuoso RDBMS , for instance.
>
>  To answer your question: the restrictions of a conventional SQL
>  schema have no real bearing when relations are represented as RDF-
>  Language sentences rather than Records in a Table :)
>
>  Kingsley
>
>>
>> **From:** Kingsley Idehen  **To:**
>> baran...@gmail.com; dbpedia-discussion@lists.sourceforge.net
>> **Sent:** Friday, November 4, 2016 12:39 PM **Subject:** Re: [DBpedia-
>> discussion] Introducing the Ontology2 Edition of DBpedia 2016-04
>>
>>
>>
>> On 11/4/16 1:38 PM, baran...@gmail.com wrote:
>>>
 I am saying:

  A personal or service-specific instance of DBpedia has less
  traffic and less volatile query mix. Once is serving the world the
  other a specific client application / service.
>>>
>>> So, you say Pauls offering has nothing to do with a dbpedia-SPARQL-
>>> endpoint serving the world, its aim is serving 'a specific client
>>> application'.
>>>
>>>  Although, it semms to be 'NICE'...
>>>
>>>  I register this as yor your opinion to my origin posting to Paul...
>>>
>>>  Thanks, baran
>>>
>>
>> Paul has a Virtuoso instance configured and deployed via an Amazon
>> AMI in the AWS Cloud. Like the DBpedia SPARQL endpoint,* **when the
>> Virtuoso RDBMS is up and running you can query data via *SPARQL
>> and/or* SQL. *
>> You have a Virtuoso instance in an AMI vs a public Virtuoso instance
>> that both provide access to the same DBpedia dataset.  Naturally, you
>> could open up access to the public using the AMI variant too (and
>> deal with the bill+++) .
>>
>> -- Regards,  Kingsley Idehen  Founder & CEO OpenLink Software   (Home
>> Page: http://www.openlinksw.com[1])  Weblogs (Blogs): Legacy Blog:
>> http://www.openlinksw.com/blog/~kidehen/[2] Blogspot Blog:
>> http://kidehen.blogspot.com[3] Medium Blog:
>> https://medium.com/@kidehen  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/dataspace/person/kidehen#this :
>> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
>>
>>

>>
>>
>>
>>
>> -
>> -
>>  Developer Access Program for Intel Xeon Phi Processors Access to
>>  Intel Xeon Phi processor-based developer platforms. With one year of
>>  Intel Parallel Studio XE. Training and support from Colfax. Order
>>  your platform today. http://sdm.link/xeonphi
>>
>> ___
>>  DBpedia-discussion mailing list DBpedia-
>>  discuss...@lists.sourceforge.net
>>

Re: [DBpedia-discussion] [Dbpedia-discussion] DBpedia as Tables release

2016-11-06 Thread Tom Morris

Perhaps here:
https://github.com/dbpedia/dbpedia/tree/master/tools/DBpediaAsTables

On Sun, Nov 6, 2016 at 10:24 AM, Dimitris Kontokostas 
wrote:

> Hi Petar,
>
> There is some interest to revive this project and cannot recall / find
> where is the code to generate these dumps.
> Will you be able to help us re-bootstrap this?
> We can create a standalone github repo and we will try to find a new
> maintainer
>
> Cheers,
> Dimtiris
>
> On Fri, Dec 13, 2013 at 2:07 AM, Petar Ristoski <
> petar.risto...@informatik.uni-mannheim.de> wrote:
>
>> Hi Pablo,
>>
>>
>>
>> I set up a web page [1] where all classes from the DBpedia ontology are
>> available for download as separate .csv and .json files.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Petar
>>
>>
>>
>> [1] http://web.informatik.uni-mannheim.de/DBpediaAsTables/DBpedi
>> aClasses.htm
>>
>>
>>
>>
>>
>> *From:* Pablo N. Mendes [mailto:pablomen...@gmail.com]
>> *Sent:* Thursday, December 12, 2013 4:44 PM
>> *To:* Petar Ristoski
>> *Cc:* ibu ☉ radempa ䷰; dbpedia-discussion@lists.sourceforge.net
>>
>> *Subject:* Re: [Dbpedia-discussion] DBpedia as Tables release
>>
>>
>>
>>
>>
>> Hi Petar,
>>
>> Thanks for sharing this! Tried to use it yesterday, but 3GB still takes
>> quite a long time to download if you're just hacking something together
>> from a Starbucks. >From the standpoint of practicality, this would be
>> infinitely more useful if we could download files individually, or at least
>> in smaller chunks.
>>
>>
>>
>> Any chance we'll get something like that shared from [1]?
>>
>>
>>
>> Cheers,
>>
>> Pablo
>>
>>
>>
>> [1] http://wiki.dbpedia.org/DBpediaAsTables
>>
>>
>>
>> On Thu, Nov 28, 2013 at 5:35 AM, Petar Ristoski <
>> petar.risto...@informatik.uni-mannheim.de> wrote:
>>
>> Hi Ibu,
>>
>> Thank you for your feedback.
>>
>> To simplify the parsing of the files, from all literals I removed the
>> following characters: "\" { } | , \n". If there are quotes in the URIs,
>> they are escaped as '""'. Also, there is no URI that starts with"{" and
>> ends with "}", so there is no need to escape "{ } |" inside the URIs.
>>
>> I apologize for those two incorrectly parsed files. I fixed them couple
>> of days ago, so please download them again.
>>
>> Regards,
>>
>> Petar
>>
>>
>> -Original Message-
>> From: ibu ☉ radempa ䷰ [mailto:i...@radempa.de]
>> Sent: Wednesday, November 27, 2013 10:00 PM
>> To: dbpedia-discussion@lists.sourceforge.net
>> Subject: Re: [Dbpedia-discussion] DBpedia as Tables release
>>
>> On 11/25/2013 02:18 PM, Petar Ristoski wrote:
>> > We are happy to announce the first version of the DBpedia as Tables
>> > tool [1].
>>
>> > Any feedback is welcome!
>>
>> > [1] http://wiki.dbpedia.org/DBpediaAsTables
>>
>> Thanks Petar,
>>
>> your CSV files are really helpful.
>>
>> For all who want to import data into Postgresql, I've written a python
>> script which automatically creates the SQL corresponding to the CSV:
>>
>> https://gitorious.org/dbpedia_csv2sql/dbpedia_csv2sql
>>
>> The column types (ofter arrays) are inferred from your headers and the
>> data rows; indexes are also created.
>>
>> (If people here find this script useful, I could also package it for pypi
>> and improve documentation a bit.)
>>
>> I was assuming that your files are encoded in UTF-8, which worked, but I
>> didn't find either a '""' or a '\"' inside a field value, so I don't know
>> how a '"' would be encoded, if there were one. Also for a multi-value field
>> (e.g. '{1|2|3}') I don't know how '{', '|' and '}' are encoded, if they
>> appear within one of the values. - Maybe you could add some documentation
>> on that.
>>
>> In your data I found 2 format problems (I don't think my download went
>> wrong, but anyway, a checksum might be helpful):
>>
>> * Film.csv seems to have no headers (it has 20004 lines for me).
>> * Aircraft.csv: the 2nd last row (
>> "http://dbpedia.org/resource/Marinens_Flyvebaatfabrikk_M.F.10;
>> ) has too many columns.
>>
>> All other files (except owl#Thing.csv and Agent.csv, which I didn't check
>> due to size and column number) were ok.
>>
>> I also noticed another thing, not concerning your tool, where some parser
>> maybe could be optimized:
>> http://dbpedia.org/resource/Americas
>> has language="American (but see [[#English usage"
>>
>> Regards,
>> ibu
>>
>> 
>> --
>> Rapidly troubleshoot problems before they affect your business. Most IT
>> organizations don't have a clear picture of how application performance
>> affects their revenue. With AppDynamics, you get 100% visibility into your
>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
>> Pro!
>> http://pubads.g.doubleclick.net/gampad/clk?id=84349351=/
>> 4140/ostg.clktrk
>> ___
>> Dbpedia-discussion mailing list
>> Dbpedia-discussion@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>
>>
>>
>>

Re: [DBpedia-discussion] [Dbpedia-discussion] DBpedia as Tables release

2016-11-06 Thread Dimitris Kontokostas

Hi Petar,

There is some interest to revive this project and cannot recall / find
where is the code to generate these dumps.
Will you be able to help us re-bootstrap this?
We can create a standalone github repo and we will try to find a new
maintainer

Cheers,
Dimtiris

On Fri, Dec 13, 2013 at 2:07 AM, Petar Ristoski <
petar.risto...@informatik.uni-mannheim.de> wrote:

> Hi Pablo,
>
>
>
> I set up a web page [1] where all classes from the DBpedia ontology are
> available for download as separate .csv and .json files.
>
>
>
> Regards,
>
>
>
> Petar
>
>
>
> [1] http://web.informatik.uni-mannheim.de/DBpediaAsTables/
> DBpediaClasses.htm
>
>
>
>
>
> *From:* Pablo N. Mendes [mailto:pablomen...@gmail.com]
> *Sent:* Thursday, December 12, 2013 4:44 PM
> *To:* Petar Ristoski
> *Cc:* ibu ☉ radempa ䷰; dbpedia-discussion@lists.sourceforge.net
>
> *Subject:* Re: [Dbpedia-discussion] DBpedia as Tables release
>
>
>
>
>
> Hi Petar,
>
> Thanks for sharing this! Tried to use it yesterday, but 3GB still takes
> quite a long time to download if you're just hacking something together
> from a Starbucks. >From the standpoint of practicality, this would be
> infinitely more useful if we could download files individually, or at least
> in smaller chunks.
>
>
>
> Any chance we'll get something like that shared from [1]?
>
>
>
> Cheers,
>
> Pablo
>
>
>
> [1] http://wiki.dbpedia.org/DBpediaAsTables
>
>
>
> On Thu, Nov 28, 2013 at 5:35 AM, Petar Ristoski <
> petar.risto...@informatik.uni-mannheim.de> wrote:
>
> Hi Ibu,
>
> Thank you for your feedback.
>
> To simplify the parsing of the files, from all literals I removed the
> following characters: "\" { } | , \n". If there are quotes in the URIs,
> they are escaped as '""'. Also, there is no URI that starts with"{" and
> ends with "}", so there is no need to escape "{ } |" inside the URIs.
>
> I apologize for those two incorrectly parsed files. I fixed them couple of
> days ago, so please download them again.
>
> Regards,
>
> Petar
>
>
> -Original Message-
> From: ibu ☉ radempa ䷰ [mailto:i...@radempa.de]
> Sent: Wednesday, November 27, 2013 10:00 PM
> To: dbpedia-discussion@lists.sourceforge.net
> Subject: Re: [Dbpedia-discussion] DBpedia as Tables release
>
> On 11/25/2013 02:18 PM, Petar Ristoski wrote:
> > We are happy to announce the first version of the DBpedia as Tables
> > tool [1].
>
> > Any feedback is welcome!
>
> > [1] http://wiki.dbpedia.org/DBpediaAsTables
>
> Thanks Petar,
>
> your CSV files are really helpful.
>
> For all who want to import data into Postgresql, I've written a python
> script which automatically creates the SQL corresponding to the CSV:
>
> https://gitorious.org/dbpedia_csv2sql/dbpedia_csv2sql
>
> The column types (ofter arrays) are inferred from your headers and the
> data rows; indexes are also created.
>
> (If people here find this script useful, I could also package it for pypi
> and improve documentation a bit.)
>
> I was assuming that your files are encoded in UTF-8, which worked, but I
> didn't find either a '""' or a '\"' inside a field value, so I don't know
> how a '"' would be encoded, if there were one. Also for a multi-value field
> (e.g. '{1|2|3}') I don't know how '{', '|' and '}' are encoded, if they
> appear within one of the values. - Maybe you could add some documentation
> on that.
>
> In your data I found 2 format problems (I don't think my download went
> wrong, but anyway, a checksum might be helpful):
>
> * Film.csv seems to have no headers (it has 20004 lines for me).
> * Aircraft.csv: the 2nd last row (
> "http://dbpedia.org/resource/Marinens_Flyvebaatfabrikk_M.F.10;
> ) has too many columns.
>
> All other files (except owl#Thing.csv and Agent.csv, which I didn't check
> due to size and column number) were ok.
>
> I also noticed another thing, not concerning your tool, where some parser
> maybe could be optimized:
> http://dbpedia.org/resource/Americas
> has language="American (but see [[#English usage"
>
> Regards,
> ibu
>
> 
> --
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351=
> /4140/ostg.clktrk
> ___
> Dbpedia-discussion mailing list
> Dbpedia-discussion@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>
>
>
> 
> --
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application.

Re: [DBpedia-discussion] Where is there a SCHEMA DIAGRAM and description of the database that I can access via SQL?

Re: [DBpedia-discussion] Where is there a SCHEMA DIAGRAM and description of the database that I can access via SQL?

Re: [DBpedia-discussion] Where is there a SCHEMA DIAGRAM and description of the database that I can access via SQL?

Re: [DBpedia-discussion] [Dbpedia-discussion] DBpedia as Tables release

Re: [DBpedia-discussion] [Dbpedia-discussion] DBpedia as Tables release

5 matches

Site Navigation

Mail list logo

Footer information