基于存储过程的累积实现

Accumulative realization base on stored procedure

针对大型数据库中传统程序调用速度慢、效率低的问题,提出了采用基于存储过程并采用1位标志位和1个处理日期2个字段来区分增量和全量、实现数据累积的方法。介绍了存储过程的特点,阐述了基于存储过程的数据累计的实现过程。实践证明,该方法明显减少了处理数据的时间,提高了存储的效率和维护的易操作性。

Aiming at the traditional program invocation calls＇ being slow and inefficient, we adopt storage process and use a sign and a processing date to distinguish increment and total content, so as to realize the accumulation of data. We have in- troduced some characteristics of the process of storage briefly, and expounded realizing the accumulation of data based on the storage process. The method has an advantage ： it decreases time of processing data, thereby, improves the efficiency of the store and the operability of maintaining.