- From: <alain.couthures@agencexml.com>
- Date: Wed, 17 Dec 2014 15:36:16 +0100 (CET)
- To: Jeremy Tandy <jeremy.tandy@gmail.com>, W3C CSV on the Web Working Group <public-csv-wg@w3.org>
Received on Wednesday, 17 December 2014 14:36:47 UTC
Hello! I have been processing CSV files recently and I decided to store them in an extended DOM structure with arrays, maps and entries nodes (as XPath 3.1 will support them). This work of mine sounds to me similar with JSON mapping and please let me describe what I added for performance purposes: Adding a way to specify a column as a unique key (I use the media type for parameters such as header or separator too) allows to map the CSV data into a JSON object where key values are distinct properties : key,a,b 1,alpha,beta 2,alpha2,beta2 becomes { key: { "1": {a: "alpha", b: "beta"}, "2": {a: "alpha2", b: "beta2"} } } This is a very efficient way to access data within a Javascript program. I successfully processed within a browser more than 30000 rows against filtering maps in few seconds. What do you think? Kind regards, Alain Couthures agenceXML > Le 11 décembre 2014 à 22:53, Jeremy Tandy <jeremy.tandy@gmail.com> a écrit : > > > All - the [JSON mapping document][1] is now published to w3c/csvw:gh-pages and > is ready for your review. Feedback welcome of course :-) > > My next job is to to the RDF mapping document; this will follow a very similar > structure … > > Jeremy > > [1]:http://w3c.github.io/csvw/csv2json/
Received on Wednesday, 17 December 2014 14:36:47 UTC