CN103810203B - A kind of data base management system connection multiplexing method and device - Google Patents
A kind of data base management system connection multiplexing method and device Download PDFInfo
- Publication number
- CN103810203B CN103810203B CN201210453646.6A CN201210453646A CN103810203B CN 103810203 B CN103810203 B CN 103810203B CN 201210453646 A CN201210453646 A CN 201210453646A CN 103810203 B CN103810203 B CN 103810203B
- Authority
- CN
- China
- Prior art keywords
- connection
- sql
- reusable
- pool
- database
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to field of data storage, more particularly to a kind of data base management system connection multiplexing method and device.Data base management system connection multiplexing method of the present invention includes：Database connection pool object is established, and creates database connection request；Analytical structure query language, connected according to the reusable in SQL type and processing condition adjudgement database connection pool with the presence or absence of idle condition, if it does, performing next step；The reusable connection for choosing the idle condition is multiplexed.Data base management system connection multiplexing method and device of the present invention sets whether MySQL connections can be multiplexed according to processed sql like language type, can fully use a MySQL connection, improves overall system performance；And set MySQL connections whether idle according to the processing state of sql like language, and the problem of avoid connection multiplexing effect from depending on user, raising service efficiency.
Description
Technical field
The invention belongs to technical field of data storage, more particularly to a kind of data base management system connection multiplexing method and dress
Put.
Background technology
Existing encapsulation mysql operation client library or realize the proxy module of mysql read and write abruptions, take
Connection multiplexing technology based on thread, database is connected as object and is stored in a container object, once database connects
After connecing foundation, different database access request cans shares these connections, so, by being multiplexed these numbers having built up
Connected according to storehouse, reduce the time for establishing database connection, greatly save system resource and time, improve the property of whole system
Energy.Wherein, mysql is a kind of associated data base management system, and linked database is saved the data in different tables, rather than
All data are placed in one big warehouse, speed is added and improves flexibility；Connection multiplexing technology is by establishing one
Individual database connection pool and a set of connection are used, distributed, management strategy so that the connection in the connection pool can obtain height
The multiplexing of effect, safety, avoid the expense that database connection is frequently established, closed.Connection multiplexing main mechanism includes：1st, establish
Database connection pool（Database connection pool is responsible for distributing, manages and discharges database and connect, and it allows application program reuse
One existing database connection, and be or else to re-establish one；The releasing idling time exceedes the data of maximum idle time
Storehouse is connected to avoid omitting because connecting without database caused by release database connection）Object simultaneously creates specified quantity
Database connection；2nd, for a database access request, an idle connection is obtained from connection pool, if database connects
Connecing does not have idle connect and connection number is not above threshold value and then creates a new database connection in pond.
The existing MySQL connection multiplexing technologies based on thread have the following disadvantages：First, system resource overhead is big；Take every
Individual MySQL connections use the mode of a thread, because thread switching and thread management can bring extra system resource overhead,
So as to influence overall performance；2nd, using being restricted；In the prior art, if some mysql connection is not idle condition
(user is not turned off or exchanged connection), the then connection can not be re-used always, and connection multiplexing effect depends on user,
Service efficiency is not high.
The content of the invention
The invention provides a kind of data base management system connection multiplexing method and device, it is intended to solves existing to be based on thread
MySQL connection multiplexing technological systems resource overhead it is big and the problem of service efficiency is not high.
The present invention is achieved in that a kind of data base management system connection multiplexing method, including：
Database connection pool object is established, and creates database connection request；
Analytical structure query language, according in SQL type and processing condition adjudgement database connection pool
Connected with the presence or absence of the reusable of idle condition, if it does, performing next step；
The reusable connection for choosing the idle condition is multiplexed.
The technical scheme of the embodiment of the present invention also includes：The database connection pool object step of establishing also includes：Set
Connection pool connects the threshold values of number, and the establishment database connection request step also includes：Judge whether is connection number in connection pool
More than threshold value, if the connection number in connection pool is not above threshold value, a new connection is created；If the connection in connection pool
Number exceedes threshold value, then analytical structure query language.
The technical scheme of the embodiment of the present invention also includes：It is described according to SQL type and processing condition adjudgement
Reusable Connection Step in database connection pool with the presence or absence of idle condition also includes：Analytical structure query language type,
Judged to whether there is reusable connection in database connection pool according to SQL type, if in connection pool existed
Reusable connection, analyze the SQL processing state of the connection；If reusable company is not present in connection pool
Connect, terminate this connection.
The technical scheme of the embodiment of the present invention also includes：It is described according to SQL type and processing condition adjudgement
Reusable Connection Step in database connection pool with the presence or absence of idle condition also includes：The reusable connection is chosen, and is divided
The SQL processing state of analysis connection, handle whether condition adjudgement connection is idle shape according to SQL
State, if being connected as idle condition, the reusable connection for choosing the idle condition is multiplexed；If it is connected as busy shape
State, terminate this connection.
The technical scheme of the embodiment of the present invention also includes：The analytical structure query language type, is looked into according to structuring
Language form is ask to judge with the presence or absence of reusable connection to include in database connection pool：Set according to SQL type
Put whether connection is reusable connection, the criterion of setting is：If SQL type possesses context, it is connected as
Not reusable connection；If SQL type does not possess context, reusable connection is connected as.
The technical scheme of the embodiment of the present invention also includes：The SQL processing state for analyzing the connection,
According to SQL processing condition adjudgement, whether the connection is that idle condition includes：According to SQL whether
It is disposed to set connection whether idle, the criterion of setting is：This is connected as if SQL is disposed
Idle condition；This is connected as busy state if SQL is not disposed.
Another technical scheme that the embodiment of the present invention is taken is：A kind of data base management system connection multiplexing device, including
Connection pool establishes module, database connection module, connection judgment module and connection and chooses module, and the connection pool establishes module use
In establishing database connection pool object；The database connection module is used to create database connection request；The connection judgment
Module is used for analytical structure query language, according in SQL type and processing condition adjudgement database connection pool
Connect with the presence or absence of the reusable of idle condition, be multiplexed if it does, choosing module by connection and choosing the connection；It is described
Connection is chosen reusable connection of the module for choosing idle condition and is multiplexed.
The technical scheme of the embodiment of the present invention also includes：The data base management system connection multiplexing device also includes connection
Number judge module and connection creation module, the connection pool establish module and establish database connection pool object and set connection pool to connect
Several threshold values is connect, the connection number judge module is used to judge whether the connection number in connection pool exceedes threshold value, if connection pool
In connection number be not above threshold value, create new connection by connecting creation module；If the connection number in connection pool exceedes
Threshold value, judge whether that reusable connects by connection judgment module；The connection creation module is used to create new connection.
The technical scheme of the embodiment of the present invention also includes：The connection judgment module also includes the first judging unit and second
Judging unit, first judging unit are used for analytical structure query language type, sentenced according to SQL type
It whether there is reusable connection in disconnected database connection pool, if reusable connection in connection pool be present, sentence by second
Disconnected element analysis SQL processing state；If reusable connection is not present in connection pool, terminate this connection.
The technical scheme of the embodiment of the present invention also includes：Second judging unit is used to choose reusable connection, and
The SQL processing state of analysis connection, according to SQL processing condition adjudgement, whether the connection is empty
Not busy state, it is multiplexed if it is, choosing module by connection and choosing the connection；If not, terminate this connection.
The technical scheme of the embodiment of the present invention also includes：The first judging unit analytical structure query language type,
Judge with the presence or absence of reusable connection to include in database connection pool according to SQL type：Looked into according to structuring
Ask language form and set whether the connection is reusable connection, if the SQL type possesses context, institute
State and be connected as not reusable connection；If the SQL type does not possess context, described to be connected as answering
Connection.
The technical scheme of the embodiment of the present invention also includes：Second judging unit analyzes the structuralized query language of the connection
Processing state is sayed, whether the connection is that idle condition includes according to SQL processing condition adjudgement：According to structuring
Whether whether query language be disposed to set the connection idle, and this is connected as if SQL is disposed
Idle condition；This is connected as busy state if SQL is not disposed.
Technical scheme has the following advantages that or beneficial effect：Data base management system connection multiplexing side of the present invention
Method and device set whether MySQL connections can be multiplexed according to processed sql like language type, can fully use a MySQL
Connection, improve overall system performance；And set MySQL connections whether idle according to the processing state of sql like language, and avoid connecting
The problem of multiplexing effect depends on user, improves service efficiency.
Brief description of the drawings
Accompanying drawing 1 is the flow chart of the data base management system connection multiplexing method of first embodiment of the invention；
Accompanying drawing 2 is the flow chart of the data base management system connection multiplexing method of second embodiment of the invention；
Accompanying drawing 3 is the structural representation of the data base management system connection multiplexing device of first embodiment of the invention；
Accompanying drawing 4 is the structural representation of the data base management system connection multiplexing device of second embodiment of the invention.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Referring to Fig. 1, it is the flow chart of the data base management system connection multiplexing method of first embodiment of the invention.This hair
The data base management system connection multiplexing method of bright first embodiment comprises the following steps：
Step S100：Database connection pool object is established, and creates database connection request；
Step S110：Analytical structure query language, according to SQL type and processing condition adjudgement data
Reusable in the connection pool of storehouse with the presence or absence of idle condition connects, if it does, performing step S120；
In step s 110, for a database operation requests, the present invention is according to SQL（Structured Query
Language, SQL, be a kind of data base querying and programming language, for access data and inquiry,
Renewal and administrative relationships Database Systems）Language form sets whether the connection is reusable connection, and the criterion of setting is：If
The sql like language type possesses context, then this is connected as not reusable connection；If the sql like language type does not possess
Context, then this be connected as reusable connection；Wherein, context is the ordered sequence of an attribute, and they are to reside in ring
Domestic object definition environment, context being created in the activation of object, object is configured as requiring some automation services,
Such as synchronization, in real time affairs, activation and security；The present invention sets the connection to be according to whether sql like language is disposed
No free time, the criterion of setting are：This is connected as idle condition if sql like language is disposed, if sql like language is not handled
Finish, this is connected as busy state.
Step S120：The reusable connection for choosing the idle condition is multiplexed；
In the step s 120, one connects the condition that is re-used and is：This is connected as reusable connection and this is connected as the free time
State.
Referring to Fig. 2, it is the flow chart of the data base management system connection multiplexing method of second embodiment of the invention.This hair
The data base management system connection multiplexing method of bright second embodiment comprises the following steps：
Step S200：Database connection pool object is established, and the threshold values of connection pool connection number is set；
Step S210：Database connection request is created, and judges whether the connection number in connection pool exceedes threshold value, if
It is no, perform step S220；If it is, perform step S230；
Step S220：A new connection is created, and performs step S260；
Step S230：Analyze sql like language type, according to sql like language type judge in database connection pool whether there is can
The connection of multiplexing, if it is, performing step S240；If not, perform step S260；
In step S230, for a database operation requests, the present invention is according to SQL（Structured Query
Language, SQL, be a kind of data base querying and programming language, for access data and inquiry,
Renewal and administrative relationships Database Systems）Language form sets whether the connection is reusable connection, and the criterion of setting is：If
The sql like language type possesses context, then this is connected as not reusable connection；If the sql like language type does not possess
Context, then this be connected as reusable connection；Wherein, context is the ordered sequence of an attribute, and they are to reside in ring
Domestic object definition environment, context being created in the activation of object, object is configured as requiring some automation services,
Such as synchronization, in real time affairs, activation and security.
Step S240：The reusable connection is chosen, and analyzes the sql like language processing state of the connection, according to sql like language
Whether the connection of processing condition adjudgement is idle condition, if it is, performing step S250；If not, perform step S260；
In step S240, for a connection, the present invention sets the connection to be according to whether sql like language is disposed
No free time, the criterion of setting are：This is connected as idle condition if sql like language is disposed；If sql like language is not handled
Finish, this is connected as busy state.
Step S250：The reusable connection for choosing the idle condition is multiplexed；
In step s 250, one connects the condition that is re-used and is：This is connected as reusable connection and this is connected as the free time
State.
Step S260：Terminate this connection.
Referring to Fig. 3, it is the structural representation of the data base management system connection multiplexing device of first embodiment of the invention.
The data base management system connection multiplexing device of first embodiment of the invention establishes module, database connection mould including connection pool
Module is chosen in block, connection judgment module and connection, wherein,
Connection pool establishes module and is used to establish database connection pool object；
Database connection module is used to create database connection request；
Connection judgment module is used for analytical structure query language, is sentenced according to SQL type and processing state
Reusable in disconnected database connection pool with the presence or absence of idle condition connects, should if it does, being chosen by connection selection module
Connection is multiplexed；Wherein, for a database operation requests, the present invention is according to SQL（Structured Query
Language, SQL, be a kind of data base querying and programming language, for access data and inquiry,
Renewal and administrative relationships Database Systems）Language form sets whether the connection is reusable connection, and the criterion of setting is：If
The sql like language type possesses context, then this is connected as not reusable connection；If the sql like language type does not possess
Context, then this be connected as reusable connection；Wherein, context is the ordered sequence of an attribute, and they are to reside in ring
Domestic object definition environment, context being created in the activation of object, object is configured as requiring some automation services,
Such as synchronization, in real time affairs, activation and security；The present invention sets the connection to be according to whether sql like language is disposed
No free time, the criterion of setting are：This is connected as idle condition if sql like language is disposed；If sql like language is not handled
Finish, this is connected as busy state.
Connection is chosen reusable connection of the module for choosing idle condition and is multiplexed；Wherein, a connection is re-used
Condition be：This is connected as reusable connection and this is connected as idle condition.
Referring to Fig. 4, it is the structural representation of the data base management system connection multiplexing device of second embodiment of the invention.
The data base management system connection multiplexing device of second embodiment of the invention establishes module, database connection mould including connection pool
Module is chosen in block, connection number judge module, connection creation module, connection judgment module and connection, wherein,
Connection pool establishes module and is used to establish database connection pool object, and sets the threshold values of connection pool connection number；
Database connection module is used to create database connection request；
Connection number judge module is used to judge whether the connection number in connection pool exceedes threshold value, if not, being created by connecting
Build the new connection of module creation；If it is, judge whether that reusable connects by connection judgment module；
Creation module is connected to be used to create a new connection；
Connection judgment module is used for analytical structure query language, is sentenced according to SQL type and processing state
Reusable in disconnected database connection pool with the presence or absence of idle condition connects, should if it does, being chosen by connection selection module
Connection is multiplexed；Specifically, connection judgment module includes the first judging unit and the second judging unit,
First judging unit is used to analyze sql like language type, according to sql like language type judge in database connection pool whether
Reusable connection be present, if it is, analyzing sql like language by the second judging unit handles state；If not, terminate this company
Connect；Wherein, for a database operation requests, the present invention is according to SQL（Structured Query Language, structuring
Query language, it is a kind of data base querying and programming language, for accessing data and inquiry, renewal and administrative relationships number
According to storehouse system）Language form sets whether the connection is reusable connection, and the criterion of setting is：If the sql like language type is
Possesses context, then this is connected as not reusable connection；If the sql like language type does not possess context, the connection
For reusable connection；Wherein, context is the ordered sequence of an attribute, and they are the object definition ring resided in environment
Border, context is created in the activation of object, object is configured as requiring some automation services, such as synchronization, affairs, real-time
Activation and security etc..
Second judging unit is used to choose the reusable connection, and analyzes the sql like language processing state of the connection, according to
Whether the connection of sql like language processing condition adjudgement is idle condition, if it is, choosing connection progress by connecting selection module
Multiplexing；If not, terminate this connection；Wherein, set for a connection, the present invention according to whether sql like language is disposed
Put whether the connection is idle, the criterion of setting is：This is connected as idle condition if sql like language is disposed；If SQL languages
Speech is not disposed, and this is connected as busy state.
Connection is chosen reusable connection of the module for choosing the idle condition and is multiplexed；Wherein, a connection is answered
Condition is：This is connected as reusable connection and this is connected as idle condition.
Data base management system connection multiplexing method and device of the present invention sets MySQL according to processed sql like language type
Whether connection can be multiplexed, and can fully use a MySQL connection, improve overall system performance；And according to the place of sql like language
Whether reason state sets MySQL connections idle, and the problem of avoid connection multiplexing effect from depend on user, improve to use and imitates
Rate.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the invention, all essences in the present invention
All any modification, equivalent and improvement made within refreshing and principle etc., should be included in the scope of the protection.
Claims (12)
1. a kind of data base management system connection multiplexing method, including：
Database connection pool object is established, and creates database connection request；
Analytical structure query language, according to SQL type and processing condition adjudgement database connection pool in whether
The reusable connection of idle condition be present, if it does, performing next step；Wherein, according to processed SQL
Type set database connect whether reusable, according to the processing condition setup data storehouse of processed SQL connect
It is whether idle；
The reusable connection for choosing the idle condition is multiplexed.
2. data base management system connection multiplexing method according to claim 1, it is characterised in that described to establish database
Connection pool object step also includes：Connection pool is set to connect the threshold values of number, the establishment database connection request step also includes：
Judge whether the connection number in connection pool exceedes threshold value, if the connection number in connection pool is not above threshold value, create one
New connection；If the connection number in connection pool exceedes threshold value, analytical structure query language.
3. data base management system connection multiplexing method according to claim 1, it is characterised in that described according to structuring
Reusable Connection Step in query language type and processing condition adjudgement database connection pool with the presence or absence of idle condition also wraps
Include：Analytical structure query language type, judged according to SQL type in database connection pool with the presence or absence of can
The connection of multiplexing, if reusable connection in connection pool be present, analyze the SQL processing state of the connection；Such as
Reusable connection is not present in fruit connection pool, terminates this connection.
4. data base management system connection multiplexing method according to claim 3, it is characterised in that described according to structuring
Reusable Connection Step in query language type and processing condition adjudgement database connection pool with the presence or absence of idle condition also wraps
Include：The reusable connection is chosen, and analyzes the SQL processing state of connection, at SQL
Manage condition adjudgement connection whether be idle condition, if being connected as idle condition, choose the idle condition reusable connect into
Row multiplexing；If being connected as busy state, terminate this connection.
5. data base management system connection multiplexing method according to claim 3, it is characterised in that the analytical structure
Query language type, judge to wrap with the presence or absence of reusable connection in database connection pool according to SQL type
Include：Set whether connection is reusable connection according to SQL type, the criterion of setting is：If structuralized query
Language form possesses context, then is connected as not reusable connection；If SQL type does not possess context,
Then it is connected as reusable connection.
6. data base management system connection multiplexing method according to claim 4, it is characterised in that described analysis connection
SQL processing state, handle whether the condition adjudgement connection is idle condition bag according to SQL
Include：Set connection whether idle according to whether SQL is disposed, the criterion of setting is：If structuring is looked into
Ask Language Processing to finish, this is connected as idle condition；This is connected as non-NULL if SQL is not disposed
Not busy state.
7. a kind of data base management system connection multiplexing device, including connection pool establish module and database connection module, described
Connection pool establishes module and is used to establish database connection pool object；The database connection module please for creating database connection
Ask；Characterized in that, also including connection judgment module and connection selection module, the connection judgment module is used for analytical structure
Query language, it whether there is idle condition according in SQL type and processing condition adjudgement database connection pool
Reusable connects, and is multiplexed if it does, choosing module by connection and choosing the connection；Wherein, according to processed structuring
Query language type set database connect whether reusable, according to the processing state of processed SQL set number
It is whether idle according to storehouse connection；The connection is chosen reusable connection of the module for choosing idle condition and is multiplexed.
8. data base management system connection multiplexing device according to claim 7, it is characterised in that also include connection number and sentence
Disconnected module and connection creation module, the connection pool establish module and establish database connection pool object and set connection pool to connect number
Threshold values, the connection number judge module is used to judge whether the connection number in connection pool exceedes threshold value, if in connection pool
Connection number is not above threshold value, and new connection is created by connecting creation module；If the connection number in connection pool exceedes threshold value,
Judge whether that reusable connects by connection judgment module；The connection creation module is used to create new connection.
9. data base management system connection multiplexing device according to claim 7, it is characterised in that the connection judgment mould
Block also includes the first judging unit and the second judging unit, and first judging unit is used for analytical structure query language class
Type, judged to whether there is reusable connection in database connection pool according to SQL type, if in connection pool
Reusable connection be present, state is handled by the second judging unit analytical structure query language；If do not deposited in connection pool
In reusable connection, terminate this connection.
10. data base management system connection multiplexing device according to claim 9, it is characterised in that described second judges
Unit is used to choose reusable connection, and analyzes the SQL processing state of connection, according to structuralized query language
Whether the connection of speech processing condition adjudgement is idle condition, is multiplexed if it is, choosing module by connection and choosing the connection；
If not, terminate this connection.
11. data base management system connection multiplexing device according to claim 9, it is characterised in that described first judges
Element analysis SQL type, judged according to SQL type in database connection pool with the presence or absence of can
The connection of multiplexing includes：Set whether the connection is reusable connection according to SQL type, if the structuring
Query language type possesses context, then described to be connected as not reusable connection；If the SQL type is not
Possess context, then it is described to be connected as reusable connection.
12. data base management system connection multiplexing device according to claim 10, it is characterised in that described second judges
The SQL processing state of the element analysis connection, according to SQL processing condition adjudgement, the connection is
It is no to include for idle condition：Set the connection whether idle according to whether SQL is disposed, such as fruit structure
Change query language to be disposed, this is connected as idle condition；This is connected as if SQL is not disposed
Busy state.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210453646.6A CN103810203B (en) | 2012-11-13 | 2012-11-13 | A kind of data base management system connection multiplexing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210453646.6A CN103810203B (en) | 2012-11-13 | 2012-11-13 | A kind of data base management system connection multiplexing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103810203A CN103810203A (en) | 2014-05-21 |
| CN103810203B true CN103810203B (en) | 2018-02-27 |
Family
ID=50706986
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210453646.6A Active CN103810203B (en) | 2012-11-13 | 2012-11-13 | A kind of data base management system connection multiplexing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103810203B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110781244B (en) * | 2014-12-03 | 2023-06-13 | 阿里巴巴集团控股有限公司 | Method and device for controlling concurrent operation of database |
| CN104636131B (en) * | 2014-12-12 | 2018-07-27 | 北京奇虎科技有限公司 | A kind of execution method and device of special instruction |
| CN105138693A (en) * | 2015-09-18 | 2015-12-09 | 联动优势科技有限公司 | Method and device for having access to databases |
| CN105426285B (en) * | 2015-10-28 | 2019-01-18 | 联动优势科技有限公司 | The method and apparatus of database connection pool monitoring and management |
| CN106021544B (en) * | 2016-05-27 | 2020-02-07 | 北京京东尚科信息技术有限公司 | Database distributed connection pool management method and system |
| CN108268546B (en) * | 2016-12-30 | 2022-05-10 | 中国移动通信集团黑龙江有限公司 | Method and device for optimizing database |
| CN112910793B (en) * | 2019-12-04 | 2023-04-07 | 天翼云科技有限公司 | Method for connection multiplexing in seven-layer load balancing and load balancer |
| CN117539949B (en) * | 2024-01-10 | 2024-04-12 | 腾讯科技（深圳）有限公司 | Processing method and device of database access request, electronic equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1510575A (en) * | 2002-12-25 | 2004-07-07 | ����ͨѶ�ɷ�����˾ | High-efficient administration method for database connection |
| CN102708175A (en) * | 2012-05-07 | 2012-10-03 | 北京航空航天大学 | Automatic reconnection method and automatic reconnection device for contingency interrupt of database connection |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8712965B2 (en) * | 2006-06-29 | 2014-04-29 | International Business Machines Corporation | Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse |
| US20080104080A1 (en) * | 2006-11-01 | 2008-05-01 | Monte Kim Copeland | Method and apparatus to access heterogeneous configuration management database repositories |
| US8996503B2 (en) * | 2010-10-04 | 2015-03-31 | Sybase, Inc. | Query plan optimization for prepared SQL statements |
-
2012
- 2012-11-13 CN CN201210453646.6A patent/CN103810203B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1510575A (en) * | 2002-12-25 | 2004-07-07 | ����ͨѶ�ɷ�����˾ | High-efficient administration method for database connection |
| CN102708175A (en) * | 2012-05-07 | 2012-10-03 | 北京航空航天大学 | Automatic reconnection method and automatic reconnection device for contingency interrupt of database connection |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103810203A (en) | 2014-05-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103810203B (en) | A kind of data base management system connection multiplexing method and device | |
| CN109783229A (en) | The method and device of thread resources distribution | |
| CN109766200A (en) | A kind of message queue processing method, device, equipment and storage medium | |
| CN104618433B (en) | A kind of service combining method based on eca rule | |
| CN107426448A (en) | A kind of automatic calling allocation method being lined up based on dynamic priority | |
| CN112492003A (en) | Cloud network convergence service processing method and device based on service orchestrator | |
| CN106339217B (en) | Event management method and system based on Unity | |
| CN103516759B (en) | Cloud system method for managing resource, cloud call center are attended a banquet management method and cloud system | |
| CN101159569B (en) | Method of issuing user service capability and present server and communication service system | |
| CN104754153A (en) | Customer service system and customer service method thereof | |
| CN111163238A (en) | Intelligent scheduling method of online customer service system | |
| CN107766160A (en) | Queue message processing method and terminal device | |
| CN107015850A (en) | Thread scheduling method and device | |
| CN109471872A (en) | Handle the method and device of high concurrent inquiry request | |
| CN102750354A (en) | Method for analyzing and processing non-structured data query operating language | |
| CN102567493A (en) | Data report system and report generation method with dynamic data source | |
| CN106227782A (en) | A kind of method being inserted into data base based on multi-data source | |
| CN106970838A (en) | The dispatching method and device of thread during a kind of search engine calling interface | |
| CN101953188A (en) | Method and apparatus for processing multi-channel request subscription under service management platform | |
| CN106445514A (en) | Android platform Activity instance management method and equipment | |
| CN104050284B (en) | A kind of data asynchronous query method and system based on one process | |
| CN1567835A (en) | Distributed cluster service management system and service management method in intelligent network | |
| CN104239537A (en) | Method for realizing generating and processing flow for large-data pre-processing text data | |
| CN108877785A (en) | Speech-sound intelligent housekeeping service system | |
| CN102662732A (en) | Double-drive thread pool model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |