CN104516960A - Method for crossing data source information exchange by database based on unidirectional access - Google Patents
Method for crossing data source information exchange by database based on unidirectional access Download PDFInfo
- Publication number
- CN104516960A CN104516960A CN201410796291.XA CN201410796291A CN104516960A CN 104516960 A CN104516960 A CN 104516960A CN 201410796291 A CN201410796291 A CN 201410796291A CN 104516960 A CN104516960 A CN 104516960A
- Authority
- CN
- China
- Prior art keywords
- project
- data
- information
- database
- request
- 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/256—Integrating or interfacing systems involving database management systems in federated or virtual 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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
A method for crossing data source information exchange by a database based on unidirectional access includes a first item and a second item. The second item acquires an information interactive request of the first item in real time and generates an information request response to be fed back to the first item, so that the information exchange process is finished. The method solves the problems that the items only capable of accessing data of the items need to acquire information in other data sources by crossing data sources in real time and exchange the information with the other data sources, an A item is separated from a b database, leakage or loss of core data caused by directly using the database is prevented, and security of separated data is ensured.
Description
Technical field
The present invention relates to a kind of information interacting method.Particularly relate to a kind of usage data storehouse based on unidirectional access to carry out across the mutual method of data source information.
Background technology
Along with the increasing unsafe factor in growing internet appears in internet network, propose a difficult problem to user information safety.In order to ensure the security of system, under many Systematic selection are deployed in this comparatively safe network environment of Intranet.In order to ensure the safety of Intranet, be provided with many fire walls, and can only be unidirectional access between many network segments.
Cause message reference inconvenience very between many network segments like this, as obstructed in visit information unidirectional between different segment, and because the situation of unidirectional access between obstructed two network segments caused in physics networking, can only be carried out.In order to solve the information interaction problem of unidirectional access.Need a kind of can carrying out across the mutual method of data source information based on the usage data storehouse of unidirectional access.Usage data library information transfer mode curve solves the information interaction problem of unidirectional access.
Summary of the invention
Technical matters to be solved by this invention is, provides a kind of usage data storehouse based on unidirectional access to carry out across the mutual method of data source information.
The technical solution adopted in the present invention is: a kind of usage data storehouse based on unidirectional access is carried out across the mutual method of data source information, include the first project and the second project, make the second project Real-time Obtaining Section 1 object information interaction request, and information generated request-reply feeds back to the first project again, thus complete the process of information interaction, specifically comprise the steps:
1) first project that sets depends on the first database be arranged in first network segment, and the second project depends on the second database be arranged in second network segment;
2) specify that the first project can only access the first database, the second project can access the first database and the second database respectively;
3) task requests table in the second project timing scan first database, if there is Section 1 object information inquiring request in task requests table, then enters next step, otherwise continues scanning;
4) the second project obtains the first project information inquiring request, from request, obtain data query formula in data;
5) the second project usage data inquiry formula goes out to the second data base querying the information that the first project will inquire about;
6) Query Result is converted into XML message form by the second project, and writes back in the Query Result field in the first database information query table;
7) final first project) directly obtain Query Result field in the first database information query table, for user shows net result.
Step 2) described in the first item access first database comprise: submit information inquiring request and automatic regular polling information inquiry table to, obtain information inquiry result.
The information inquiring request that the first described project is submitted to is deposited in the inquiry request field in the first database information query table with XML message form information inquiring request.
Containing two fields in stored data, one of them field is data data result field, and another field is formula data query formula field, step 4) described in the data query formula that obtains from request msg be:
By DATA.A, DATA.B inside the value replacement data of A, B in Data inquiry formula.
Step 6) described in XML message form that Query Result is converted into be first Query Result is saved in pojo data-mapping object, re-use JAXB transfer tool and result be converted into XML message.
Usage data storehouse based on unidirectional access of the present invention is carried out across the mutual method of data source information, solve the project that those can only access oneself data source, need again to carry out across information in real-time other data source of acquisition of data source and carry out the problem of information interaction with it, by A project and b database are isolated, prevent its direct usage data storehouse from causing core data to reveal or losing, ensure that the security of a segregate number formulary certificate.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of the inventive method.
Embodiment
Be described in detail of the present invention below in conjunction with embodiment and accompanying drawing.
As shown in Figure 1, usage data storehouse based on unidirectional access of the present invention is carried out across the mutual method of data source information, include the first project A and the second project B, make the information interaction request of the second project B Real-time Obtaining first project A, and information generated request-reply feeds back to the first project A again, thus complete the process of information interaction, specifically comprise the steps:
1) set the first project A and depend on the first database a be arranged in first network segment, the second project B depends on the second database b be arranged in second network segment;
2) owing to can not be interconnected between first network segment, second network segment, specify that the first project A can only access the first database a, the second project B can access the first database a and the second database b respectively;
Described first project A accesses the first database a and comprises: submit information inquiring request and automatic regular polling information inquiry table to, obtains information inquiry result.The information inquiring request that the first described project A submits to is deposited in the inquiry request field in the first database a information inquiry table with XML message form information inquiring request.
3) at this moment, if the first project A needs the data in acquisition second database b, directly to obtain successfully, need task requests table in the second project B timing scan first database a, if there is the information inquiring request of the first project A in task requests table, then enter next step, otherwise continue scanning;
4) the second project B obtains the first project A information inquiring request, from request, obtain data query formula in data;
Containing two fields in stored data, one of them field is data data result field, and another field is formula data query formula field, step 4) described in the data query formula that obtains from request msg be:
By DATA.A, DATA.B inside the value replacement data of A, B in Data inquiry formula.
5) the second project B usage data inquiry formula inquires to the second database b the information that the first project A will inquire about;
6) Query Result is converted into XML message form by the second project B, and writes back in the Query Result field in the first database a information inquiry table; The described XML message form that is converted into by Query Result is first saved to by Query Result in pojo data-mapping object, re-uses JAXB transfer tool and result is converted into XML message;
7) final first project A directly obtains the Query Result field in the first database a information inquiry table, for user shows net result.
Claims (5)
1. the usage data storehouse based on unidirectional access is carried out across the mutual method of data source information, it is characterized in that, include the first project (A) and the second project (B), make the information interaction request of the second project (B) Real-time Obtaining first project (A), and information generated request-reply feeds back to the first project (A) again, thus complete the process of information interaction, specifically comprise the steps:
1) set the first project (A) and depend on the first database (a) be arranged in first network segment, the second project (B) depends on the second database (b) be arranged in second network segment;
2) specify that the first project (A) can only access the first database (a), the second project (B) can access the first database (a) and the second database (b) respectively;
3) task requests table in the second project (B) timing scan first database (a), if there is the information inquiring request of the first project (A) in task requests table, then enters next step, otherwise continues scanning;
4) the second project (B) obtains the first project (A) information inquiring request, from request, obtain data query formula in data;
5) the second project (B) usage data inquiry formula inquires to the second database (b) information that the first project (A) will inquire about;
6) Query Result is converted into XML message form by the second project (B), and writes back in the Query Result field in the first database (a) information inquiry table;
7) final first project (A) directly obtains the Query Result field in the first database (a) information inquiry table, for user shows net result.
2. the usage data storehouse based on unidirectional access according to claim 1 is carried out across the mutual method of data source information, it is characterized in that, step 2) described in the first project (A) access the first database (a) and comprising: submit information inquiring request and automatic regular polling information inquiry table to, obtain information inquiry result.
3. the usage data storehouse based on unidirectional access according to claim 2 is carried out across the mutual method of data source information, it is characterized in that, the information inquiring request that described the first project (A) is submitted to is deposited in the inquiry request field in the first database (a) information inquiry table with XML message form information inquiring request.
4. the usage data storehouse based on unidirectional access according to claim 1 is carried out across the mutual method of data source information, it is characterized in that, containing two fields in stored data, one of them field is data data result field, another field is formula data query formula field, step 4) described in the data query formula that obtains from request msg be:
Formula sample (varchar2 form):
SELECT DATA.B FROM DATA.A
By DATA.A, DATA.B inside the value replacement data of A, B in Data inquiry formula.
5. the usage data storehouse based on unidirectional access according to claim 1 is carried out across the mutual method of data source information, it is characterized in that, step 6) described in XML message form that Query Result is converted into be, first Query Result is saved in pojo data-mapping object, re-uses JAXB transfer tool and result is converted into XML message.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410796291.XA CN104516960A (en) | 2014-12-18 | 2014-12-18 | Method for crossing data source information exchange by database based on unidirectional access |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410796291.XA CN104516960A (en) | 2014-12-18 | 2014-12-18 | Method for crossing data source information exchange by database based on unidirectional access |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104516960A true CN104516960A (en) | 2015-04-15 |
Family
ID=52792259
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410796291.XA Pending CN104516960A (en) | 2014-12-18 | 2014-12-18 | Method for crossing data source information exchange by database based on unidirectional access |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104516960A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108932329A (en) * | 2018-07-04 | 2018-12-04 | 北京奇安信科技有限公司 | A kind of data query processing method and processing device |
| CN111198917A (en) * | 2020-01-06 | 2020-05-26 | 中国建设银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN114598700A (en) * | 2022-01-25 | 2022-06-07 | 阿里巴巴（中国）有限公司 | Communication method and communication system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040205576A1 (en) * | 2002-02-25 | 2004-10-14 | Chikirivao Bill S. | System and method for managing Knowledge information |
| CN101534480A (en) * | 2009-04-14 | 2009-09-16 | 南京大学 | Cross network file synchronizing method based on mobile software agent |
| CN103179462A (en) * | 2011-12-21 | 2013-06-26 | 北大方正集团有限公司 | Method and device for querying program information and radio and television broadcasting system |
| CN103685207A (en) * | 2012-09-21 | 2014-03-26 | 百度在线网络技术（北京）有限公司 | System, apparatus, and method for integrating data spanning data sources |
-
2014
- 2014-12-18 CN CN201410796291.XA patent/CN104516960A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040205576A1 (en) * | 2002-02-25 | 2004-10-14 | Chikirivao Bill S. | System and method for managing Knowledge information |
| CN101534480A (en) * | 2009-04-14 | 2009-09-16 | 南京大学 | Cross network file synchronizing method based on mobile software agent |
| CN103179462A (en) * | 2011-12-21 | 2013-06-26 | 北大方正集团有限公司 | Method and device for querying program information and radio and television broadcasting system |
| CN103685207A (en) * | 2012-09-21 | 2014-03-26 | 百度在线网络技术（北京）有限公司 | System, apparatus, and method for integrating data spanning data sources |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108932329A (en) * | 2018-07-04 | 2018-12-04 | 北京奇安信科技有限公司 | A kind of data query processing method and processing device |
| CN111198917A (en) * | 2020-01-06 | 2020-05-26 | 中国建设银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN114598700A (en) * | 2022-01-25 | 2022-06-07 | 阿里巴巴（中国）有限公司 | Communication method and communication system |
| CN114598700B (en) * | 2022-01-25 | 2024-03-29 | 阿里巴巴（中国）有限公司 | Communication method and communication system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105786808B (en) | A kind of method and apparatus for distributed execution relationship type computations | |
| CN105183735B (en) | The querying method and inquiry unit of data | |
| CN104102710A (en) | Massive data query method | |
| US20130138681A1 (en) | Method and system for metadata driven processing of federated data | |
| CN107113341A (en) | The system of the high-throughput processing of affairs in the Distributed Relation Database Management System divided for data | |
| US10489386B2 (en) | Managing transactions requesting non-existing index keys in database systems | |
| CN103810224A (en) | Information persistence and query method and device | |
| CN104239368A (en) | Form data inquiring method based on setting | |
| CN103823846A (en) | Method for storing and querying big data on basis of graph theories | |
| CN105205189B (en) | The integrated approach of BIM model and high speed acquisition data system based on container | |
| CN104516960A (en) | Method for crossing data source information exchange by database based on unidirectional access | |
| JP6400073B2 (en) | How to query one or more databases | |
| WO2018006023A1 (en) | Time series data query engine | |
| Papadakis | Families of asymmetric periodic solutions in the restricted four-body problem | |
| CN109800226A (en) | A kind of data administer in task management method and device | |
| CN102760164B (en) | A kind of method of exchanges data between relational database management system and XML data base management system | |
| CN105930354B (en) | Storage model conversion method and device | |
| CN103078946A (en) | Mass real-time data distributing method and mass real-time data access method | |
| Haikun et al. | Research and Application of the IOT Gateway Based on the Real-Time Specification for Java. | |
| CN104133876A (en) | Affair-based incremental management cluster configuration file method | |
| CN105659226B (en) | The method and system for keeping data synchronous | |
| CN105653205A (en) | User request processing method and system | |
| Mitchell | The current state of linked data in libraries, archives, and museums | |
| US10366130B2 (en) | Generation of complementary applications | |
| Smith et al. | Managing metadata in heterogeneous sensor networks |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150415 |
|
| WD01 | Invention patent application deemed withdrawn after publication |