基于存储过程的科研绩效统计分析系统的实现

Stored Procedure-Based Statistic Analysis Approach of Scientific Research Performance and System Implementation

根据存储过程的可移植性、可重用性、安全性和可伸缩性等优势,利用存储过程分析设计一种科研绩效统计分析的计算方法,即将科研绩效统计分析所涉及的计算方法用存储过程来实现;且使整个统计分析计算集中在一起,这样既可以降低用Java类的程序冗余性,也可以提高数据处理速度、用户操作的方便性;这些统计分析功能主要包括绩效成果分配比例分配与报表输出。最后测试表明,随着统计分析的数目增多,采用存储过程的方法比传统方法有明显的优点。

On the basis of advantages of stored procedure such as portability,reusability,security and scalability,employ stored procedure to accomplish a computing approach of scientific research performance of statistic analysis.It can not only reduce redundancy of Java class,but also improve data processing speed and users＇ convenience.The approach＇s function mainly included progress sharing plan and data output.Finally,some data test showed that stored procedure-based approach is more better than bussiness logic-based approach.