csj-report.pdf

Size: px

Start display at page:

Download "csj-report.pdf"

ふみないせき
7 years ago
Views:

1 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 ( Trn Windows Trn > > grep *.trn

2 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

3 mawk CSJ & mawk32 AWK AWK gawk, jgawk, nawk -F"&" &NF==2{print FILENAME, $1} $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

4 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 :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

5 AWK word[] temp { temp=$10":"$9":"$12 word[temp]++ } END{ for (name in word) {print name, word[name]} } 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

6 532 9 CSJ CSJ AWK Ruby Perl Ruby GREP AWK Perl Perl 9.3 RDB SQL CSJ CSJ 4 CSJ Excel 65, % 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) SQL select pron, count(*) from sdb where llemma= group by pron order by 2 desc; 1

7 9.3 RDB SQL 533 SQL 9.8 NHK NHK 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 (? ) ;) 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

8 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 9.3 RDB SQL 535 spkid count(xsdb_var.lemma) SQL CSJ CSJ RDB talk_partial SQL t1t2 (alias) 2 as t1as t2 SQL sdb2 sdb 4 6 where ID 1 ASSQL 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 MySQL RDB 9.12 Excel Excel

10 536 9 CSJ SQL RDB GUI MySQL GUI Excel copy and paste Excel Access RDB GUI Excel RDB SQL Excel ODBC RDB ODBC spont pron count(t1.pron) SQL 9.12 SQL RDB 1970

11 9.4 XSLT XSLT 1 XSLT XML XSLT XSLT Apache Project Xalan ( CSJ XML Xalan xsltproc ( XPath XPath preceding following Xalan xsltproc preceding following CSJ XSLT Windows (msxsl.exe) ( ID ID BI 3 XML XSLT JIS 8 self::suw[@clauseboundarylabel] XPath  xsltproc XSLT XML Windows Linux 9.13 xsltsample.xsl off for %%I in (%1) do xsltproc xsltsample.xsl %%I XML xsltsample.xsl xslt1.bat XML xsltsample.xsl XML XML 9.14 > testxslt1 *.xml

12 538 9 CSJ 9.13 XSLT 1 1.6

13 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, XSLT 9.5 CSJ CSJ CSJ CSJ CSJ CSJ 4 CSJ CSJ 9.7

14 540 9 CSJ CSJ RDB RDB CSJ 98% 650 CSJ 13

15 X-JToBI 2 X-JToBI A XML 7 CSJ X-JToBI XML XSLT X-JToBI X-JToBI AYOR CSJ CSJ RDB SQL GUI *1 URL URL CSJ CSJ CSJ *1 CSJ

データ連携ソリューションスイート「ASTERIA WARP」　ご紹介資料

データ連携ソリューションスイート「ASTERIA WARP」　ご紹介資料 RIA ASTERIA WARP / ) ) CSV) ) / / ) Web A B ASTERIA DB DB C (Excel ) Mail Excel / 6 A RDB ORACLE B XML DB Cyber Luxeon BI CSV Excel ASTERIA WARP Work-Flow EIP Front-End B2B EDI CRM BI Web OLAP Mail BPM