[1] [3]. SQL SELECT GENERATE< media >< T F E > GENERATE. < media > HTML PDF < T F E > Target Form Expression ( ), 3.. (,). : Name, Tel name tel

Size: px

Start display at page:

Download "[1] [3]. SQL SELECT GENERATE< media >< T F E > GENERATE. < media > HTML PDF < T F E > Target Form Expression ( ), 3.. (,). : Name, Tel name tel"

きみおあくや
5 years ago
Views:

1 DEIM Forum 2011 C7-5 SuperSQL tomonari@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL, SQL SELECT GENERATE SQL., SuperSQL HTML,.,. SuperSQL, HTML, Equivalent Transformation on Link Expression in a SuperSQL Query Abstract Yosuke TOMONARI and Motomichi TOYAMA Department of Information and Computer Science, Keio University Hiyoshi , Kouhoku-ku, Yokohama-shi, Kanagawa, Japan tomonari@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL is an extension language, which enables us to express a variety of layouts, specifying output medium using GENERATE clause which syntax is GENERATE< media >< T F E > instead of SELECT clause in SQL. This article proposes a system which performs equivalent transformation on a link expression of a SuperSQL query specifying output medium to HTML and divides queries we can update partly. Additionally, we describe effectivenesses of what enables us to update queries partly. Key words SuperSQL, HTML, query language 1.,,,. WWW,. SuperSQL, SQL SE- LECT GENERATE< media >< T F E > GENERATE. media, HTML, PDF, SWF, Excel. T F E Target Form Expression,,. SuperSQL, HTML, Web. HTML, SuperSQL. TFE %, link, invoke. %,,,. Web. link, %, Web,., %, link.,. 2 SuperSQL. 3, 4. 5, SuperSQL SuperSQL. SuperSQL, SQL,

2 [1] [3]. SQL SELECT GENERATE< media >< T F E > GENERATE. < media > HTML PDF < T F E > Target Form Expression ( ), 3.. (,). : Name, Tel name tel (! ). name : Name! Tel tel (%) 3. HTML. : Name % Tel name tel % SuperSQL, % HTML. HTML, HTML. SuperSQL Qa.sql, HTML Qa1.html, HTML, Qa2.html, Qa3.html, % html 2. 2,.,. [ ]!, [ ]!, [ ]!,. [![, ]! ]!,,.,. ( [ ], ),. : [Name], name1 name2 name10 ( [ ]! ),. name1 name2 : [Name]! name SuperSQL,,,,,,,. ( ). < >@{ < > } =., SuperSQL imagefile imagefile.,. imagefile(id, path=./pic ) link ( HTML link foreach.. link(cou.name, file=./menu.sql, att=co.country) link 1 URL, 2, 3. foreach, foreach. link 3 foreach,. foreach SuperSQL, foreach HTML. link Super-

SQL HTML, link 3 URL. link HTML, foreach foreach,. 2. 4. 3 invoke invoke,.

country= +co.country) 2. 4. 4 embed embed., HTML embed. embed(file=./test.

%, Web,.,. % link,,. 3. 2 %,,. link,. % link,. 3. 3 % Web,. link,. 2 %, 3 link, Web.

3 SQL HTML, link 3 URL. link HTML, foreach foreach, invoke invoke,. link, SuperSQL, invoke,,. invoke(cou.name, file=./menu.sql, condition= ca.country= +co.country) embed embed., HTML embed. embed(file=./test.sql where= ca.id= att=ca.id) 3. % link [4] web SuperSQL, GENERATE media HTML, %,. %, Web,.,. % link,, %,,. link,. % link, % Web,. link,. 2 %, 3 link, Web. %,. link,, HTML %,. link,,,,. 4. % link. %, TFE. TFE,,., FROM WHERE, % link [5] [6]. 4. 4, 5.

4 GENERATE T F E. 6 Q0.sql TFE link %,., TFE., TFE.. link, link 1., link 1 foreach, link 3.. link.,., link 2.. q1.sql TFE,, n.nation. link., q2.sql FROM,. FROM, FROM WHERE FROM, WHERE, WHERE. 6 Q0.sql TFE, %.,. %, % link. %. 7 Q0.sql q1.sql, q2.sql, q3.sql. 4. 5, foreach link 1,. link 1 S(1), foreach S(f). link 3, S(1) = S(f),. Q from T Q f (T ), where T Q w (T ). Q, Q f (T ) = Q w (T ).,. 7 q1.sql, q2.sql, q3.sql , % link. %, , SuperSQL,., link, link %,. 14 % link 8., % link

8,, 21%. 8, link 3, 3. 43%. 9. link 3, 3., link 3 HTML link 3. 3. link 3.. 5.

43%.,,. 10. 10 11, % 1, 2, 3, 2., %, link. %, link. SuperSQL, %. SuperSQL link,.

5 8,, 21%. 8, link 3, 3. 43%. 9. link 3, 3., link 3 HTML link link % link, link. SuperSQL % 1, 2, 3, link.,.,. % 3, SuperSQL, HTML., web.,,. 43%.,, , % 1, 2, 3, 2., %, link. %, link. SuperSQL, %. SuperSQL link,. 10, movie.id=cast.movie cast.actor=actor.id,,. link 3, % link SuperSQL HTML %, link.., 60%

6 ., % link,,., SuperSQL % link link 3, link 3., link 1 link 3,, link , link 3,. % link,, link 3., link 3,. % link, link 3., link 3. [1] SuperSQL: [2] :,, Vol.93,No.152, P79-88,, 1993 [3] Motomichi Toyama, SupreSQL: An Extended SQL for Database Publishing and Presentation, Preceedings of ACM SIGMOD 98 International Conference on Management of Data, pp , 1998 [4], : Web, 46(SIG 13(TOD 27)), 1-15, [5] T. Seto, T. Nagafuji and M. Toyama, Generating HTML Sources with TFE Enhanced SQL, Proc. ACM Symp. on Applied Computing(SAC 97), pp , 1997 [6] Motomichi Toyama and Takuhiro Nagafuji: Dynamic and Structured Presentation of Database Contents on the Web Lecture Notes in Computer Science, 1998, Volume 1377/1998, [7] E. F. Codd: A relational model of data for large shared data banks, Communications of the ACM, Volume 13 Issue 6, June 1970 [8] Alfred V. Aho, Jeffrey D. Ullman and John E. Hopcroft: Data Structures and Algorithms, Addison Wesley, January 11, 1983 [9] David Gries: Compiler Construction for Digital Computers, John Wiley & Sons, December, 1971 [10] J s GOAL - J :

: Name, Tel name tel (! ) name : Name! Tel tel ( % ) 3. HTML. : Name % Tel name tel 2. 2,., [ ]!, [ ]!, [ ]!,. [! [, ]! ]!,,. ( [ ], ),. : [Name], nam

: Name, Tel name tel (! ) name : Name! Tel tel ( % ) 3. HTML. : Name % Tel name tel 2. 2,., [ ]!, [ ]!, [ ]!,. [! [, ]! ]!,,. ( [ ], ),. : [Name], nam 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