CSV to RDF converter

2012-12-12 Thread Ying Ding
Hi, I am looking for a open source software to convert csv file to RDF based on one pre-defined ontology. Also, this converter should support complicated SQL queries (e.g., Group BY query and IF/THEN/ELSE query) while defining the mapping between csv to our pre-defined ontology. thanks ying

Re: CSV to RDF converter

2012-12-12 Thread Davide Palmisano
Dear Ying, maybe this could help[1]. all the best [1] http://any23.apache.org/ On Wed, Dec 12, 2012 at 9:08 PM, Ying Ding wrote: > Hi, > > I am looking for a open source software to convert csv file to RDF based on > one pre-defined ontology. Also, this converter should support complicated > S

Re: CSV to RDF converter

2012-12-12 Thread Barry Norton
Ying, this might sound like a stupid question, but if you want SQL features why not pull your CSV into a relational DB table then R2RML it into RDF (since mappings will allow you arbitrary SQL)? Barry On 12/12/2012 21:08, Ying Ding wrote: Hi, I am looking for a open source software to co

Re: CSV to RDF converter

2012-12-12 Thread Kingsley Idehen
On 12/12/12 4:15 PM, Barry Norton wrote: Ying, this might sound like a stupid question, but if you want SQL features why not pull your CSV into a relational DB table then R2RML it into RDF (since mappings will allow you arbitrary SQL)? +1 Links: 1. http://www.w3.org/TR/r2rml/ 2. http://ww

Re: CSV to RDF converter

2012-12-12 Thread Michael Lang Jr.
Hi Ying, We make a tool called Spyder, which is not open-source, but is free - http://www.revelytix.com/content/spyder. It will let you use R2RML over a CVS file directly to convert to RDF (or query with SPARQL without converting). Mike phone: 410-584-0009 (office) 443-928-3782 (cell

Re: CSV to RDF converter

2012-12-12 Thread Sergio Fernández
in case you are actually asking about CSV files (sorry, but what you said about SQL queries confuses me), you should take a look to Tabels, by CTIC: http://idi.fundacionctic.org/tabels On 12.12.2012 22:08, Ying Ding wrote: Hi, I am looking for a open source software to convert csv file to RD

Re: CSV to RDF converter

2012-12-12 Thread Martynas Jusevičius
Hey Ying, why don't you just convert CSV to "raw" RDF and then do the mapping, using SPARQL 1.1? Google Refine with RDF extension should be enough to do the first step: http://code.google.com/p/google-refine/ http://refine.deri.ie Martynas graphity.org On Wed, Dec 12, 2012 at 11:08 PM, Ying Di

Re: CSV to RDF converter

2012-12-12 Thread Sergio Fernández
also OpenRefine (formerly Google Refine): http://github.com/OpenRefine/OpenRefine/wiki On 12.12.2012 22:47, Sergio Fernández wrote: in case you are actually asking about CSV files (sorry, but what you said about SQL queries confuses me), you should take a look to Tabels, by CTIC: http://idi.

Re: CSV to RDF converter

2012-12-12 Thread Boris Villazon-Terrazas
On 12/12/2012 22:31, Kingsley Idehen wrote: On 12/12/12 4:15 PM, Barry Norton wrote: Ying, this might sound like a stupid question, but if you want SQL features why not pull your CSV into a relational DB table then R2RML it into RDF (since mappings will allow you arbitrary SQL)? +1 +1 The

Re: CSV to RDF converter

2012-12-12 Thread Boris Villazon-Terrazas
You can also pull your CSV into a spreadsheet and work with NOR2O [1] Moreover, you can find a more complete list here [2] Boris [1] http://oeg-dev.dia.fi.upm.es/nor2o/ [2] http://www.w3.org/wiki/ConverterToRdf On 12/12/2012 22:52, Sergio Fernández wrote: also OpenRefine (formerly Google Refine

Re: CSV to RDF converter

2012-12-12 Thread Giovanni Tummarello
As Davide points, any23 converts CSV to RDF in a rather concise and useful way. (naive conversions will involve way too mnay triples making it very inefficient) best of luck. you are 1 java call away from loading it into your favorite triple store. Gio On Wed, Dec 12, 2012 at 9:13 PM, Davide Pal

Re: CSV to RDF converter

2012-12-12 Thread Hideaki Takeda
Dear Ying, Another option is http://linkdata.org/ It is a kind of converter just like drag and drop way Yours, Hideaki On Thu, 13 Dec 2012 00:00:13 + Giovanni Tummarello wrote: > As Davide points, any23 converts CSV to RDF in a rather concise and > useful way. (naive conversions will invol

Re: CSV to RDF converter

2012-12-12 Thread Hugh Williams
Hi Ying, Note Virtuoso can be use to map CSV files to SQL either by bulk loading if there are many files as detailed at: http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtCsvFileBulkLoader or via the Virtuoso Conductor from the “Database -> Import” tab if you only have a single or

Re: CSV to RDF converter

2012-12-13 Thread Boris Villazon-Terrazas
Moreover, this in line with our paper Data Shapes and data transformations [1] [2] Best, Boris [1] http://www.slideshare.net/boricles/data-shapes-and-data-transformations [2] http://arxiv.org/abs/1211.1565 On 12/12/2012 22:15, Barry Norton wrote: Ying, this might sound like a stupid questio

Re: CSV to RDF converter

2012-12-13 Thread François Scharffe
Also in ths category you can use Datalift to do naive CSV to RDF and then SPARQL CONSTRUCT. Also provide a simple GUI to generate part of the CONSTRUCT queries. http://datalift.org/ Le 12/12/12 22:50, Martynas Jusevičius a écrit : Hey Ying, why don't you just convert CSV to "raw" RDF and then

Re: CSV to RDF converter

2012-12-13 Thread Christophe Guéret
Hi Ying, I'd like to add to the list these two softwares: * Karma: http://www.isi.edu/integration/karma/ * VIVO Harvester: http://vivo-project.github.com/ They both can import data from either CSV files or relational data bases. We used them to convert some data to RDF expressed using the VIVO on

Re: CSV to RDF converter

2012-12-13 Thread Ivan Ermilov
On 12/12/2012 10:08 PM, Ying Ding wrote: I am looking for a open source software to convert csv file to RDF based on one pre-defined ontology. Also, this converter should support complicated SQL queries (e.g., Group BY query and IF/THEN/ELSE query) while defining the mapping between csv to our

Re: CSV to RDF converter

2012-12-13 Thread Tim rdf
Hi, Ying, I keep a disheveled list of everyone's golden hammers and lists of golden hammers at [1]. Regards, Tim Lebo [1] https://github.com/timrdf/csv2rdf4lod-automation/wiki/Alternative-Tabular-to-RDF-converters On Wed, Dec 12, 2012 at 4:08 PM, Ying Ding wrote: > Hi, > > I am looking for a