CN102609467A - Method and device for database connection management - Google Patents
Method and device for database connection management Download PDFInfo
- Publication number
- CN102609467A CN102609467A CN2012100131121A CN201210013112A CN102609467A CN 102609467 A CN102609467 A CN 102609467A CN 2012100131121 A CN2012100131121 A CN 2012100131121A CN 201210013112 A CN201210013112 A CN 201210013112A CN 102609467 A CN102609467 A CN 102609467A
- Authority
- CN
- China
- Prior art keywords
- database connection
- database
- linking number
- connections
- thread
- 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.)
- Pending
Links
Images
Abstract
The invention provides a method and a device for database connection management. The method includes: obtaining a maximum number of connections of a database pool and a currently used number of connections when an operation needs to obtain connections from the database connection pool; obtaining thread attributes of the threads operating the operation when difference between the maximum number of connections and the currently used number of connections is less than or equal to preset reserved connections for important operations; distributing a database connection from the database connection pool to the operation when the thread attributes meet preset attribute requirements, and updating the used number of connections. The device comprises a first acquisition module, a second acquisition module and a distribution module. The method and the device for database connection management are capable of guaranteeing that the important operations can obtain the database connection, fully utilizing the database connection and enhancing usability of the important operations in an application system.
Description
Technical field
The present invention relates to the communication technology, relate in particular to a kind of database connection management method and apparatus.
Background technology
Java is a kind of object-oriented programming language that can write cross-platform application software; The Java technology has remarkable versatility, high efficiency, platform transplantation property and security, is widely used in fields such as individual PC, data center, game console, science supercomputer, mobile phone and internet.In application system based on Java, To enterprises user's application system especially, database access is one of gordian technique.It is a kind of limited and expensive resources of key that database connects, and connecting database is a kind of not only consumption of natural resource but also time-consuming job, if frequently carry out database manipulation, the performance of system will sharply descend.In order to improve system performance, the notion of database connection pool has been proposed; Database connection pool is responsible for distribution, management and release data storehouse and is connected, and its database that when initialization, will in database connection pool, create some connects; The quantity that these databases connect is set by minimum data storehouse linking number, and the maximum number of connections of setting data storehouse connection pool is connected with the unlimited of database to prevent application system simultaneously.When certain service needed accessing database; Only needing from database connection pool, to take out a database connects; Need not to rebulid database and connect, and again this database connection is put back in the database connection pool after finishing using, it can be used by other business.Connect through the multiplex data storehouse, thereby can avoid frequent foundation that database connects, close the system resource overhead of being brought, saved system resource and time.
In application system, exist some business more important with respect to other are professional usually, there are some business more continual service possibly is provided.When system load causes database in the database connection pool to connect more greatly using up; These important service will connect temporarily unavailable because of obtaining database; When having available database to connect, just recover, will cause the availability of important service under high load condition to reduce like this.
Fig. 1 is the application scenarios synoptic diagram that database connects in the prior art; As shown in Figure 1; Be respectively important service and general service in the prior art and distribute a database connection pool; The database connection pool that general service is used is set to database connection pool 1, and the database connection pool that important service is used is set to database connection pool 2, makes general service not take and can impact important service what database connected like this.
Yet higher when the load of important service, and the load of general service is when low, and the idle data storehouse that is used for the database connection pool of general service connects and can not supply important service to use, so prior art can't make full use of database and connects.
Summary of the invention
The present invention provides a kind of database connection management method and apparatus, when preferential assurance important service can get access to the database connection, makes full use of database and connects.
First aspect of the present invention provides a kind of database connection management method, comprising:
Obtain when connecting from database connection pool when a service needed, obtain the maximum number of connections and the current linking number that has used of said database connection pool;
If the difference of said maximum number of connections and the said current linking number that has used is less than or equal to the reservation linking number of preset important service, then obtain the thread attribute of the thread of the said business of operation;
When said thread attribute satisfies preset attribute conditions, be that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
Another aspect of the present invention provides a kind of database connection management device, comprising:
First acquisition module is used for obtaining when connecting from database connection pool when a service needed, obtains the maximum number of connections and the current linking number that has used of said database connection pool;
Second acquisition module is used for obtaining the thread attribute of the thread of the said business of operation if the difference of said maximum number of connections and the said current linking number that has used is less than or equal to the reservation linking number of preset important service;
Distribution module is used for when said thread attribute satisfies preset attribute conditions, is that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
Technique effect of the present invention is: when a service needed is obtained when connecting from database connection pool; Obtain the maximum number of connections and the current linking number that has used of this database connection pool; When if the difference of maximum number of connections and the current linking number that has used is less than or equal to the reservation linking number of preset important service; Obtain this professional thread attribute of operation; When this thread attribute satisfies preset attribute conditions, be that database of traffic assignments connects from database connection pool, and the linking number that has used is upgraded.The present invention has made full use of the database connection when preferential assurance important service can get access to the database connection, improved the availability of important service in the application system.
Description of drawings
Fig. 1 is the application scenarios synoptic diagram that database connects in the prior art;
Fig. 2 is the process flow diagram of database connection management method embodiment one of the present invention;
The application scenarios synoptic diagram that Fig. 3 connects for database among the database connection management method embodiment one of the present invention;
Fig. 4 is the process flow diagram of database connection management method embodiment two of the present invention;
Fig. 5 is the structural drawing of database connection management device embodiment one of the present invention;
Fig. 6 is the structural drawing of database connection management device embodiment two of the present invention.
Embodiment
Fig. 2 is the process flow diagram of database connection management method embodiment one of the present invention, and as shown in Figure 2, present embodiment provides a kind of database connection management method, can specifically comprise the steps:
Step 201 is obtained when connecting from database connection pool when a service needed, obtains the maximum number of connections and the current linking number that has used of said database connection pool.
The application scenarios synoptic diagram that Fig. 3 connects for database among the database connection management method embodiment one of the present invention; As shown in Figure 3; Present embodiment guarantees that for preferential important service can get access to database and connect; The database connection of avoiding simultaneously existing in the prior art utilizes inadequate defective; General service and important service are shared a database connection pool in the present embodiment, handle each professional all functions module and all from the connection pool of unified data storehouse, obtain the database connection, and need not to be concerned about how the database connection distributes.This step is specially when a service needed and obtains when connecting from database connection pool, obtains the maximum number of connections of this database connection pool earlier, and the current linking number that has used in this database connection pool.Wherein, The maximum number of connections of database connection pool can be for disposing or distributing in advance; Can suppose that here X is a maximum number of connections; The current linking number that has used connects the back in each allocation database to be brought in constant renewal in and obtains, and is used for representing the quantity that database that this database connection pool has been used connects, and can suppose that here U is the current linking number that has used.
Step 202 if the difference of said maximum number of connections and the current linking number that has used is less than or equal to the reservation linking number of preset important service, is then obtained the thread attribute of the thread of the said business of operation.
After maximum number of connections X that gets access to database connection pool and the current linking number U that has used; Whether the difference of judging maximum number of connections X and the current linking number U that has used is greater than the reservation linking number of preset important service; Wherein, The reservation linking number of important service is meant in order to guarantee that important service connects for important service priority allocation database as far as possible; And be the linking number that important service keeps in the predefined database connection pool, suppose that here R is the reservation linking number of the important service preset.This step is judged for process; When if the difference of maximum number of connections X and the current linking number U that has used is less than or equal to the reservation linking number R of important service; Show that linking number available in the current database connection pool has reached the linking number upper limit, then obtain the thread attribute of this professional thread of operation this moment.The linear properties here can be specially linear title, thread type etc.
Step 203 when said thread attribute satisfies preset attribute conditions, is that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
In the present embodiment, to important service, for it sets up dedicated thread, and the thread attribute through thread identifies it and is dedicated thread, to distinguish mutually with the thread of operation general service.In the present embodiment; When if the difference of maximum number of connections X and the current linking number U that has used is less than or equal to the reservation linking number R of important service; Judge further whether this professional thread attribute satisfies preset attribute conditions; If then be that database of this traffic assignments connects from this database connection pool, and the linking number U that has used upgraded.The preset attribute conditions here specifically can be the prefix of thread attribute, perhaps other identification information, and coming identification service through the thread attribute is general service or important service.When this thread attribute meets preset attribute conditions; Show that this business is an important service; Then be that database of this traffic assignments connects, and the linking number U that has used upgraded that the linking number U that has soon used adds 1 to be handled from said database connection pool.
Further; The database connection management method that present embodiment provides can also comprise the steps: if the difference of said maximum number of connections and the said current linking number that has used greater than the reservation linking number of the important service of presetting; Then be that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
Further; The database connection management method that present embodiment provides can also comprise the steps: when said thread attribute does not satisfy preset attribute conditions; The difference of waiting for said maximum number of connections and the said current linking number that has used just is said traffic assignments database connection during greater than the reservation linking number of preset important service.
Further, the database connection management method that provides of present embodiment can also comprise the steps: that the character according to different business is important service and general service with each delineation of activities; For said important service is set up dedicated thread, and the thread attribute of said dedicated thread is unified for presetting attribute.
Further; The database connection management method that present embodiment provides can also comprise the steps: after the execution of accomplishing said business is handled; To be discharged in the said database connection pool for the database connection of said traffic assignments, and upgrade the said current linking number that has used.
Present embodiment provides a kind of database connection management method; When a service needed is obtained when connecting from database connection pool; Obtain the maximum number of connections and the current linking number that has used of this database connection pool; When if the difference of maximum number of connections and the current linking number that has used is less than or equal to the reservation linking number of preset important service, obtain this professional thread attribute of operation, when this thread attribute satisfies preset attribute conditions; Be that database of traffic assignments connects from database connection pool, and the linking number that has used is upgraded.Present embodiment has made full use of the database connection when preferential assurance important service can get access to the database connection, improved the availability of important service in the application system.
Fig. 4 is the process flow diagram of database connection management method embodiment two of the present invention, and as shown in Figure 4, present embodiment provides a kind of database connection management method, can specifically comprise the steps:
Step 401 is important service and general service according to the character of different business with each delineation of activities.
In the present embodiment, can according to the character of different business each business be divided earlier for important traffic assignments database connects, it is divided into important service and general service for preferential the assurance.
Step 402 for said important service is set up dedicated thread, and is preset prefix with the prefix of the title of said dedicated thread is unified.
In the present embodiment, the thread attribute that is used to identify dedicated thread is specially the thread title, adopts thread type identification dedicated thread similarly, repeats no more here.Present embodiment is that important service is set up dedicated thread, and these dedicated threads are exclusively used in the operation important service, and with reference to above-mentioned Fig. 3, important service directly adds in important service processing threads 1, the important service processing threads 2 to be handled.In the present embodiment, be preset prefix with the prefix of the title of these dedicated threads is unified,, for example, the thread that is exclusively used in important service all is configured to start with impt.Present embodiment improves through the processing code to important service, gives dedicated thread at the program entry place with important service and handles.In the prior art processing code function1 and the function2 of sequence call important service; And in the present embodiment above-mentioned code is improved, the processing code function1 of important service and function2 are arranged in the unified dedicated thread of prefix handle.
Step 403 is obtained when connecting from database connection pool when a service needed, obtains the maximum number of connections and the current linking number that has used of said database connection pool.
General service and important service are shared a database connection pool in the present embodiment, handle each professional all functions module and all from the connection pool of unified data storehouse, obtain the database connection.This step is specially when a service needed and obtains when connecting from database connection pool, obtains the maximum number of connections of this database connection pool earlier, and the current linking number that has used in this database connection pool.Wherein, The maximum number of connections of data road connection pool can be for disposing or distributing in advance; Can suppose that here X is a maximum number of connections; The current linking number that has used connects the back in each allocation database to be brought in constant renewal in and obtains, and is used for representing the quantity that database that this database connection pool has been used connects, and can suppose that here U is the current linking number that has used.
Whether step 404, the difference of judging maximum number of connections and the current linking number that has used greater than the reservation linking number of preset important service, if then execution in step 405, otherwise execution in step 406.
This step is whether the difference of maximum number of connections X and the current linking number U that has used of judgment data storehouse connection pool is greater than the reservation linking number R of preset important service, if then execution in step 405, otherwise execution in step 406.
Step 405 is that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
When the difference of the maximum number of connections X of database connection pool and the current linking number U that has used during greater than the reservation linking number R of preset important service; Show that the linking number in this database connection pool does not reach the upper limit as yet; No matter should business be important service or general service then; All be that database of said traffic assignments connects from said database connection pool; And the said linking number U that has used upgraded, be specially and U is added 1 handle, use in order to next business being connected the branch timing.
In addition; In the present embodiment, when the difference of the maximum number of connections X of database connection pool and the current linking number U that has used is less than or equal to the reservation linking number R of preset important service, and when should business being important service; Also carry out this step 405; Be that database of important traffic assignments connects from database connection pool, and the linking number U that has used is upgraded, be specially and U is added 1 handle.That is to say; For important service, even the linking number that has used in the database connection pool has reached the upper limit, but owing to kept R linking number for important service before; Then still be that database of important traffic assignments connects, with the availability of preferential assurance important service.
Step 406 is obtained the thread title of thread of the said business of operation.
When the difference of the maximum number of connections X of database connection pool and the current linking number U that has used is less than or equal to the reservation linking number R of preset important service; Show that the linking number in this database connection pool has reached the upper limit, then this step is obtained the thread title of this professional thread of operation earlier.
Whether this step satisfies the title condition for the thread title of judging this professional thread of operation; Be specially here whether the prefix of judging this thread title is preset prefix; If show that then this business is an important service, then returns execution in step 405; Distribute a database for this important service and connect, otherwise execution in step 408.
Step 408, the difference of waiting for said maximum number of connections and the said current linking number that has used just are said traffic assignments database connection during greater than the reservation linking number of preset important service.
The reservation linking number R that is less than or equal to preset important service when the difference of the maximum number of connections X of database connection pool and the current linking number U that has used; And judgement through above-mentioned steps 407; The prefix of knowing the thread title of this professional thread of operation is not preset prefix; When promptly should business being general service; Earlier be that this traffic assignments database connects, but the difference of waiting for maximum number of connections X and the current linking number U that has used just is the connection of traffic assignments database during greater than the reservation linking number R of the important service of presetting.
Step 409 after the execution of accomplishing said business is handled, will be discharged in the said database connection pool for the database connection of said traffic assignments, and upgrades the said current linking number that has used.
In the present embodiment, when complete one when professional, can also the database for this traffic assignments be connected and be discharged in the database connection pool, upgrade the current linking number U that has used this moment, is specially the current linking number that has used is subtracted 1 to handle.
Present embodiment provides a kind of database connection management method; When a service needed is obtained when connecting from database connection pool; Obtain the maximum number of connections and the current linking number that has used of this database connection pool; When if the difference of maximum number of connections and the current linking number that has used is less than or equal to the reservation linking number of preset important service, obtain this professional thread title of operation, when this thread title satisfies preset title condition; Be that database of traffic assignments connects from database connection pool, and the linking number that has used is upgraded.Present embodiment has made full use of the database connection when preferential assurance important service can get access to the database connection, improved the availability of important service in the application system.
In the present embodiment, when the load of application system hour, important service and the general service database in can the shared data bank connection pool is connected; When load increases to the residue linking number when being less than or equal to R, to have only important service could continue to get access to database and connect, general service will get clogged, and promptly last R database in the database connection pool connects and only supplies the important service use.Under the extremely busy situation of important service; Also can all databases in the database connection pool be connected and all be used for important service; At this moment general service can't get access to the database connection; But important service still can get access to database to be connected, and has ensured the availability of important service to the full extent.In the present embodiment, only needing the inlet of important service in the application system is improved, and the correlation parameter of database connection pool is configured, is transparent to the concrete processing procedure of business, can adapt to business change well; When important service changes to general service, when perhaps general service changes to important service, only need to do minor modifications and get final product at ingress for service.
One of ordinary skill in the art will appreciate that: all or part of step that realizes above-mentioned each method embodiment can be accomplished through the relevant hardware of programmed instruction.Aforesaid program can be stored in the computer read/write memory medium.This program the step that comprises above-mentioned each method embodiment when carrying out; And aforesaid storage medium comprises: various media that can be program code stored such as ROM, RAM, magnetic disc or CD.
Fig. 5 is the structural drawing of database connection management device embodiment one of the present invention, and as shown in Figure 5, present embodiment provides a kind of database connection management device, can specifically carry out each step among the said method embodiment one, repeats no more here.The database connection management device that present embodiment provides can specifically comprise first acquisition module 501, second acquisition module 502 and distribution module 503.Wherein, first acquisition module 501 is used for obtaining when connecting from database connection pool when a service needed, obtains the maximum number of connections and the current linking number that has used of said database connection pool.Second acquisition module 502 is used for if the difference of said maximum number of connections and the said current linking number that has used is less than or equal to the reservation linking number of preset important service, obtains the thread attribute of the thread of the said business of operation.Distribution module 503 is used for when said thread attribute satisfies preset attribute conditions, is that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
Fig. 6 is the structural drawing of database connection management device embodiment two of the present invention, and as shown in Figure 6, present embodiment provides a kind of database connection management device, can specifically carry out each step among the said method embodiment two, repeats no more here.The database connection management device that present embodiment provides is on above-mentioned basis shown in Figure 5; Distribution module 503 also be used for if the difference of said maximum number of connections and the said current linking number that has used greater than the reservation linking number of the important service of presetting; Be that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
Further; The database connection management device that present embodiment provides can also comprise waits for distribution module 601; Wait for that distribution module 601 is used for when said thread attribute does not satisfy preset attribute conditions; The difference of waiting for said maximum number of connections and the said current linking number that has used just is said traffic assignments database connection during greater than the reservation linking number of preset important service.
Further, the database connection management device that provides of present embodiment can also comprise and divides module 602 and set up module 603.Wherein, dividing the character that module 602 is used for according to different business is important service and general service with each delineation of activities.Set up module 603 and be used to said important service and set up dedicated thread, and be preset attribute with the thread attribute of said dedicated thread is unified.
Further; The database connection management device that present embodiment provides can also comprise release module 604; Release module 604 is used for after the execution of accomplishing said business is handled; To be discharged in the said database connection pool for the database connection of said traffic assignments, and upgrade the said current linking number that has used.
Present embodiment provides a kind of database connection management device; When a service needed is obtained when connecting from database connection pool; Obtain the maximum number of connections and the current linking number that has used of this database connection pool; When if the difference of maximum number of connections and the current linking number that has used is less than or equal to the reservation linking number of preset important service, obtain this professional thread attribute of operation, when this thread attribute satisfies preset attribute conditions; Be that database of traffic assignments connects from database connection pool, and the linking number that has used is upgraded.Present embodiment has made full use of the database connection when preferential assurance important service can get access to the database connection, improved the availability of important service in the application system.
What should explain at last is: above each embodiment is only in order to explaining technical scheme of the present invention, but not to its restriction; Although the present invention has been carried out detailed explanation with reference to aforementioned each embodiment; Those of ordinary skill in the art is to be understood that: it still can be made amendment to the technical scheme that aforementioned each embodiment put down in writing, perhaps to wherein part or all technical characteristic are equal to replacement; And these are revised or replacement, do not make the scope of the essence disengaging various embodiments of the present invention technical scheme of relevant art scheme.
Claims (10)
1. a database connection management method is characterized in that, comprising:
Obtain when connecting from database connection pool when a service needed, obtain the maximum number of connections and the current linking number that has used of said database connection pool;
If the difference of said maximum number of connections and the said current linking number that has used is less than or equal to the reservation linking number of preset important service, then obtain the thread attribute of the thread of the said business of operation;
When said thread attribute satisfies preset attribute conditions, be that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
2. method according to claim 1 is characterized in that, also comprises:
Connect if the difference of said maximum number of connections and the said current linking number that has used greater than the reservation linking number of preset important service, then is database of said traffic assignments from said database connection pool, and the said linking number that has used is upgraded.
3. method according to claim 1 and 2 is characterized in that, also comprises:
When said thread attribute did not satisfy preset attribute conditions, the difference of waiting for said maximum number of connections and the said current linking number that has used just was said traffic assignments database connection during greater than the reservation linking number of preset important service.
4. method according to claim 1 is characterized in that, also comprises:
Character according to different business is important service and general service with each delineation of activities;
For said important service is set up dedicated thread, and the linear properties of said dedicated thread is unified for presetting attribute.
5. method according to claim 1 is characterized in that, also comprises:
After the execution of accomplishing said business is handled, will be discharged in the said database connection pool for the database connection of said traffic assignments, and upgrade the said current linking number that has used.
6. a database connection management device is characterized in that, comprising:
First acquisition module is used for obtaining when connecting from database connection pool when a service needed, obtains the maximum number of connections and the current linking number that has used of said database connection pool;
Second acquisition module is used for obtaining the thread attribute of the thread of the said business of operation if the difference of said maximum number of connections and the said current linking number that has used is less than or equal to the reservation linking number of preset important service;
Distribution module is used for when said thread attribute satisfies preset attribute conditions, is that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
7. device according to claim 6; It is characterized in that; Said distribution module also be used for if the difference of said maximum number of connections and the said current linking number that has used greater than the reservation linking number of the important service of presetting; Be that database of said traffic assignments connects from said database connection pool, and the said linking number that has used is upgraded.
8. according to claim 6 or 7 described devices, it is characterized in that, also comprise:
Wait for distribution module; Be used for when said thread attribute does not satisfy preset attribute conditions; The difference of waiting for said maximum number of connections and the said current linking number that has used just is said traffic assignments database connection during greater than the reservation linking number of preset important service.
9. device according to claim 6 is characterized in that, also comprises:
Divide module, the character that is used for according to different business is important service and general service with each delineation of activities;
Set up module, be used to said important service and set up dedicated thread, and the thread attribute of said dedicated thread is unified for presetting attribute.
10. device according to claim 6 is characterized in that, also comprises:
Release module is used for after the execution of accomplishing said business is handled, and will connect for the database of said traffic assignments to be discharged in the said database connection pool, and upgrade the said current linking number that has used.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100131121A CN102609467A (en) | 2012-01-16 | 2012-01-16 | Method and device for database connection management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100131121A CN102609467A (en) | 2012-01-16 | 2012-01-16 | Method and device for database connection management |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102609467A true CN102609467A (en) | 2012-07-25 |
Family
ID=46526839
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012100131121A Pending CN102609467A (en) | 2012-01-16 | 2012-01-16 | Method and device for database connection management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102609467A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968457A (en) * | 2012-10-30 | 2013-03-13 | 北京奇虎科技有限公司 | Switching method and system between databases |
| CN103455377A (en) * | 2013-08-06 | 2013-12-18 | 北京京东尚科信息技术有限公司 | System and method for managing business thread pool |
| CN103605727A (en) * | 2013-11-19 | 2014-02-26 | 浪潮电子信息产业股份有限公司 | Connection pool based efficient multiuser database access optimization method and framework |
| CN104917810A (en) * | 2015-04-14 | 2015-09-16 | 天脉聚源（北京）教育科技有限公司 | Global-variable-based user equipment connection method and connecting device |
| CN105512188A (en) * | 2015-11-25 | 2016-04-20 | 用友网络科技股份有限公司 | Data connection method and data connection system |
| CN106250500A (en) * | 2016-07-29 | 2016-12-21 | 广州唯品会信息科技有限公司 | The dynamic management approach of database connection pool and system |
| CN106326446A (en) * | 2016-08-26 | 2017-01-11 | 广州唯品会信息科技有限公司 | Distribution type database connecting method and device |
| CN106354801A (en) * | 2016-08-26 | 2017-01-25 | 广州唯品会信息科技有限公司 | Distributed database connection method and device |
| CN109542940A (en) * | 2018-11-26 | 2019-03-29 | 三星电子（中国）研发中心 | A kind of database connection distribution method and device |
| CN110019113A (en) * | 2017-08-31 | 2019-07-16 | 华为软件技术有限公司 | A kind of method for processing business and database server of database |
| CN115328978A (en) * | 2022-06-27 | 2022-11-11 | 光大环境科技（中国）有限公司 | Connection method of connection pool and server |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040221031A1 (en) * | 2003-04-29 | 2004-11-04 | Oracle International Corporation | Method and apparatus using connection pools in communication networks |
| CN102004803A (en) * | 2010-12-30 | 2011-04-06 | 用友软件股份有限公司 | Method and device for scheduling database resources |
| CN102243652A (en) * | 2011-06-16 | 2011-11-16 | 苏州阔地网络科技有限公司 | Database connection management method and device |
-
2012
- 2012-01-16 CN CN2012100131121A patent/CN102609467A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040221031A1 (en) * | 2003-04-29 | 2004-11-04 | Oracle International Corporation | Method and apparatus using connection pools in communication networks |
| CN102004803A (en) * | 2010-12-30 | 2011-04-06 | 用友软件股份有限公司 | Method and device for scheduling database resources |
| CN102243652A (en) * | 2011-06-16 | 2011-11-16 | 苏州阔地网络科技有限公司 | Database connection management method and device |
Non-Patent Citations (1)
| Title |
|---|
| 孙叶枫 等: "JSP中基于连接池的数据库访问技术", 《计算机应用》, vol. 24, no. 6, 30 June 2004 (2004-06-30), pages 80 - 82 * |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102968457B (en) * | 2012-10-30 | 2015-09-30 | 北京奇虎科技有限公司 | Database method for switching between and system |
| CN102968457A (en) * | 2012-10-30 | 2013-03-13 | 北京奇虎科技有限公司 | Switching method and system between databases |
| CN103455377A (en) * | 2013-08-06 | 2013-12-18 | 北京京东尚科信息技术有限公司 | System and method for managing business thread pool |
| CN103455377B (en) * | 2013-08-06 | 2019-01-22 | 北京京东尚科信息技术有限公司 | System and method for management business thread pool |
| CN103605727B (en) * | 2013-11-19 | 2017-07-28 | 浪潮电子信息产业股份有限公司 | Multiuser database based on connection pool accesses high efficiency optimization method and system |
| CN103605727A (en) * | 2013-11-19 | 2014-02-26 | 浪潮电子信息产业股份有限公司 | Connection pool based efficient multiuser database access optimization method and framework |
| CN104917810A (en) * | 2015-04-14 | 2015-09-16 | 天脉聚源（北京）教育科技有限公司 | Global-variable-based user equipment connection method and connecting device |
| CN105512188A (en) * | 2015-11-25 | 2016-04-20 | 用友网络科技股份有限公司 | Data connection method and data connection system |
| CN106250500A (en) * | 2016-07-29 | 2016-12-21 | 广州唯品会信息科技有限公司 | The dynamic management approach of database connection pool and system |
| CN106354801A (en) * | 2016-08-26 | 2017-01-25 | 广州唯品会信息科技有限公司 | Distributed database connection method and device |
| CN106326446A (en) * | 2016-08-26 | 2017-01-11 | 广州唯品会信息科技有限公司 | Distribution type database connecting method and device |
| CN106326446B (en) * | 2016-08-26 | 2019-07-19 | 广州品唯软件有限公司 | Distributed data base connection method and device |
| CN106354801B (en) * | 2016-08-26 | 2019-12-20 | 广州品唯软件有限公司 | Distributed database connection method and device |
| CN110019113A (en) * | 2017-08-31 | 2019-07-16 | 华为软件技术有限公司 | A kind of method for processing business and database server of database |
| CN110019113B (en) * | 2017-08-31 | 2022-11-08 | 华为技术有限公司 | Database service processing method and database server |
| CN109542940A (en) * | 2018-11-26 | 2019-03-29 | 三星电子（中国）研发中心 | A kind of database connection distribution method and device |
| CN109542940B (en) * | 2018-11-26 | 2021-07-30 | 三星电子（中国）研发中心 | Database connection allocation method and device |
| CN115328978A (en) * | 2022-06-27 | 2022-11-11 | 光大环境科技（中国）有限公司 | Connection method of connection pool and server |
| CN115328978B (en) * | 2022-06-27 | 2023-11-17 | 光大环境科技（中国）有限公司 | Connection method of connection pool and server |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102609467A (en) | Method and device for database connection management | |
| CN103036946B (en) | A kind of method and system processing file backup task for cloud platform | |
| CN105049268A (en) | Distributed computing resource allocation system and task processing method | |
| CN104572301B (en) | A kind of resource allocation methods and system | |
| CN102393889A (en) | Permissions configuration management system | |
| CN102520948A (en) | Application program maintenance and update method and device | |
| CN104639594A (en) | System and method for allocating physical resources and virtual resources | |
| CN102254021A (en) | Method for constructing database based on virtual machine management system | |
| CN102946413B (en) | Method and system for resource preprocessing in dispatching and deployment performing process of virtual machine | |
| CN103810046A (en) | Method and system for managing resources in single machine | |
| CN101673358B (en) | Method and device for managing authority in workflow component based on authority component | |
| CN102667714B (en) | Support the method and system that the function provided by the resource outside operating system environment is provided | |
| CN103593229A (en) | Integrating and uniform dispatching frame of heterogeneous cloud operation systems and dispatching method thereof | |
| CN102520887A (en) | Storage space configuration and management method applied to cloud computing | |
| CN102393848A (en) | Method and system for acquiring identification information of data terminal equipment | |
| CN104468638A (en) | Distributed data processing method and system | |
| CN104965708A (en) | Method and apparatus for managing memory in application program running process | |
| CN104268022B (en) | The resource allocation methods and system of process in a kind of operating system | |
| CN103092645A (en) | Geographic spatial information application system and implement method thereof based on microkernel technology | |
| CN103377079A (en) | Terminal, device and method for terminal application running and application program running method | |
| CN104077266B (en) | Many kernel operating system implementation methods and realize apparatus and system | |
| CN105528371A (en) | Method, device, and system for executing writing task | |
| CN104375866A (en) | Single board driving updating method and device | |
| CN104536773B (en) | Embedded software dynamic memory recovery method based on internal memory scanning | |
| CN103218305A (en) | Distribution method of memory space |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120725 |