Generating Arbitrary Cross Table Layout in SuperSQL

Atsutomo Tabata, Kento Goto, Motomichi Toyama

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

Abstract

In many Web site, various data presented in the form of a cross-table. Cross-table displays two sets of labels, typically on the top and left of the table, and attributes corresponding to the intersection of both labels in the middle. The simplest example of a cross table is a double entry table. In this work, we propose a formal model for cross-table and a way to describe cross-table from relational data. Using this model, we implement cross tables as a function of the SuperSQL system, an extension of the SQL language which generates structured documents from declarative queries on relational data. Using this method, we create elaborate and expressive cross tables that were not readily obtainable with other systems.

Original languageEnglish
Title of host publicationIntelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings
PublisherSpringer Verlag
Pages13-24
Number of pages12
ISBN (Print)9783319754192
DOIs
Publication statusPublished - 2018 Jan 1
Event10th International scientific conferences on research and applications in the field of intelligent information and database systems, ACIIDS 2018 - Dong Hoi City, Viet Nam
Duration: 2018 Mar 192018 Mar 21

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume10752 LNAI
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other10th International scientific conferences on research and applications in the field of intelligent information and database systems, ACIIDS 2018
CountryViet Nam
CityDong Hoi City
Period18/3/1918/3/21

    Fingerprint

Keywords

  • Cross table
  • Database
  • Pivot table
  • SQL
  • SuperSQL

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Computer Science(all)

Cite this

Tabata, A., Goto, K., & Toyama, M. (2018). Generating Arbitrary Cross Table Layout in SuperSQL. In Intelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings (pp. 13-24). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 10752 LNAI). Springer Verlag. https://doi.org/10.1007/978-3-319-75420-8_2