Management method and management system of database connection

A technology of connection management and connection pool management table, which is applied in the database field to achieve the effect of improving access efficiency

Active Publication Date: 2013-10-23
ALIBABA GRP HLDG LTD
View PDF7 Cites 68 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] This application provides a database connection management method and system to solve the management problem of many connection pool resources

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
  • Management method and management system of database connection
  • Management method and management system of database connection
  • Management method and management system of database connection

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0043] This application proposes a database connection management method, which manages thousands of database connection pools through a unified platform, and the corresponding database access requests enter the unified query entry of the platform, and obtain the connection resources of the memory through this entry, Connect to the target data source according to the connection resource.

[0044] Furthermore, the management method can also reclaim and manage the connections in the memory according to a certain strategy, so as to further improve the hit rate and the overall access efficiency.

[0045] refer to figure 1 As shown in , it is a schematic diagram of the platform described in the embodiment of...

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 management method and a management system of database connection. The method and the system aim at solving the problem of management of multiple connection tank resources. The method comprises the steps that a database access request sent by a client side is received; an operation type and a keyword connected with a target are obtained from content of the request; a connection tank object matched with the keyword connected with the target is queried from a connection tank management table of a memory; the connection resource is obtained from the queried connection tank object; a corresponding database is connected according to the connection resource; connection is recorded to a database connection management table; corresponding database operation is executed according to the operation type; an operation result is returned; a connection resource management table is detected; and the connection is recovered according to detection. According to the method and the system, thousands of connection tank resources can be managed uniformly, and corresponding database connection is uniformly dispatched and controlled by a platform, so that the access efficiency is improved significantly compared with mutually independent management of connection tanks in the prior art.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database connection management method and system. Background technique [0002] Database connections are a critical, limited and expensive resource, especially in multi-user web applications. The management of database connections can significantly affect the scalability and robustness of the entire application, and affect the performance indicators of the program. [0003] In the traditional database connection method, a database connection object corresponds to a physical database connection, and the establishment and closure of a database connection is an operation that consumes system resources for the system. [0004] The database connection pool is proposed for this problem. When the database connection pool is initialized, a certain number of database connections will be created and placed in the connection pool, and the database connection pool is responsi...

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
Inventor 谢宇
Owner ALIBABA GRP HLDG LTD
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