摘要
报表统计在二代身份证系统中非常重要,而且要求以天为单位按行政区划统计。当数据量比较小时,可以实时统计,但是当数据量比较大时,实践表明如果采用常规的统计方法,性能较差。因此,针对这种情况,提出了一种基于ORACLE的新统计方法—增量统计法,提高系统性能,来满足省、地市、区县、派出所各级公安机关工作人员的统计需求。
Report statistics is very important in the second generation ID card system,and more it’s statistics according administrative per day.When the amount is small,the system can be real-time statistic,but when exists a large amount of data,practice shows that if use usual statistic method the system is poor performance.Therefore in this case the paper proposes a new statistic method base on oracle–incremental statistics to improve system performance and to meet the statistical requirements for all level public security staff such as provincial,city,district police station.
出处
《电脑开发与应用》
2013年第5期49-51,共3页
Computer Development & Applications
关键词
增量统计
数据库任务
存储过程
incremental statistics
database task
storage process