Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Allocation and recovery method of database connections

A database and connection pool technology, applied in database distribution/replication, digital data processing, structured data retrieval, etc., can solve problems such as insufficient utilization of MySQL connection resources and reduced access performance.

Active Publication Date: 2015-07-29
BEIJING JINGDONG 360 DEGREE E COMMERCE CO LTD
View PDF6 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] The purpose of the present invention is to solve the problems existing in the connection pool implementation method of the middleware solution, that is, the insufficient utilization of MySQL connection resources and the reduced access performance

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
  • Allocation and recovery method of database connections
  • Allocation and recovery method of database connections
  • Allocation and recovery method of database connections

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] When the application wants to access the database in the distributed database system, it needs to establish a database connection (database connection), so that the database can be accessed, such as querying, adding, modifying and deleting the data in the database through SQL operations, and in Close the database connection when the operation is complete. For a complex database application, frequent establishment and shutdown of the database will greatly reduce system performance, increase system overhead, and even become a system bottleneck. Database connections become a finite and expensive resource.

[0023] In order to make reasonable use of resources such as database connections, a database connection pool technology has emerged. The basic idea of ​​the connection pool technology is to establish and store the database connection as an object in the memory when the system is initialized. When the application requests to access the database, instead of establishing ...

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 relates to an allocation and recovery method of database connections. According to the allocation and recovery method, a database connection pool is used; the database connection pool comprises a global connection pool and a logical connection pool; the global connection pool comprises queues; the logical connection pool comprises queue corresponding to all databases. According to the invention, the queue structure of two connection pools is used, so that the connection in the sequence corresponding to the least active database or the connection never used can be found rapidly through the global connection pool, and the full utilization of connection resources of all the databases can be ensured.

Description

technical field [0001] The invention relates to a method for allocating and reclaiming database connections. Background technique [0002] With the continuous development of the Internet, the amount of data on the Internet has increased dramatically. Traditional stand-alone databases have faced obvious bottlenecks in processing large-scale data. Major Internet companies have begun to study the implementation of distributed databases. [0003] In the implementation plan of distributed database, it includes the following two categories: one is the client solution, which introduces a new client to process data fragmentation; the other is the introduction of database middleware, which fragments data The processing is done by the middleware, and the application only needs to access the database middleware, and the whole access process is almost the same as accessing the original database. [0004] Among database middleware solutions, there are relatively many solutions for MySQL...

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
IPC IPC(8): G06F17/30
CPCG06F16/24578G06F16/27G06F16/278
Inventor 张成远田琪季锡强
Owner BEIJING JINGDONG 360 DEGREE E COMMERCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com