动态多连接池实现高效地数据库访问  

Using Dynamical Multi-connection Pools to Imporve Database Accessing Performance

作　　者：安红心[1] 徐玉生[1] 

机构地区：[1]兰州大学信息科学与工程学院,兰州730000

出　　处：《微计算机应用》2010年第12期34-41,共8页Microcomputer Applications

摘　　要：连接池技术是实现高效数据库访问的一种重要手段,本文在分析现有连接池技术的基础上,提出了一种真正的动态、多连接池的实现方案。该方案通过多连接池的不同配置,实现严格的访问权限控制;多连接池采取统一管理,发生请求碰撞时,分别在不同的连接池挂起等待,实现多用户并行连接池访问;依据连接池运行的历史数据,作为进一步连接池配置的参数,从而实现连接池配置管理动态化、自动化。在实现动态多连接池管理的同时,也加强了数据库访问的安全控制,同时还实现了异构数据库管理系统(DBMS)的统一访问。实验结果表明,该方案可以有效地的提高数据库访问效率,同时实现数据库的细粒度访问控制。Connection pool is a primary technique to improve pertformanee of database accessing. By analyzing implementations of connection pool, a novel schema was proposed, which can maintain dynamical multi - connection pools configuration automatically. Under this schema, each connection pool has its own configuration parameters, and fined access control can be implemented. All connection pools ware managed by one connection pool manager. When all connections ware all used, a request thread must suspend itself according connection pool The number of paralleled request users was recorded as request log, which was used for dynamical multi - connection pools configuration by connection pool manager. Comprehensive performance experiments study shows that this dynamical multi - connection pools schema can effectively improve performance of database accessing, while has excellent features such as fined access control, hybrid data sources connection, dynamical configuration, etc.

关 键 词：连接池 动态多连接池 异构数据源连接池 数据库安全 细粒度访问控制 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]