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

Labels
Layout
Table
Arbitrary
Websites
Display devices
Tables
Formal Model
Display
Intersection
Attribute
Query

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

Generating Arbitrary Cross Table Layout in SuperSQL. / Tabata, Atsutomo; Goto, Kento; Toyama, Motomichi.

Intelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings. Springer Verlag, 2018. p. 13-24 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 10752 LNAI).

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

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. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 10752 LNAI, Springer Verlag, pp. 13-24, 10th International scientific conferences on research and applications in the field of intelligent information and database systems, ACIIDS 2018, Dong Hoi City, Viet Nam, 18/3/19. https://doi.org/10.1007/978-3-319-75420-8_2
Tabata A, Goto K, Toyama M. Generating Arbitrary Cross Table Layout in SuperSQL. In Intelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings. Springer Verlag. 2018. p. 13-24. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). https://doi.org/10.1007/978-3-319-75420-8_2
Tabata, Atsutomo ; Goto, Kento ; Toyama, Motomichi. / Generating Arbitrary Cross Table Layout in SuperSQL. Intelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings. Springer Verlag, 2018. pp. 13-24 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{8af7adc50def434da5be439248e911e5,
title = "Generating Arbitrary Cross Table Layout in SuperSQL",
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.",
keywords = "Cross table, Database, Pivot table, SQL, SuperSQL",
author = "Atsutomo Tabata and Kento Goto and Motomichi Toyama",
year = "2018",
month = "1",
day = "1",
doi = "10.1007/978-3-319-75420-8_2",
language = "English",
isbn = "9783319754192",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "13--24",
booktitle = "Intelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings",
address = "Germany",

}

TY - GEN

T1 - Generating Arbitrary Cross Table Layout in SuperSQL

AU - Tabata, Atsutomo

AU - Goto, Kento

AU - Toyama, Motomichi

PY - 2018/1/1

Y1 - 2018/1/1

N2 - 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.

AB - 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.

KW - Cross table

KW - Database

KW - Pivot table

KW - SQL

KW - SuperSQL

UR - http://www.scopus.com/inward/record.url?scp=85043588423&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85043588423&partnerID=8YFLogxK

U2 - 10.1007/978-3-319-75420-8_2

DO - 10.1007/978-3-319-75420-8_2

M3 - Conference contribution

AN - SCOPUS:85043588423

SN - 9783319754192

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 13

EP - 24

BT - Intelligent Information and Database Systems - 10th Asian Conference, ACIIDS 2018, Proceedings

PB - Springer Verlag

ER -