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 few CSV files to load as detailed at:
http://docs.openlinksw.com/virtuoso/htmlconductorbar.html#conductorbar
Once the CSV data has been loaded/imported into the Virtuoso as SQL tables, you
could then use with R2RML or Virtuoso RDFViews to map the relational
representation to RDF as detailed at
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtR2RML
http://www.openlinksw.com/dataspace/dav/wiki/Main/VOSSQL2RDF
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRdb2RDFViewsGeneration
Also, note the Virtuoso Sponger Middleware includes a CSV sponger (rdf’izer)
extractor cartridge that can automatically map web accessible CSV files into
RDF as detailed at:
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtSponger
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtSpongerCartridgeSupportedDataSourcesNonRDF
It is also possible to write your own custom sponger extractor or meta
cartridges to control the form of RDF transformation performed as detailed at:
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtSpongerCartridgeProgrammersGuide
The CSV (or any other supported format) files can also be uploaded into
Virtuoso WebDAV rdf_sink folders and automatically invoke the sponger service
to transform to RDF as detailed at:
http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoRDFSinkFolder
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 12 Dec 2012, at 21: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
>
>
> Links:
>
> 1. http://www.w3.org/TR/r2rml/
> 2. http://www.w3.org/2001/sw/rdb2rdf/wiki/Implementations .
>
>
> Kingsley
>>
>> Barry
>>
>>
>>
>> On 12/12/2012 21:08, 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
>>> 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
>>>
>>>
>>
>>
>>
>>
>
>
> --
>
> Regards,
>
> Kingsley Idehen
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog: http://www.openlinksw.com/blog/~kidehen
> Twitter/Identi.ca handle: @kidehen
> Google+ Profile: https://plus.google.com/112399767740508618350/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
>
>
>
>
>
smime.p7s
Description: S/MIME cryptographic signature
