管家式自适应数据库连接池及其应用.PDFVIP

2012 年 第 6 卷 第 1 期 南 方 电 网 技 术 开发与应用 2012 ，Vol. 6 ，No. 1 SOUTHERN POWER SYSTEM TECHNOLOGY Development Application 文章编号：1674-0629 (2012)01-0078-05 中图分类号：TP311.131 文献标志码：A 管家式自适应数据库连接池及其应用 1 1 1 1 2 康明光 ，廖胜利 ，程春田 ，马慧芳 ，蔡华祥 （1. 大连理工大学，辽宁 大连116024；2. 云南电力调度中心，昆明650011 ） 摘要：针对常规数据库连接池由于参数静态设置所致适应能力较弱及可扩展性较差等问题，提出和设计了管家式自适应 数据库连接池方案。该方案的管家方式以单例模式和双向链表为基础，通过引入日志动态分析策略和对数据库连接的预 建方式，实现了数据库连接池的自适应。在云南小水电系统的应用表明，该方案比常规连接池更为高效实用。 关键词： 自适应；双向链表；连接池；模式；小水电 The Self-Adaptive Database Connection Pool in a Stewardship Way and Its Application 1 1 1 1 2 KANG Mingguang , LIAO Shengli , CHENG Chuntian , MA Huifang , CAI Huaxiang (1. Dalian University of Technology, Dalian, Liaoning 116024, China; 2. Yunnan Power Dispatching and Communication Center, Kunming 650011, China) Abstract: A self-adaptive scheme on database connection pool in a stewardship way is proposed in this paper because of the poor adaptability and scalability of normal database connection pool which are caused by parameters’ static setting. Based on singleton pattern and doubly linked list, the scheme realizes its self-adaptation by adopting the strategy of log dynamic analysis and pre-built method of database connection. The application in small hydropower system in Yunnan power grid shows that the scheme is more efficient and practical than normal connection pool. Key words: self-adaptive; doubly linked list; connection pool; pattern; small hydrostation 数据库以其强大的数据操作和组织能力，被广 态配置策略使得自适应能力不足。例如连接池的容 泛应用于电力、银行、财务、电子商务等大型应用