([ ],), : [Name], name1 name2 name10 4, 2 SuperSQL, ([ ]!), name1 name2 : [Name]! name SuperSQL,,,,,,, < < > } =,

Size: px

Start display at page:

Download "([ ],), : [Name], name1 name2 name10 4, 2 SuperSQL, ([ ]!), name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, < < > } =,"

あつのこけい
9 years ago
Views:

1 DEIM Forum 2014 E3-5 SuperSQL 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 [ ]!,[ ]!,[ ]!,, [! [, ]! ]!,,,

2 ([ ],), : [Name], name1 name2 name10 4, 2 SuperSQL, ([ ]!), name1 name2 : [Name]! name SuperSQL,,,,,,, (@) < >@{ < > } =, [employee.name@{width=200, color=red}]! image image, image(id, path=./pic ) link ( HTML ) link, FOREACH link(cou.name, file=./menu.sql, att=co.country) 3. SuperSQL, SuperSQL 2 SuperSQL, Eclipse SuperSQL [3] SuperSQL 1 2 SuperSQL emacs vi 3 ssql Super SQL 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 1 2 3 GENERATE < media > FROM ; SuperSQL, ssql,,,, 0.2,,,,,,, HTML,,, *,,, ssqltool, ssqltool,, , ssql,,,,, /preference,,,,,,, ssqltool., MacOS 5. ssqltool,,, Viewer, , {},

4 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 , Ctrl(Command)+Space 1 Ctrl(Command)+Space, Ctrl+Space,, ,, Ctrl(Command)+F 5, XML ssqltool, XML Viewer JavaFX JavaFX JavaFX, Java (RIA) GUI, Java SE 7 Update 2, Swing, FXML XML CSS JavaFX AWT Swing Java GUI, JavaFX, Java JavaFX, HTML Viewer, SuperSQL HTML,,. SuperSQL, Viewer,

5 Viewer Viewer SuperSQL 2, 2, /* */ 1 ssqltool, Ctrl(Command)+/,, 9, 2 1, 3 35 ssqltool, 21 1, ssqltool, SuperSQL, ssqltool 2. ssqltool 3. 11, 12, % ssqltool, 2, 95%, 3,,. ssqltool ssqltool,,,,, ssqltool 6. 2, PostgreSQL pgadmin [4] SQLite SQLiteStudio [5] 2 ssqltool 3

6 13 12 ssqltool Linux ssqltool pgadmin SQLiteStudio 3 OS OS, DB Windows OS, ssqltool , SuperSQL SuperSQL ssqltool, ssqltool, Viewer SuperSQL, SuperSQL,, SuperSQL ssqltool 2 2 SQLiteStudio pgadmin ssqltool UNDO REDO Viewer [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 , 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: [5] SQLiteStudio: 2, ssqltool Web,, Viewer pgadmin SQLiteStudio,, ssqltool 1 3 OS Windows, Mac,

. ([ ],) : [Name] name1 name2 name10 ([ ]!). name1 name2 : [Name]! name10 2. 3 (@) < >@{ < > } = [employee.name@{width=200 color=red}]! 2. 4 2. 4. 1 l

. ([ ],) : [Name] name1 name2 name10 ([ ]!). name1 name2 : [Name]! name10 2. 3 (@) < >@{ < > } = [employee.name@{width=200 color=red}]! 2. 4 2. 4. 1 l DEIM Forum 2015 C5-1 SuperSQL SSedit 223-8522 3-14-1 E-mail: {yusuke,masato,goto}@db.ics.keio.ac.jp, [email protected] SuperSQL SQL SuperSQL SSedit SuperSQL SuperSQL link FOREACH 1. SuperSQL SQL SQL