AW: CSV on the Web - QB vocabulary

Dear Jeremy,

Thank you for your clear answer.

> From reading your response, I think you are suggesting that the `qb:DataStructureDefinition` could be coupled directly to the metadata description of the columns in the CSV file - effectively short-cutting the process of generating a compact RDF data cube?
Yes. 

> I had not thought of this approach and it certainly may provide some optimisation. However, developing such a normalization algorithm is beyond the scope of the CSV on the web Working Group.
I understand. Do you think, an explicit reference from the CSV on the Web WG results to the QB vocabulary would be possible? I think it would be helpful since QB often is used to represent numeric data originally stored as XLS or CSV. 

Best

Benedikt

.........................................................
Dipl.-Inform. Benedikt Kämpgen

Information Process Engineering

FZI Forschungszentrum Informatik
Haid-und-Neu-Str. 10–14 
76131 Karlsruhe, Germany
Tel.: +49 721 9654-824
Fax: +49 721 9654-825

kaempgen@fzi.de

.........................................................
FZI Forschungszentrum Informatik am Karlsruher Institut für Technologie
Stiftung des bürgerlichen Rechts
Stiftung Az: 14-0563.1 Regierungspräsidium Karlsruhe
Vorstand: Prof. Dr. Andreas Oberweis, Prof. Dr. Ralf Reussner, 
Jan Wiesenberger, Prof. Dr.-Ing. J. Marius Zöllner
Vorsitzender des Kuratoriums: Ministerialdirigent Günther Leßnerkraus
.........................................................

Von: Jeremy Tandy [mailto:jeremy.tandy@gmail.com] 
Gesendet: Mittwoch, 15. Juli 2015 11:22
An: Benedikt Kaempgen <kaempgen@fzi.de>; public-csv-wg-comments@w3.org
Betreff: Re: CSV on the Web - QB vocabulary

Hi- 

There are likely to be many improvements that can be made to the RDF Data Cube implementation that I used in my example :-)

From reading your response, I think you are suggesting that the `qb:DataStructureDefinition` could be coupled directly to the metadata description of the columns in the CSV file - effectively short-cutting the process of generating a compact RDF data cube?

I had not thought of this approach and it certainly may provide some optimisation. However, developing such a normalization algorithm is beyond the scope of the CSV on the web Working Group. 

I believe that there is a proposal to establish a community group related to working with tabular data on the web - primarily to look at developing richer, template-based transformation mechanisms. (at present, I am unsure of the status of this proposal- apologies)

If you are able to create a normalization algorithm such as you suggest above, it would be interesting to share your work in this community group. 

Best Regards, Jeremy

On Tue, 14 Jul 2015 at 17:47 Benedikt Kaempgen <kaempgen@fzi.de> wrote:
Dear Jeremy,

Thank you for your answer [1]. Unfortunately, since I am not subscribed to public-csv-wg-comments, I only found it now.

Your example [2] is interesting.

I am wondering whether based on your work it would be possible to have a more compact representation of a qb:DataSet with:

1) A definition of a qb:DataSet with a link to the metadata of a CSV file and a link to the CSV file (or links to rows in a CSV file)
2) A definition of a qb:DataStructureDefinition with links to instances of qb:DimensionProperty, qb:MeasureProperty, and qb:AttributeProperty, each with links to columns in the CSV file.

Given the data and metadata one could have an algorithm similar to the QB Normalization algorithm [3] to translate this compact to a normalized qb:DataSet.

Best

Benedikt

[1] ------------
(cross-posted from our issue tracker on Github: https://github.com/w3c/csvw/issues/509 <https://github.com/w3c/csvw/issues/509> . if you have a Github account, please feel free to add your comments there)

Hi Benedikt - I always had an eye on using the [RDF Data Cube][1] as output from the CSV to RDF conversion.

To illustrate use of the RDF Data Cube for converted CSV data I have created a real example - based on historical weather observations published by the [Met Office][2]. The example is described [here][3].

Please let us know if this illustrates what you need to know.

[1]: http://www.w3.org/TR/vocab-data-cube/

[2]: http://www.metoffice.gov.uk

[3]: https://github.com/w3c/csvw/blob/gh-pages/examples/rdf-data-cube-example.md

--------------------------------
[2] https://github.com/w3c/csvw/blob/gh-pages/examples/cambornedata-snippet-standard.ttl

[3] http://www.w3.org/TR/vocab-data-cube/#normalize-algorithm

.........................................................
Dipl.-Inform. Benedikt Kämpgen

Information Process Engineering

FZI Forschungszentrum Informatik
Haid-und-Neu-Str. 10-14
76131 Karlsruhe, Germany
Tel.: +49 721 9654-824
Fax: +49 721 9654-825

kaempgen@fzi.de

.........................................................
FZI Forschungszentrum Informatik am Karlsruher Institut für Technologie
Stiftung des bürgerlichen Rechts
Stiftung Az: 14-0563.1 Regierungspräsidium Karlsruhe
Vorstand: Prof. Dr. Andreas Oberweis, Prof. Dr. Ralf Reussner,
Jan Wiesenberger, Prof. Dr.-Ing. J. Marius Zöllner
Vorsitzender des Kuratoriums: Ministerialdirigent Günther Leßnerkraus
.........................................................

> -----Ursprüngliche Nachricht-----
> Von: Benedikt Kaempgen
> Gesendet: Dienstag, 21. April 2015 19:36
> An: 'public-csv-wg-comments@w3.org'
> Betreff: CSV on the Web - QB vocabulary
>
> Hello,
>
> I am wondering about the relationship to the CSV on the Web efforts and the
> QB vocabulary [1].
>
> Thanks for your efforts, I think, the use case to have CSV files on the web as
> a compact data representation and RDF for describing the meaning of the
> data is very interesting.
>
> Best
>
> Benedikt
>
> [1] <http://www.w3.org/TR/vocab-data-cube/>
>
> .........................................................
> Dipl.-Inform. Benedikt Kämpgen
>
> Information Process Engineering
>
> FZI Forschungszentrum Informatik
> Haid-und-Neu-Str. 10-14
> 76131 Karlsruhe, Germany
> Tel.: +49 721 9654-824
> Fax: +49 721 9654-825
>
> kaempgen@fzi.de
>
> .........................................................
> FZI Forschungszentrum Informatik am Karlsruher Institut für Technologie
> Stiftung des bürgerlichen Rechts Stiftung Az: 14-0563.1 Regierungspräsidium
> Karlsruhe
> Vorstand: Prof. Dr. Andreas Oberweis, Prof. Dr. Ralf Reussner, Jan
> Wiesenberger, Prof. Dr.-Ing. J. Marius Zöllner Vorsitzender des Kuratoriums:
> Ministerialdirigent Günther Leßnerkraus
> .........................................................

Received on Monday, 24 August 2015 07:35:18 UTC