DEIM Forum 2014 E3-5 SuperSQL 223-8522 3-14-1 E-mail: {masato,goto}@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL, SQL, SuperSQL ssqltool, ssqltool, SuperSQL, Viewer Viewer, SuperSQL,,,, HTML, 1. SQL, SuperSQL, Swing, GUI, IDE, Java, JavaFX SuperSQL, SQL SQL,, SuperSQL, HTML PHP Web SuperSQL, SuperSQL, SuperSQL,, SuperSQL ssqltool ssqltool,,, 3,., ssqltool SuperSQL, SuperSQL, HTML, SuperSQL, 2 SuperSQL, 3 SuperSQL 4 ssqltool, 5 ssqltool, 6, 7,, 2. 1 ( ), 3 (,) : Name, Tel name tel (!) : Name! Tel (%) name tel 3 HTML. : Name % Tel name tel 2. 2,, 2. SuperSQL SuperSQL SuperSQL, SQL, [1] [2]. SQL SELECT GENERATE< media >< TFE > GENER- ATE < media >, HTML, PDF. < TFE > Target Form Expression [ ]!,[ ]!,[ ]!,, [! [, ]! ]!,,,
([ ],), : [Name], name1 name2 name10 4, 2 SuperSQL, ([ ]!), name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, (@) < >@{ < > } =, [employee.name@{width=200, color=red}]! 2. 4 2. 4. 1 image image, image(id, path=./pic ) 2. 4. 2 link ( HTML ) link, FOREACH link(cou.name, file=./menu.sql, att=co.country) 3. SuperSQL, SuperSQL 2 SuperSQL, Eclipse SuperSQL [3]. 3. 1 1 SuperSQL 1 2 SuperSQL emacs vi 3 ssql Super SQL 3. 2 2 Eclipse Eclipse SuperSQL 1 2 SuperSQL Eclipse 3 Eclipse SuperSQL, 4 Eclipse Eclipse, 2 1 Eclipse SuperSQL 1 SuperSQL, SuperSQL. SuperSQL., SuperSQL ssqltool 4. SuperSQL : ssqltool 4. 1 ssqltool Java Swing ssqltool, SuperSQL, ssqltool, SuperSQL, ssqltool 4. 2 ssqltool,,, 3 1, 2, 3 4. 2. 1,,,
1 2 3 GENERATE < media > FROM ; SuperSQL, ssql,,,, 0.2,,,,,,, HTML,,, *,,, ssqltool, ssqltool,, 4. 2. 2, ssql,,,,, 4. 2. 3 /preference,,,,,,, 4. 3 1 ssqltool., MacOS 5. ssqltool,,, Viewer, 5. 1 5. 1. 1 1, SuperSQL @ 1, @ {},
1 Ctrl(Command)+Enter Esc or Ctrl(Command)+W ssqltool Ctrl(Command)+S Ctrl(Command)+Z UNDO Ctrl(Command)+Y REDO Ctrl(Command) - +Alt(option)+ - Ctrl(Command)+D - - Ctrl(Command)+/ - - @ SuperSQL Ctrl(Command)+F SuperSQL Ctrl(Command)+Space 5. 2 1, Ctrl(Command)+Space 1 Ctrl(Command)+Space, Ctrl+Space,, 6 7 4 6 4 5. 1. 2,, Ctrl(Command)+F 5, XML ssqltool, XML 5 7 5. 3 Viewer 5. 3. 1 JavaFX JavaFX JavaFX, Java (RIA) GUI, Java SE 7 Update 2, Swing, FXML XML CSS JavaFX AWT Swing Java GUI, JavaFX, Java 5. 3. 2 JavaFX, HTML Viewer, SuperSQL HTML,,. SuperSQL, Viewer,
Viewer 8 10 6. 8 Viewer 5. 4 5. 4. 1 SuperSQL 2, 2, /* */ 1 ssqltool, Ctrl(Command)+/,, 9, 2 1, 3 35 ssqltool, 21 1, ssqltool,. 6. 1 1. SuperSQL, ssqltool 2. ssqltool 3. 11, 12, 13. 11 90% ssqltool, 2, 95%, 3,,. ssqltool 9 5. 4. 2 ssqltool,,,,, 10 11 ssqltool 6. 2, PostgreSQL pgadmin [4] SQLite SQLiteStudio [5] 2 ssqltool 3
13 12 ssqltool Linux ssqltool pgadmin SQLiteStudio 3 OS OS, DB Windows OS, ssqltool 7. 7. 1, SuperSQL SuperSQL ssqltool, ssqltool, Viewer SuperSQL, SuperSQL,, SuperSQL ssqltool 2 2 SQLiteStudio pgadmin ssqltool UNDO REDO Viewer [1] SuperSQL: http://supersql.db.ics.keio.ac.jp/ [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. 584-586, 1998 [3] Ria Mae BORROMEO: Integrating SuperSQL in Software Development Environment Systems, Proceedings of the 3rd Forum on Data Engineering and Information Management, 2011 [4] pgadmin: http://www.pgadmin.org/ [5] SQLiteStudio: http://sqlitestudio.pl/ 2, ssqltool Web,, Viewer pgadmin SQLiteStudio,, ssqltool 1 3 OS Windows, Mac,