| 基于存储过程的累积实现 |
| |
| 引用本文： | 冯舸,王华军,谢羽佳. 基于存储过程的累积实现[J]. 数字通信, 2012, 39(5): 59-61 |
| |
| 作者姓名： | 冯舸 王华军 谢羽佳 |
| |
| 作者单位： | 1. 成都理工大学信息科学与技术学院,成都,610059
2. 西南科技大学,四川绵阳,621010 |
| |
| 摘 要： | 针对大型数据库中传统程序调用速度慢、效率低的问题,提出了采用基于存储过程并采用1位标志位和1个处理日期2个字段来区分增量和全量、实现数据累积的方法.介绍了存储过程的特点,阐述了基于存储过程的数据累计的实现过程.实践证明,该方法明显减少了处理数据的时间,提高了存储的效率和维护的易操作性.
|
| 关 键 词： | 存储过程 数据库 SQL |
| 收稿时间： | 2012-03-09 |
Accumulative realization base on stored procedure |
| |
| FENG Ge,WANG Huajun,XIE Yujia. Accumulative realization base on stored procedure[J]. Digital Communication, 2012, 39(5): 59-61 |
| |
| Authors: | FENG Ge WANG Huajun XIE Yujia |
| |
| Affiliation: | Chengdu University of Technology, Chengdu 610059,P.R.China |
| |
| Abstract: | 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 introduced 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. |
| |
| Keywords: | stored procedure database SQL |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
| 点击此处可从《数字通信》浏览原始摘要信息 |
|
点击此处可从《数字通信》下载全文 |
|
