中间库法加速区域气象观测站数据检索

为提高区域气象观测站降水资料检索效率，在VB6．0下编程调用T—sql语句，后台定时从区域气象观测站中心数据库提取降水数据，去除原始数据存储库中冗余内容，生成小时、日、月降水中间库表，大大降低数据库体积。在进行长时段累计降水查询时，将查询时段分成5段，分别查询小时、日、月降水中间库表，大大提高检索效率。满足了防汛抗旱部门及时掌握区域气象观测站降水资料的要求，发挥了区域气象观测站的投资效益。

Accelerated Searching of Regional Weather Station Data through Middle Database

To improve the inquiring efficiency of regional weather station rain data,a program is compiled with the T-SQL clause under VB.The rain data can be obtained with the program from the central database of regional weather stations at the given periods as a background task.The redundancy can be removed from the original database,and the volume of the database is reduced greatly through creating a middle database of hour,day,and month tables.When the long-term accumulation rainfall is inquired,the inquiry is di...