Method, device and system for managing database connection pool

A management method and database technology, applied in the field of database connection pool management, can solve problems affecting the response speed of application programs and databases, and achieve the effect of saving resources and realizing maintenance

Inactive Publication Date: 2017-10-24
BEIJING UNION VOOLE TECH
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a management method, device and system of a database connection pool, which are used to solve the problem that the application program in the prior art establishes a connection with the shared database connection pool through a protocol or an interface, which affects the application program and the database. The problem of the response speed of the connection between

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method, device and system for managing database connection pool
  • Method, device and system for managing database connection pool
  • Method, device and system for managing database connection pool

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0134] Such as Figure 7 As shown, one of the specific embodiments of the database connection pool management method provided by the embodiment of the present invention includes:

[0135] Step 501: The shared database connection pool component receives a request for database connection sent by an application component in the OSGI framework in a service manner, and the request carries information about the application component's access to the database.

[0136] In step 502, the shared database connection pool component judges whether the database connection pool corresponding to the information that the application component accesses the database is stored in the registry of the shared database connection pool component, if yes, execute step 503; otherwise, execute step 504.

[0137] Step 503: The shared database connection pool component determines the database connection pool corresponding to the information that the application component accesses the database, and allocates the dat...

Embodiment 2

[0142] Such as Figure 8 As shown, one of the specific embodiments of the database connection pool management method provided by the embodiment of the present invention includes:

[0143] Step 601: The shared database connection pool component receives a request for a database connection sent by an application component in the OSGI framework in a service manner, and the request carries the identification of the application component and the information of the application component accessing the database.

[0144] In step 602, the shared database connection pool component judges whether the database connection pool corresponding to the information that the application component accesses the database is stored in the registry of the shared database connection pool component, if yes, execute step 603; otherwise, execute step 604.

[0145] In step 603, the shared database connection pool component determines the database connection pool corresponding to the information that the applicatio...

Embodiment 3

[0151] Such as Picture 10 As shown, the method for maintaining the shared database connection pool component in the database connection pool management method provided by the embodiment of the present invention includes:

[0152] Step 701: The shared database connection pool component judges whether the application component releases the message of the database connection pool corresponding to the information that the application component accesses the database. If yes, execute step 702; otherwise, execute step 701.

[0153] Step 702: The shared database connection pool component parses the identifier of the application component carried in the monitored message.

[0154] Step 703: The shared database connection pool component queries the connection record table for the database access information corresponding to the identifier of the application component according to the parsed identifier of the application component.

[0155] In step 704, the shared database connection pool compon...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method, device and system for managing a database connection pool. The method comprises the following steps: receiving a request for requesting a database connection pool sent by an application component; determining whether a shared database connection pool component stores the database connection pool corresponding to information that the application component accesses the database; if yes, allocating the database connection pool corresponding to the information that the application component accesses the database to the application component; and if not, establishing the database connection pool corresponding to the information that the application component accesses the database in the shared database connection pool component according to the information that the application component accesses the database, and allocating the established database connection pool corresponding to the information that the application component accesses the database to the application component. According to the method, device and system provided by the invention, the speed of accessing the database and the response speed of the connection between the application and the database can be improved.

Description

Technical field [0001] The present invention relates to the technical field of database application, in particular to a method, device and system for managing a database connection pool. Background technique [0002] The database connection pool is used to allocate, manage, and release database connections, and release database connections whose idle time exceeds the maximum idle time to avoid connection omissions caused by not releasing database connections. This technology can significantly improve the performance of database operations. [0003] Generally, multiple database connections are initialized in the database connection pool to wait for application calls. An application retrieves a database connection from the database connection pool each time. At this time, the retrieved database connection cannot be retrieved by other applications. After the application uses the retrieved database connection, the database connection is returned to the database connection pool. When ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/25
Inventor 张彦忠蒋雨含蒋剑锋
Owner BEIJING UNION VOOLE TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap