•   Home
  • Proceedings
  • International Conference on Engineering and Business Managem...

International Conference on Engineering and Business Management (EBM 2010 PAPERBACK)

Chengdu,China,China,3.24-3.26,2010

ISBN: 978-1-935068-05-1 Scientific Research Publishing, USA

Paperback 6066pp Pub. Date: March 2010

Category: Engineering

Price: $280

Title: An Implementation of Connection Pool Independence of Client
Source: International Conference on Engineering and Business Management (EBM 2010 PAPERBACK) (pp 5177-5180)
Author(s): Ke YANG, School of Traffic and Transportation, Beijing Jiaotong University, Beijing, China
Bao-ming HAN, School of Traffic and Transportation, Beijing Jiaotong University, Beijing, China
Zu-ji LI, Beijing Public Transport Holdings, Ltd., Beijing, China
Abstract: Abstract: Database connection is an expensive、rare and important resource in the database system, whether it can be used efficiently can effect the system’s scalability、 stability and performance. Database connection pooling is a technique used for sharing database connections among requesting clients and causing overheads on the database resource. However, it has two limits when using it. On one hand, client applications must use connection pool's API in order to use it. On the other hand, the database connection in the connection pool is not used completely. In this paper, a connection pool without depending on client application is introduced. It can be used without changing a line of the existing code or using its API in a new application, otherwise database connection can be used on the transaction level. The prototype system based on PostgreSQL and the TPC-B performance evaluation present that it can take advantage of the database connection evidently and the database’s performance keeps stable while requesting clients increasing. Database connection Pool can be referred when designing or implementing the database balancer、 database replication engine and database gateway.
Proceedings by Subjects
Resources
Products
Contact us
book@scirp.org
WhatsApp +86 18163351462(WhatsApp)
Click here to send a message to me 1243940697
Book Publishing WeChat
Follow SCIRP
Free SCIRP Newsletters
Copyright © 2006-2024 Scientific Research Publishing Inc. All Rights Reserved.
Top