Keita Terui
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.
- SuperSQL: http://ssql.db.ics.keio.ac.jp/Google Scholar
- 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.Google ScholarDigital Library
- Toshiyuki Seto, Takuhiro Nagafuji and Motomichi Toyama. Generating HTML Sources with TFE Enhanced SQL, In ACM Symposium on Applied Computing, pp.96--100, 1997.Google ScholarDigital Library
- 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.Google ScholarDigital Library
- PipelineDB: https://www.pipelinedb.com/Google Scholar
- 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
- Spark Streaming: https://spark.apache.org/streaming/Google Scholar
- Amazon Kinesis: http://aws.amazon.com/kinesis/Google Scholar
Index Terms
- Implementation of dynamic page generation for stream data by SuperSQL
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 dataSuperSQL 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