CN102243654A - Method and device for controlling and managing database connections - Google Patents
Method and device for controlling and managing database connections Download PDFInfo
- Publication number
- CN102243654A CN102243654A CN 201110161306 CN201110161306A CN102243654A CN 102243654 A CN102243654 A CN 102243654A CN 201110161306 CN201110161306 CN 201110161306 CN 201110161306 A CN201110161306 A CN 201110161306A CN 102243654 A CN102243654 A CN 102243654A
- Authority
- CN
- China
- Prior art keywords
- database
- connection
- storehouse
- open mode
- connect
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention provides a method and device for controlling and managing database connections. A database scheduling program receives a database operation request from a service logic program, and sends the database operation request to a corresponding database execution program according to the priority of the service type of the database operation request and the mapping relationship between the service type and the database execution program; the corresponding database execution program receives the database operation request from the database scheduling program, and judges the type of the database operation request; a control program calls a corresponding number of connections according to the type of the database operation request and a call policy so as to access corresponding databases to execute the database operation request according to the service type of the database operation request; after executing the database operation request through the connections, the database execution program puts the connections in the open state back to a database connection stack for next calling; and the control program closes the corresponding number of connections in the open state in the database connection stack according to a closing policy.
Description
Technical field
The invention belongs to database access technology, relate in particular to a kind of connection control and management method and device of database.
Background technology
Nowadays, extensive application needs accessing database to obtain needed data.General in the application of database, use connect carry out and database between mutual.In actual conditions, application request all will be set up a database connection each time.Specific practice is as follows: at first, set up database and connect; Secondly, opening database connects; Once more, use this connection to carry out SQL statement; At last, closing database connects, and discharges database connection resource.
Yet there is following defective in above-mentioned way: when operated as the mass data storehouse (1), the connection of the mass data storehouse of foundation can not get timely release, caused internal memory to rise, and can make program crashing when serious; (2) set up database and connect after, need open connection, open and connect consuming time longlyer, when the concurrent operations of mass data storehouse, can cause database to carry out efficient and decline to a great extent; (3) open database and connect after, execute SQL statement and only will connect release, database connection resource does not obtain recycling, causes the efficient reduction.
In addition, there is following shortcoming in general distributed database server: the service that (1) each database provides is the same, does not provide the diversity service according to database pressure and service logic needs; (2) the database scheduler module is not considered the priority of database manipulation only according to the pressure condition distribution services of database service.
Summary of the invention
The invention provides a kind of database connection control and management method and the device to address the above problem.
The invention provides a kind of connection control and management method of database, may further comprise the steps.The database dispatching process receives the database manipulation request from professional logical process, and with the mapping relations of database executive process the database manipulation request is sent to corresponding database executive process according to the priority and the type of service of the type of service of database manipulation request.Corresponding database executive process receives the database manipulation request from the database dispatching process, and the type of judgment data storehouse operation requests.The connection that the control process is called respective number according to the type and the regulative strategy of database manipulation request is to carry out the database operation requests according to the corresponding database of the type of service visit of database manipulation request.After connecting execution database operation requests, the connection that the database executive process will be in open mode is returned to database connection storehouse, for call next time.The control process connects the connection that is in open mode of respective number in the storehouse according to the shutdown strategy closing database.
The present invention also provides a kind of connection control management device of database, comprises scheduler module, receiver module, judge module, connection management module and control module.Scheduler module is used for receiving the database manipulation request from professional logical process.Receiver module links to each other with scheduler module.Scheduler module is sent to corresponding receiver module with the mapping relations of database executive process with the database manipulation request according to the priority and the type of service of the type of service of database manipulation request.Judge module links to each other with receiver module, is used for the type of judgment data storehouse operation requests.The connection management module links to each other with judge module.Control module links to each other with the connection management module, is used for the connection that type and regulative strategy according to the database manipulation request call respective number, to carry out the database operation requests according to the corresponding database of the type of service visit of database manipulation request.After connecting execution database operation requests, the connection that the connection management module is used for being in open mode is returned to database connection storehouse, for call next time, control module connects the connection that is in open mode of respective number in the storehouse according to the shutdown strategy closing database.
Compared to prior art, according to the connection control and management method and the device of database provided by the invention, connect according to the corresponding database of the type of service visit of database manipulation request and carry out the database operation requests, carry out efficient thereby improve database.In addition, the database dispatching process is sent to corresponding database executive process with the mapping relations of database executive process with the database manipulation request according to the priority and the type of service of the type of service of database manipulation request, so, help balancing the load, thereby improve the whole efficient of carrying out of database.In addition, controlling database according to regulative strategy and shutdown strategy by the control process connects opening of connecting in the storehouse and calls and close, thereby improves the utilization factor that connects.In addition, connect recycling of storehouse fulfillment database connection, prevent to set up the multiple database connection simultaneously and take Installed System Memory by database.And after connecting execution database operation requests, the connection that is in open mode will be returned to database and connect storehouse.So, the connection that can be recycled and opened, thus improve the service efficiency that connects.In addition, call the connection that is connected with its corresponding database in the storehouse, so, database manipulation is separated, improve database and carry out efficient according to the type of database manipulation request.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
Figure 1 shows that the process flow diagram of the connection control and management method of the database that preferred embodiment according to the present invention provides;
Figure 2 shows that the process flow diagram of the connection control and management method of the database that preferred embodiment according to the present invention provides;
Figure 3 shows that the synoptic diagram of the connection control management device of the database that preferred embodiment according to the present invention provides.
Embodiment
Hereinafter will describe the present invention with reference to the accompanying drawings and in conjunction with the embodiments in detail.Need to prove that under the situation of not conflicting, embodiment and the feature among the embodiment among the application can make up mutually.
Figure 1 shows that the process flow diagram of the connection control and management method of the database that preferred embodiment according to the present invention provides.As shown in Figure 1, the connection control and management method of the database that provides of preferred embodiment of the present invention comprises step 101～105.In step 101, the database dispatching process receives the database data request from professional logical process, and with the mapping relations of database executive process the database manipulation request is sent to corresponding database executive process according to the priority and the type of service of the type of service of database manipulation request.In step 102, corresponding database executive process receives the database manipulation request from the database dispatching process, and the type of judgment data storehouse operation requests.In step 103, the connection that the control process is called respective number according to the type and the regulative strategy of database manipulation request is to carry out the database operation requests according to the corresponding database of the type of service visit of database manipulation request.In step 104, after connecting execution database operation requests, the connection that the database executive process will be in open mode is returned to database connection storehouse, for call next time.In step 105, the control process connects the connection that is in open mode of respective number in the storehouse according to the shutdown strategy closing database.
Wherein, shutdown strategy is: when the linking number of carrying out the database operation requests in database connects storehouse is less than or equal to preset value with the ratio that is in the linking number of open mode, connect the unnecessary connection that is in open mode in the storehouse according to default number percent closing database.Regulative strategy comprises: be less than or equal to database in the number of current database operation requests and connect and be in open mode in the storehouse but not during the number of the connection of executable operations, that calls that database connects respective number in the storehouse is in open mode but the not connection of executable operations; In the number of current database operation requests greater than database connect be in open mode in the storehouse but not the number of the connection of executable operations and be less than or equal to database connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call database and connect in the storehouse and be in open mode but the not connection of executable operations, and open and call the connection that is in closed condition that described database connects respective number in the storehouse; In the number of current database operation requests greater than database connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call in the database connection storehouse and be in open mode but the not connection of executable operations, open and call described database and connect the connection that all is in closed condition in the storehouse, and call other databases and connect vacant available connection in storehouses, if described vacant available connection is in closed condition, then open and call described vacant available connection.
Following said process is elaborated.Please refer to Fig. 2.Figure 2 shows that the process flow diagram of the control and management method of the database connection that preferred embodiment according to the present invention provides.As shown in Figure 2, the control and management method that connects of the database that provides of present embodiment comprises step 201～206.In step 201, the database dispatching process receives the database manipulation request from professional logical process.
In step 202, the database dispatching process is sent to corresponding database executive process with the mapping relations of database executive process with the database manipulation request according to the priority and the type of service of the type of service of database manipulation request.In this, the type of service of database manipulation request comprises subscriber information management, information off-line management and chat message management.Yet the present invention does not limit this.In practical application, other type of service can be set as required.
Particularly, after the database dispatching process receives the database manipulation request,, adopt the execution sequence of task queue management database operation requests according to the priority of the type of service of database manipulation request.In this, preferentially carry out type of service priority higher data storehouse operation requests.For example, the priority of subscriber information management is higher than information off-line management and chat message management, the priority of information off-line management is higher than the chat message management, at this moment, to the operation of subscriber information management (for example, inquiry or modification) priority processing, then, the operation of information off-line management and chat message management is carried out successively.
In addition, the database dispatching process is sent to corresponding database executive process with the mapping relations of database executive process with the database manipulation request according to type of service.For example, if about the type of service of subscriber information management corresponding to database executive process 1, about the type of service of information off-line management corresponding to database executive process 2, about the type of service of chat message management corresponding to database executive process 3, priority in conjunction with above-mentioned type of service, then the database dispatching process preferentially is sent to database executive process 1 with the database manipulation request of relevant subscriber information management, the database manipulation request of successively relevant information off-line being managed is sent to database executive process 2 then, and the database manipulation request that relevant chat message is managed is sent to database executive process 3.
In step 203, the type of judgment data storehouse operation requests after the request of database executive process reception database manipulation.In this, the type of database manipulation request comprises inquiry, increase, deletion and revises.Yet the present invention is not limited thereto.
Particularly, after the database executive process receives the database manipulation request, at first task queue is put in the database manipulation request that receives.Then, the database executive process is according to the database manipulation request of task queue scheduling, the type of judgment data storehouse operation requests.Yet the present invention is not limited thereto.In other embodiment, the database executive process receive after the database manipulation request can first judgment data storehouse operation requests type, then, different task queues is put in the database manipulation request, for follow-up execution according to the type of database manipulation request.
Next, be that example is elaborated with the query manipulation, the execution of other operations is identical with the execution of query manipulation, so repeat no more in this.In present embodiment, according to the type of database manipulation request, its corresponding database is at first called in different database manipulation requests connect connection in storehouse, to carry out described database manipulation request, carry out efficient thereby improve database.
In step 204, the connection that the control process is called respective number according to regulative strategy is to carry out the data base querying request according to the corresponding database of the type of service visit of data base querying request.Wherein, regulative strategy comprises following three aspects.
Being less than or equal to data base querying in the number of current database query requests connects and is in open mode in the storehouse but not during the number of the connection of executable operations, call interior the described of respective number of data base querying connection storehouse and be in open mode but the not connection of executable operations, to carry out the current database query requests.For example, if the current database query requests has 5, data base querying just connects in the storehouse, and the linking number in executable operations is 4, it is 10 that data base querying connects the linking number of having opened in the storehouse, then calls interior 5 connections of having opened of data base querying connection storehouse and carries out the request of current 5 data library inquiries.
In the number of current database query requests greater than data base querying connect be in open mode in the storehouse but not the number of the connection of executable operations and be less than or equal to data base querying connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call data base querying and connect in the storehouse and be in open mode but the not connection of executable operations, and open and call the connection that is in closed condition that data base querying connects respective number in the storehouse.For example, if the current database query requests has 10, data base querying connects the connection that is provided with in the storehouse and adds up to 20, the linking number of having opened is 10, just the linking number in executable operations is 4, then call interior 6 of data base querying connection storehouse and be in open mode but the not connection of executable operations, and open and call 4 connections that are in closed condition.
In the number of current database query requests greater than data base querying connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that closed condition is connected, call in the data base querying connection storehouse and be in open mode but the not connection of executable operations, open and call data base querying and connect the connection that all is in closed condition in the storehouse, and (for example call other databases connection storehouses, the database deletion connects storehouse, database update connects storehouse, database increases the connection storehouse) interior vacant available connection, if described vacant available connection is in closed condition, then open and call described vacant available connection.For example, if the current database query requests has 10, data base querying connects the connection that is provided with in the storehouse and adds up to 20, the linking number of having opened is 18, just the linking number in executable operations is 15, then call interior 3 of data base querying connection storehouse and be in open mode but the not connection of executable operations, open and call 2 connections that are in closed condition, and call 5 vacant available connections in the database update connection storehouse.
The process that connects the vacant available connection in the storehouse about other databases of control process transfer is that example is described as follows with database update connection storehouse.Control process lock database is revised and is connected storehouse, and calls the vacant available connection that database update connects respective number in the storehouse.Remove the locking of database update connection storehouse in the control process after, the data base querying request of respective number is carried out in above-mentioned vacant available connection.Wherein, if above-mentioned vacant available connection is in open mode, then directly calls above-mentioned vacant available connection and carry out the data base querying request; If above-mentioned vacant available connection is in closed condition, then need opens above-mentioned connection earlier and carry out the data base querying request again.
In addition, below specify the process that connects in the step 204 according to the corresponding database execution data base querying request of the type of service visit of data base querying request.For example, the type of service of data base querying request comprises user profile inquiry, information off-line inquiry and chat message inquiry.Correspondingly, database comprises User Information Database, information off-line database and chat message database.When the type of service of data base querying request was the user profile inquiry, the connected reference user information corresponding database of control process transfer was with searching user's information; When the type of service of data base querying request is the information off-line inquiry, the information off-line database of the connected reference correspondence of control process transfer; When the type of service of data base querying request is the chat message inquiry, the chat message database of the connected reference correspondence of control process transfer.In this, the addressable different database of connection of control process transfer.Yet the present invention is not limited thereto.In other embodiment, the connection of control process transfer can be set to visit the database of corresponding types according to the type of service of database manipulation request.
In step 205, after connecting the request of execution data base querying, the connection that the database executive process will be in open mode is returned to database connection storehouse, for call next time.In this, when the connection when the data base querying request connects storehouse by data base querying in was carried out, will the be finished connection that is in open mode of database executive process all was returned to data base querying and connects storehouse.When the data base querying request was connected storehouse and database update and connects connection in the storehouse and carry out jointly by data base querying, the connection that the database executive process can be in open mode with being finished was returned in data base querying connects storehouse or data base querying connects storehouse and database update is connected storehouse.Yet the present invention does not limit this.Wherein it should be noted that, when the database executive process will be finished the connection that is in open mode when being returned to database update and connecting storehouse, need first lock database to revise and connect storehouse, and after putting back to connection, remove the locking that database update is connected storehouse.
So, the connection that database connects in the storehouse can be recycled, thereby increases operation rate.And in a single day connection is in open mode after being opened always, opens the spent time thereby saved dramatically to connect, and has improved the execution efficient of database.
In step 206, the control process is according to the connection that is in open mode of respective number in the shutdown strategy closing database inquiry connection storehouse.Wherein, shutdown strategy specifically describes as follows.The linking number of carrying out the database operation requests in data base querying connects storehouse (for example is less than or equal to preset value with the ratio that is in the linking number of open mode, 70%) time, connect the unnecessary connection that is in open mode in the storehouse according to default number percent (for example, 80%) closing database inquiry.The number of the connection that is in open mode that wherein, need close equal to be in open mode connection number with just at the difference of the number that is connected of executable operations product with default number percent.For example, if it is 60 that data base querying connects the linking number of carrying out the database operation requests in the storehouse, it is 100 that data base querying connects the linking number that is in open mode in the storehouse, both ratio then connects 32 connections that are in open mode in the storehouse according to default number percent (80%) closing database inquiry less than preset value (70%).In practical application, if the number of the connection that is in open mode that the needs that process calculates are closed not is to be integer, the above-mentioned number that then will calculate rounds in the mode that rounds up, with the number of the definite connection that is in open mode that need close.For example, if it is 65 that data base querying connects the linking number of carrying out the database operation requests in the storehouse, it is 100 that data base querying connects the linking number that is in open mode in the storehouse, both ratio is less than preset value (70%), then connect the connection that storehouse interior 26 (actual computation numerical value is 26.25, and round is 26) is in open mode according to default number percent (75%) closing database inquiry.
In addition, in present embodiment, the control process is opened to call and be can be real-time control what connect, the closing control that connects be can be real-time control also can be timing controlled.For example, control process connected the connection that is in open mode of respective number in the storehouse according to the shutdown strategy closing database every 30 minutes.Yet the present invention does not do any qualification to this.
Figure 3 shows that the synoptic diagram of the connection control management device of the database that preferred embodiment provides according to the present invention.As shown in Figure 3, the connection control management device of the database that provides of present embodiment comprises scheduler module 300, receiver module 301, judge module 302, connection management module 303 and control module 304.Wherein, scheduler module 300 links to each other with receiver module 301, and judge module 302 links to each other with receiver module 301, and connection management module 303 links to each other with judge module 302, and control module 304 links to each other with connection management module 303.Yet the present invention is not limited thereto.
In present embodiment, scheduler module 300 is used for receiving the database manipulation request from professional logical process, and with the mapping relations of database executive process the database manipulation request is sent to corresponding receiver module 301 according to the priority and the type of service of the type of service of database manipulation request.Receiver module 301 is used for receiving the database manipulation request from scheduler module 300.Judge module 302 is used to judge the type of the database manipulation request that receives.Control module 304 is used for the connection of calling respective number according to the type of database manipulation request and regulative strategy, to carry out the database operation requests according to the corresponding database of the type of service visit of logarithmic data storehouse operation requests.After connecting execution database operation requests, the connection that connection management module 303 will be in open mode is returned to database connection storehouse, for call next time.Control module 304 connects the connection that is in open mode of respective number in the storehouse according to the shutdown strategy closing database.Detailed process is ditto described, so repeat no more in this.
In sum, the connection control and management method and the device of the database that preferred embodiment provides according to the present invention connect according to the corresponding database of the type of service visit of database manipulation request and carry out the database operation requests, carry out efficient thereby improve database.In addition, the database dispatching process is sent to corresponding database executive process with the mapping relations of database executive process with the database manipulation request according to the priority and the type of service of the type of service of database manipulation request, so, help balancing the load, thereby improve the whole efficient of carrying out of database.In addition, controlling database according to regulative strategy and shutdown strategy by the control process connects opening of connecting in the storehouse and calls and close, thereby improves the utilization factor that connects.In addition, connect recycling of storehouse fulfillment database connection, prevent to set up the multiple database connection simultaneously and take Installed System Memory by database.And after connecting execution database operation requests, the connection that is in open mode is returned to database and connects storehouse.So, the connection that can be recycled and opened, thus improve the service efficiency that connects.In addition, call the connection that is connected with its corresponding database in the storehouse, so, database manipulation is separated, improve database and carry out efficient according to the type of database manipulation request.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the connection control and management method of a database is characterized in that, may further comprise the steps:
The database dispatching process receives the database manipulation request from professional logical process, and with the mapping relations of database executive process described database manipulation request is sent to corresponding database executive process according to the priority and the type of service of the type of service of database manipulation request;
The database executive process of described correspondence receives the database manipulation request from described database dispatching process, and judges the type of described database manipulation request;
The connection that the control process is called respective number according to the type and the regulative strategy of described database manipulation request is carried out described database manipulation request with the corresponding database of type of service visit according to the database manipulation request;
After described database manipulation request was carried out in described connection, described database executive process was returned to database with the described connection that is in open mode and connects storehouse, for call next time;
Described control process is closed the connection that is in open mode that described database connects respective number in the storehouse according to shutdown strategy.
2. the connection control and management method of database according to claim 1, it is characterized in that, described shutdown strategy is: when the linking number of carrying out the database operation requests in database connects storehouse is less than or equal to preset value with the ratio that is in the linking number of open mode, connect the unnecessary connection that is in open mode in the storehouse according to default number percent closing database.
3. the connection control and management method of database according to claim 1, it is characterized in that, described regulative strategy comprises: be less than or equal to database in the number of current database operation requests and connect and be in open mode in the storehouse but not during the number of the connection of executable operations, call database and connect that the described of respective number is in open mode but the not connection of executable operations in the storehouse; In the number of current database operation requests greater than database connect be in open mode in the storehouse but not the number of the connection of executable operations and be less than or equal to database connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call described database and connect in the storehouse and be in open mode but the not connection of executable operations, and open and call the connection that is in closed condition that described database connects respective number in the storehouse; In the number of current database operation requests greater than database connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call in the described database connection storehouse and be in open mode but the not connection of executable operations, open and call described database and connect the connection that all is in closed condition in the storehouse, and call other databases and connect vacant available connection in storehouses, if described vacant available connection is in closed condition, then open and call described vacant available connection.
4. the connection control and management method of database according to claim 1 is characterized in that, described type of service comprises subscriber information management, information off-line management and chat message management.
5. the connection control and management method of database according to claim 1, it is characterized in that, the type of described database manipulation request comprises inquiry, increase, deletion and revises that described database connects storehouse and comprises that data base querying connection storehouse, database increase connect storehouse, the database deletion connects storehouse and database update connection storehouse.
6. the connection control management device of a database is characterized in that, comprising:
Scheduler module is used for receiving the database manipulation request from professional logical process;
Receiver module links to each other with described scheduler module, and described scheduler module is sent to corresponding receiver module with the mapping relations of database executive process with described database manipulation request according to the priority and the type of service of the type of service of database manipulation request;
Judge module links to each other with described receiver module, is used to judge the type of described database manipulation request;
The connection management module links to each other with described judge module;
Control module, link to each other with described connection management module, be used for the connection that type and regulative strategy according to described database manipulation request call respective number, carry out described database manipulation request with the corresponding database of type of service visit according to the database manipulation request, after described database manipulation request is carried out in described connection, described connection management module is returned to database with the described connection that is in open mode and connects storehouse, for call next time, described control module is closed the connection that is in open mode that described database connects respective number in the storehouse according to shutdown strategy.
7. the connection control management device of database according to claim 6, it is characterized in that, described shutdown strategy is: when the linking number of carrying out the database operation requests in database connects storehouse is less than or equal to preset value with the ratio that is in the linking number of open mode, connect the unnecessary connection that is in open mode in the storehouse according to default number percent closing database.
8. the connection control management device of database according to claim 6, it is characterized in that, described regulative strategy comprises: be less than or equal to database in the number of current database operation requests and connect and be in open mode in the storehouse but not during the number of the connection of executable operations, call database and connect that the described of respective number is in open mode but the not connection of executable operations in the storehouse; In the number of current database operation requests greater than database connect be in open mode in the storehouse but not the number of the connection of executable operations and be less than or equal to database connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call described database and connect in the storehouse and be in open mode but the not connection of executable operations, and open and call the connection that is in closed condition that described database connects respective number in the storehouse; In the number of current database operation requests greater than database connect be in open mode in the storehouse but not the number of the connection of executable operations when being in the number sum that is connected of closed condition, call in the described database connection storehouse and be in open mode but the not connection of executable operations, open and call described database and connect the connection that all is in closed condition in the storehouse, and call other databases and connect vacant available connection in storehouses, if described vacant available connection is in closed condition, then open and call described vacant available connection.
9. the connection control management device of database according to claim 6 is characterized in that, described type of service comprises subscriber information management, information off-line management and chat message management.
10. the connection control management device of database according to claim 6, it is characterized in that, the type of described database manipulation request comprises inquiry, increase, deletion and revises that described database connects storehouse and comprises that data base querying connection storehouse, database increase connect storehouse, the database deletion connects storehouse and database update connection storehouse.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101613061A CN102243654B (en) | 2011-06-16 | 2011-06-16 | Method and device for controlling and managing database connections |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101613061A CN102243654B (en) | 2011-06-16 | 2011-06-16 | Method and device for controlling and managing database connections |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102243654A true CN102243654A (en) | 2011-11-16 |
| CN102243654B CN102243654B (en) | 2012-07-18 |
Family
ID=44961709
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011101613061A Expired - Fee Related CN102243654B (en) | 2011-06-16 | 2011-06-16 | Method and device for controlling and managing database connections |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102243654B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106156185A (en) * | 2015-04-20 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of service request performs the querying method of state, Apparatus and system |
| CN110012075A (en) * | 2019-03-12 | 2019-07-12 | 平安科技（深圳）有限公司 | Data transmission method and relevant device |
| CN115858551A (en) * | 2023-01-31 | 2023-03-28 | 天津南大通用数据技术股份有限公司 | LDAP-based memory management method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1815469A (en) * | 2005-02-01 | 2006-08-09 | 华为技术有限公司 | Database connection resource management method |
| US20070260542A1 (en) * | 2006-05-08 | 2007-11-08 | Kinghood Technology Co., Ltd. | Distributed transaction processing system and method thereof |
| CN101408899A (en) * | 2008-11-21 | 2009-04-15 | 北京中企开源信息技术有限公司 | Method and apparatus for switching website multiple data sources |
| CN101916298A (en) * | 2010-08-31 | 2010-12-15 | 深圳市赫迪威信息技术有限公司 | Database operation method, apparatus and system |
-
2011
- 2011-06-16 CN CN2011101613061A patent/CN102243654B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1815469A (en) * | 2005-02-01 | 2006-08-09 | 华为技术有限公司 | Database connection resource management method |
| US20070260542A1 (en) * | 2006-05-08 | 2007-11-08 | Kinghood Technology Co., Ltd. | Distributed transaction processing system and method thereof |
| CN101408899A (en) * | 2008-11-21 | 2009-04-15 | 北京中企开源信息技术有限公司 | Method and apparatus for switching website multiple data sources |
| CN101916298A (en) * | 2010-08-31 | 2010-12-15 | 深圳市赫迪威信息技术有限公司 | Database operation method, apparatus and system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106156185A (en) * | 2015-04-20 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of service request performs the querying method of state, Apparatus and system |
| CN106156185B (en) * | 2015-04-20 | 2019-12-13 | 阿里巴巴集团控股有限公司 | Method, device and system for inquiring service request execution state |
| CN110012075A (en) * | 2019-03-12 | 2019-07-12 | 平安科技（深圳）有限公司 | Data transmission method and relevant device |
| CN110012075B (en) * | 2019-03-12 | 2022-02-18 | 平安科技（深圳）有限公司 | Data transmission method and related equipment |
| CN115858551A (en) * | 2023-01-31 | 2023-03-28 | 天津南大通用数据技术股份有限公司 | LDAP-based memory management method, device, equipment and storage medium |
| CN115858551B (en) * | 2023-01-31 | 2023-11-14 | 天津南大通用数据技术股份有限公司 | Memory management method, device, equipment and storage medium based on LDAP |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102243654B (en) | 2012-07-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102243597B (en) | Method and device for controlling and managing database connections | |
| CN102243655B (en) | Method and device for managing database connections | |
| CN102243653B (en) | Method and device for managing database connections | |
| CN101360309B (en) | Execution method, apparatus and system for service open command | |
| US20060206894A1 (en) | Method of scheduling jobs using database management system for real-time processing | |
| US5999916A (en) | No-reset option in a batch billing system | |
| US20080306950A1 (en) | Arrival rate throttles for workload management | |
| US8042119B2 (en) | States matrix for workload management simplification | |
| CN102081554A (en) | Cloud computing operating system as well as kernel control system and method thereof | |
| CN110383764A (en) | The system and method for usage history data processing event in serverless backup system | |
| CN109840144B (en) | Information service scheduling method and system for cross-mechanism batch service request | |
| CN108874903A (en) | Method for reading data, device, computer equipment and computer readable storage medium | |
| CN105159736A (en) | Establishment method of SaaS software deployment scheme supporting performance analysis | |
| US6556996B1 (en) | Service package application and a service activation manager for use with a service control point in an advanced intelligent network | |
| EP2437527B1 (en) | Method and device for implementing intelligent group service of mobile virtual private network | |
| CN102243654B (en) | Method and device for controlling and managing database connections | |
| CN102243652B (en) | Database connection management method and device | |
| CN111427608B (en) | Gray scale release method for bank core system | |
| CN102243651B (en) | Database connection control management method and device | |
| CN105975614B (en) | Cluster configuration device, and method and device for updating data | |
| CN112748997A (en) | Workflow scheduling method and system | |
| JPH10502221A (en) | Mobility in telecommunications networks | |
| US11917505B2 (en) | Methods and systems for provisioning rate plan features in a wireless communication network | |
| CN102262655B (en) | Connection control method and device for database | |
| CN101754156A (en) | Office data management method, device and charging system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Suzhou City, Jiangsu province 215121 Fengting Avenue Suzhou Industrial Park No. 666 Weiting Intelligent Industrial Park Building 8 Patentee after: Kuo Di education and science company limited Address before: Suzhou City, Jiangsu province 215121 Fengting Avenue Suzhou Industrial Park No. 666 Weiting Intelligent Industrial Park Building 8 Patentee before: Suzhou Kuodi Network Technology Co., Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120718 Termination date: 20180616 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |