提高数据库事务处理性能的中间件设计

数据库服务器对于客户端请求都有一个最大的连接数，这限制了数据库事务处理性能，尤其在对一些具有终端操作的事务处理类型的应用，每分钟能处理的事务数不高，表现为TPC-C测试中的tpmC的性能值偏低。本文提出了提高数据库TPC-C测试的tpmC值的两种中间件的策略，在传统的连接池技术的基础上，提出了降低调度柱度，以事务乃至语句——而不是客户端请求——为调度单位的中间件模型，从而可提高数据库的事务处理效率。

The Design of Middleware to Advance the Transaction Processing Performances of the Databases

Each database server sets the max value of the connection number to the users, which restricts the transaction-processing performance of the database server. so that the transaction-processing number by second of these systems is not high,and the value of tpmC in TPC-C test is low. For improving the value of tpmC.this paper is based on the technique of the connection pool,and puts forward two middleware models,which scheduling unit is a transaction or a SQL sentence of client' s requests to advance the transaction-processing performances of the databases.