TY - GEN
T1 - Implementation of dynamic page generation for stream data by SuperSQL
AU - Terui, Keita
AU - Goto, Kento
AU - Toyama, Motomichi
N1 - Publisher Copyright:
© 2020 ACM.
PY - 2020/8/12
Y1 - 2020/8/12
N2 - 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.
AB - 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.
KW - IDEAS
KW - international database engineering applications symposium
UR - http://www.scopus.com/inward/record.url?scp=85091122775&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85091122775&partnerID=8YFLogxK
U2 - 10.1145/3410566.3410607
DO - 10.1145/3410566.3410607
M3 - Conference contribution
AN - SCOPUS:85091122775
T3 - ACM International Conference Proceeding Series
BT - Proceedings of the 24th International Database Engineering and Applications Symposium, IDEAS 2020
A2 - Desai, Bipin C.
PB - Association for Computing Machinery
T2 - 24th International Database Engineering and Applications Symposium, IDEAS 2020
Y2 - 12 August 2020 through 14 August 2020
ER -