CN102722575A - System and method for managing multi-type database connection pool - Google Patents

Abstract

The invention discloses a system and a method for managing a multi-type database connection pool. The management system comprises a database connection pool, a service logic processing unit, a plurality of applications and a plurality of databases, wherein the database connection pool comprises a plurality of sub database connection pools; one application in a plurality of applications submits an actual processing request to the service logic processing unit to carry out processing and the service logic processing unit carries out connection pool object distribution according to received parameters so as to implement the read-write operation on different databases. After the system and the method which are disclosed by the invention are used, an application system can easily implement the cross-platform and cross-database application and the problems of fussy program debugging and correction caused by change of the database type are effectively solved. The unnecessary investment caused by the independence of the applications on the database type is avoided, so that the investment cost is saved.

Description

A kind of multi-type database connection pool management system and management method

Technical field

The invention belongs to computer realm, relate to database connected reference technology, be specifically related to a kind of multi-type database connection pool management system and management method.

Background technology

Along with the computer information technical development; Many application systems integrated platform is used more and more widely; Because each subsystem construction specification disunity makes database can not carry out friendly integration; Can not realize the data base administration between each system, share to import and export by traditional data dealing with, the system complexity that so just further strengthens has increased cost investment.

Summary of the invention

In view of this, fundamental purpose of the present invention is to provide a kind of management system of multi-type database connection resource, can carry out data management to a plurality of distinct type data-bases simultaneously through this system, and effectively solves the data sharing between a plurality of databases.

The present invention specifically discloses a kind of multi-type database connection pool management system; Comprise: database connection pool, business logic processing unit, a plurality of application and a plurality of database; Wherein comprise a plurality of subdata base connection pools in the database connection pool; An application in a plurality of application is submitted to the business logic processing unit with the actual treatment demand and is handled, and the business logic processing unit carries out the connection pool object according to the parameter that receives and distributes the read-write operation of realizing disparate databases.

Wherein, the subdata base connection pool comprises Mssql database connection pool, oracle database connection pool and other database connection pools.

Wherein, give unique connecting object title for each sub-connection pool.

Further, said a plurality of databases are distinct type data-bases, or the same type database.

The invention also discloses above-mentioned management system and carry out the management method of multi-type database connection pool, comprise the steps:

According to business demand initialization data storehouse connection pool configuration file, in the connection pool configuration file, set up a plurality of database configuration informations;

The user submits to the business logic processing unit with the actual treatment demand and handles, and the business logic processing unit carries out the connection pool object according to the parameter that receives and distributes the read-write operation of realizing disparate databases.

Can make easily cross-platform, the integration across database use of realization of application system after using the present invention, efficiently solve owing to change red tape debugging and the correction that type of database causes.Avoid owing to use the unnecessary investment that the dependence to type of database causes, thereby practice thrift cost of investment.Can carry out read-write operation to a plurality of databases simultaneously after using the present invention, effectively separate to many application systems the data sharing problem in integrated.

Description of drawings

Fig. 1: be multi-type database connected reference process flow diagram;

Fig. 2: two types of database connected reference process flow diagrams.

Embodiment

According to accompanying drawing and practical implementation case the present invention is done further explain below.

As shown in Figure 1, multi-type database connection pool management system of the present invention comprises database connection pool, business logic processing unit, a plurality of application and a plurality of database.

According to business demand initialization data storehouse connection pool configuration file; Can set up a plurality of database configuration informations in the connection pool configuration file; Can be a plurality of distinct type data-bases, also can be a plurality of same type databases, and give unique connecting object title for each connection pool disposes.Database connection pool can comprise Mssql database connection pool, oracle database connection pool and other database connection pools etc.

The user submits to the business logic processing unit with the actual treatment demand and handles, and the business logic processing unit carries out the connection pool object according to the parameter that receives and distributes the read-write operation of realizing disparate databases.

Fig. 2 has specifically illustrated two types of database connected reference process flow diagrams as a kind of embodiment:

Two connection pools of initialization--connection pool 1 (connection of mssql database) and connection pool 2 (the mysql database is connected);

The application 1 database 1 that need conduct interviews; Application 1 is submitted to the business logic processing unit and is handled application; By the business logic processing unit through judging 1 (connections of mssql database) of identification distribution database connection pool) the mssql data 1 that conduct interviews, realization is to the read-write operation of mssql database 1;

The application 2 database 2 that need conduct interviews, application 2 are submitted to the business logic processing unit and are handled application, through judging the identification distribution database connection pool 2 mysql database 2 that conducts interviews, realize the read-write operation to the mysql database by business logic processing.

Claims (6)

1. multi-type database connection pool management system; It is characterized in that; Comprise: database connection pool, business logic processing unit, a plurality of application and a plurality of database; Wherein comprise a plurality of subdata base connection pools in the database connection pool, an application in a plurality of application is submitted to the business logic processing unit with the actual treatment demand and is handled, and the business logic processing unit carries out the connection pool object according to the parameter that receives and distributes the read-write operation of realizing disparate databases.

2. management system according to claim 1 is characterized in that: the subdata base connection pool comprises Mssql database connection pool, oracle database connection pool and other database connection pools.

3. management system according to claim 2 is characterized in that: for each sub-connection pool is given unique connecting object title.

4. according to each described management system of claim 1-3, it is characterized in that: said a plurality of databases are distinct type data-bases, or the same type database.

5. the management system in the employing claim 1 is carried out the management method of multi-type database connection pool, it is characterized in that:

According to business demand initialization data storehouse connection pool configuration file, in the connection pool configuration file, set up a plurality of database configuration informations;

The user submits to the business logic processing unit with the actual treatment demand and handles, and the business logic processing unit carries out the connection pool object according to the parameter that receives and distributes the read-write operation of realizing disparate databases.

6. management method according to claim 5 is characterized in that: said a plurality of databases are distinct type data-bases, or the same type database.

Images