ToT for CSV: Accessing open data CSV files through SQL

Yasushi Doi, Motomichi Toyama

研究成果: Conference contribution

1 被引用数 (Scopus)

抄録

Recently, the push for open data has been very strong, and more and more sources, such as governments are sharing data such as weather records or demographic statistics. The Remote Table Access (RTA) system allows the easy publication of data from a relational database, and its use through SQL-like queries by remote users. Still, the data currently being shared as open data comes in many formats, not always directly integrable with relational databases, and many sources publish data as raw CSV, XML or even PDF files. These files then need to be downloaded, parsed, and integrated with the final user's data, often in a relational database. In this work, we present Table on Top (ToT) for CSV, an extension of the RTA system that allows the easy publication and access of data contained in CSV files through RTA.

本文言語English
ホスト出版物のタイトル21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019 - Proceedings
編集者Maria Indrawan-Santiago, Eric Pardede, Ivan Luiz Salvadori, Matthias Steinbauer, Ismail Khalil, Gabriele Anderst-Kotsis
出版社Association for Computing Machinery
ISBN(電子版)9781450371797
DOI
出版ステータスPublished - 2019 12 2
イベント21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019 - Munich, Germany
継続期間: 2019 12 22019 12 4

出版物シリーズ

名前ACM International Conference Proceeding Series

Conference

Conference21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019
CountryGermany
CityMunich
Period19/12/219/12/4

ASJC Scopus subject areas

  • Software
  • Human-Computer Interaction
  • Computer Vision and Pattern Recognition
  • Computer Networks and Communications

フィンガープリント 「ToT for CSV: Accessing open data CSV files through SQL」の研究トピックを掘り下げます。これらがまとまってユニークなフィンガープリントを構成します。

引用スタイル