CN102243597A - Method and device for controlling and managing database connections - Google Patents
Method and device for controlling and managing database connections Download PDFInfo
- Publication number
- CN102243597A CN102243597A CN 201110161290 CN201110161290A CN102243597A CN 102243597 A CN102243597 A CN 102243597A CN 201110161290 CN201110161290 CN 201110161290 CN 201110161290 A CN201110161290 A CN 201110161290A CN 102243597 A CN102243597 A CN 102243597A
- Authority
- CN
- China
- Prior art keywords
- database
- connection
- storehouse
- connects
- open mode
- 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. The method comprises the steps as follows: 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 execute 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 control and management method and device that a kind of database connects.
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 control and management method that a kind of database connects and device to address the above problem.
The invention provides the control and management method that a kind of database connects, 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.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 control management device that the present invention also provides a kind of database to connect 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.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, control and management method and device according to database connection provided by the invention, 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 control and management method of the database connection that preferred embodiment according to the present invention provides;
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;
Figure 3 shows that the synoptic diagram of the control management device of the database connection 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 control and management method of the database connection that preferred embodiment according to the present invention provides.As shown in Figure 1, the control and management method that connects 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.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.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 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 control management device of the database connection that preferred embodiment provides according to the present invention.As shown in Figure 3, the control management device that connects 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.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, control and management method and device that the database that preferred embodiment provides according to the present invention connects, 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 control and management method that database connects 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 to carry out described 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 control and management method that database according to claim 1 connects, 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 control and management method that database according to claim 1 connects, 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 control and management method that database according to claim 1 connects is characterized in that, described type of service comprises subscriber information management, information off-line management and chat message management.
5. the control and management method that database according to claim 1 connects, 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 control management device that database connects 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, to carry out described 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 control management device that database according to claim 6 connects, 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 control management device that database according to claim 6 connects, 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 control management device that database according to claim 6 connects is characterized in that, described type of service comprises subscriber information management, information off-line management and chat message management.
10. the control management device that database according to claim 6 connects, 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 |
|---|---|---|---|
| CN2011101612904A CN102243597B (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 |
|---|---|---|---|
| CN2011101612904A CN102243597B (en) | 2011-06-16 | 2011-06-16 | Method and device for controlling and managing database connections |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102243597A true CN102243597A (en) | 2011-11-16 |
| CN102243597B CN102243597B (en) | 2012-08-22 |
Family
ID=44961668
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011101612904A Expired - Fee Related CN102243597B (en) | 2011-06-16 | 2011-06-16 | Method and device for controlling and managing database connections |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102243597B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103530314A (en) * | 2013-07-26 | 2014-01-22 | 苏州亿倍信息技术有限公司 | Data processing method and system |
| CN104052677A (en) * | 2013-03-14 | 2014-09-17 | 阿里巴巴集团控股有限公司 | Soft load balancing method and apparatus of single data source |
| WO2015010411A1 (en) * | 2013-07-26 | 2015-01-29 | 苏州亿倍信息技术有限公司 | Data access processing method and system |
| CN107301190A (en) * | 2016-04-15 | 2017-10-27 | 中国移动通信集团湖北有限公司 | The method and device that a kind of control data is accessed |
| CN107688607A (en) * | 2017-07-26 | 2018-02-13 | 努比亚技术有限公司 | The method and mobile terminal of a kind of database access, computer-readable recording medium |
| CN108834087A (en) * | 2018-07-03 | 2018-11-16 | 平安科技（深圳）有限公司 | Note transmission method, device, computer equipment and storage medium |
Citations (3)
| 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 |
-
2011
- 2011-06-16 CN CN2011101612904A patent/CN102243597B/en not_active Expired - Fee Related
Patent Citations (3)
| 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 |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104052677A (en) * | 2013-03-14 | 2014-09-17 | 阿里巴巴集团控股有限公司 | Soft load balancing method and apparatus of single data source |
| CN104052677B (en) * | 2013-03-14 | 2018-04-10 | 阿里巴巴集团控股有限公司 | The soft load-balancing method and device of data mapping |
| CN103530314A (en) * | 2013-07-26 | 2014-01-22 | 苏州亿倍信息技术有限公司 | Data processing method and system |
| WO2015010411A1 (en) * | 2013-07-26 | 2015-01-29 | 苏州亿倍信息技术有限公司 | Data access processing method and system |
| CN107301190A (en) * | 2016-04-15 | 2017-10-27 | 中国移动通信集团湖北有限公司 | The method and device that a kind of control data is accessed |
| CN107688607A (en) * | 2017-07-26 | 2018-02-13 | 努比亚技术有限公司 | The method and mobile terminal of a kind of database access, computer-readable recording medium |
| CN108834087A (en) * | 2018-07-03 | 2018-11-16 | 平安科技（深圳）有限公司 | Note transmission method, device, computer equipment and storage medium |
| CN108834087B (en) * | 2018-07-03 | 2021-08-24 | 平安科技（深圳）有限公司 | Short message sending method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102243597B (en) | 2012-08-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102243597B (en) | Method and device for controlling and managing database connections | |
| CN102243653B (en) | Method and device for managing database connections | |
| CN101360309B (en) | Execution method, apparatus and system for service open command | |
| CN102243655B (en) | Method and device for managing database connections | |
| US20060206894A1 (en) | Method of scheduling jobs using database management system for real-time processing | |
| CN102081554A (en) | Cloud computing operating system as well as kernel control system and method thereof | |
| CN109840144B (en) | Information service scheduling method and system for cross-mechanism batch service request | |
| CN105159736A (en) | Establishment method of SaaS software deployment scheme supporting performance analysis | |
| EP2437527B1 (en) | Method and device for implementing intelligent group service of mobile virtual private network | |
| CN102243652B (en) | Database connection management method and device | |
| CN106528853A (en) | Data interaction management device and cross-database data interaction processing device and method | |
| CN102243654B (en) | Method and device for controlling and managing database connections | |
| US20030145013A1 (en) | Service package application and a service activation manager for use with a service control point in an advanced intelligent network | |
| CN111427608B (en) | Gray scale release method for bank core system | |
| CN101694632A (en) | Method for executing resource plans on demands and being applied to data base cluster system | |
| CN102243651B (en) | Database connection control management method and device | |
| US5826019A (en) | Modular application software and data providing mobility in telecommunication networks | |
| CN112748997A (en) | Workflow scheduling method and system | |
| CN102262655B (en) | Connection control method and device for database | |
| US11917505B2 (en) | Methods and systems for provisioning rate plan features in a wireless communication network | |
| CN101754156A (en) | Office data management method, device and charging system | |
| CN102681881B (en) | Across machine dispatching method and system thereof | |
| CN1332531C (en) | A method for dynamically adjusting system service performance on service management point | |
| CN110795248A (en) | Method for processing Java instance garbage recovery of search system | |
| CN101197689B (en) | Combined service charging method and 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: 20120822 Termination date: 20180616 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |