1 CSV CSV Wirawit Chaochaisit Ken Sakamura Noboru
問題点 1 CSVの形式 CSVファイルの自由度が高い Wirawit Chaochaisit, Ken Sakamura, Noboru Koshizuka, Masahiro Bessho : CSV-X: A Linked Data Enabled Schema Language, Model, and Processing Engine for Non-Uniform CSV. i. Things/Green. Com/CPSCom/Smart. Data 2016: 795 -804 8
解決策 1 CSVの整形 Cross Table to List 例3. クロス表 全 国 01北海道 02青 森 1935 34734133 1593845 484277 ・・・ ・・・ 2014 61041000 2537000 619000 全国人口動態調査 行header/列headerを属性の値 として格納 人口 34734133 1593845 484277 ・・・ 45877602 2544753 694037 ・・・ 61041000 2537000 619000 ・・・ 都道府県 全国 01北海道 02青森 ・・・ 年 1935 ・・・ 1960 ・・・ 2014 ・・・ 16
参考文献 1. T. Lebo, J. S. Erickson, L. Ding, A. Graves, G. T. Williams, D. Di. Franzo, X. Li, J. Michaelis, J. G. Zheng, J. Flores, Z. Shangguan, D. L. Mc. Guinness, and J. Hendler, “Producing and Using Linked Open Government Data in the TWC LOGD Portal, ” in Linking 2. Wirawit Chaochaisit, Ken Sakamura, Noboru Koshizuka, Masahiro Bessho : CSV-X: A Linked Data Enabled Schema Language, Model, and Processing Engine for Non-Uniform CSV. i. Things/Green. Com/CPSCom/Smart. Data 2016: 795 -804 3. Till Döhmen, Hannes Mühleisen, Peter Boncz “Multi-Hypothesis CSV Parsing”, SSDBM '17 Proceedings of the 29 th International Conference on Scientific and Statistical Database Management Article No. 16 20
参考文献 4. 2014: The Year of CSV | News, Open Data Institute. [Online]. Available: https: //theodi. org/blog/2014 -the-year-of-csv. [Accessed: 15 - Jul-2016]. 5. T. Davies, R. M. Sharif, and J. M. Alonso, “Open Data Barometer Global Report, ” World Wide Web Found. , 2015. 6. Y. Shafranovich, “Common format and MIME type for comma- separated values (CSV) files, ” 2005. 7. Data. gov: http: //data. gov/ 8. Data. gov. uk: http: //data. gov. uk/ 9. Data. gov. it: http: //data. gov. it/ 10. https: //ckan. open-governmentdata. org/dataset/ 21
- Slides: 21