DEIM Forum 2010 F6-1 SuperSQL Ajax 223 8522 3 14 1 E-mail: kabu@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL Ajax, GUI, GUI,, Ajax SuperSQL, HTML, Ajax, RIA Abstract Layout Function Extends for Generating Ajax Pages of SuperSQL Ryo KABUKI and Motomichi TOYAMA Department of Information and Computer Science, Keio University Hiyoshi 3 14 1, Kouhoku-ku, Yokohama-shi, Kanagawa, 223 8522 Japan E-mail: kabu@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp For Ajax page generation in conventional SuperSQL, there was the limitation that only one front end could have for one page, and that a kind of the GUI was poor. This article proposes adding GUI and technique to control plural front ends on a single horn page and expanded the layout function in the Ajax page generation of SuperSQL. Key words SuperSQL, HTML, Ajax, RIA 1., HTML, RIA(Rich Internet Application) [5],. RIA, Ajax [6]., SuperSQL HTML PDF Excel HTML, Ajax, SuperSQL Ajax,, GUI,, GUI SuperSQL Ajax. 2 SuperSQL 3 Ajax 4 5, 6 2. SuperSQL SuperSQL. SuperSQL, SQL, [1] [2]. SQL SELECT GENERATE< media >< T FE > GENERATE < media > HTML PDF < T FE > Target Form Expression 2. 1 ( ), 3. (, )
: Name, Tel name tel (! ) name : Name! Tel tel ( % ) 3. HTML. : Name % Tel name tel 2. 2,., [ ]!, [ ]!, [ ]!,. [! [, ]! ]!,,. ( [ ], ),. : [Name], name1 name2 name10. imagefile(id, path=./pic ) 2. 4. 2 link ( HTML link FOREACH. link(cou.name, file=./menu.sql, att=co.country) 2. 4. 3 invoke invoke link, SuperSQL, invoke,. invoke(cou.name, file=./menu.sql, condition= ca.country= +co.country) 2. 4. 4 embed embed., HTML embed. embed(file=./test.sql, where= ca.id=, att=ca.id) 2. 5 Ajax SuperSQL Ajax, HTML, -ajax. Ajax, Ajax SuperSQL. SuperSQL Ajax 1. ( [ ]! ),. name1 : [Name]! name2 name10 2. 3 SuperSQL,,,,,,,. ( ). < >@{ < > } =.,. 2. 4 SuperSQL 4. 2. 4. 1 imagefile imagefile 1 Ajax index, index,. index JavaScript, SuperSQL., SuperSQL, HTML. JavaScript HTML,
. SuperSQL Ajax SuperSQL RIA [4]. 3. 3. 1 SuperSQL Ajax, index SuperSQL index.sql, SuperSQL SuperSQL,, index SuperSQL., index.sql, index.sql index.sql, SuperSQL embed, HTML div,,,, 3. 2 GUI GUI, div,,,, Ajax GUI. SuperSQL,, RIA 3. 3,, GUI, GUI. 3 Ajax, index.sql. index.html,,,, index.sql., 2 index.sql index.sql, SuperSQL,., index.sql,,, 3 index.sql, 4 4. 2, 4,, GUI., ( 4 north ), ( 4 east ),, Ajax., SuperSQL Ajax Yahoo!UI [9] Ext JS [7]., SuperSQL
. 4. 1 centerlayout index.sql,,, centerlayout SuperSQL, centerlayout, 1., file sql, SuperSQL HTML. file html,, file, index.sql centerlayout, type menu 3,, N(N=1,2,3...)., 3 obj, obj1, obj2, obj3 3. objn filen sql condn file sql Where targetn id 3 type menu id width height file sql cond file sql Where 1 centerlayout 4. 2 extlayout centerlayout, GUI. GUI, GUI., extlayout, centerlayout extlayout, 2. id GUI cid GUI id. GUI region cid GUI type GUI. menu, tab, calender width GUI height GUI title GUI collapse GUI 2 extlayout, type menu, 3, type calender 4, file sql html, file sql cond file sql Where target id 4 type calender 4. 3 4. 3. 1 SuperSQL,., SuperSQL id. id sql,, id,., id, id, SuperSQL. 4. 3. 2 GUI SuperSQL Ajax GUI., link panel=yes,,, GUI,,.,, GUI. link extwin=yes GUI. GUI,,
,. 5. 5. 1 Ajax SuperSQL Ajax, SuperSQL Ajax, SuperSQL, SuperSQL,, 3. 20 3 5 ( ) 4 ( ) 3 ( ) 2 ( ) 1 ( ) 5 Q1. Q2. Q3. Ajax, Ajax, Ajax, GUI, Ajax, SuperSQL,,. Ajax 5, Ajax 6. 5 6 5. 2 7., A SuperSQL Ajax, B SuperSQL, Ajax, C SuperSQL, 7 Q1., Ajax., SuperSQL C., SuperSQL, SuperSQL Ajax Q2. Ajax A. index.sql, html SuperSQL SuperSQL embed, GUI GUI, SuperSQL SuperSQL GUI,. Q3. Ajax, Ajax A, SuperSQL Ajax B, SuperSQL C, Ajax, ID, SuperSQL, SuperSQL Ajax.,,
5, 6. JavaScript 38 - Ext JS 47 - HTML 176 17 SuperSQL - 67 261 84 5 Vol.93,No.152 P79-88 1993 [4], : SuperSQL RIA Vol.107,No.131 P289-294 2007 [5] Jeremy Allaire.: Macromedia Flash MX-A next-generatoin rich client. Technical report, Macromedia, March 2002 [6] Linda D. Paulson : Building Rich Web Applications with Ajax. Computer38(10), pp.14-17, 2005 [7] ExtJs: http://extjs.co.jp/ [8], : ExtJS UI Web Ajax, 2009 [9] YAHOO! UI Library: http://developer.yahoo.com/yui/ 6 JavaScript 52 - Ext JS 87 - HTML 674 50 SuperSQL - 80 813 128 SuperSQL HTML,, JavaScript Ext JS Ajax 5 6, SuperSQL, index.sql., GUI Ext JS, HTML, SuperSQL HTML, HTML SuperSQL 6. SuperSQL Ajax,, GUI, SuperSQL, Ajax SuperSQL. [1] SuperSQL: http://supersql.db.ics.keio.ac.jp/ [2] 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 [3] :