21 RDB Wiki 0830016 : : 2010 1 29
1 1 5 1.1........................................... 5 1.2 Wiki...................................... 7 1.2.1 Wiki.................... 7 1.2.2 Wiki.................. 8 1.3 RDB........................................... 9 1.3.1 RDB........................ 9 1.3.2 RDB....................... 9 1.3.3 WWW-RDB...................... 9 1.4...................................... 10 1.4.1 Wiki RDB................... 10 1.4.2 RDB Wiki..................... 10 1.4.3 Wiki RDB.................. 10 2 11 2.1 Wiki Wiki.......................... 11 2.1.1 Wiki.................................... 11 2.1.2 PukiWiki PukiWiki...................... 12 2.1.3 YagiWiki.................................... 14 2.2 RDB.............................. 14 2.2.1 SQL....................................... 14 2.2.2 RDB WWW........................ 15 2.2.3 MySQL phpmyadmin........................... 16 3 18 3.1.................................. 18 3.2.................................. 18 3.2.1.............................. 18 3.2.2.............................. 19 3.2.3.............................. 19 3.2.4 Wiki............................. 20 3.3...................................... 22 3.3.1 Wiki............................ 22 3.3.2.............................. 22 3.3.3.............................. 25 3.4...................................... 25
2 3.4.1......................... 25 3.4.2................ 25 3.4.3.................... 27 3.5.............................. 27 3.5.1 Wiki............... 27 3.5.2 WWW-RDB.................. 30 4 32 4.1 MySQL............................... 33 4.1.1.................................. 33 4.1.2..................................... 34 4.1.3................................. 34 4.2 PHP........................................... 35 4.2.1............................ 35 4.2.2............................. 35 4.2.3.................................. 37 4.3 JavaScript........................................ 38 5 40 5.1 Wiki............................. 40 5.1.1..................................... 40 5.1.2....................................... 43 5.1.3....................................... 44 5.2 Wiki............................. 44 5.2.1..................................... 44 5.2.2....................................... 46 5.2.3....................................... 46 5.3......................................... 46 6 50 6.1........................................... 50 6.2....................................... 50 6.2.1................................ 50 6.2.2.................................. 51 52 53
3 1.1 Wikipedia............................ 6 1.2 Wiki.................. 7 2.1 PukiWiki Wiki........................... 11 2.2 areaedit.......................... 12 2.3 table edit..................... 13 2.4 YagiWiki............................. 14 2.5 phpmyadmin....................... 16 3.1.................................. 18 3.2.................................. 19 3.3................................ 20 3.4................................ 21 3.5 Wiki............................ 22 3.6................................ 23 3.7.............................. 24 3.8............................ 26 3.9........................... 26 3.10............................ 27 3.11......................... 28 3.12....................... 29 3.13..................... 30 3.14 phpmyadmin..................... 31 4.1.............................. 32 4.2.................................. 33 4.3 JavaScript....................... 39 5.1 Wikipedia...................... 41 5.2............................ 42 5.3............................... 43 5.4.......................... 45 5.5............................ 46 5.6................................. 47
4 2.1 SQL................................. 15 4.1 log................................ 33 4.2 t [ ]......................... 34 4.3 logdate............................. 34 5.1............................... 43 5.2.......................... 43 5.3.......................... 46 5.4 Q1............................. 46
5 1 1.1 Web Web HTML Web HTML HTML Web Web HTML Web Web HTML Wiki Web Wiki Web Wikipedia 15) ( 1.1) Wiki Wiki Wiki RDB Web RDB
1 6 1.1: Wikipedia WWW-RDB 5) Wiki RDB Wiki Web
1 7 1.2 Wiki Wiki CMS( ) 1) CMS Web 1.2.1 Wiki Web Web Web ( 1.2) 1.2: Wiki HTML 1.2 HTML Web Wiki Wiki 2
1 8 Wiki 1.2.2 Wiki Wiki Wiki Wiki
1 9 1.3 RDB RDB( ) 1.3.1 RDB RDB 1.3.2 RDB SQL SQL SQL 2 RDB 1.3.3 WWW-RDB RDB RDB RDB Web WWW-RDB
1 10 1.4 Wiki RDB Wiki RDB Wiki Wiki RDB 3 Wiki RDB 1.4.1 Wiki RDB RDB SQL RDB RDB SQL Wiki RDB 1.4.2 RDB Wiki Wiki RDB RDB Wiki SQL Wiki Wiki Wiki Wiki 1.4.3 Wiki RDB
11 2 Wiki Wiki 1)2)3) RDB WWW RDB 4)5)6) 2.1 Wiki Wiki 2.1.1 Wiki Wiki Wiki Wiki PukiWiki 10) *( ) [[, ]] PukiWiki Wiki 2.1 2.1: PukiWiki Wiki HTML Wiki Wiki
2 12 2.1.2 PukiWiki PukiWiki PukiWiki PukiWiki 10) PHP Wiki 1.2 PukiWiki Wiki PukiWiki PukiWiki areaedit areaedit.inc.php 11) PukiWiki ( 2.2) 2.2: areaedit 1
2 13 Wiki Wiki Wiki table edit table edit.inc.php 12) Wiki PukiWiki Wiki 2.3 1n 1 1 2.3: table edit Wiki
2 14 RDB Wiki 2.1.3 YagiWiki YagiWiki 7) 3 Wiki ( 2.4) 2.4: YagiWiki YagiWiki 2.2 RDB 2.2.1 SQL RDB RDB SQL SQL 2.1
2 15 CREATE TABLE T ( C1 TEXT, C2 TEXT, C3 TEXT ); T ( C1 C2 C3 TEXT ) C1 C2 C3 INSERT INTO T ( C1, C2, C3 ) VALUES( 1, a, ); INSERT INTO T ( C1, C2, C3 ) VALUES( 2, b, ); INSERT INTO T ( C1, C2, C3 ) VALUES( 3, c, ); T 3 C1 C2 C3 1 a 2 b 3 c SELECT C1,C3 FROM T ORDER BY C1 DESC; C1 C1, C3 C1 C3 3 2 1 UPDATE T SET C2 = x WHERE C1 = 2 ; C1 2 C2 x 2.1: SQL C1 C2 C3 1 a 2 x 3 c SQL RDB SQL SQL RDB RDB SQL 2.2.2 RDB WWW RDB WWW 2 1 RDB RDB 5)6) Oracle Database 8) WebDB 9) phpmyadmin 2 RDB Web RDB RDB MediaWki
2 16 2.2.3 MySQL phpmyadmin MySQL MySQL 13) RDB RDBMS phpmyadmin MySQL phpmyadmin 14) phpmyadmin PHP MySQL ( 2.5) 2.5: phpmyadmin MySQL SQL phpmyadmin SQL RDB MySQL SQL MySQL phpmyadmin MySQL Web
2 17 MediaWiki MediaWiki Wikipedia Wiki PHP MySQL RDBMS RDB Wiki Wikipedia Wikipedia MediaWiki RDB RDB RDB
18 3 3.1 Wiki 3.1 3.1: 3.2 3.2.1 CREATE ( 3.2)
3 19 3.2: 3.2.2 Enter ( 3.3) 3.2.3 + - ( 3.4)
3 20 3.3: 1 3.2.4 Wiki EDIT Wiki Wiki ( 3.5) Wiki Wiki
3 21 3.4:
3 22 3.5: Wiki 3.3 3.3.1 Wiki Wiki EDIT Wiki 3.3.2 &table( ); ( 3.6) ( 3.7) &table( ){ 1 2 }; 1 2
3 23 3.6: &table( ){ = }; = > < <= >= &table( ){ LIKE }; &table( ){sort: }; &table( ){reverse: };
3 24 3.7: sort reverse &table( 1)( 2){join: }; 1 2
3 25 3.3.3 ( 3.3) 3.4 3.4.1 SEARCH ( 3.8) Wiki 3 ( 3.9) 3.4.2 ( 3.10)
3 26 3.8: 3.9:
3 27 3.10: 3.4.3 ( 3.11) [ ] 3.5 3.5.1 Wiki 1 Wiki 2 Wiki Wiki
3 28 3.11: ( 3.12) area edit table edit ( 3.13) 1 Wiki
3 29 3.12: Wiki YagiWiki Wiki Wiki I( ) l( ) 1( )
3 30 3.13: 3.5.2 WWW-RDB 1 SQL RDB WWW-RDB WWW-RDB 2 1 RDBMS SQL 2 RDBMS Web RDB RDBMS RDBMS Wiki phpmyadmin ( 3.14)
3 31 3.14: phpmyadmin 2 Web 1 phpmyadmin 2 2 MediaWiki 1 2 WWW-RDB WWW Wiki MediaWiki RDB Wiki RDB Wiki RDB
32 4 Wiki Web PHP MySQL Web PHP MySQL Web PHP PHP MySQL ( 4.1) 4.1: MySQL PHP MySQL JavaScript
4 33 4.1 MySQL MySQL 3 4.2 MySQL log logdata tmp t t t 4.2: MySQL MySQL 1 2 3 4 4.1.1 log 4.1 id name text date p [ ] int( ) text( ) longtext( ) date( ) 1 p index * ( ) 2010-01-27 00:00:44 4.1: log
4 34 id PHP 1 2 name p [ ] 4.1.2 t [ ] t PHP 4.2 id...... int text/double( )... text/double 4.2: t [ ] id PHP Wiki text( ) double( ) tmp EDIT 4.1.3 Wiki logdate 4.3 id name date p [ ]/t [ ] int text date 7 t test 2009-11-13 23:31:13 4.3: logdate id name p t
4 35 4.2 PHP PHP MySQL index.php PHP 4.2.1 1. PHP 2. MySQL log MySQL t [ ] MySQL PHP 3. HTML 1. PHP 2. MySQL log 3. 4. PHP MySQL log log ( ) 5. logdate 6. 4.2.2 1. PHP PHP MySQL 2. t [ ] PHP HTML
4 36 log PHP HTML 3. HTML 1. PHP PHP MySQL t [ ] logdate t [ ] MySQL 2. EDIT 1. PHP PHP MySQL t [ ] 2. Wiki 3. Wiki 4. PHP Wiki 5. MySQL t [ ] tmp t [ ] tmp t [ ] 6. logdata
4 37 Wiki 5 tmp 1. id PHP 2. MySQL id 3. 4. PHP MySQL 5. 1. PHP MySQL 2. MySQL t PHP 1 3 MySQL 3. PHP 4.2.3 1. PHP MySQL logdate 2. HTML
4 38 4.3 JavaScript JavaScript Web HTML Web Web JavaScript / / / PHP JavaScript PHP <div> JavaScript HTML <div> ( 4.3) 8 JavaScript
4 39 4.3: JavaScript
40 5 Wiki Wiki 2 Wiki Wiki 5.1 Wiki 5.1.1 20 10 PukiWiki PukiWiki Wikipedia 2 5.1 A4 Wiki PukiWiki 10) 2 PukiWiki 1 1 2 1 2 2 2 PukiWiki 2 1 50 2 2 2 Wiki
5 41 5.1: Wikipedia
5 42 PukiWiki IntelCore2 IntelCore2 PukiWiki PukiWiki 2 2 1. PukiWiki 2. PukiWiki 3. 4. 5. 5.2 Q1. PukiWiki Q2. PukiWiki Q3. PukiWiki Q4.Wiki PukiWiki 5.2: PukiWki PukiWiki IntelCore2 IntelCore2 4
5 43 5.1.2 5.1 5.3 PukiWiki PukiWiki IntelCore2 PukiWiki 4 59 5 29 IntelCore2 5 18 3 58 5 9 4 43 5.1: 5.3: 5.2 Wiki 1 2 3 4 5 Q1 0 0 8 1 1 3.3 Q2 0 0 0 4 6 4.6 Q3 0 0 0 1 9 4.9 Q4 0 0 0 5 5 4.5 5.2:
5 44 5.1.3 Q3 PukiWiki PukiWiki 1 1 3 3 PukiWiki IntelCore2 PukiWiki PukiWiki IntelCore2 l( ) PukiWiki PukiWiki PukiWiki Q1 Wiki PukiWiki 5.2 Wiki 5.2.1 10
5 45 5.4 5.4: 5.5
5 46 Q1. No Yes Q2. No Yes 5.5: 5.2.2 5.3 1 2 3 4 5 Q1 0 0 0 1 9 4.9 Q2 0 0 0 7 1 4.1 5.3: 5.2.3 Wiki 5.3 2 5.6 5.4 1 2 3 4 5 Q1 0 0 0 6 4 4.4 5.4: Q1
5 47 Q1. PukiWiki PukiWiki Q2.PukiWiki Wiki Q3.PukiWiki Wiki Q4. 5.6: PukiWiki Q2,Q,3,Q4 Q1. PukiWiki CSS
5 48 Q2. PukiWiki Wiki Q3. 1 /1 1 1 Enter Tab PukiWiki Wiki
5 49
50 6 6.1 Wiki RDB Web RDB Wiki RDB 6.2 6.2.1 (GUI) 5
6 51 6.2.2 Wiki
52
53 [1] Bo Leuf and Ward Cunningham, The Wiki Way: Quick Collaboration on the Web, Addison- Wesley, 2001. [2] Roberto Tazzoli Paolo Castagna Stefano Emilio Campanini, Towards a Semantic WikiWiki- Web, Poster Track, 3rd international Semantic Web Conference pp.7-11, 2004. [3] Kouichirou Eto Satoru Takabayashi Toshiyuki Masui, qwikweb: integrating mailing list and WikiWikiWeb for group communication, Proceedings of the 2005 International Symposium on Wikis pp.17-23, 2005. [4] D. Andresen et al., The WWW Prototype of the Alexandria Digital Library, Proceedings of ISDL 95 pp.17-27, 1995. [5], WWW-RDB, 38(2), pp.349-358, 1997. [6], DB Web,, 2001. [7], Yagi Wiki: Wiki, 49 pp.41-48, 2008. [8] Oracle Database http://www.oracle.com/lang/jp/database/. [9] Oracle WebDB http://www.oracle.com/technology/global/jp/products/webdb/. [10] PukiWiki-official http://pukiwiki.sourceforge.jp/. [11] /areaedit.inc.php - PukiWiki-official http://pukiwiki.sourceforge.jp/? /areaedit.inc.php. [12] /table edit.inc.php - PukiWiki-official http://pukiwiki.sourceforge.jp/? /table edit.inc.php. [13] MySQL::The world s most popular open source database, http://www.mysql.com/. [14] phpmyadmin, http://www.phpmyadmin.net. [15] Wikipedia, http://wikipedia.org/. [16] MediaWiki, http://www.mediawiki.org/wiki/mediawiki/.