527 9 CSJ CSJ CSJ 1 8 XML CSJ XML Browser (MonoForC) CSJ 1.7 CSJ CSJ CSJ 9.1 GREP GREP Unix Windows Windows (http://www.vector.co.jp/) Trn Windows Trn > > grep *.trn
528 9 CSJ A01F0132.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0286.trn:& A01M0286.trn:& (? ) A01M0286.trn:& (? ) (? ) A01M0286.trn:& (? ) 9.1 GREP GREP GREP > grep [] *.trn A01F0132.trn:& A01M0077.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0097.trn:& A01M0104.trn:& A01M0258.trn:& A01M0258.trn:& 9.2 GREP GREP 9.2 GREP AWK, Perl, Ruby AWK AWK AWK Windows Perl Ruby
9.2 529 mawk 9.19.2 CSJ & mawk32 AWK AWK gawk, jgawk, nawk -F"&" &NF==2{print FILENAME, $1} 1 2 1 1 2 9.3 $1$2 > mawk32 -F"&" NF==2{print FILENAME, $1} *.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn a01f0001.trn 9.3 AWK result.txt AWK > > mawk32 -F"&" NF==2{print FILENAME, $1} *.trn > result.txt 9.3 A01F0001.trn > mawk32 -F"&" NF==2{if($1~/ []/)print FILENAME, $1} *.trn 1 GREP
530 9 CSJ a01f0132.trn a01m0077.trn a01m0097.trn a01m0097.trn a01m0097.trn a01m0097.trn a01m0097.trn a01m0097.trn a01m0104.trn a01m0258.trn a01m0258.trn 9.4 AWK GREP 9.2 AWK GREP AWK GREP AWK AWK & 1 ($1) GREP AWK GREP GREP GREP AWK GREP AWK 9.5 9.4 :GREP > grep [] *.trn mawk32 -F"&" {print $1} A01F0132.trn: A01M0077.trn: A01M0097.trn: A01M0097.trn: A01M0097.trn: A01M0097.trn: A01M0097.trn: A01M0097.trn: A01M0104.trn: A01M0258.trn: A01M0258.trn: 9.5 GREP AWK AWK 9.6 SDB 10 9 12
9.2 531 AWK word[] temp { temp=$10":"$9":"$12 word[temp]++ } END{ for (name in word) {print name, word[name]} } 9.6 9.6 suw_count.awk -F"Y=t" -f suw_count.awks01*.sdb S01 01 sort Windows > mawk32 -F"Y=t" -f suw_count.awk S01*.sdb sort 9.7 :: 1 :: 273 :: 6 :: 1 :: 3 :: 1 :: 3 :: 1 :: 2 :: 5 :: 1 :: 4 :: 1 :: 1 9.7
532 9 CSJ CSJ AWK Ruby Perl Ruby GREP AWK Perl Perl 9.3 RDB SQL CSJ CSJ 4 CSJ Excel 65,536 752 1% Access Access CSJ 100 Access Access 1GB CSJ RDB MySQL Oracle RDB PostgreSQL 4 RDB SQLServer RDB RDB RDB MySQL PostgreSQL RDB Oracle SQLServer RDB SQL RDB SQL MySQL SQL SQL ANSI SQL sdb (llemma) NHK (pron) 1 2 3 4 5 SQL select pron, count(*) from sdb where llemma= group by pron order by 2 desc; 1
9.3 RDB SQL 533 SQL 9.8 NHK NHK 1 1.8 SQL (W) 2 select pron, count(*) from sdb where llemma= group by pron order by 2 desc; (W ;) 95 (W ;) 19 (W ;) 9 4 (W ;) 3 (W ;) 2 (W (? ) ;) 2 <H> 1 (W ;) 1 (W ;) 1 (W ;) 1 (W ;) 1 (W (? ) ;) 1 9.8 SQL NHK SQL CSJ IDA01F0001 ID ID ID CSJ CSJ 1,417 ID ID (talk_data.dat) CSJ data_attribute.pdf ID ID ID ID ID ID ID 9.9 ID A01M001 S09M072 SQL (JOIN) talk_partial ID spkid SQL ID (talkid) (sdb) (left join) talk_partial spkid
534 9 CSJ 9.9 ID 9.10 spkid select talk_partial.spkid, count(sdb.lemma) from sdb left join talk_partial on (sdb.talkid = talk_partial.talkid) group by talk_partial.spkid order by 2 desc;
9.3 RDB SQL 535 spkid count(xsdb_var.lemma) 610 63118 8 55686 373 40351 631 33270 790 28188 1391 27821 19 26359 1107 25839 1268 25512 1185 25342 563 24892 1083 24073 9.10 SQL CSJ CSJ RDB talk_partial SQL t1t2 (alias) 2 as t1as t2 SQL sdb2 sdb 4 6 where 4 5 6 ID 1 ASSQL 7-1999 15 select t2.spont, t1.pron, count(t1.pron) from sdb as t1 left join talk_partial as t2 on (t1.talkid=t2.talkid) where t1.llemma= and (t1.pron= or t1.pron= ) and (left(t1.talkid,1)= S or left(t1.talkid,1)= A ) and (t2.spont>0 and t2.spont<6) group by t2.spont, t1.pron; SQL 9.11 9.12 MySQL RDB 9.12 Excel Excel
536 9 CSJ SQL RDB GUI MySQL GUI http://www.navicat.jp/ Excel copy and paste Excel Access RDB GUI Excel RDB SQL Excel ODBC RDB ODBC spont pron count(t1.pron) 1 10 1 15 2 18 2 35 3 31 3 154 4 53 4 437 5 76 5 768 9.11 SQL 9.12 SQL RDB 1970
9.4 XSLT 537 9.4 XSLT 1 XSLT XML XSLT XSLT Apache Project Xalan (http://xml.apache.org/xalan-j/) CSJ XML Xalan xsltproc (http://xmlsoft.org/xslt/xsltproc2.html)xslt XPath XPath preceding following Xalan xsltproc preceding following 1 1.6 CSJ XSLT Windows (msxsl.exe) (http://www.microsoft.com/downloads/) 9.13 1 1.6 1 ID ID BI 3 XML XSLT JIS 8 self::suw[@clauseboundarylabel] XPath <!-- output starts here --> xsltproc XSLT XML Windows Linux 9.13 xsltsample.xsl testxslt1.bat @echo off for %%I in (%1) do xsltproc xsltsample.xsl %%I XML xsltsample.xsl xslt1.bat XML xsltsample.xsl XML XML 9.14 > testxslt1 *.xml
538 9 CSJ 9.13 XSLT 1 1.6
9.5 539 A01F0132,0237,25,1,,,,,,,[],A,3 A01F0132,0240,6,1,,,,,,,//,L%,3 A01F0132,0240,16,2,,,,,,,<>,pH,3 A01F0132,0241,14,1,,,,,,,<>,H%,2+b A01F0132,0245,7,1,,,,,,,[],L%,3 A01F0132,0246,2,1,,,,,,,[],L%,1 A01F0143,0001,1,4,,,,,,,[],A,3 A01F0143,0001,6,1,,,,,,,[],A,3 A01F0143,0003,11,3,,,,,,,<>,H%,2+bp A01F0143,0003,14,1,,,,,,,[],L%,3 A01F0143,0006,1,3,,,,,,,[],A,3 9.14 9.13 XSLT 9.5 CSJ CSJ CSJ CSJ CSJ 1 9.5.1 CSJ 4 CSJ CSJ 9.7
540 9 CSJ 9.5.2 CSJ 3 2 1 1 1 2 1 RDB 9.5.3 3 100 650 1 2 1 2 1 2 1 2 3 1 2 1 2 3 4 1 2 4 RDB 9.5.4 CSJ 98% 650 CSJ 13
9.6 541 9.5.5 X-JToBI 2 X-JToBI A XML 7 CSJ X-JToBI XML 1 1.6 XSLT X-JToBI X-JToBI AYOR 7 9.6 CSJ CSJ RDB SQL GUI http://www.kokken.go.jp/lrc/ *1 URL URL CSJ CSJ CSJ http://www.f.waseda.jp/kikuchi/tips/csj_use.html *1 CSJ