CN105279263A - Database connection system and method capable of supporting multi-application sharing - Google Patents
Database connection system and method capable of supporting multi-application sharing Download PDFInfo
- Publication number
- CN105279263A CN105279263A CN201510698186.7A CN201510698186A CN105279263A CN 105279263 A CN105279263 A CN 105279263A CN 201510698186 A CN201510698186 A CN 201510698186A CN 105279263 A CN105279263 A CN 105279263A
- Authority
- CN
- China
- Prior art keywords
- database
- connection
- grouping
- combining
- application
- 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
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
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Abstract
The invention discloses a database connection system capable of supporting multi-application sharing. The database connection system comprises a database grouping connection medium, wherein the database grouping connection medium is used for receiving the database connection request instructions of a plurality of application programs and distributing database connection for each application program according to the database connection request instructions; and the database grouping connection medium is connected with a database. Each application program is not directly connected with the database by an own database connection pool of each application program, instead, the database grouping connection medium is connected with the database to send the database connection request instructions to the database grouping connection medium, and the database grouping connection medium distributes the database connection for each application program according to the database connection request instruction of each application. The database grouping connection medium carries out equilibrium management and reasonable distribution on the database connection, database connection efficiency is improved, database connection waste is avoided, and a database connection use ratio can be greatly improved for a situation that a plurality of applications access the same database.
Description
Technical field
The application relates to DataBase combining field, particularly a kind of DataBase combining system and method supporting many Application share.
Background technology
Along with the development of technology, people more and more pay close attention to the method that many Application share connect same database.
Existing database connection pool is mainly applied to single application, the situation that corresponding single application there will not be DataBase combining to waste, but for many application, can not shared data bank physical connection between these connection pools, cannot communicate and coordinate, the application data base easily caused connects restriction, and some application data bases connect not enough situation, cause the waste of DataBase combining.
Therefore, how to make full use of each connection of database, avoid the connection in certain application to leave unused, and the not enough drawback of connection in other application, the Utilization ability improving DataBase combining is the current technical issues that need to address of those skilled in the art.
Summary of the invention
Technical problems to be solved in this application are to provide a kind of DataBase combining system and method supporting many Application share, solve the application data base easily caused in prior art and connect restriction, some application data bases connect not enough situation, cause the problem of the waste of DataBase combining.
Its concrete scheme is as follows:
Support a DataBase combining system for many Application share, this system comprises:
Database grouping connects intermediary, for receiving the DataBase combining request instruction of multiple application program, and is each application assigned DataBase combining according to described DataBase combining request instruction;
Described database grouping connects intermediary and is connected with database.
Above-mentioned system, preferably, described database grouping connects intermediary and comprises:
Database grouping connection pool.
Above-mentioned system, preferably, described database grouping connection pool, comprising:
The dbConnect Manager be connected successively, load equalizer and connection route device;
Described dbConnect Manager, for receiving the DataBase combining request instruction of multiple application program, and reuses by parameter judgement the connection used in connection pool, the newly-increased and destruction of the connection in the connection pool of process database grouping simultaneously;
Described load equalizer, for the service condition of analytical database physical connection, and according to the request instruction of DataBase combining, is that each application assigned database physical connects;
Described connection route device, for connection data storehouse, and sends to dbConnect Manager to manage the DataBase combining of generation.
Support a database connection method for many Application share, be applied to a kind of DataBase combining system supporting many Application share, this system comprises database grouping and connects intermediary, and described database grouping connects intermediary and is connected with database;
The method comprises:
Multiple application program sends DataBase combining request instruction;
Described database grouping connects the DataBase combining request instruction that intermediary receives multiple application program, and is each application assigned DataBase combining according to described DataBase combining request instruction;
Described database grouping connects intermediary and is connected with Database.
A kind of DataBase combining system supporting many Application share that the application provides, comprise: database grouping connects intermediary, for receiving the DataBase combining request instruction of multiple application program, and be each application assigned DataBase combining according to described DataBase combining request instruction; Described database grouping connects intermediary and is connected with database.In the application, each application program is not utilize the database connection pool of oneself to be directly connected with Database, but database grouping connection intermediary is connected with database, database is sent to by DataBase combining request instruction to divide into groups to connect intermediary, it is each application assigned DataBase combining according to the DataBase combining request instruction that each is applied that database grouping connects intermediary, database grouping connects intermediary and carries out balanced management to DataBase combining, reasonable distribution, improve DataBase combining efficiency, avoid DataBase combining waste, for the situation of the same database of many application access, greatly can improve the utilization factor of DataBase combining.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present application, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the application, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is a kind of structural representation supporting the DataBase combining system embodiment of many Application share of the application.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present application, be clearly and completely described the technical scheme in the embodiment of the present application, obviously, described embodiment is only some embodiments of the present application, instead of whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not making the every other embodiment obtained under creative work prerequisite, all belong to the scope of the application's protection.
With reference to figure 1, show a kind of structural representation supporting the DataBase combining system embodiment of many Application share of the application, this system comprises:
Database grouping connects intermediary, for receiving the DataBase combining request instruction of multiple application program, and is each application assigned DataBase combining according to described DataBase combining request instruction.
Described database grouping connects intermediary and is connected with database.
In the application, an intermediary is set up between application and database, this intermediary can provide quantity to be greater than the connection of the maximum number of connections that database can provide, that is, application configuration or the DataBase combining sum kept can be greater than the actual linking number of database, and the rear end of intermediary is connected with database.When there being request process, intermediary's ability to database, after request returns, then accepts request forward other request, thus reaches efficiently reusing of DataBase combining, reduces the waste of DataBase combining.
It is database grouping connection pool that described database grouping connects intermediary.
Database connection pool is when system initialization, is stored in internal memory using DataBase combining as object, when user needs accessing database, not sets up a new connection, but take out an idle connecting object set up from connection pool.After finishing using, connection also not by connection closed, but is put back in connection pool by user, uses for next request access.And establishment of connection, disconnection are all managed by connection pool self.
Database grouping connection pool carries out grouping management to each DataBase combining applied, sum can be provided to be greater than the actual available maximum number of connections of database, namely each application not only can configure more maximum number of connections (concrete numeral can be determined according to the visit capacity of application), these connections are all in connection status, in extreme circumstances, even all database processing power can be obtained.Secondly, due to the mode adopting DataBase combining to share, each connection of database can be made full use of, avoid the connection in certain application to leave unused, and the drawback that connection in other application is not enough, thus drastically increase the Utilization ability of DataBase combining.
Described database grouping connection pool, comprising: the dbConnect Manager be connected successively, load equalizer and connection route device.
Application program comprises SQL statement, when application program initiates the request to database, first this request arrives dbConnect Manager, dbConnect Manager by parameter (such as: user name, database, protocol version) judge to reuse the connection used in connection pool, the operations such as newly-increased, the destruction of the connection simultaneously in dbConnect Manager process connection pool.
When there being database processing request to enter, connection request is sent to load equalizer by dbConnect Manager, and load equalizer is responsible for the service condition of analytical database physical connection, and connects according to request dispatching database physical.
Connection route device can be real be connected with Database, and give dbConnect Manager by the connection of generation and manage.
A kind of DataBase combining system supporting many Application share that the application provides, each application program is not utilize the database connection pool of oneself to be directly connected with Database, but share a database grouping connection intermediary, database grouping connects intermediary and is connected with database, database is sent to by DataBase combining request instruction to divide into groups to connect intermediary, it is each application assigned DataBase combining according to the DataBase combining request instruction that each is applied that database grouping connects intermediary, database grouping connects intermediary and carries out balanced management to DataBase combining, reasonable distribution, improve DataBase combining efficiency, avoid DataBase combining waste, for the situation of the same database of many application access, greatly can improve the utilization factor of DataBase combining.
Corresponding with a kind of system supporting that the DataBase combining system embodiment of many Application share provides of above-mentioned the application, present invention also provides a kind of database connection method embodiment supporting many Application share, in the present embodiment, the method is applied to above-mentioned a kind of DataBase combining system supporting many Application share, this system comprises database grouping and connects intermediary, and described database grouping connects intermediary and is connected with database;
The method comprises:
Multiple application program sends DataBase combining request instruction.
Described database grouping connects the DataBase combining request instruction that intermediary receives multiple application program, and is each application assigned DataBase combining according to described DataBase combining request instruction.
Described database grouping connects intermediary and is connected with Database.
To sum up, the application sets up an agent platform between application and database, balanced management is carried out to DataBase combining, reasonable distribution, improve DataBase combining efficiency, avoid DataBase combining to waste, for the situation of the same database of many application access, greatly can improve the utilization factor of DataBase combining
It should be noted that, each embodiment in this instructions all adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar part mutually see.
Finally, also it should be noted that, in this article, the such as relational terms of first and second grades and so on is only used for an entity or operation to separate with another entity or operational zone, and not necessarily requires or imply the relation that there is any this reality between these entities or operation or sequentially.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thus make to comprise the process of a series of key element, method, article or equipment and not only comprise those key elements, but also comprise other key elements clearly do not listed, or also comprise by the intrinsic key element of this process, method, article or equipment.When not more restrictions, the key element limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment comprising described key element and also there is other identical element.
For convenience of description, various unit is divided into describe respectively with function when describing above device.Certainly, the function of each unit can be realized in same or multiple software and/or hardware when implementing the application.
What provide the application above a kind ofly supports that the DataBase combining system and method for many Application share is described in detail, apply specific case herein to set forth the principle of the application and embodiment, the explanation of above embodiment is just for helping method and the core concept thereof of understanding the application; Meanwhile, for one of ordinary skill in the art, according to the thought of the application, all will change in specific embodiments and applications, in sum, this description should not be construed as the restriction to the application.
Claims (4)
1. support a DataBase combining system for many Application share, it is characterized in that, this system comprises:
Database grouping connects intermediary, for receiving the DataBase combining request instruction of multiple application program, and is each application assigned DataBase combining according to described DataBase combining request instruction;
Described database grouping connects intermediary and is connected with database.
2. system according to claim 1, is characterized in that, described database grouping connects intermediary and comprises:
Database grouping connection pool.
3. system according to claim 2, is characterized in that, described database grouping connection pool, comprising:
The dbConnect Manager be connected successively, load equalizer and connection route device;
Described dbConnect Manager, for receiving the DataBase combining request instruction of multiple application program, and reuses by parameter judgement the connection used in connection pool, the newly-increased and destruction of the connection in the connection pool of process database grouping simultaneously;
Described load equalizer, for the service condition of analytical database physical connection, and according to the request instruction of DataBase combining, is that each application assigned database physical connects;
Described connection route device, for connection data storehouse, and sends to dbConnect Manager to manage the DataBase combining of generation.
4. support a database connection method for many Application share, it is characterized in that, be applied to a kind of DataBase combining system supporting many Application share, this system comprises database grouping and connects intermediary, and described database grouping connects intermediary and is connected with database;
The method comprises:
Multiple application program sends DataBase combining request instruction;
Described database grouping connects the DataBase combining request instruction that intermediary receives multiple application program, and is each application assigned DataBase combining according to described DataBase combining request instruction;
Described database grouping connects intermediary and is connected with Database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510698186.7A CN105279263A (en) | 2015-10-23 | 2015-10-23 | Database connection system and method capable of supporting multi-application sharing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510698186.7A CN105279263A (en) | 2015-10-23 | 2015-10-23 | Database connection system and method capable of supporting multi-application sharing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105279263A true CN105279263A (en) | 2016-01-27 |
Family
ID=55148277
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510698186.7A Pending CN105279263A (en) | 2015-10-23 | 2015-10-23 | Database connection system and method capable of supporting multi-application sharing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105279263A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106021544A (en) * | 2016-05-27 | 2016-10-12 | 北京京东尚科信息技术有限公司 | Distributive connection pool management method and system for databases |
| 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 |
| CN109145061A (en) * | 2018-07-26 | 2019-01-04 | 阿里巴巴集团控股有限公司 | A kind of method, database and the server of database distribution session object |
| CN111131173A (en) * | 2016-10-20 | 2020-05-08 | 杭州孚嘉科技有限公司 | Method for actively providing service by intranet |
| CN111949721A (en) * | 2020-08-25 | 2020-11-17 | 深圳市广通软件有限公司 | Method, system and storage medium for realizing quick access of Web database |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102346767A (en) * | 2011-09-19 | 2012-02-08 | 北京金和软件股份有限公司 | Database connection method based on double connection pools |
| CN103605727A (en) * | 2013-11-19 | 2014-02-26 | 浪潮电子信息产业股份有限公司 | Connection pool based efficient multiuser database access optimization method and framework |
| CN104871134A (en) * | 2013-04-26 | 2015-08-26 | 甲骨文国际公司 | Support for cloud-based multi-tenant environments using connection labeling |
-
2015
- 2015-10-23 CN CN201510698186.7A patent/CN105279263A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102346767A (en) * | 2011-09-19 | 2012-02-08 | 北京金和软件股份有限公司 | Database connection method based on double connection pools |
| CN104871134A (en) * | 2013-04-26 | 2015-08-26 | 甲骨文国际公司 | Support for cloud-based multi-tenant environments using connection labeling |
| CN103605727A (en) * | 2013-11-19 | 2014-02-26 | 浪潮电子信息产业股份有限公司 | Connection pool based efficient multiuser database access optimization method and framework |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106021544A (en) * | 2016-05-27 | 2016-10-12 | 北京京东尚科信息技术有限公司 | Distributive connection pool management method and system for databases |
| 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 |
| 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 |
| CN111131173A (en) * | 2016-10-20 | 2020-05-08 | 杭州孚嘉科技有限公司 | Method for actively providing service by intranet |
| CN109145061A (en) * | 2018-07-26 | 2019-01-04 | 阿里巴巴集团控股有限公司 | A kind of method, database and the server of database distribution session object |
| CN111949721A (en) * | 2020-08-25 | 2020-11-17 | 深圳市广通软件有限公司 | Method, system and storage medium for realizing quick access of Web database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105279263A (en) | Database connection system and method capable of supporting multi-application sharing | |
| CN105283838B (en) | Distributed lock management in cloud computing environment | |
| CN102750602B (en) | A kind of cloud platform isomery Integrative resource management system | |
| CN102821162B (en) | Towards the system of loose cloud node serve platform under system for cloud computing environment | |
| CN102426596B (en) | Map loading method and device | |
| Moghaddam et al. | Cloud computing: Vision, architecture and Characteristics | |
| CN105531688A (en) | Providing services as resources for other services | |
| CN105049435A (en) | Cloud testing framework oriented to protocol conformance of heterogeneous wireless sensor network | |
| CN105518648A (en) | Providing resources to customers via node-relationship models | |
| CN103744719A (en) | Lock management method, lock management system, lock management system configuration method and lock management system configuration device | |
| CN105824625A (en) | Business application construction device and method based on cloud environment | |
| CN109462508A (en) | Node deployment method, device and storage medium | |
| CN103886104A (en) | Distributed real-time database management system and implementation method applicable to electric system | |
| CN103997523A (en) | Smart city service system based on cloud services and implementation method thereof | |
| CN103747107A (en) | Compatible cloud operating platform and realizing method thereof | |
| CN103929441A (en) | Task allocation method and device | |
| CN104468223B (en) | A kind of data center calculates, stored, the network equipment manages distribution method automatically | |
| CN109743202B (en) | Data management method, device and equipment and readable storage medium | |
| CN108848132A (en) | A kind of distribution scheduling station system based on cloud | |
| CN110071965A (en) | A kind of data center management system based on cloud platform | |
| CN103729742B (en) | A kind of Data Resources Management System based on SOA framework and executing model drive structure | |
| CN108376214A (en) | Right management method, device and vehicle-mounted background system | |
| CN110086854A (en) | A kind of privately owned cloud system of distribution | |
| CN104008200B (en) | Lock the treating method and apparatus of application | |
| CN105933270A (en) | Cloud encryptor processing method and apparatus |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160127 |
|
| RJ01 | Rejection of invention patent application after publication |