CN105824866A - Distributed type relational database shared connection pool achieved on basis of NIO - Google Patents
Distributed type relational database shared connection pool achieved on basis of NIO Download PDFInfo
- Publication number
- CN105824866A CN105824866A CN201510929544.0A CN201510929544A CN105824866A CN 105824866 A CN105824866 A CN 105824866A CN 201510929544 A CN201510929544 A CN 201510929544A CN 105824866 A CN105824866 A CN 105824866A
- Authority
- CN
- China
- Prior art keywords
- data access
- access agent
- connection pool
- layer
- agent layer
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
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)
- Computing Systems (AREA)
- Computer And Data Communications (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a distributed type relational database shared connection pool achieved on the basis of an NIO. The distributed type relational database shared connection pool comprises a business application layer, a data access agent layer and a storage layer, wherein the business application layer is used for shielding complex protocols of the business application layer and the data access agent layer by using a communication protocol jar packet provided by a data access agent in an embedded jar packet invasion mode; the data access agent layer is used for providing a core service function of the whole data access agent layer; the storage layer is used as an Oracle database of a data persistence zone and is abutted with the Oracle database through a JDBC driving program. By adopting the distributed type relational database shared connection pool, the total connection number of Oracle servers can be reduced, the total connection number of application establishment is reduced, and multiple types of target databases can be supported.
Description
Technical field
The present invention relates to connection pool, particularly relate to one and realize the shared connection pool of distributed relational database based on NIO.
Background technology
Owing to the data volume of the transaction of telecommunication system is the hugest, application service is many, the database link number that single oracle database can be supported is limited to machine performance and Oracle service, it is difficult to bears substantial amounts of application service and connects.And data have divided multiple disparate databases node according to business and districts and cities, application needs to create multiple data source and connects different database nodes, causes database link waste serious, has reached database node maximum link number bottleneck.So in order to improve database link utilization rate, improving database performance, a kind of multiplex data storehouse chained technology is needed to create database connection pool quantity and multiplexing disparate databases node link to reach to reduce to apply.
Summary of the invention
The technical problem to be solved in the present invention is, for the deficiencies in the prior art, it is provided that a kind of can reduce oracle server always connect number, save application create always connect number, support polytype target database realize the shared connection pool of distributed relational database based on NIO.
For solving above-mentioned technical problem, the present invention adopts the following technical scheme that.
One realizes the shared connection pool of distributed relational database based on NIO, it includes service application layer, data access Agent layer and accumulation layer, wherein: the communication protocol jar bag that described service application layer is provided by data access agency, use and embed jar bag invasive pattern, shielding service application layer and the complex protocol of data access Agent layer, simplify the communication process of service application layer；Described data access Agent layer is for providing the kernel service function of whole data access Agent layer；Described accumulation layer, as the oracle database in data persistence district, docks oracle database by JDBC driver.
Preferably, described data access Agent layer includes routing procedure, and it points to corresponding database connection pool by database user name.
Preferably, described data access Agent layer includes SQL statement transparent transmission process, the most not to applying incoming SQL to be altered, performs in the Oracle that user name is pointed to, and returns perform result to application end.
Preferably, described data access Agent layer supports many Oracle storehouse, acts on behalf of multiple oracle database simultaneously, and the connection pool unification of all access data bases is managed by data access Agent layer.
The present invention having the beneficial effects that compared to existing technologies, first, the database user that the present invention makes multiple application system identical shares connection pool, with reach to save connect reduce oracle server always connect number；Secondly, present invention achieves one connection pool multiplexing of application and link multiple database nodes, apply create always to connect number to reach to save；Additionally, the present invention shields the difference of various database protocol, support that rear end is stored polytype target database, including MySQL, DB2, Oracle etc..
Accompanying drawing explanation
Fig. 1 is the composition frame chart of the present invention.
Detailed description of the invention
With embodiment, the present invention is described in more detail below in conjunction with the accompanying drawings.
The invention discloses one and realize the shared connection pool of distributed relational database based on NIO, as shown in Figure 1, it includes service application layer 1, data access Agent layer 2 and accumulation layer 3, wherein: the communication protocol jar bag that described service application layer 1 is provided by data access agency, use and embed jar bag invasive pattern, shielding service application layer 1 and the complex protocol of data access Agent layer 2, simplify the communication process of service application layer 1；Described data access Agent layer 2 is for providing the kernel service function of whole data access Agent layer；Described accumulation layer 3, as the oracle database in data persistence district, docks oracle database by JDBC driver.
Disclosed by the invention realize the shared connection pool of distributed relational database based on NIO, it provides an Oracle access agent layer to be managed collectively the connection pool of all user names, the database user making it to make multiple application system identical shares connection pool, with reach save connect reduce oracle server always connect number.And shield the difference of various database protocol, support that rear end is stored polytype target database, including MySQL, DB2, Oracle etc..The present invention further provided with configuration center and Surveillance center, thus realizes configuring the functions such as simple and convenient, monitoring database link state.
Further, described data access Agent layer 2 includes routing procedure, and it points to corresponding database connection pool by database user name.
In the present embodiment, described data access Agent layer 2 includes SQL statement transparent transmission process, the most not to applying incoming SQL to be altered, performs in the Oracle that user name is pointed to, and returns perform result to application end.
As a kind of optimal way, described data access Agent layer 2 is supported many Oracle storehouse, is acted on behalf of multiple oracle database simultaneously, and the connection pool unification of all access data bases is managed by data access Agent layer 2.
The present invention having the beneficial effects that compared to existing technologies, first, the database user that the present invention makes multiple application system identical shares connection pool, with reach to save connect reduce oracle server always connect number；Secondly, present invention achieves one connection pool multiplexing of application and link multiple database nodes, apply create always to connect number to reach to save；Additionally, the present invention shields the difference of various database protocol, support that rear end is stored polytype target database, including MySQL, DB2, Oracle etc..
The above is preferred embodiment of the present invention, is not limited to the present invention, all amendment, equivalent or improvement etc. made in the technical scope of the present invention, should be included in the range of the present invention protected.
Claims (4)
1. one kind realizes the shared connection pool of distributed relational database based on NIO, it is characterised in that include service application layer, data access Agent layer and accumulation layer, wherein:
The communication protocol jar bag that described service application layer is provided by data access agency, uses the jar bag invasive pattern that embeds, shielding service application layer and the complex protocol of data access Agent layer, simplifies the communication process of service application layer；
Described data access Agent layer is for providing the kernel service function of whole data access Agent layer；
Described accumulation layer, as the oracle database in data persistence district, docks oracle database by JDBC driver.
2. realize the shared connection pool of distributed relational database based on NIO as claimed in claim 1, it is characterised in that described data access Agent layer includes routing procedure, and it points to corresponding database connection pool by database user name.
3. realize the shared connection pool of distributed relational database based on NIO as claimed in claim 1, it is characterized in that, described data access Agent layer includes SQL statement transparent transmission process, the most not to applying incoming SQL to be altered, the Oracle that user name is pointed to performs, returns perform result to application end.
4. realize the shared connection pool of distributed relational database based on NIO as claimed in claim 1, it is characterized in that, described data access Agent layer supports many Oracle storehouse, acts on behalf of multiple oracle database simultaneously, and the connection pool unification of all access data bases is managed by data access Agent layer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510929544.0A CN105824866A (en) | 2015-12-14 | 2015-12-14 | Distributed type relational database shared connection pool achieved on basis of NIO |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510929544.0A CN105824866A (en) | 2015-12-14 | 2015-12-14 | Distributed type relational database shared connection pool achieved on basis of NIO |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105824866A true CN105824866A (en) | 2016-08-03 |
Family
ID=56513491
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510929544.0A Pending CN105824866A (en) | 2015-12-14 | 2015-12-14 | Distributed type relational database shared connection pool achieved on basis of NIO |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105824866A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897299A (en) * | 2015-12-17 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of data bank access method and device |
| CN110019113A (en) * | 2017-08-31 | 2019-07-16 | 华为软件技术有限公司 | A kind of method for processing business and database server of database |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050210073A1 (en) * | 2004-03-19 | 2005-09-22 | Takashi Oeda | System executing log data transfer synchronously and database data transfer asynchronously |
| CN103678354A (en) * | 2012-09-11 | 2014-03-26 | 中国移动通信集团公司 | Local relation type database node scheduling method and device based on cloud computing platform |
-
2015
- 2015-12-14 CN CN201510929544.0A patent/CN105824866A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050210073A1 (en) * | 2004-03-19 | 2005-09-22 | Takashi Oeda | System executing log data transfer synchronously and database data transfer asynchronously |
| CN103678354A (en) * | 2012-09-11 | 2014-03-26 | 中国移动通信集团公司 | Local relation type database node scheduling method and device based on cloud computing platform |
Non-Patent Citations (2)
| Title |
|---|
| CSDN博客: "Oracle统一访问代理层方案", 《HTTPS://BLOG.CSDN.NET/WANGYANGZHIZHOU/ARTICLE/DETAILS/48971069》 * |
| 红黑联盟: "Oracle统一访问代理层方案", 《HTTPS://WWW.2CTO.COM/KF/201510/445019.HTML》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897299A (en) * | 2015-12-17 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of data bank access 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 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20190294621A1 (en) | Management of a database system | |
| EP3365805B1 (en) | Ability to group multiple container databases as a single container database cluster | |
| CN106503163B (en) | Global configuration multi-tenant dynamic data source system based on SaaS application | |
| US10803078B2 (en) | Ability to group multiple container databases as a single container database cluster | |
| CN111294401B (en) | Internet of things equipment access method and device | |
| US20090005065A1 (en) | System and method for setting status flags for mobile data distribution based on distribution rules | |
| CN103136338B (en) | A kind of metadata distribution method based on catalogue division and device | |
| CN103838770A (en) | Logic data partition method and system | |
| CN104519130B (en) | A kind of data sharing caching method across IDC | |
| CN105472002A (en) | Session synchronization method based on instant copying among cluster nodes | |
| CN102063502A (en) | Method for realizing synchronization of data in heterogeneous database | |
| CN102984267B (en) | A kind of method and system that realize distributed caching node and dynamically update client | |
| CN103118130A (en) | Cluster management method and cluster management system for distributed service | |
| US20130060803A1 (en) | Database translation system and method | |
| CN101500145A (en) | Digital household public transportation enquiry system based on bi-directional set-top box | |
| CN103577561B (en) | The storage method of executive plan, apparatus and system | |
| US11140072B2 (en) | Transparent satellite routing system and method | |
| CN105824866A (en) | Distributed type relational database shared connection pool achieved on basis of NIO | |
| CN103761102A (en) | Unified data service platform and implementation method thereof | |
| CN107770277A (en) | Big data collaborative platform based on mixed cloud | |
| CN105306529B (en) | A kind of data-sharing systems and method towards multi-data source | |
| CN106790489A (en) | Parallel data loading method and system | |
| CN101834914B (en) | Method for realizing mapping relation between identity and position | |
| CN105868045A (en) | Data caching method and apparatus | |
| CN105786946A (en) | Virtualized data integration and query system and implementation method thereof |
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: 20160803 |
|
| RJ01 | Rejection of invention patent application after publication |