Database connection resource management method

A technology for connecting resources and management methods, which is applied in the field of database access, can solve problems such as unstable system operation, system crashes, and system performance degradation, and achieve optimal utilization, correctness, and I/O performance. Effect

Inactive Publication Date: 2006-08-09
HUAWEI TECH CO LTD
View PDF0 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the I / O is significantly increased as the bottleneck of the system performance, the average value and dispersion of the message process delay are significantly increased, and the operating state of the system becomes very unstable.
[0009] To sum up, the database connection allocation mechanism of the existing database connection pool cannot effectively enable all application processes to use the allocated connections to access accurate data. If dirty reading is to be avoided, the system performance will only decrease significantly, and even cause the system to crash

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
  • Database connection resource management method
  • Database connection resource management method
  • Database connection resource management method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0035] The present invention provides a method for managing database connection resources. The main design idea is: when an application process accesses a database through a business process, the database connection pool is one or more applications with logical relationships in the application process allocated to each business process. Process accesses are assigned the same connection object.

[0036] Wherein, the application process attribute can be used to associate the logical relationship between the application processes, so the application processes with the same attribute can be regarded as the application process with the logical relationship. Therefore, the database connection pool should allocate the same connection object for the access of the application process with the same attribute in the application process assigned ...

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 method includes steps (1) after connection pool of database receives accessing request from service process, the method determines connection object corresponding to application flow of having logical relation to the relevant accessing request; (2) assigning connection object determined from step (1) to the service process for accessing. Advantages are: avoiding misreading and guaranteeing performance of database system.

Description

technical field [0001] The invention relates to database access technology, in particular to a management method of database connection resources. Background technique [0002] With the development of computer technology, the scale of data management is getting bigger and bigger, not only the amount of data is increasing sharply, but also the requirements for data sharing are getting higher and higher, so there is a database system for unified, centralized and independent management of all data , making data storage independent of the programs that use the data, enabling data sharing. [0003] At present, large-scale central database systems are widely used in many fields, especially in the field of communication. This large-scale database system needs to process the access of multiple business processes in parallel, and allocate database connection resources for the access of each business process. How to ensure the efficient operation of the database system and the consis...

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 HUAWEI TECH CO 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