中央社新聞(CNA news)

jdwang@asia.edu.tw

• Term-Histroy Program
  • Perl_MR_MySQL_Search_jdwang.zip

• Maximal Repeats Examples
  • MR_CNA1991_1_3_Test60.zip(CNA (1991~1993)每月20篇共60篇)
  • OutputMR_Test1.rar
• Install ApprServ(TextMiningTools)
  • root,1234
  • Create Database.
    • SQL=>CREATE DATABASE `CNA` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
• MySQL

  • ps. 心得 / 終於搞懂 MySQL 資料庫編碼

  • Create Tables
    • perl Create_MySQLTable_Local_CNAEvent.pl
    • perl Create_MySQLTable_Local_CNAEventHistory.pl
  • Parse Events into MySQL database
    • Line30=>$dbh->do("set character set big5");
    • Line31=>$dbh1->do("set character set big5");
    • perl MR2DB_CNA_Local.pl ../OutputMR_Test
• Test WebSearch
  • http://localhost/Search1/search_jdwang1.php
  • Google Chart API