TY - GEN
T1 - ToT for CSV
T2 - 21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019
AU - Doi, Yasushi
AU - Toyama, Motomichi
N1 - Publisher Copyright:
© 2019 Association for Computing Machinery.
PY - 2019/12/2
Y1 - 2019/12/2
N2 - 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.
AB - 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.
KW - CSV
KW - Open data
KW - SQL
UR - http://www.scopus.com/inward/record.url?scp=85117543259&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85117543259&partnerID=8YFLogxK
U2 - 10.1145/3366030.3366130
DO - 10.1145/3366030.3366130
M3 - Conference contribution
AN - SCOPUS:85117543259
T3 - ACM International Conference Proceeding Series
BT - 21st International Conference on Information Integration and Web-Based Applications and Services, iiWAS 2019 - Proceedings
A2 - Indrawan-Santiago, Maria
A2 - Pardede, Eric
A2 - Salvadori, Ivan Luiz
A2 - Steinbauer, Matthias
A2 - Khalil, Ismail
A2 - Anderst-Kotsis, Gabriele
PB - Association for Computing Machinery
Y2 - 2 December 2019 through 4 December 2019
ER -