CN100362516C - Heterogeneous database realtime integration system and method - Google Patents
Heterogeneous database realtime integration system and method Download PDFInfo
- Publication number
- CN100362516C CN100362516C CNB2005100593898A CN200510059389A CN100362516C CN 100362516 C CN100362516 C CN 100362516C CN B2005100593898 A CNB2005100593898 A CN B2005100593898A CN 200510059389 A CN200510059389 A CN 200510059389A CN 100362516 C CN100362516 C CN 100362516C
- Authority
- CN
- China
- Prior art keywords
- data
- database
- instruction
- realtime
- exchanging platform
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a heterogeneous database real-time integration system which comprises at least one first type database, a terminal device and a database exchange platform, wherein the terminal device has a second type database, and inputs a first real-time instruction by a user interface; the database exchange platform is used for establishing at least one first instruction according to the first real-time instruction and selecting first data from the first type database according to the first instruction; then, the data format of the first data is converted for generating second data; the second data conforms to the needed data form of the second type database; subsequently, the second data is transmitted to the terminal device.
Description
Technical field
The invention relates to a kind of data in real time integration system and method, especially in regard to a kind of heterogeneous database realtime integration system and method.
Background technology
Large enterprise is because human organization is huge, the research and development technology and the kind that manufactures a product are numerous and diverse, for all types of information such as the information such as occurrences in human life, production equipment, research and development flow process and finance in the effective management enterprise, enterprises is provided with database in the hope of can be momentarily and positively control above-mentioned important information.Yet the restriction on ocean and land is often crossed at the strong point of large enterprise, among being distributed in all over the world, and the employed database in different strong points also may be different, the otherness of these data and database makes enterprises real-time integration information smoothly, enterprises employee must spend thought to obtain the information of each strong point data of integration.
Shown in Figure 1A, if a user is by seeking information in a client 14 to first databases 11, one second database 12 and one the 3rd database 13, produce because data is huge easily and omit careless mistakes such as seeking or confuse data, and switching between each database also causes the user tired easily, thereby can't be absorbed in the search of data, cause data to seek or the mistake of comparison.In addition, even seek out specific data in each database, the correctness of judging these data still depends on the user and compares data one by one with manpower.Moreover because database is a heterogeneous database, after data was finished in user's comparison, the particular profile of upgrading in each database still needed the user to carry out more new element one by one in each database.
Below as can be known, no matter be search, judgement and the renewal of particular profile, all need user oneself to be online to operation instructions in each database, can't only operate single interface and finish search, judgement and the renewal of particular profile, complicated operation steps makes the user easily can't search correct data because of artificial careless mistake, and data is also easily because of renewal that artificially careless mistake can't be correct.
In order to overcome the problem that aforementioned numerous and diverse database on line operation is produced, can set up a master data base 15 each data-base content is downloaded and deposited in wherein by the part program of larding speech with literary allusions.As Figure 1B institute not, by the part program of larding speech with literary allusions, the content of first database 11, second database 12 and the 3rd database 13 is downloaded to first Database Replica 151, second Database Replica 152 and the 3rd Database Replica 153 in the master data base 15 respectively, after the user can use a client 14 to be online to master data base 15, the every database instruction of operation was to search the data in first Database Replica 151, second Database Replica 152 and the 3rd Database Replica 153 in the master data base 15 in master data base 15.
Yet in the said method, master data base 15 is if can't download the data for updating of each database at any time with the part program of larding speech with literary allusions, master data base 15 can't each database of real time reaction in actual data, the user can hunt out in master data base 15 and the inconsistent old information of each database present situation.In addition, the data of database transmission speed is subjected to the influence of network on-line quality and network bandwidth, so master data base 15 by lard speech with literary allusions the part program from each database downloaded data can make because of network on-line instability and frequency range are not enough download time elongate and update efficiency not high, and then influence the ageing and correctness of master data base 15 interior data.
Therefore, how a kind of heterogeneous database realtime integration system and method are provided, in the hope of can on-line real-time to each heterogeneous database, and can integrate each database data according to the real-time command that the user assigns, guarantee that the user uses the ageing and correctness of data, one of current just important topic.
Summary of the invention
Because above-mentioned problem, the invention provides a kind of heterogeneous database realtime integration system and method for data that can the real-time integration heterogeneous database.
So, according to heterogeneous database realtime integration system of the present invention, comprise at least one first kind database, one end device and a database exchanging platform, wherein end device has one second types of database, and import one first real-time command via a user interface, database exchanging platform is set up at least one first instruction according to first real-time command, and one first data is chosen in foundation first instruction in first kind database, the data layout of changing first data then is to produce one second data, and second data meets the required data layout of second types of database, and second data that then transmits is to end device.
In addition, the present invention also provides a kind of heterogeneous database realtime integration method, wherein when a database exchanging platform receives first real-time command of being imported via a user interface of an end device, carry out the heterogeneous database realtime integration method, the heterogeneous database realtime integration method comprises the following step: database exchanging platform is set up at least one first instruction according to first real-time command, one first data is chosen in database exchanging platform and foundation first instruction at least one first kind database, then database exchanging platform is changed the data layout of first data to produce one second data, wherein second data meets the required data layout of one second types of database of end device, and transmits second data to end device via database exchanging platform.
From the above, because of having database exchanging platform according to heterogeneous database realtime integration system of the present invention and method, can on-line real-time to each heterogeneous database, and integrate each database data according to the real-time command that the user assigns, so the user is able to correctly use in real time the data of heterogeneous database also effectively.
Description of drawings
Figure 1A is a synoptic diagram, shows known manually-operated several databases;
Figure 1B is a synoptic diagram, shows several databases that the known part device of larding speech with literary allusions duplicates;
Fig. 2 is a synoptic diagram, shows the heterogeneous database realtime integration system according to preferred embodiment of the present invention;
Fig. 3 is a synoptic diagram, shows the heterogeneous database realtime integration system according to preferred embodiment of the present invention, and wherein database exchanging platform more comprises the data integration module;
Fig. 4 is a synoptic diagram, shows the heterogeneous database realtime integration system according to preferred embodiment of the present invention, and wherein window interface shows the integrated results of the 3rd data and the 4th data;
Fig. 5 is a synoptic diagram, shows the heterogeneous database realtime integration system according to preferred embodiment of the present invention, wherein window interface display analysis result;
Fig. 6 is a process flow diagram, shows the heterogeneous database realtime integration method according to preferred embodiment of the present invention;
Fig. 7 is a process flow diagram, shows the heterogeneous database realtime integration method according to preferred embodiment of the present invention, data conformity step wherein; And
Fig. 8 is a process flow diagram, shows the heterogeneous database realtime integration method according to preferred embodiment of the present invention, analysis step wherein.
The element numbers explanation:
11: the first databases
12: the second databases
13: the three databases
14: client
15: master data base
151: the first Database Replicas
152: the second Database Replicas
153: the three Database Replicas
2: first kind database
21: the first data
22: the three data
3: end device
31: the second types of database
311: the second data
312: the four data
32: the user interface
321: the first real-time commands
4: database exchanging platform
41: instruction makes up module
Instruction in 411: the first
Instruction in 412: the second
Instruction in 413: the three
42: the data decimation module
43: data conversion module
44: data transmitting module
45: the data integration module
46: data update module
47: data analysis module
471: analysis result
5: end device
51: window interface
511: the second real-time commands
52: data disaply moudle
S01-S04: heterogeneous database realtime integration method
S11-S19: heterogeneous database realtime integration method
S21-S23: heterogeneous database realtime integration method
Embodiment
Hereinafter with reference to correlative type, heterogeneous database realtime integration system and method according to preferred embodiment of the present invention are described.
Please refer to shown in Figure 2, the heterogeneous database realtime integration system of preferred embodiment of the present invention, comprise at least one first kind database 2, one end device 3 and a database exchanging platform 4, wherein end device 3 has one second types of database 31, and via a user interface 32 inputs one first real-time command 321, database exchanging platform 4 is set up at least one first instruction according to first real-time command 321, and in first kind database, 2 choose one first data 21 according to first instruction, the data layout of changing first data 21 then is to produce one second data 311, and second data 311 meets the required data layout of second types of database 31, and second data 311 that then transmits is to end device 3.
In the present embodiment, database exchanging platform 4 has an instruction and makes up module 41, a data decimation module 42, a data conversion module 43 and a data transmitting module 44, wherein instruct construction module 41 to set up at least one first instruction 411 according to first real-time command 321, wherein first instruction 411 meets the order format of first kind database 2.Data decimation module 42 is chosen first data 21 according to first instruction 411 in first kind database 2, the data layout of data conversion module 43 conversions first data 21 is to produce second data 311, and second data 311 meets the required data layout of second types of database 31, and data transmitting module 44 transmits second data 311 to end device 3.
In the present embodiment, first kind database 2, end device 3 and database exchanging platform 4 are online mutually by world-wide web.First real-time command 321 can be SQL instruction, user interface 32 can be a window, data decimation module 42 is in link (Link) mode, see through the database access interface, directly and first kind database 2 on-line real-times and choose first data 21, but not as known technology, download first kind data-base content in database exchanging platform in advance.
Please refer to Fig. 3 and shown in Figure 4, in the present embodiment, database exchanging platform 4 more comprises a data integration module 45 and a data update module 46.One end device 5 comprises a window interface 51 and a data disaply moudle 52, and window interface 51 receives one second real-time command 511.The instruction of database exchanging platform 4 makes up module 41 and sets up at least one second instruction, 412 and 1 the 3rd instruction 413 according to one second real-time command 511, and wherein second instruction the 412 and the 3rd instruction 413 meets the order format of the first kind database 2 and second types of database 31 respectively.Data decimation module 42 is chosen one the 3rd data 22 according to second instruction 412 in first kind database 2, and chooses one the 4th data 312 according to the 3rd instruction 413 in second types of database 31.Data integration module 45 is integrated the 3rd data 22 and the 4th data 312.Merging is referring to Fig. 3 and Fig. 4, and data disaply moudle 52 can show that the integrated results of the 3rd data 22 and the 4th data 312 is in window interface 51.
In another embodiment, the integrated results of data transmitting module 44 output the 3rd data 22 and the 4th data 312 is to end device 5 (not shown)s.
Referring again to shown in Figure 3, data update module 46 is judged the 3rd data 22 and the 4th data 312, and how persons are more correct, when the 3rd data 22 is correct, upgrade the 4th data 312 according to the 3rd data 22, when the 4th data 312 is correct, upgrade the 3rd data 22 according to the 4th data 312.Wherein the mode of data for updating can realize by amalgamation mode (merge comprises insertion (insert), deletion (delete) and upgrades (update)).
In the present embodiment, first kind database 2, end device 3, database exchanging platform 4 and end device 5 are online mutually by world-wide web.Second real-time command 511 can be SQL instruction, data decimation module 42 is in link (Link) mode, see through the database access interface, directly and first kind database 2 and second types of database, 31 on-line real-times and choose the 3rd data 22 and the 4th data 312, be dissolved in database exchanging platform but not as known technology, download in the first kind database and second types of database in advance.
Please refer to Fig. 3 and shown in Figure 5, in the present embodiment, database exchanging platform 4 more comprises a data analysis module 47, its integrated results of analyzing the 3rd data 22 and the 4th data 312 is to produce an analysis result 471, data transmitting module 44 output analysis results 471 are to end device 5, and data disaply moudle 52 output analysis results 471 are to window interface 51.On the other hand, data analysis module 47 also can be analyzed first data 21 to produce analysis result 471, and data transmitting module 44 output analysis results 471 are to end device 3.In the present embodiment, the integrated results of the 3rd data 22 and the 4th data 312 is error loggings of the first kind database 2 and second types of database 31, and data analysis module 47 can be added up the quantity of all types of mistakes in analysis result 471 according to the reason that mistake takes place.
On the other hand, in the present embodiment, data analysis module 47 can produce an analysis result 471 according to first data 21, and data transmitting module 44 output analysis results 471 are to end device 3.
Please refer to shown in Figure 6, heterogeneous database realtime integration method according to preferred embodiment of the present invention, wherein when a database exchanging platform receives first real-time command of being imported via a user interface of an end device, carry out the heterogeneous database realtime integration method, the heterogeneous database realtime integration method comprises step S01 to step S04.
Among step S01, database exchanging platform is set up at least one first instruction according to first real-time command.
Among step S02, database exchanging platform is chosen one first data according to first instruction at least one first kind database.
Among step S03, database exchanging platform is changed the data layout of first data to produce one second data, and wherein second data meets the required data layout of one second types of database of end device.
Among step S04, transmit second data to end device via database exchanging platform.
Heterogeneous database realtime integration method in the present embodiment was discussed in the embodiment of Fig. 2, so repeat no more.
Please refer to shown in Figure 7ly, present embodiment more can comprise step S11 to step S19.
Among step S11, database exchanging platform is set up at least one second instruction and one the 3rd instruction according to one second real-time command.
Among step S12, database exchanging platform is chosen one the 3rd data according to second instruction in first kind database.
Among step S13, database exchanging platform is chosen one the 4th data according to the 3rd instruction in second types of database.
Among step S14, database exchanging platform is integrated the 3rd data and the 4th data.
Among step S15, export the integrated results of the 3rd data and the 4th data via database exchanging platform.
Among step S16, database exchanging platform sees through the integrated results that a window is exported the 3rd data and the 4th data.
Among step S17, database exchanging platform is judged the 3rd data and the 4th data, and how the person is more correct, when the 3rd data is correct, enters step S18, when the 4th data is correct, enters step S19.
Among step S18, according to the 3rd data updating the 4th data.
Among step S19, according to the 4th data updating the 3rd data.
Heterogeneous database realtime integration method in the present embodiment was discussed in the embodiment of Fig. 3 and Fig. 4, so repeat no more.
Please refer to shown in Figure 8ly, present embodiment more can comprise step S21 to step S23.
Among step S21, database exchanging platform is analyzed the integrated results of the 3rd data and the 4th data to produce an analysis result.
In step S22, via database exchanging platform output analysis result.
In step S23, database exchanging platform sees through window output analysis result.
Heterogeneous database realtime integration method in the present embodiment was discussed in the embodiment of Fig. 3 and Fig. 5, so repeat no more.
In sum, because of having database exchanging platform according to heterogeneous database realtime integration system of the present invention and method, can on-line real-time to each heterogeneous database, and integrate each database data according to the real-time command that the user assigns, so the user is able to correctly use in real time the data of heterogeneous database also effectively.
The above only is an illustrative, but not is restrictive.Anyly do not break away from spirit of the present invention and category, and it is carried out equivalent modifications or change, all should be contained in the appended claim.
Claims (10)
1. heterogeneous database realtime integration method, wherein when a database exchanging platform receives first real-time command of being imported via a user interface of an end device, carry out described heterogeneous database realtime integration method, described heterogeneous database realtime integration method comprises:
Described database exchanging platform is set up at least one first instruction according to described first real-time command;
Described database exchanging platform is chosen one first data according to described first instruction at least one first kind database;
Described database exchanging platform is changed the data layout of described first data to produce one second data, and wherein said second data meets the required data layout of one second types of database of described end device; And
Transmit described second data to described end device via described database exchanging platform.
2. as 1 described heterogeneous database realtime integration method of claim the, more comprise:
Described database exchanging platform is set up at least one second instruction and one the 3rd instruction according to one second real-time command;
Described database exchanging platform is chosen one the 3rd data according to described second instruction in described first kind database;
Described database exchanging platform is chosen one the 4th data according to described the 3rd instruction in described second types of database;
Described database exchanging platform is integrated described the 3rd data and described the 4th data; And
Export the integrated results of described the 3rd data and described the 4th data via described database exchanging platform.
3. as 2 described heterogeneous database realtime integration methods of claim the, more comprise:
Described database exchanging platform is judged described the 3rd data and described the 4th data, and how the person is more correct;
When described the 3rd data is correct, according to described the 4th data of described the 3rd data updating;
When described the 4th data is correct, according to described the 3rd data of described the 4th data updating;
Described database exchanging platform is analyzed the integrated results of described the 3rd data and described the 4th data to produce an analysis result; And
Export described analysis result via described database exchanging platform.
4. as 2 described heterogeneous database realtime integration methods of claim the, wherein said database exchanging platform sees through the integrated results that a window is exported described the 3rd data and described the 4th data.
5. as 1 described heterogeneous database realtime integration method of claim the, more comprise:
Described database exchanging platform is analyzed described first data to produce an analysis result; And
Export described analysis result via described database exchanging platform.
6. as 1 described heterogeneous database realtime integration method of claim the, wherein said end device, described database exchanging platform, described first kind database and described second types of database are online mutually by world-wide web.
7. heterogeneous database realtime integration system comprises:
At least one first kind database;
One end device, it has one second types of database, and imports one first real-time command via a user interface; And
One database exchanging platform, it sets up at least one first instruction according to described first real-time command, and one first data is chosen in described first instruction of foundation in described first kind database, the data layout of changing described first data then is to produce one second data, and described second data meets the required data layout of described second types of database, then transmits described second data to described end device.
8. as 7 described heterogeneous database realtime integration systems of claim the, wherein said database exchanging platform comprises:
One instruction makes up module, and it sets up described first instruction according to described first real-time command;
One data decimation module, it chooses described first data according to described first instruction in described first kind database;
One data conversion module, its data layout of changing described first data are producing described second data, and described second data meets the required data layout of described second types of database;
One data transmitting module, it transmits described second data to described end device, wherein said instruction makes up module and sets up at least one second instruction and one the 3rd instruction according to one second real-time command, described data decimation module is chosen one the 3rd data according to described second instruction in described first kind database, and chooses one the 4th data according to described the 3rd instruction in described second types of database;
One data update module, it judges described the 3rd data and described the 4th data, and how the person is more correct, when described the 3rd data is correct, according to described the 4th data of described the 3rd data updating, when described the 4th data is correct, according to described the 3rd data of described the 4th data updating;
One data integration module, it integrates described the 3rd data and described the 4th data, and exports the integrated results of described the 3rd data and described the 4th data by described data transmitting module; And
One data analysis module, its integrated results of analyzing described first data or analyzing described the 3rd data and described the 4th data to be producing an analysis result, and export described analysis result by described data transmitting module.
9. as 8 described heterogeneous database realtime integration systems of claim the, more comprise:
One data disaply moudle, it exports the integrated results or described analysis result to a window of described the 3rd data and described the 4th data.
10. as 7 described heterogeneous database realtime integration systems of claim the, wherein said end device, described database exchanging platform, described first kind database and described second types of database are online mutually by world-wide web.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100593898A CN100362516C (en) | 2005-03-29 | 2005-03-29 | Heterogeneous database realtime integration system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100593898A CN100362516C (en) | 2005-03-29 | 2005-03-29 | Heterogeneous database realtime integration system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1652115A CN1652115A (en) | 2005-08-10 |
| CN100362516C true CN100362516C (en) | 2008-01-16 |
Family
ID=34876822
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2005100593898A Active CN100362516C (en) | 2005-03-29 | 2005-03-29 | Heterogeneous database realtime integration system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100362516C (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5546304A (en) * | 1994-03-03 | 1996-08-13 | At&T Corp. | Real-time administration-translation arrangement |
| CN1432951A (en) * | 2002-01-17 | 2003-07-30 | 英业达股份有限公司 | Integrating method of hetero information platform in decision system |
| CN1471015A (en) * | 2002-07-24 | 2004-01-28 | 威盛电子股份有限公司 | Distributed parallel edition management system and method |
| CN1477840A (en) * | 2002-08-23 | 2004-02-25 | 英业达股份有限公司 | Real-time condition back-reporting system and its method |
-
2005
- 2005-03-29 CN CNB2005100593898A patent/CN100362516C/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5546304A (en) * | 1994-03-03 | 1996-08-13 | At&T Corp. | Real-time administration-translation arrangement |
| CN1432951A (en) * | 2002-01-17 | 2003-07-30 | 英业达股份有限公司 | Integrating method of hetero information platform in decision system |
| CN1471015A (en) * | 2002-07-24 | 2004-01-28 | 威盛电子股份有限公司 | Distributed parallel edition management system and method |
| CN1477840A (en) * | 2002-08-23 | 2004-02-25 | 英业达股份有限公司 | Real-time condition back-reporting system and its method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1652115A (en) | 2005-08-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112688865B (en) | Design method of OPC UA gateway for graphical online modeling | |
| US5999926A (en) | View maintenance for unstructured databases | |
| CN110198237A (en) | A kind of wireless configuration method for being intended to driving network | |
| EP0809831B1 (en) | A method for building a telecommunications network database | |
| CN108846020A (en) | Knowledge mapping automated construction method, system are carried out based on multi-source heterogeneous data | |
| CN102141990A (en) | Searching method and device | |
| CN102083116B (en) | Method for constructing intelligent communication alarm fault positioning expert system based on meta-knowledge | |
| CN106886408A (en) | It is applied to the intelligent decision system of robot software engineer | |
| CN112667909B (en) | Method and device for recommending scenes in smart home | |
| CN110502538A (en) | Label of drawing a portrait generates method, system, equipment and the storage medium of logical mappings | |
| CN113656647A (en) | Intelligent operation and maintenance oriented engineering archive data management platform, method and system | |
| CN101996257B (en) | Method for searching reconfigurable route exchange platform component | |
| CN113810489A (en) | Industrial internet control system and method | |
| CN1271812C (en) | Wireless facility synchronizing system and method | |
| Moyne et al. | A generic cell controller for the automated VLSI manufacturing facility | |
| CN100362516C (en) | Heterogeneous database realtime integration system and method | |
| CN112199154A (en) | Distributed collaborative sampling central optimization-based reinforcement learning training system and method | |
| CN112612802A (en) | Real-time data middlebox processing method, device and platform | |
| Stollberg et al. | H-Techsight—A next generation knowledge management platform | |
| CN102054008A (en) | Method and device for acquiring network information | |
| CN1971557A (en) | Glossary shared system and method | |
| CN114997154A (en) | Automatic construction method and system for speaker-to-speaker robot corpus | |
| US8762381B2 (en) | Storing multipart XML documents | |
| US20070168921A1 (en) | Method for automatic recovery of uml model requirements and updating thereof | |
| CN111082969B (en) | Management method and device for mass terminal equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |