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
> > .........................................................
>
>