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

【Abstract】 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 divided into 5 parts,with each part running separately,so the inquiring efficiency is improved greatly.The system can well satisfy the needs of flood-control and drought-relief departments.更多还原