CN107967274A - The method and apparatus of data synchronization in database - Google Patents
The method and apparatus of data synchronization in database Download PDFInfo
- Publication number
- CN107967274A CN107967274A CN201610912457.9A CN201610912457A CN107967274A CN 107967274 A CN107967274 A CN 107967274A CN 201610912457 A CN201610912457 A CN 201610912457A CN 107967274 A CN107967274 A CN 107967274A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- network
- materialized view
- trigger
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The present invention relates to information technology field, the method and apparatus for disclosing data synchronization in database, this method includes：Data in the database of second network are synchronized to the database of first network using the Materialized View method of synchronization；Data in the database of first network are synchronized to the database of the second network using the trigger method of synchronization；Wherein, the security level of second network is higher than the first network.The present invention can realize one database of routine access and use the data in two networks, and then eliminate the exception caused by integration across database accesses.
Description
Technical field
The present invention relates to information technology field, and in particular, to the method and apparatus of data synchronization in a kind of database.
Background technology
In IT application in enterprise, related service requirement in part uses database (such as inscriptions on bones or tortoise shells oracle database)
Relevant application operating and management are carried out, using being public with some data in kernel program, as kernel program customizes
Data message limitation application in management information.For example, Administrator Info can be defined in kernel program, can be in the application
Use Administrator Info.For example, the network system that can be required if necessary to on-line customer in high safety is (for example, business
Secret network) inner realize the business made out an invoice, it may be desirable to the two kinds of networks in internet and business secret network are disposed, to realize internet
Upper access related service, business secret can have the function of to make out an invoice on the net.
Consuming resource is compared in the access that disparate databases are directly carried out due to program, can be with by way of database synchronization
Realize one database of routine access and use the data in two networks.Therefore need to provide it is a kind of to data in database into
The synchronous method of row, and then eliminate the exception caused by integration across database accesses.
The content of the invention
The object of the present invention is to provide a kind of method and apparatus of data synchronization in database, to solve above-mentioned technical problem
Or at least part of solution above-mentioned technical problem.
To achieve these goals, the method that the present invention provides data synchronization in a kind of database, this method include：Using
Data in the database of second network are synchronized to the database of first network by the Materialized View method of synchronization；It is same using trigger
Data in the database of first network are synchronized to the database of the second network by step mode；Wherein, the peace of second network
The first network is superior to entirely.
Preferably, it is described that data in the database of second network are synchronized to by the first net using the Materialized View method of synchronization
The database of network includes：In the database of the second network materialized view log is created for the form of storage data；Described
The wide area information server link for leading to the second network is created in the database of first network；In the database of the first network
It is middle to create the Materialized View for carrying out Refresh Data according to the materialized view log by the database link；To what is created
Materialized View performs refresh operation.
Preferably, it is described to be included according to materialized view log progress Refresh Data：According to the materialized view log
Changed data in the form in the database of the second network are determined, by the data update of change to the Materialized View
In；And/or the refresh time include it is following at least one：Specify refresh time, when in the database of the second network form have
The time that data are submitted and the time using preset time period as the cycle.
Preferably, it is described that data in the database of first network are synchronized to by the second network using the trigger method of synchronization
Database include：When the database to first network carries out data manipulation, judge whether to trigger corresponding trigger；When tactile
When sending out trigger corresponding, data in the database of the second network are refreshed according to data in the database of first network.
Preferably, it is described to judge whether that triggering corresponding trigger includes：To more line numbers involved by the data manipulation
Data line in judges whether that trigger event occurs, is determined when trigger event occurs for the data line corresponding
Trigger is triggered once；Or the whole data involved by the data manipulation are judged whether trigger event occurs, work as pin
Determine that corresponding trigger is triggered once when trigger event occurs to the whole data；And/or the trigger event includes
It is following at least one：Data insertion, data update and data are deleted.
According to another aspect of the present invention, there is provided the device of data synchronization, the device include in a kind of database：Materialization
View synchronization module, for the data in the database of the second network to be synchronized to first network using the Materialized View method of synchronization
Database；Trigger synchronization module, for using the trigger method of synchronization that the data in the database of first network are synchronous
To the database of the second network；Wherein, the security level of second network is higher than the first network.
Preferably, the Materialized View synchronization module includes：Materialized view log creating unit, in the second network
Form in database for storage data creates materialized view log；Database link creating unit, for described first
The wide area information server link for leading to the second network is created in the database of network；Materialized View creating unit, in institute
State to create in the database of first network and Refresh Data is carried out according to the materialized view log by the database link
Materialized View；Materialized View refresh unit, for performing refresh operation to the Materialized View created.
Preferably, it is described to be included according to materialized view log progress Refresh Data：According to the materialized view log
Changed data in the form in the database of the second network are determined, by the data update of change to the Materialized View
In；And/or the refresh time include it is following at least one：Specify refresh time, when in the database of the second network form have
The time that data are submitted and the time using preset time period as the cycle.
Preferably, the trigger synchronization module includes：Trigger judging unit, for when to the database of first network into
During row data manipulation, judge whether to trigger corresponding trigger；Refresh Data unit, for when triggering corresponding trigger,
Data in the database of the second network are refreshed according to data in the database of first network.
Preferably, it is described to judge whether that triggering corresponding trigger includes：To more line numbers involved by the data manipulation
Data line in judges whether that trigger event occurs, is determined when trigger event occurs for the data line corresponding
Trigger is triggered once；Or the whole data involved by the data manipulation are judged whether trigger event occurs, work as pin
Determine that corresponding trigger is triggered once when trigger event occurs to the whole data；And/or the trigger event includes
It is following at least one：Data insertion, data update and data are deleted.
Through the above technical solutions, for first network and the second network, wherein the security level of the second network is higher than the
Data in the database of second network, the database of first network is synchronized to using the Materialized View method of synchronization by one network；
Data in the database of first network are synchronized to the database of the second network using the trigger method of synchronization；So can be real
Existing one database of routine access and use the data in two networks, and then eliminate the exception caused by integration across database accesses.
Other features and advantages of the present invention will be described in detail in subsequent specific embodiment part.
Brief description of the drawings
Attached drawing is for providing a further understanding of the present invention, and a part for constitution instruction, with following tool
Body embodiment is used to explain the present invention together, but is not construed as limiting the invention.In the accompanying drawings：
Fig. 1 is the flow chart of the method for data synchronization in database according to embodiments of the present invention；
Fig. 2 is the stream of the method for data in the method for synchronization sync database according to embodiments of the present invention using Materialized View
Cheng Tu；
Fig. 3 is the flow of the method for data in the method for synchronization sync database according to embodiments of the present invention using trigger
Figure；
Fig. 4 is the schematic diagram for realizing the scene of the method for data synchronization in database according to embodiments of the present invention；
Fig. 5 is the stream according to embodiments of the present invention that the method for data synchronization in database is realized under scene shown in Fig. 4
Cheng Tu；
Fig. 6 is the structure chart of the device of data synchronization in database according to embodiments of the present invention；And.
Fig. 7 is the structure chart of the device of data synchronization in database according to embodiments of the present invention.
Embodiment
The embodiment of the present invention is described in detail below in conjunction with attached drawing.It should be appreciated that this place is retouched
The embodiment stated is merely to illustrate and explain the present invention, and is not intended to limit the invention.
Fig. 1 is the flow chart of the method for data synchronization in database according to embodiments of the present invention, and this method can be used for net
In network equipment, such as in server.As shown in Figure 1, this method may include following steps.
In step s 110, the data in the database of the second network are synchronized to first using the Materialized View method of synchronization
The database of network.
Wherein, the security level of the second network is higher than first network.
The database of first network is physically may not be used by the database used in equipment in first network, the database
Positioned at first network, and positioned at the addressable any network of equipment in first network.
For example, first network is internet, and the second network is business secret network.Due to from business secret network
The data that (the hereinafter referred to as close net of business) is synchronized to internet are more, and the table structure being related to is more, therefore same using Materialized View
Data in the close grid database of business are synchronized to internet database by step mode.
The Materialized View method of synchronization is will to be stored and brushed according to remote table essentially as the Materialized View of a table
Newly.Materialized View is the database object for including a query result, and Materialized View stores the data based on remote table, equivalent to
One data duplication of remote table.Materialized View allows user in the copy of local maintenance teledata, but these number of copies
According to for only reading mode, it is impossible to carry out data manipulation (for example, DML is operated) to the data of Materialized View.If carry out related behaviour
Make, it is necessary to using more advanced data synchronization scenario.Under normal conditions, it is synchronized to mutually by the common base data of the close net of business
When in networking, do not allow to carry out data manipulation to the common data of the close net of business, therefore be used herein as Materialized View method of synchronization symbol
Close the actual requirement of data synchronization.
In one embodiment, as shown in Fig. 2, it is described using the Materialized View method of synchronization by the database of the second network
The database that data are synchronized to first network includes the following steps.
In step S202, materialized view log is created for the form of storage data in the database of the second network.
In step S204, the wide area information server chain for leading to the second network is created in the database of first network
Connect.
In step S206, in the database of first network create by database link according to materialized view log into
The Materialized View of row Refresh Data.
In step S208, refresh operation is performed to the Materialized View created.
Further, it is described to may include according to materialized view log progress Refresh Data：According to the materialized view log
Changed data in the form in the database of the second network are determined, by the data update of change to the Materialized View
In.Can also will be complete in the form in the database of the second network in addition, in addition to the above methods, when refreshing to Materialized View
Portion's Refresh Data is into Materialized View.
The refresh time may include it is following at least one：Specify refresh time, when form in the database of the second network
There are the time that data are submitted and the time using preset time period as the cycle.
For example, it is necessary to which data in the database of the close net of business are synchronized in internet database.
Materialized view log is created for the form of storage data first in the database of the close net of business, such as form
Test creates materialized view log.The data manipulation to form test can be recorded in materialized view log.
creatematerializedviewlogontest
The database link led in the database of the close net of business is created in the database of internet
GRANT CREATE DATABASE LINK,CREATE PUBLIC DATABASE LINK TO TEST
create database link db_link_B connect to B_user identified by"B_
user_passwd"using
'db_B'
Created in the database of first network and Refresh Data is carried out according to materialized view log by database link
Materialized View.
create materialized view mv_test refresh fast on commit as select*
from test@db_link_B
Wherein, creating the syntactic structure of Materialized View is：
create materialized view[view_name]
refresh[fast|complete|force]
[on[commit|demand]|start with(start_time)next(next_time)]
As { query statement for creating Materialized View }
Wherein, the mode that refresh [fast | complete | force] refreshes for Materialized View.
Fast represents incremental refreshment, it is assumed that the preceding time once refreshed is t1, then is using fast pattern refreshing materializations
During view, t1 is only added into Materialized View to the data in current slot, changed in the database table of the close net of business..
Complete represents refresh all, equivalent to the query statement for re-executing once establishment Materialized View
Force represents that this is the Refresh Data mode of acquiescence.
The time of Materialized View Refresh Data includes：
On demand represent to refresh when user needs and refreshes, and require user to do it yourself to refresh number here
According to (job periodic refreshings can also be used)
On commit are represented when having data submission in form in the data block of the close net of business, are refreshed in Materialized View
Data
Start with next were represented since the specified time, (are specified by next) just refresh one at regular intervals
Secondary.
In this embodiment, Materialized View refreshes mode using fast, and refresh time uses commit modes.
Afterwards, refresh operation is performed to the Materialized View created.
execdbms_mview.refresh('mv_test','F')
Further, it is also possible to carry out inquiry operation.
For example, data syn-chronization situation is checked on the internet.
select*from mv_test
selectmview_name,last_refresh_date,staleness from user_mviews
In the close online enquiries synchrodata daily record situation of business.
select*from user_mview_logs；
In the step s 120, the data in the database of first network are synchronized to by the second net using the trigger method of synchronization
The database of network.
The traffic table that the data of internet to the close net of business are synchronously related to is fewer, and data synchronization can be realized using trigger.
Further, since Materialized View cannot carry out the data in database data manipulation (such as DML is operated), for internet data
It is close online that the related data of middle change needs to be synchronized to business, therefore uses trigger to realize the synchronization of business datum.Trigger
Stored in lane database with independent object, and trigger starts operation by event.
In one embodiment, as shown in figure 3, it is described using the trigger method of synchronization by the number in the database of first network
It may include following steps according to the database for being synchronized to the second network.
In step s 302, when the database to first network carries out data manipulation, judge whether to trigger corresponding touch
Send out device.
In step s 304, when triggering corresponding trigger, according to data in the database of first network to the second net
Data are refreshed in the database of network.
Further, it is described to judge whether that triggering corresponding trigger may include：To more involved by the data manipulation
Data line in row data judges whether that trigger event occurs, is determined pair when trigger event occurs for the data line
The trigger answered is triggered once；Or the whole data involved by the data manipulation are judged whether trigger event occurs,
Determine that corresponding trigger is triggered once when trigger event occurs for the whole data.
The trigger event may include it is following at least one：Data insertion, data update and data are deleted.
For example, the triggering sequential of trigger is respectively preceding triggering and rear triggering mode, and preceding triggering is to perform triggering
Event triggers the trigger currently created before, and rear triggering is that the triggering currently created is triggered after trigger event is performed
Device.Trigger can divide into line trigger and sentence trigger.Line trigger requirement is related to database when a DML statement operation
In multirow data when, for each data row therein, as long as they meet triggering constraints, activate and once trigger
Device.And sentence trigger operates whole sentence as trigger event, when it meets constraints, a trigger is activated.
Triggering and line trigger after being used in this programme according to the demand of practical business.
Being only used for DML statement in the executable portion of trigger, (SELECT (inquiry), INSERT (insertion), UPDATE are (more
Newly), DELETE (deletion)), it is impossible to use DDL sentences (CREATE (establishment), ALTER (exchange), DROP (discarding)).Trigger
In cannot include transaction controlling sentence (COMMIT (submission), ROLLBACK (rollback), SAVEPOINT (storage point)) etc..
By technical solution in the present invention, service function can be realized in the close net system of business by solving Internet user, be protected
The synchronization of two heterogeneous networks data is demonstrate,proved, without influencing related business process.
Fig. 4 is the schematic diagram for realizing the scene of the method for data synchronization in database according to embodiments of the present invention.Interconnection
The gateway connection close net of business is crossed by Netcom, and user realizes function of making out an invoice, server by the server 1 being connected with internet
Server1 accesses database D B1, databases of the database D B1 as internet when performing and operating.Advanced level user passes through service
Device server2 carries out feature operation, and server 2 accesses database D B2 when performing and operating, and database D B2 is as business
The database of close net.Various businesses module can be included on server 2, function of making out an invoice can be included on server 1
Module.Related common data, tissue, material, measurement unit, bank information etc. in the database D B2 of the close net of business, to its into
The successful data of the operations such as row DML need real-time synchronization into database D B1.It is and public to more than on server 1
Data do not support any renewal operation, and the practical business drawn a bill, such as some behaviour to invoice are related on server 2
Make flow examination ＆ verification, anti-examination ＆ verification, the calcellation correlation transition information to invoice are needed to be synchronized on database D B1.Wherein communication uses
TCP (transmission control protocol) agreement, digital independent use SQL (structured query language).As described in Figure 5, side in the present embodiment
Method may include following steps.
In step S502, materialized view log is created for the form of storage data in database D B2.In step
In S504, the database link for leading to database D B2 is created in database D B1.In step S506, in database D B1
Create Materialized View.When the refreshing mode of Materialized View is that form has data submission in database D B2, pass through database link
To determine changed data in the form in database D B2 according to materialized view log, by the data update of change to thing
Change in view.In step S508, refresh operation is performed to the Materialized View created by the refreshing mode of Materialized View.
In step S510, when carrying out data manipulation to database DB1, to the data line in the multirow data involved by data manipulation
Judge whether that trigger event occurs.In step S512, corresponding triggering is determined when trigger event occurs for data line
Device is triggered once, and data in database DB2 are refreshed according to data in database D B1.Wherein, trigger event can wrap
Include it is following at least one：Data insertion, data update and data are deleted.
In the above-mentioned technical solutions, the data synchronization scenario being combined using Materialized View and trigger, is in internet
Business demand of making out an invoice provides technical support.
Fig. 6 is the structure chart of the device of data synchronization in database according to embodiments of the present invention.As shown in fig. 6, the dress
Putting may include following module.
Materialized View synchronization module 610, for using the Materialized View method of synchronization by the number in the database of the second network
According to the database for being synchronized to first network.
Trigger synchronization module 620, for using the trigger method of synchronization that the data in the database of first network are same
Walk the database to the second network.
Wherein, the security level of second network is higher than the first network.
In one embodiment, as shown in fig. 7, the Materialized View synchronization module 610 may include such as lower unit.
Materialized view log creating unit 702, for being directed to the form wound of storage data in the database of the second network
Build materialized view log.
Database link creating unit 704, leads to the second network for being created in the database of the first network
Wide area information server links.
Materialized View creating unit 706, passes through the data basd link for being created in the database of the first network
Connect the Materialized View that Refresh Data is carried out according to the materialized view log.
Materialized View refresh unit 708, for performing refresh operation to the Materialized View created.
Further, it is described to may include according to materialized view log progress Refresh Data：According to the Materialized View
Daily record determines changed data in the form in the database of the second network, and the data update of change is regarded to the materialization
In figure.
The refresh time may include it is following at least one：Specify refresh time, when form in the database of the second network
There are the time that data are submitted and the time using preset time period as the cycle.
In one embodiment, as shown in fig. 7, trigger synchronization module 620 may include such as lower unit.
Judging unit 710 is triggered, for when the database to first network carries out data manipulation, judging whether triggering pair
The trigger answered.
Refresh Data unit 712, for when triggering corresponding trigger, according to data pair in the database of first network
Data are refreshed in the database of second network.
Further, it is described to judge whether that triggering corresponding trigger may include：To more involved by the data manipulation
Data line in row data judges whether that trigger event occurs, is determined pair when trigger event occurs for the data line
The trigger answered is triggered once；Or the whole data involved by the data manipulation are judged whether trigger event occurs,
Determine that corresponding trigger is triggered once when trigger event occurs for the whole data.The trigger event may include
It is following at least one：Data insertion, data update and data are deleted.
Above device is corresponding with preceding method, and embodiment can be found in preceding method and be described in detail, herein not
Repeat again.
One database of routine access can be realized by above device to use the data in two networks, and then eliminated
Integration across database accesses caused exception.
The preferred embodiment of the present invention is described in detail above in association with attached drawing, still, the present invention is not limited to above-mentioned reality
The detail in mode is applied, in the range of the technology design of the present invention, a variety of letters can be carried out to technical scheme
Monotropic type, these simple variants belong to protection scope of the present invention.
It is further to note that each particular technique feature described in above-mentioned embodiment, in not lance
In the case of shield, can be combined by any suitable means, in order to avoid unnecessary repetition, the present invention to it is various can
The combination of energy no longer separately illustrates.
In addition, various embodiments of the present invention can be combined randomly, as long as it is without prejudice to originally
The thought of invention, it should equally be considered as content disclosed in this invention.
Claims (10)
1. the method for data synchronization, this method include in a kind of database：
Data in the database of second network are synchronized to the database of first network using the Materialized View method of synchronization；
Data in the database of first network are synchronized to the database of the second network using the trigger method of synchronization；
Wherein, the security level of second network is higher than the first network.
2. according to the method described in claim 1, it is characterized in that, it is described using the Materialized View method of synchronization by the second network
The database that data in database are synchronized to first network includes：
In the database of the second network materialized view log is created for the form of storage data；
The wide area information server link for leading to the second network is created in the database of the first network；
Created in the database of the first network by the database link according to the materialized view log into line number
According to the Materialized View of refreshing；
Refresh operation is performed to the Materialized View created.
3. according to the method described in claim 2, it is characterized in that, described carry out Refresh Data according to the materialized view log
Including：Changed data in the form in the database of the second network are determined according to the materialized view log, will be changed
Data update into the Materialized View；And/or
The refresh time include it is following at least one：Specify refresh time, when in the database of the second network form have data
The time being submitted and the time using preset time period as the cycle.
4. according to the method described in claim 1, it is characterized in that, it is described using the trigger method of synchronization by the number of first network
The database of the second network is synchronized to according to the data in storehouse to be included：
When the database to first network carries out data manipulation, judge whether to trigger corresponding trigger；
When triggering corresponding trigger, according to data in the database of first network to data in the database of the second network into
Row refreshes.
5. according to the method described in claim 4, it is characterized in that, described judge whether that triggering corresponding trigger includes：It is right
The data line in multirow data involved by the data manipulation judges whether that trigger event occurs, when for a line number
Determine that corresponding trigger is triggered once according to when trigger event occurs；Or to the whole data involved by the data manipulation
Judge whether that trigger event occurs, determine that corresponding trigger is triggered one when trigger event occurs for the whole data
It is secondary；And/or
The trigger event include it is following at least one：Data insertion, data update and data are deleted.
6. the device of data synchronization, the device include in a kind of database：
Materialized View synchronization module, for being synchronized to the data in the database of the second network using the Materialized View method of synchronization
The database of first network；
Trigger synchronization module, for the data in the database of first network to be synchronized to second using the trigger method of synchronization
The database of network；
Wherein, the security level of second network is higher than the first network.
7. device according to claim 6, it is characterised in that the Materialized View synchronization module includes：
Materialized view log creating unit, the form for being directed to storage data in the database of the second network create materialization and regard
Figure daily record；
Database link creating unit, the database of the second network is led to for being created in the database of the first network
Database link；
Materialized View creating unit, for being created in the database of the first network by the database link according to institute
State the Materialized View that materialized view log carries out Refresh Data；
Materialized View refresh unit, for performing refresh operation to the Materialized View created.
8. device according to claim 7, it is characterised in that described that Refresh Data is carried out according to the materialized view log
Including：Changed data in the form in the database of the second network are determined according to the materialized view log, will be changed
Data update into the Materialized View；And/or
The refresh time include it is following at least one：Specify refresh time, when in the database of the second network form have data
The time being submitted and the time using preset time period as the cycle.
9. device according to claim 6, it is characterised in that the trigger synchronization module includes：
Judging unit is triggered, for when the database to first network carries out data manipulation, judging whether to trigger corresponding touch
Send out device；
Refresh Data unit, for when triggering corresponding trigger, according to data in the database of first network to the second net
Data are refreshed in the database of network.
10. device according to claim 9, it is characterised in that described to judge whether that triggering corresponding trigger includes：It is right
The data line in multirow data involved by the data manipulation judges whether that trigger event occurs, when for a line number
Determine that corresponding trigger is triggered once according to when trigger event occurs；Or to the whole data involved by the data manipulation
Judge whether that trigger event occurs, determine that corresponding trigger is triggered one when trigger event occurs for the whole data
It is secondary；And/or
The trigger event include it is following at least one：Data insertion, data update and data are deleted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610912457.9A CN107967274A (en) | 2016-10-19 | 2016-10-19 | The method and apparatus of data synchronization in database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610912457.9A CN107967274A (en) | 2016-10-19 | 2016-10-19 | The method and apparatus of data synchronization in database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107967274A true CN107967274A (en) | 2018-04-27 |
Family
ID=61996310
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610912457.9A Pending CN107967274A (en) | 2016-10-19 | 2016-10-19 | The method and apparatus of data synchronization in database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107967274A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783501A (en) * | 2018-12-27 | 2019-05-21 | 北京奇安信科技有限公司 | A kind of database synchronization method based on one-way optical gate, system, equipment and medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1618196A (en) * | 2001-12-11 | 2005-05-18 | 勒克罗伊公司 | Precise synchronization of distributed systems |
| CN1858710A (en) * | 2006-01-19 | 2006-11-08 | 华为技术有限公司 | Method and system for synchronizing data |
| CN101158958A (en) * | 2007-10-23 | 2008-04-09 | 浙江大学 | Fusion enquire method based on MySQL storage engines |
| CN101477524A (en) * | 2008-12-11 | 2009-07-08 | 金蝶软件（中国）有限公司 | System performance optimization method and system based on materialized view |
| CN101567943A (en) * | 2009-05-26 | 2009-10-28 | 中兴通讯股份有限公司 | Colorful ring back tone system with separated data management and call management and implementing method |
| US20130332487A1 (en) * | 2012-06-06 | 2013-12-12 | Tata Consultancy Services Limited | Generating reports based on materialized view |
-
2016
- 2016-10-19 CN CN201610912457.9A patent/CN107967274A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1618196A (en) * | 2001-12-11 | 2005-05-18 | 勒克罗伊公司 | Precise synchronization of distributed systems |
| CN1858710A (en) * | 2006-01-19 | 2006-11-08 | 华为技术有限公司 | Method and system for synchronizing data |
| CN101158958A (en) * | 2007-10-23 | 2008-04-09 | 浙江大学 | Fusion enquire method based on MySQL storage engines |
| CN101477524A (en) * | 2008-12-11 | 2009-07-08 | 金蝶软件（中国）有限公司 | System performance optimization method and system based on materialized view |
| CN101567943A (en) * | 2009-05-26 | 2009-10-28 | 中兴通讯股份有限公司 | Colorful ring back tone system with separated data management and call management and implementing method |
| US20130332487A1 (en) * | 2012-06-06 | 2013-12-12 | Tata Consultancy Services Limited | Generating reports based on materialized view |
Non-Patent Citations (1)
| Title |
|---|
| 杨京 等: "用物化视图实现广播监测数据的同步", 《广播电视信息》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783501A (en) * | 2018-12-27 | 2019-05-21 | 北京奇安信科技有限公司 | A kind of database synchronization method based on one-way optical gate, system, equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105357037B (en) | A kind of implementation method of public's wechat platform centralized management | |
| Kelly et al. | Intravenous oxytocin alone for cervical ripening and induction of labour | |
| CN105554133B (en) | HTTP remote data access system and method | |
| CN106716421A (en) | Data query method, device and node apparatus | |
| CN103793514B (en) | Database synchronization method and database | |
| CN104205099B (en) | Method and system for centralized issue track | |
| CN106534164B (en) | Effective virtual identity depicting method based on cyberspace user identifier | |
| CN106339639A (en) | Credit score management method and system based on block chain | |
| CN110096551A (en) | Credit data storage method, device, equipment and medium based on block chain | |
| Little et al. | Single imputation methods | |
| CN103198142B (en) | Page data renewal processing method, client and server | |
| CN105095462A (en) | Method and system for processing webpage repeated requests | |
| CN107220142A (en) | Perform the method and device of data recovery operation | |
| CN110929229A (en) | Block chain-based office document credibility verification method and system | |
| Draper et al. | Selecting the “best” regression equation | |
| CN107798037A (en) | The acquisition methods and server of user characteristic data | |
| CN109493072A (en) | A method of the privacy contract protection based on alliance's block chain | |
| CN110147684A (en) | For realizing the method and apparatus of block chain data-privacy protection | |
| CN105956143B (en) | Data bank access method and database broker node | |
| CN109993524A (en) | Card certificate management method, device, equipment and computer readable storage medium | |
| CN104317957B (en) | A kind of open platform of report form processing, system and report processing method | |
| CN106528391A (en) | Recording method of operating log by management platform on SSR | |
| CN110309197A (en) | Project data verification method and its device | |
| CN110233850A (en) | Register method, application server, user terminal and system based on alliance's chain | |
| CN107845044A (en) | A kind of method and device of electronic copyright registration |
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: 20180427 |
|
| RJ01 | Rejection of invention patent application after publication |