(高分)请大家推荐关于“词频统计”的算法或者相应的网页?急!!!
sufu 2002-05-22 09:44:59 比如在下面的文本文件中:
(这只是一小部分,完整的有几百K之多)
11 14:31:24 SQL Prepare: INFORMIX 3.32 32 BIT - select * from m_adm_version
where depart_code=?
13 14:31:24 SQL Execute: INFORMIX 3.32 32 BIT - select * from m_adm_version
where depart_code=?
31 14:31:25 SQL Prepare: INFORMIX 3.32 32 BIT - select right_code,depart_code,level_code,staffer_name
from su_staffer_manage
where manager_code=?
and password=?
34 14:31:25 SQL Execute: INFORMIX 3.32 32 BIT - select right_code,depart_code,level_code,staffer_name
from su_staffer_manage
where manager_code=?
and password=?
59 14:31:25 SQL Prepare: INFORMIX 3.32 32 BIT - select description
from su_adm_level
where level_code=? and depart_mk='1'
61 14:31:25 SQL Execute: INFORMIX 3.32 32 BIT - select description
from su_adm_level
where level_code=? and depart_mk='1'
要找出from后的表名(如m_adm_version,su_staffer_manage等),select和 from之间的字段名字的出现规律统计数字。
并且试图找出某些执行频率高,执行时间长的sql语句。
各位,有谁知道,一定给分啊!