ToT for CSV: Accessing open data CSV files through SQL

Yasushi Doi, Motomichi Toyama

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

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.

Original languageEnglish
Title of host publication21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019 - Proceedings
EditorsMaria Indrawan-Santiago, Eric Pardede, Ivan Luiz Salvadori, Matthias Steinbauer, Ismail Khalil, Gabriele Anderst-Kotsis
PublisherAssociation for Computing Machinery
ISBN (Electronic)9781450371797
DOIs
Publication statusPublished - 2019 Dec 2
Event21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019 - Munich, Germany
Duration: 2019 Dec 22019 Dec 4

Publication series

NameACM 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

Keywords

  • CSV
  • Open data
  • SQL

ASJC Scopus subject areas

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

Fingerprint Dive into the research topics of 'ToT for CSV: Accessing open data CSV files through SQL'. Together they form a unique fingerprint.

  • Cite this

    Doi, Y., & Toyama, M. (2019). ToT for CSV: Accessing open data CSV files through SQL. In M. Indrawan-Santiago, E. Pardede, I. L. Salvadori, M. Steinbauer, I. Khalil, & G. Anderst-Kotsis (Eds.), 21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019 - Proceedings (ACM International Conference Proceeding Series). Association for Computing Machinery. https://doi.org/10.1145/3366030.3366130