CN108920702A - Realize that heterogeneous database synchronizes the online method exchanged and share - Google Patents
Realize that heterogeneous database synchronizes the online method exchanged and share Download PDFInfo
- Publication number
- CN108920702A CN108920702A CN201810789487.4A CN201810789487A CN108920702A CN 108920702 A CN108920702 A CN 108920702A CN 201810789487 A CN201810789487 A CN 201810789487A CN 108920702 A CN108920702 A CN 108920702A
- Authority
- CN
- China
- Prior art keywords
- database
- access
- share
- synchronizes
- shared
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
It realizes that heterogeneous database synchronizes the method for exchanging and sharing online the present invention relates to a kind of, synchronizes online exchange for realizing the data between heterogeneous database and share, steps are as follows for the method：S1：Establish the shared server for exchanging and sharing for realizing multiple heterogeneous database datas；S2：Access end initiates data exchange or sharing request；S3：Shared server receives access request and authentication-access permission；It has permission, identifies the structure type of the access client database；Lack of competence is then refused, and request stops；S4：Shared server calls corresponding exchange or shared data, and will be exchanged according to the structure type of access client database or shared data is converted into corresponding format by transcoder and is sent to access end.This programme system architecture is simple, can realize data exchange and sharing in a short time.
Description
Technical field
The present invention relates to database fields, and in particular to a kind of to realize that heterogeneous database synchronizes the online side exchanged and share
Method.
Background technique
Heterogeneous database system is the set of relevant multiple Database Systems, and the shared and transparent visit of data may be implemented
It asks, several Database Systems inherently have existed before heterogeneous database system is added, and possess the data matrix management of oneself
System, outer structure database each component part there is itself autonomy, while realizing data sharing, each data base set
System still has application characteristic, integrity control and the safety control of oneself.The isomerism of heterogeneous database system is mainly reflected in
The following aspects：
The isomery of Computer Architecture, the database of each participation can be separately operable mainframe, minicomputer, work station,
In PC or embedded system.
The isomery of underlying Operating System, the underlying Operating System of each Database Systems can be Unix, Windows NT,
Linux etc..
The isomery of DBMS itself, can be is all Oracle, SQL Server of system R etc., can also
To be the database of different data model, such as relationship, mode, level, network, object-oriented, function type database is collectively constituted
One heterogeneous database system.
Heterogeneous database system aims at data information resource, the hardware device resources realized between disparate databases
Merging with human resources and shared.Wherein crucial is a little exactly to establish global number based on local data bank mode
According to mode or global external view.This global schema is particularly important for establishing advanced DSS.
Large corporation suffers from the Information Number of oneself in many place Dou You branch, the database of each clamp mechanism
According to, and decision work out personnel be generally only concerned macroscopic view, for information described in global schema.It establishes in data warehouse technology base
The description of heterogeneous database global schema on plinth is a kind of good solution.Data warehouse can be from heterogeneous database system
In multiple databases in collect information, and establish unified global schema, the data being collected simultaneously also are supported to historical data
Access, user carries out the inquiry of decision support by the unified data-interface that data warehouse provides.
It is open（Bulletin）Number CN102521254A discloses a kind of unified access method of heterogeneous database, including step：
Foreground client receives the SQL statement of user's input, and SQL statement request is sent to background data base request handler；Afterwards
Whether platform database request handler is legal according to SQL standard syntactic analysis SQL statement；Primary grammar is carried out to request SQL
Analysis, decomposites the empty table table name to be operated, then judges current request is which class isomeric data be sent to according to empty table table name
Library server；The result judged according to step 3 select the SQL analysis processor of corresponding heterogeneous database server come
Handle the practical read-write requests in SQL statement；Result after step 4 is executed returns to foreground client.This method can be real
Various heterogeneous databases are now accessed by unified access interface, to reduce the difficulty in database application development process, contracting
The time cycle of short exploitation further decreases the maintenance cost in application system later period.
Disadvantage of the prior art is that：Data sharing and exchange between heterogeneous database are generally required by very multiple
Miscellaneous communications protocol is just able to achieve, so that whole system increased costs, process is complicated.
Summary of the invention
It is an object of the invention to overcome the deficiencies of the prior art and provide a kind of realization heterogeneous databases to synchronize online exchange
With shared method, system architecture is simple, can realize data exchange and sharing in a short time.
The purpose of the present invention is achieved through the following technical solutions：
A method of realizing that heterogeneous database synchronizes online exchange and shares, it is same for realizing the data between heterogeneous database
Step is online to be exchanged and shares；
It is access end that data exchange or the database of sharing request are actively initiated in definition, and definition passively receives data exchange or shared
Database be receiving end；
Steps are as follows for the method：
S1：Establish the shared server for exchanging and sharing for realizing multiple heterogeneous database datas；
S2：Access end initiates data exchange or sharing request；
S3：Shared server receives access request and authentication-access permission；It has permission, identifies the structure class of the access client database
Type；
Lack of competence is then refused, and request stops；
S4：Shared server calls corresponding exchange or shared data, and will be exchanged according to the structure type of access client database
Or shared data is converted into corresponding format by transcoder and is sent to access end.
As a further improvement of the present invention, each database and shared server respectively configure a transcoder.
As a further improvement of the present invention, the process flow of the shared server is multiple threads, can be simultaneously
It handles multiple databases and carries out data exchange and sharing.
As a further improvement of the present invention, the access authority is by respective database sets itself.
As a further improvement of the present invention, the access authority is divided into open, fixed point access, three kinds of conditional access,
It is described it is open refer to all with may have access to per family, the fixed point access refers to that the user in setting list is accessible, described
Conditional access refers to that access end reaches setting condition and may have access to.
As a further improvement of the present invention, the condition of the conditional access includes：
Access end database security grade；
The access end Database time limit；
Whether access client database has negative effect, and the negative effect is to crawl the big number of news by shared server analysis
According to.
As a further improvement of the present invention, the structure type of the access client database includes following three classes：
The isomery of Computer Architecture, including mainframe, minicomputer, work station, PC or embedded system；
The isomery of underlying Operating System, including Unix, Windows NT, Linux；
The isomery of DBMS itself, Oracle, SQL Server including being all system R；
Or and, the database of different data model, including relationship, mode, level, network, object-oriented.
As a further improvement of the present invention, the structure type of the access authority verification and access client database identifies institute
It takes time and is no more than 1 second.
As a further improvement of the present invention, the quantity database that the multiple threads item number and shared server are shared
It is identical.
As a further improvement of the present invention, may be implemented to be in communication with each other between each heterogeneous database, request its to
Give access authority.
The beneficial effects of the invention are as follows：Compared to the prior art, this programme realizes number by one shared server of setting
According to exchange perhaps share and be in the prior art by between two databases carry out agreement conversion or other synchronization
Means realize data exchange and sharing, in contrast, simpler on this programme implementation, it is only necessary to which that a transcoder can
With by the data conversion between heterogeneous database at can be interchangeable data, so that synchronous process is simplified, so that data
Exchange and share more convenient.
Detailed description of the invention
Fig. 1 is flow diagram of the invention.
Specific embodiment
Technical solution of the present invention is described in further detail combined with specific embodiments below, but protection scope of the present invention is not
It is confined to as described below.
As shown in Figure 1：
A method of realizing that heterogeneous database synchronizes online exchange and shares, it is same for realizing the data between heterogeneous database
Step is online to be exchanged and shares, and it is access end that data exchange or the database of sharing request are actively initiated in definition, defines passively receiving
Data exchange or shared database are receiving end.
The present embodiment is illustrated by taking 4 heterogeneous databases as an example, as shown in Figure 1 includes database A, database B, data
Library C, database D, it is to be understood that the data bulk of achievable data sharing and exchange is not limited to this implementation in the present invention
Number cited by example, quantity database in the reasonable scope.In order to realize method that this programme is proposed, system
Mating to include at least a shared server, the power of shared server is rationally designed according to the quantity of database, to mention
The speed of high its data sharing and exchange.A transcoder is configured between each database and shared server, as shown in Figure 1,
A transcoder is respectively configured between database A, database B, database C, database D and shared server in the present embodiment,
That is 4 transcoders in total.
The method of its data exchange and sharing is as follows：
S1：Establish the shared server for exchanging and sharing for realizing multiple heterogeneous database datas；
S2：Access end initiates data exchange or sharing request；
S3：Shared server receives access request and authentication-access permission；It has permission, identifies the structure class of the access client database
Type；
Lack of competence is then refused, and request stops；
S4：Shared server calls corresponding exchange or shared data, and will be exchanged according to the structure type of access client database
Or shared data is converted into corresponding format by transcoder and is sent to access end.
As one embodiment, the process flow of above-mentioned shared server is multiple threads, can handle multiple data simultaneously
Library carries out data exchange and sharing, i.e., at least dual-thread, to improve the speed of data exchange and sharing, realizes that data are same
Step；As a kind of optimal selection, multiple threads item number is identical as the quantity database that shared server is shared, such as upper
It states and is provided with 4 databases in embodiment, then 4 thread process of corresponding setting.
As one embodiment, above-mentioned access authority, can between each heterogeneous database by respective database sets itself
Be in communication with each other with realizing, it requested to give access authority, here be in communication with each other between only mutual database administrator and pipe
Being in communication with each other between reason person, and being in communication with each other in non-data, can determine whether to be right by the connection between administrator
Fang Kaishe permission provides the platform of a data exchange and sharing.
As the further explanation of the present embodiment, access authority is divided into open, fixed point access, three kinds of conditional access, institute
State it is open refer to all with may have access to per family, the fixed point access refers to that the user in setting list is accessible, the item
Part access refers to that access end reaches setting condition and may have access to.
The condition of the conditional access includes：
Access end database security grade；
The access end Database time limit；
Whether access client database has negative effect, and the negative effect is to crawl the big number of news by shared server analysis
According to.
The structure type of the access client database includes following three classes：
The isomery of Computer Architecture, including mainframe, minicomputer, work station, PC or embedded system；
The isomery of underlying Operating System, including Unix, Windows NT, Linux；
The isomery of DBMS itself, Oracle, SQL Server including being all system R；
Or and, the database of different data model, including relationship, mode, level, network, object-oriented.
It is no more than 1 second the time required to the structure type identification of the access authority verification and access client database.
The above is only a preferred embodiment of the present invention, it should be understood that the present invention is not limited to described herein
Form should not be regarded as an exclusion of other examples, and can be used for other combinations, modifications, and environments, and can be at this
In the text contemplated scope, modifications can be made through the above teachings or related fields of technology or knowledge.And those skilled in the art institute into
Capable modifications and changes do not depart from the spirit and scope of the present invention, then all should be in the protection scope of appended claims of the present invention
It is interior.
Claims (10)
1. a kind of realize that heterogeneous database synchronizes the online method exchanged and share, for realizing the data between heterogeneous database
It synchronizes online exchange and shares, it is characterised in that：
It is access end that data exchange or the database of sharing request are actively initiated in definition, and definition passively receives data exchange or shared
Database be receiving end；
Steps are as follows for the method：
S1：Establish the shared server for exchanging and sharing for realizing multiple heterogeneous database datas；
S2：Access end initiates data exchange or sharing request；
S3：Shared server receives access request and authentication-access permission；It has permission, identifies the structure class of the access client database
Type；
Lack of competence is then refused, and request stops；
S4：Shared server calls corresponding exchange or shared data, and will be exchanged according to the structure type of access client database
Or shared data is converted into corresponding format by transcoder and is sent to access end.
2. according to claim 1 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
It states each database and shared server respectively configures a transcoder.
3. according to claim 2 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
The process flow for stating shared server is multiple threads, can handle multiple databases simultaneously and carry out data exchange and sharing.
4. according to claim 3 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
Access authority is stated by respective database sets itself.
5. according to claim 4 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
It states access authority and is divided into open, fixed point access, three kinds of conditional access, it is described open to refer to all with may have access to per family, institute
It states fixed point access and refers to that the user in setting list is accessible, the conditional access refers to that access end reaches setting condition
Access.
6. according to claim 5 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
The condition for stating conditional access includes：
Access end database security grade；
The access end Database time limit；
Whether access client database has negative effect, and the negative effect is to crawl the big number of news by shared server analysis
According to.
7. according to claim 6 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
The structure type for stating access client database includes following three classes：
The isomery of Computer Architecture, including mainframe, minicomputer, work station, PC or embedded system；
The isomery of underlying Operating System, including Unix, Windows NT, Linux；
The isomery of DBMS itself, Oracle, SQL Server including being all system R；
Or and, the database of different data model, including relationship, mode, level, network, object-oriented.
8. according to claim 1 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
It states access authority verification and accesses the structure type identification required time of client database no more than 1 second.
9. according to claim 3 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that institute
It is identical as the quantity database that shared server is shared to state multiple threads item number.
10. according to claim 1 realize that heterogeneous database synchronizes the online method exchanged and share, which is characterized in that
It may be implemented to be in communication with each other between each heterogeneous database, it requested to give access authority.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810789487.4A CN108920702A (en) | 2018-07-18 | 2018-07-18 | Realize that heterogeneous database synchronizes the online method exchanged and share |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810789487.4A CN108920702A (en) | 2018-07-18 | 2018-07-18 | Realize that heterogeneous database synchronizes the online method exchanged and share |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108920702A true CN108920702A (en) | 2018-11-30 |
Family
ID=64414985
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810789487.4A Pending CN108920702A (en) | 2018-07-18 | 2018-07-18 | Realize that heterogeneous database synchronizes the online method exchanged and share |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108920702A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143467A (en) * | 2019-12-05 | 2020-05-12 | 贵州师范大学 | Data sharing method of cloud platform for realizing distributed heterogeneous data sharing |
| CN113377800A (en) * | 2021-06-08 | 2021-09-10 | 国网电子商务有限公司 | Data security sharing method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090125563A1 (en) * | 2007-11-08 | 2009-05-14 | Lik Wong | Replicating and sharing data between heterogeneous data systems |
| CN101697166A (en) * | 2009-10-28 | 2010-04-21 | 浪潮电子信息产业股份有限公司 | Method for accelerating data integration of heterogeneous platform |
| CN103281368A (en) * | 2013-05-22 | 2013-09-04 | 河海大学 | Data sharing exchange model and method based on cloud computation |
| CN103414705A (en) * | 2013-07-30 | 2013-11-27 | 电子科技大学 | Method for mobile internet heterogeneous data exchange based on SAAS mode |
| CN103607469A (en) * | 2013-11-28 | 2014-02-26 | 东莞中国科学院云计算产业技术创新与育成中心 | Cloud platform for achieving distributed isomerous data sharing and data sharing method thereof |
| CN108134764A (en) * | 2016-12-01 | 2018-06-08 | 中国电子科技集团公司第十五研究所 | A kind of Distributed data share exchange method and system |
-
2018
- 2018-07-18 CN CN201810789487.4A patent/CN108920702A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090125563A1 (en) * | 2007-11-08 | 2009-05-14 | Lik Wong | Replicating and sharing data between heterogeneous data systems |
| CN101697166A (en) * | 2009-10-28 | 2010-04-21 | 浪潮电子信息产业股份有限公司 | Method for accelerating data integration of heterogeneous platform |
| CN103281368A (en) * | 2013-05-22 | 2013-09-04 | 河海大学 | Data sharing exchange model and method based on cloud computation |
| CN103414705A (en) * | 2013-07-30 | 2013-11-27 | 电子科技大学 | Method for mobile internet heterogeneous data exchange based on SAAS mode |
| CN103607469A (en) * | 2013-11-28 | 2014-02-26 | 东莞中国科学院云计算产业技术创新与育成中心 | Cloud platform for achieving distributed isomerous data sharing and data sharing method thereof |
| CN108134764A (en) * | 2016-12-01 | 2018-06-08 | 中国电子科技集团公司第十五研究所 | A kind of Distributed data share exchange method and system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143467A (en) * | 2019-12-05 | 2020-05-12 | 贵州师范大学 | Data sharing method of cloud platform for realizing distributed heterogeneous data sharing |
| CN113377800A (en) * | 2021-06-08 | 2021-09-10 | 国网电子商务有限公司 | Data security sharing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101587639B (en) | City bus information management and dispatch decision support system based on network | |
| CN104008135A (en) | Multi-source heterogeneous database fusion system and data query method thereof | |
| CN102917006B (en) | A kind of unified control and management method and device realizing computational resource and object permission | |
| CN106777227A (en) | Multidimensional data convergence analysis system and method based on cloud platform | |
| CN111813570A (en) | Event-driven message interaction method for power Internet of things | |
| CN109656963B (en) | Metadata acquisition method, apparatus, device and computer readable storage medium | |
| CN113176875A (en) | Resource sharing service platform architecture based on micro-service | |
| CN109677465B (en) | Distributed real-time system architecture for rail transit integrated monitoring system | |
| CN109241054A (en) | A kind of multimodal data library system, implementation method and server | |
| CN106934060A (en) | Smart city public information management method and smart city public information management system | |
| CN110298189A (en) | Data base authority management method and equipment | |
| CN108924228B (en) | Industrial internet optimization system based on edge calculation | |
| Huang et al. | BoR: Toward high-performance permissioned blockchain in RDMA-enabled network | |
| CN108920702A (en) | Realize that heterogeneous database synchronizes the online method exchanged and share | |
| Theeten et al. | Towards the optimization of a parallel streaming engine for telco applications | |
| CN103645959A (en) | Telecom real-time system multi-process SMP (shared memory pool) interaction assembly and method | |
| CN109951370A (en) | Much data centers are layered the method and device that interconnects | |
| CN101719188A (en) | CFD computation operation management system and method | |
| CN101834902A (en) | Front-end processor system and method for comprehensive management of remote power distribution room | |
| CN114676179A (en) | Multi-source heterogeneous data interaction and fusion method and system for shield scene | |
| US10740348B2 (en) | Application programming interface and hypergraph transfer protocol supporting a global hypergraph approach to reducing complexity for accelerated multi-disciplinary scientific discovery | |
| Du et al. | Construction of a campus Q&A platform based on big data and microservice architecture | |
| Li | Design and implementation of distributed asynchronous data aided computer information interaction system | |
| CN110019415A (en) | Cloud computing big data digging system based on mobile terminal | |
| d'Orazio et al. | Semantic caching for pervasive grids |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181130 |
|
| RJ01 | Rejection of invention patent application after publication |