research-article

Implementation of dynamic page generation for stream data by SuperSQL

Authors:

Keita Terui,

Kento Goto,

Motomichi ToyamaAuthors Info & Claims

IDEAS '20: Proceedings of the 24th Symposium on International Database Engineering & Applications

Article No.: 16, Pages 1 - 6

https://doi.org/10.1145/3410566.3410607

Published: 25 August 2020 Publication History

Get Access

Abstract

SuperSQL is an extension of SQL that allows you to structure the output of relational databases by writing your own queries and to express various layouts. However, this method is not suitable for data with high update frequency, such as stream data, because the information in the database refers to the data at the time of SuperSQL execution. In this study, we propose an implementation of a web page generation function that asynchronously updates a web page with the latest information for frequently updated data, using PipelineDB and SuperSQL, both of which are DBMSs capable of processing streams. You can specify the dynamic part of the stream by specifying the stream in the "decorator" which is a feature of SuperSQL. At the same time, you can specify "pull" and "push" in the stream decorator to select how the dynamic part is updated. This makes it possible to create a web page that displays the latest stock prices at any time in a page that displays a list of stock prices.

References

[1]

SuperSQL: http://ssql.db.ics.keio.ac.jp/

Google Scholar

[2]

M. Toyama: "SuperSQL: An Extended SQL for Database Publishing and Presentation", Proceedings of ACM SIGMOD'98 International Conference on Management of Data, pp.584--586, 1998.

Digital Library

Google Scholar

[3]

Toshiyuki Seto, Takuhiro Nagafuji and Motomichi Toyama. Generating HTML Sources with TFE Enhanced SQL, In ACM Symposium on Applied Computing, pp.96--100, 1997.

Digital Library

Google Scholar

[4]

K. Goto and M. Toyama, "Mobile Web Application Generation Features For SuperSQL", in Proceedings of the 20th International Database Engineering & Applications Symposium, IDEAS 2016, pp. 308--315, 2016.

Digital Library

Google Scholar

[5]

PipelineDB: https://www.pipelinedb.com/

Google Scholar

[6]

Jay Kreps, Neha Narkhede, and Jun Rao. Kafka: a distributed messaging system for log processing. ACM SIGMOD Workshop on Networking Meets Databases. page 6. 2011.

Google Scholar

[7]

Spark Streaming: https://spark.apache.org/streaming/

Google Scholar

[8]

Amazon Kinesis: http://aws.amazon.com/kinesis/

Google Scholar

Index Terms

Implementation of dynamic page generation for stream data by SuperSQL
1. Information systems
  1. World Wide Web
    1. Web data description languages
      1. Markup languages
        Hypertext languages

Recommendations

Column Access-aware In-stream Data Cache with Stream Processing Framework

In recent years, researches focus on addressing the query bottleneck issue of big data, e.g. NoSQL databases, MapReduce and big data processing framework. Although NoSQL databases have many advantages on On-Line Analytical Processing (OLAP), it is a big ...
SuperSQL: an extended SQL for database publishing and presentation

SuperSQL is an extension of SQL that allows query results presented in various media for publishing and presentations with simple but sophisticated formatting capabilities. SuperSQL query can generate various kinds of materials, for example, a LaTeX ...
SuperSQL: an extended SQL for database publishing and presentation
SIGMOD '98: Proceedings of the 1998 ACM SIGMOD international conference on Management of data

SuperSQL is an extension of SQL that allows query results presented in various media for publishing and presentations with simple but sophisticated formatting capabilities. SuperSQL query can generate various kinds of materials, for example, a LaTeX ...

Comments

Information & Contributors

Information

Published In

IDEAS '20: Proceedings of the 24th Symposium on International Database Engineering & Applications

August 2020

252 pages

ISBN:9781450375030

DOI:10.1145/3410566

General Chairs:
Bipin C. Desai
Concordia University, Canada
,
Wan-Sup Cho
Chungbuk National University, Korea

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 25 August 2020

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

IDEAS 2020

IDEAS 2020: 24th International Database Engineering & Applications Symposium

August 12 - 14, 2020

Seoul, Republic of Korea

Acceptance Rates

IDEAS '20 Paper Acceptance Rate 27 of 57 submissions, 47%;

Overall Acceptance Rate 74 of 210 submissions, 35%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

0
Total Citations
28
Total Downloads

Downloads (Last 12 months)1
Downloads (Last 6 weeks)0

Reflects downloads up to 27 Jul 2024

Other Metrics

View Author Metrics

Citations

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Index Terms

Recommendations

Column Access-aware In-stream Data Cache with Stream Processing Framework

SuperSQL: an extended SQL for database publishing and presentation

SuperSQL: an extended SQL for database publishing and presentation

Comments

Published In

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Acceptance Rates

Other Metrics

Article Metrics

Other Metrics

Login options

Full Access

PDF

eReader

Abstract

References

Index Terms

Recommendations

Column Access-aware In-stream Data Cache with Stream Processing Framework

SuperSQL: an extended SQL for database publishing and presentation

SuperSQL: an extended SQL for database publishing and presentation

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Author Tags

Qualifiers

Conference

Acceptance Rates

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations