轨道交通系统中多客户端连接池动态分配策略

Dynamic Allocation Strategy for Multi-client Connection Pool in Rail Transit System

针对轨道交通集群调度系统中数据库连接池参数一次性设定后不可修改的问题,设计面向多客户端的数据库连接池动态分配策略。通过使用动态分配算法,根据每个客户端访问频率的不同为当前客户端分配最优连接数,从而达到提高系统资源利用率的目的。实验结果表明,该动态分配策略能够缩短连接池响应时间,提高系统运行效率。

In the rail transit clusters dispatch system,the parameters of database connection pool is one-time set and can not be modified. Aiming at this shortage, a dynamic allocation strategy of multi-client database connection pool is designed. It uses a dynamic allocation algorithm to allocate the optimal number of connections according to the different access frequency of each client for current client, so as to achieve the purpose of improving the utilization of system resources. Experimental results show that the dynamic allocation strategy proposed in this paper can shorten the response time of connection pool and improve the efficiency of system.