Design And Implementation Of Optimization Performance Of Database Middleware

In the Chinese stock quote, trade platform and broker system, it has been forsook that trade in stock exchange, and the mode of concentrative trade is becoming popular with developing internet rapidly and applying relative technology based on multi-layer. When the mode of concentrative trade is used, it becomes important that how to improve database's management capacity and data safety.Middleware is a usual service between platform (including hardware and operating system)and application. This service has standard program interface and protocol. Database middleware can eliminate the difference between different manufacturer or database, and share different data So an enterprise can use the valuable data coming from different periods and different areas. In realizing connection pool of typical database middleware, the performance of accessing database would be improved to a certain extent by pooling and using buffer memory technology, but database will be blocked when the operation becomes high frequent suddenly that the case is due to in traditional database connection pool technology that maximum connections of database connection pool is constant and database connection permission and role is changeable in the field of concentrative trade with sudden high frequent and high concentrative accessing. In this article a database middleware organization and its realization mode is discussed aiming at a stock company's actual requirement in Shenyang city. It optimizes database connection pool strategy and active connection role permission. It realizes database connection dynamic balance and permission transform based on maximum number of connections by using connection pool shrink and balanceable technology and connection role take-over technology. The optimize will make database middleware connection pool to satisfy the demand of sudden high frequent and high concentrative accessing in trade, and it will eliminate capacity bottleneck when visiting database by traditional mode.