Implementation of dynamic page generation for stream data by SuperSQL

Keita Terui, Kento Goto, Motomichi Toyama

研究成果: Conference contribution

抄録

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.

本文言語English
ホスト出版物のタイトルProceedings of the 24th International Database Engineering and Applications Symposium, IDEAS 2020
編集者Bipin C. Desai
出版社Association for Computing Machinery
ISBN(電子版)9781450375030
DOI
出版ステータスPublished - 2020 8 12
イベント24th International Database Engineering and Applications Symposium, IDEAS 2020 - Incheon/Seoul, Online, Korea, Republic of
継続期間: 2020 8 122020 8 14

出版物シリーズ

名前ACM International Conference Proceeding Series

Conference

Conference24th International Database Engineering and Applications Symposium, IDEAS 2020
CountryKorea, Republic of
CityIncheon/Seoul, Online
Period20/8/1220/8/14

ASJC Scopus subject areas

  • Software
  • Human-Computer Interaction
  • Computer Vision and Pattern Recognition
  • Computer Networks and Communications

フィンガープリント 「Implementation of dynamic page generation for stream data by SuperSQL」の研究トピックを掘り下げます。これらがまとまってユニークなフィンガープリントを構成します。

引用スタイル