DEIM Forum 2019 H2-2 SuperSQL SuperSQL SQL SuperSQL Web SuperSQL DBMS Pi

Size: px

Start display at page:

Download "DEIM Forum 2019 H2-2 SuperSQL SuperSQL SQL SuperSQL Web SuperSQL DBMS Pi"

かねろうさかど
4 years ago
Views:

DEIM Forum 2019 H2-2 SuperSQL 223 8522 3 14 1 E-mail: {terui,goto}@db.ics.keio.ac.

1 DEIM Forum 2019 H2-2 SuperSQL {terui,goto}@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL SQL SuperSQL Web SuperSQL DBMS PipelineDB SuperSQL Web Web 1 SQL SuperSQL HTML SuperSQL SQL SQL SuperSQL SuperSQL Web php SuperSQL Web SuperSQL SuperSQL Web DBMS PipelineDB DBMS Web SuperSQL Web SuperSQL Web Ajax Server Sent Events 2 Web SuperSQL Web 2 SuperSQL 3 4 SuperSQL Web SuperSQL SuperSQL 1 SuperSQL 1 SuperSQL SuperSQL SQL [1], [2] SQL SELECT GENERATE <media> <TFE> GENERATE <media> HTML PDF Mobile HTML5 [3] <TFE> Target Form Expression

2 2. 1 ( ) 3 (,) name, place name place (!) name name! place place 2. 2 []!, []!, [ ]! [! [, ]! ]! ([ ],) [Name], name1 name2 name10 ([ ]!) name1 name2 [Name]! name SuperSQL (@) < >@{< >} =, [name@{width=100, color=red}]! PipelineDB PipelineDB [4] SQL PostgreSQL PostgreSQL PipelineDB SQL PostgreSQL 1 1 PipelineDB Stream INSERT Stream Stream Stream Continous View SQL SQL ETL Apache Kafka [5] Spark Streaming [7] Amazon Kinesis [6] SuperSQL DBMS PostgreSQL PostgreSQL PipelineDB 3. 2 google map JavaScript DOM Ajax W3C html5 API Server Sent Events Ajax polling Server Sent Events HTTP server push

2 2 Super- SQL HTML CSS JavaScript PHP 3 pull 2 PHP JSON HTML JavaScript 4. 3 3.

3 1 pull Ajax push Server Sent Events 4 SuperSQL Web 4. 1 SuperSQL 3 Web n n n 1000 SuperSQL stream [ TEF1, [ TEF2 ]! ]!@{stream=n} Super- SQL HTML CSS JavaScript PHP 3 pull 2 PHP JSON HTML JavaScript pull stream mode= pull mode pull pull Ajax push stream mode= push push Server Sent Events 4 push crypto(id exchange name rate) users(id name) monitor(c id, u id) crypto Continuos View users monitor crypto users crypto Stream INSERT

4 4 sample.ssql push GENERATE HTML bootstrap [ null((asc)u.id) u.name, [ c.exchange, c.name, c.rate ]! ]!@{stream=3000} FROM users u, crypto c, monitor m WHERE c.id = m.c id AND u.id = m.u id sample.ssql Web cpu OS: CentOS CPU: Intel(R) Xeon(R) CPU E GHz 10 2core : 126GB DBMS: PipelineDB OS: Mac OS Mojave CPU: 3.1 GHz Intel Core i5 : 16GB : firefox 64.0 Web 100, 200,..., 1000 CPU sample.ssql 5 5 PipelineDB pull push cpu pull pull 2.1 CPU pull push 5. 2 PipelineDB PipelineDB CPU Web Web 1, 2,..., 10 PipelineDB CPU 7 PipelineDB

5 [4] PipelineDB: [5] Jay Kreps Neha Narkhede and Jun Rao Kafka: a distributed messaging system for log processing ACM SIG- MOD Workshop on Networking Meets Databases page [6] Amazon Kinesis: [7] Spark Streaming: 7 PipelineDB PipelineDB CPU (CPU ) () (1) 1 (1 ) () = ( ) (PHP ) () (2) Web Web CPU ( ) ( CPU ) () (3) (PHP ) (1 ) ( ) ( CPU ) ( ) () (4) (PHP ) (1 ) 6 SuperSQL Web Web HTML JavaScript PHP SuperSQL Web [1] SuperSQL: [2] M Toyama SuperSQL: An Extended SQL for Database Publishing and Presentation Proceedings of ACM SIG- MOD 98 International Conference on Management of Data pp [3] 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

([ ]!) name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, (@) < >@{ < > } =,,., 200,., TFE,, 1 2.,, 4, 3.,,,, Web EGG [5] SSVisual [6], Java SSedit( ss

([ ]!) name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, (@) < >@{ < > } =,,., 200,., TFE,, 1 2.,, 4, 3.,,,, Web EGG [5] SSVisual [6], Java SSedit( ss DEIM Forum 2016 H6-3 SuperSQL CSS 223 8522 3-14-1 E-mail: {ryosuke,goto}@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL, SQL. SuperSQL HTML, PHP,,,, SuperSQL Web, CSS 1. SQL, SuperSQL, CSS SuperSQL,