CN101853274A - Method for realizing interconnection of heterogeneous databases - Google Patents
Method for realizing interconnection of heterogeneous databases Download PDFInfo
- Publication number
- CN101853274A CN101853274A CN 201010167533 CN201010167533A CN101853274A CN 101853274 A CN101853274 A CN 101853274A CN 201010167533 CN201010167533 CN 201010167533 CN 201010167533 A CN201010167533 A CN 201010167533A CN 101853274 A CN101853274 A CN 101853274A
- Authority
- CN
- China
- Prior art keywords
- database
- connection
- server
- platform
- unified
- 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
- 238000000034 method Methods 0.000 title claims abstract description 17
- 230000006855 networking Effects 0.000 claims description 5
- 230000006870 function Effects 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 description 3
- 238000005538 encapsulation Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for realizing the interconnection of heterogeneous databases. In the method, Internet communications engine (ICE) middleware is used for supporting a unified database gateway platform; a java database connectivity (JDBC) driver supported by mainstream databases at present is used for driving the databases; the interface of the ICE middleware performs system internal authentication on connection requests at application ends of the databases, judges the transaction grade of each database application request, allocates connection pool resources to each database application request on a gateway platform, establishes connection with a backstage database platform; and the JDBC interface sends the requests in the connecting pool to a database system on the background so as to complete the connection of the databases.
Description
Technical field
The present invention relates to database technology, specifically a kind of method that realizes that heterogeneous database is interconnected.
Background technology
Along with the development of computer science and technology with popularize, the range of application of database constantly enlarges.Meanwhile, database technology is also in develop rapidly, and various new products constantly occur, and is that the database product of representative moves to maturity gradually with the relevant database.Current, people to the demand of information more and more widely, this demand not only is confined to the mutual visit of database in the department, also relates to the data sharing between the department.Therefore, what current user was faced is the environment of a multi-vendor heterogeneous database, xenogenesis operating system and heterogeneous network, the interconnected more and more urgent demand of people that becomes between heterogeneous database.This is the problem to be solved in the present invention just.As everyone knows, with regard to the interconnected problem of heterogeneous database, which kind of Database Systems no matter, most of basic database use method of operating all is consistent concerning database user, key is how to solve after the user sends the db transaction operation requests, how to connect between database application end and database platform end, processing and transaction results return.This just need be in database application end and the pilot process that is connected database application end and database platform end a kind of program that can satisfy the demands of exploitation.The method that realizes generally is or carries out interface exploitation at the database application end, or carries out interface exploitation at the database platform end.
At present the maximum of usefulness are Oracle, Microsoft SQL Server, MYSQL, the way of general application end exploitation is exactly the database manipulation mechanism that each application end all realizes oneself separately, the mechanism of using also is not quite similar: such as c below the linux, the c++ program is used odbc, the perhaps api of database producer encapsulation.Cbuilder below the Window, vc etc. use odbc usually, and ado also may be own dll encapsulation according to database producer, and web developer then selects jdbc.
Summary of the invention
The purpose of this invention is to provide a kind of method that realizes that heterogeneous database is interconnected.
The objective of the invention is to realize in the following manner, select the ICE middleware to support as the unified database Networking Platform, the JDBC that database-driven then selects the database of present main flow all to provide support, the ICE middleware interface is carried out the internal system checking with the connection request of database application end, judge the affair mechanism grade of every kind of database application request, distribute the connection pool resource at Networking Platform for it then, and connect with the background data base platform, the JDBC interface mails to the Database Systems on backstage with the request in the connection pool, finishes the connection of database;
Concrete steps are as follows:
1) at the database application end, comprise database application server, WEB server, or follow the server system deploy ICE interface software of database server independent operating, set up connection simultaneously with database client;
2) at the database intermediate server, comprise that with the database platform server be same equipment or independent middleware equipment or alone server deploy ICE interface software, the JDBC interface software sets up heterogeneous database and uses connection pool, sets up the connection with database platform simultaneously;
3), comprise equipment, Oracle, SQLServer, MYSQL or other Database Systems deploy JDBC interface software of database server, runtime database system at database platform.
It realizes that core is a kind of unified database operating gateway of exploitation, is applicable to the interconnected of several data storehouse, possesses unified database connection management function, can realize the unified interface of SQL statement.
The present invention is based on above-mentioned development idea, design a kind of unified database gateway.Because the ICE middleware is not only a kind of distributed middleware easily, supports multiple development language, and support the multiple systems platform, so select the ICE middleware to support as the unified database Networking Platform.
Excellent effect of the present invention is, the unified database gateway can carry out the conversion of SQL statement according to different databases, such as type conversion, date function of time conversion etc., and the database application end do not need will be different according to different database writes the sql statement.Simplified the interconnected complicacy of heterogeneous database.Be applicable to the interconnected of several data storehouse, possess unified database connection management function, can realize the unified interface of SQL statement.
The unified database operating gateway, being meant can fulfillment database application end and the interconnected program of database platform, and it is a core of the present invention.
Several data storehouse interconnected is meant the interconnected visit and the operation that are applicable to such as databases such as Oracle, Microsoft SQL Server, MYSQL.
Unified database connection management, the connection request that it is characterized by the database application end carries out intelligent management, avoid occurring a plurality of requests and initiate simultaneously to connect, the database connection that database application end and DataBase Gateway directly are connected with connection pool manages.
Realize the unified interface of SQL statement, be meant and adopt the ICE middleware to support multiple development language and multiple systems platform.
Description of drawings
Accompanying drawing 1 is realized configuration diagram for the unified database operating gateway.
Embodiment
Explain below with reference to Figure of description the interconnected method of realization heterogeneous database of the present invention being done.
The interconnected method of realization heterogeneous database of the present invention, its structure is by of the invention process
Concrete steps are as follows:
1) disposes the ICE interface software at database application end (can be the database application server, be generally the WEB server, be the server system with the database server independent operating), set up connection simultaneously with database client;
2) (can be same equipment at the database intermediate server with the database platform server, it also can be independent middleware equipment, independent server is adopted in suggestion) deploy ICE interface software, the JDBC interface software, set up heterogeneous database and use connection pool, set up connection simultaneously with database platform;
3) in database platform (the database here can be Oracle, SQL Server, MYSQL or other Database Systems for database server, the equipment of runtime database system) deploy JDBC interface software.
Claims (5)
1. method that realizes that heterogeneous database is interconnected, it is characterized in that, select the ICE middleware to support as the unified database Networking Platform, the JDBC that database-driven then selects the database of present main flow all to provide support, the ICE middleware interface is carried out the internal system checking with the connection request of database application end, judge the affair mechanism grade of every kind of database application request, distribute the connection pool resource at Networking Platform for it then, and connect with the background data base platform, the JDBC interface mails to the Database Systems on backstage with the request in the connection pool, finishes the connection of database;
Concrete steps are as follows:
1) at the database application end, comprise database application server, WEB server, or follow the server system deploy ICE interface software of database server independent operating, set up connection simultaneously with database client;
2) at the database intermediate server, comprise that with the database platform server be same equipment or independent middleware equipment or alone server deploy ICE interface software, the JDBC interface software sets up heterogeneous database and uses connection pool, sets up the connection with database platform simultaneously;
3) at database platform, the equipment, Oracle, SQLServer, MYSQL or other Database Systems deploy JDBC interface software that comprise database server, runtime database system, be applicable to the interconnected of several data storehouse, possess unified database operating gateway and unified database connection management function, realize the unified interface of SQL statement.
2. method according to claim 1 is characterized in that, the unified database operating gateway, and being meant can fulfillment database application end and the interconnected program of database platform.
3. method according to claim 1 is characterized in that, several data storehouse interconnected is meant the interconnected visit and the operation that are applicable to such as databases such as Oracle, Microsoft SQL Server, MYSQL.
4. method according to claim 1, it is characterized in that, unified database connection management, be that connection request to the database application end carries out intelligent management, avoid occurring a plurality of requests and initiate simultaneously to connect, the database connection that database application end and DataBase Gateway directly are connected with connection pool manages.
5. method according to claim 1 is characterized in that, realizes the unified interface of SQL statement, is meant to adopt the ICE middleware to support multiple development language and multiple systems platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010167533 CN101853274A (en) | 2010-05-10 | 2010-05-10 | Method for realizing interconnection of heterogeneous databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010167533 CN101853274A (en) | 2010-05-10 | 2010-05-10 | Method for realizing interconnection of heterogeneous databases |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101853274A true CN101853274A (en) | 2010-10-06 |
Family
ID=42804766
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201010167533 Pending CN101853274A (en) | 2010-05-10 | 2010-05-10 | Method for realizing interconnection of heterogeneous databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101853274A (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102262561A (en) * | 2011-07-01 | 2011-11-30 | 深圳市极限网络科技有限公司 | Method for scheduling processing of massive tasks of databases |
| CN102314375A (en) * | 2011-03-18 | 2012-01-11 | 北京神州数码思特奇信息技术股份有限公司 | Heterogeneous database storage unified interface and database access method |
| CN102385628A (en) * | 2011-11-14 | 2012-03-21 | 北京锐安科技有限公司 | Java data base connectivity (JDBC)-based data distributed processing method |
| CN102426594A (en) * | 2011-10-31 | 2012-04-25 | 沈文策 | Method and system for operating database |
| CN102546810A (en) * | 2012-01-16 | 2012-07-04 | 广州市新信荟智信息产业有限公司 | Remote access method of database |
| CN103020061A (en) * | 2011-09-20 | 2013-04-03 | 佳都新太科技股份有限公司 | Method for supporting multiple databases connection |
| CN103809944A (en) * | 2012-11-08 | 2014-05-21 | 镇江华扬信息科技有限公司 | Web database development component processing method based on JDBC |
| CN104462497A (en) * | 2014-12-19 | 2015-03-25 | 深圳中兴网信科技有限公司 | Crossing-base transaction processing method and system based on relational databases |
| CN104503989A (en) * | 2014-12-03 | 2015-04-08 | 中建材国际贸易有限公司 | Method for completing collection of isomerous database |
| CN104794147A (en) * | 2013-12-30 | 2015-07-22 | 深圳键桥通讯技术股份有限公司 | Heterogeneous database access method |
| CN105389342A (en) * | 2015-10-23 | 2016-03-09 | 浪潮软件股份有限公司 | Database access tool, system and method |
| CN105760174A (en) * | 2016-03-09 | 2016-07-13 | 浪潮软件集团有限公司 | Suggested data extraction method based on Windows timed task |
| CN108415909A (en) * | 2017-02-09 | 2018-08-17 | 北京京东尚科信息技术有限公司 | A kind of system and method accessing disparate databases |
| CN110232145A (en) * | 2017-10-31 | 2019-09-13 | 中移(苏州)软件技术有限公司 | A kind of data quick access method, apparatus and system |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101556587A (en) * | 2008-04-10 | 2009-10-14 | 中兴通讯股份有限公司 | Operation agent device for heterogeneous database |
-
2010
- 2010-05-10 CN CN 201010167533 patent/CN101853274A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101556587A (en) * | 2008-04-10 | 2009-10-14 | 中兴通讯股份有限公司 | Operation agent device for heterogeneous database |
Non-Patent Citations (1)
| Title |
|---|
| 《ChinaUnix博客》 20080509 jiangdm 开发"统一数据库网关"的初步设想 正文第1页第1段，第1页第4段到第2页最后1段 1-5 , 2 * |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102314375A (en) * | 2011-03-18 | 2012-01-11 | 北京神州数码思特奇信息技术股份有限公司 | Heterogeneous database storage unified interface and database access method |
| CN102262561B (en) * | 2011-07-01 | 2016-06-01 | 深圳市极限网络科技有限公司 | The dispatching method that massive tasks of databases processes |
| CN102262561A (en) * | 2011-07-01 | 2011-11-30 | 深圳市极限网络科技有限公司 | Method for scheduling processing of massive tasks of databases |
| CN103020061A (en) * | 2011-09-20 | 2013-04-03 | 佳都新太科技股份有限公司 | Method for supporting multiple databases connection |
| CN102426594A (en) * | 2011-10-31 | 2012-04-25 | 沈文策 | Method and system for operating database |
| CN102426594B (en) * | 2011-10-31 | 2013-05-29 | 沈文策 | Method and system for operating database |
| CN102385628A (en) * | 2011-11-14 | 2012-03-21 | 北京锐安科技有限公司 | Java data base connectivity (JDBC)-based data distributed processing method |
| CN102546810A (en) * | 2012-01-16 | 2012-07-04 | 广州市新信荟智信息产业有限公司 | Remote access method of database |
| CN103809944A (en) * | 2012-11-08 | 2014-05-21 | 镇江华扬信息科技有限公司 | Web database development component processing method based on JDBC |
| CN104794147A (en) * | 2013-12-30 | 2015-07-22 | 深圳键桥通讯技术股份有限公司 | Heterogeneous database access method |
| CN104503989A (en) * | 2014-12-03 | 2015-04-08 | 中建材国际贸易有限公司 | Method for completing collection of isomerous database |
| CN104503989B (en) * | 2014-12-03 | 2019-04-19 | 中建材国际贸易有限公司 | A method of it completing heterogeneous database and collects |
| CN104462497A (en) * | 2014-12-19 | 2015-03-25 | 深圳中兴网信科技有限公司 | Crossing-base transaction processing method and system based on relational databases |
| CN104462497B (en) * | 2014-12-19 | 2018-07-10 | 深圳中兴网信科技有限公司 | Inter-library transaction methods and system based on relevant database |
| CN105389342A (en) * | 2015-10-23 | 2016-03-09 | 浪潮软件股份有限公司 | Database access tool, system and method |
| CN105760174A (en) * | 2016-03-09 | 2016-07-13 | 浪潮软件集团有限公司 | Suggested data extraction method based on Windows timed task |
| CN108415909A (en) * | 2017-02-09 | 2018-08-17 | 北京京东尚科信息技术有限公司 | A kind of system and method accessing disparate databases |
| CN110232145A (en) * | 2017-10-31 | 2019-09-13 | 中移(苏州)软件技术有限公司 | A kind of data quick access method, apparatus and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101853274A (en) | Method for realizing interconnection of heterogeneous databases | |
| JP6750102B2 (en) | Managed query service | |
| US10936589B1 (en) | Capability-based query planning for heterogenous processing nodes | |
| Yang et al. | On 3G mobile e-commerce platform based on cloud computing | |
| CN106462467A (en) | Integrated APIs and UIs for consuming services across different distributed networks | |
| CN101977212B (en) | Basic sharing platform for Internet of things | |
| CN105045607A (en) | Method for achieving uniform interface of multiple big data calculation frames | |
| CN112347212A (en) | Railway cloud GIS platform for BIM application and building method thereof | |
| CN102769709B (en) | A kind of for providing the method and apparatus of service contact information to user | |
| CN103024078A (en) | Resource allocation method and device in cloud computing environment | |
| CN104050276A (en) | Cache processing method and system of distributed database | |
| CN103399894A (en) | Distributed transaction processing method on basis of shared storage pool | |
| JP2017531844A (en) | Dynamic update stream for real-time provisioning | |
| Shu-Qing et al. | The improvement of PaaS platform | |
| CN106471501A (en) | The method of data query, the storage method data system of data object | |
| CN103685535A (en) | Interface design of cloud database system for large-scale distributed heterogeneous data treatment | |
| CN109150964B (en) | Migratable data management method and service migration method | |
| CN105404530B (en) | It is a kind of to realize easy deployment and the system and method using private clound | |
| CN102724290B (en) | Method, device and system for getting target customer group | |
| CN105549964A (en) | Page display method and system | |
| CN102664952A (en) | Method for managing and monitoring embedded equipment cluster | |
| CN102156697A (en) | Method and terminal equipment for realizing webpage application through widget | |
| CN101727459A (en) | WEB-based data exchange system and method applicable to distributed database | |
| CN107066595A (en) | A kind of many application searches method of servicing of big data and system | |
| Swaroop et al. | Mobile distributed real time database systems: A research challenges |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20101006 |