Connection control method and device for database
A connection control and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as program crash, memory increase, efficiency reduction, etc., to prevent occupation of system memory, improve execution efficiency, and improve usage. The effect of efficiency
Inactive Publication Date: 2012-09-26
SUZHOU CODYY NETWORK SCI & TECH
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, the above method has the following defects: (1) When there are a large number of database operations, the large number of database connections established cannot be released in time, causing memory to rise, and in severe cases, the program will crash; (2) After the database connection is established, it needs to open Connection, it takes a long time to open the connection. When there are a large number of concurrent operations on the database, the execution efficiency of the database will drop significantly; (3) After opening the database connection, the connection is only released after the SQL statement is executed, and the database connection resources are not recycled. lead to reduced efficiency
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0012] Hereinafter, the present invention will be described in detail with reference to the drawings and examples. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.
[0013] figure 1 Shown is a flow chart of the database connection control method provided according to the preferred embodiment of the present invention. Such as figure 1 As shown, the database connection control method provided by the preferred embodiment of the present invention includes steps 101-105. In step 101, the database execution process receives a database data request from the database scheduling process. In step 102, the database execution process determines the type of the database operation request. In step 103, the control process invokes a corresponding number of connections according to the type of the database operation request and the calling strategy, so as to access the corre...
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
Login to View More Abstract
The invention provides a connection control method and a connection control device for a database. The method comprises the following steps that: a database execution process receives a database operation request from a database scheduling process; the database execution process determines the type of the database operation request; a control process calls corresponding number of connection according to the type of the database operation request and a call policy, accesses the corresponding database and performs the database operation request according to the service type of the database operation request; the database execution process releases the connection which is in an open state to a database connection stack for next call after connecting and performing the database operation request; and the control process closes the corresponding number of connection which is in an open state and in the database connection stack according to a close policy.
Description
technical field [0001] The invention belongs to database access technology, in particular to a database connection control method and device. Background technique [0002] Today, a large number of applications need to access the database to obtain the required data. Generally, connections are used in database applications to interact with the database. In practice, a database connection must be established for each application request. The specific method is as follows: firstly, establish the database connection; secondly, open the database connection; thirdly, use the connection to execute the SQL statement; finally, close the database connection and release the database connection resources. [0003] However, the above method has the following defects: (1) When there are a large number of database operations, the large number of database connections established cannot be released in time, causing memory to rise, and in severe cases, the program will crash; (2) After the ...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 胡加明
Owner SUZHOU CODYY NETWORK SCI & TECH