CN106708842A - Data loading method for application system, database and application system - Google Patents
Data loading method for application system, database and application system Download PDFInfo
- Publication number
- CN106708842A CN106708842A CN201510772107.2A CN201510772107A CN106708842A CN 106708842 A CN106708842 A CN 106708842A CN 201510772107 A CN201510772107 A CN 201510772107A CN 106708842 A CN106708842 A CN 106708842A
- Authority
- CN
- China
- Prior art keywords
- application system
- mdl
- sequence number
- notification message
- data
- 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.)
- Granted
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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- 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
Embodiments of the invention disclose a data loading method for a node application system, a database, and the application system. The method comprises the steps that a first application system performs writing operation on a main database and performs self-increment operation on values of serial numbers in a serial number table added in the main database; the first application system sends a notification message to a second application system; the second application system receives the notification message, reads the serial numbers from the notification message, and notifies a local backup database to be synchronized with the main database; the second application system verifies whether synchronous serial numbers matched with the read serial numbers exist in the local backup database or not; and if the synchronous serial numbers matched with the read serial numbers exist, the second application system loads data in the backup database. By utilizing the method, the database and the application system provided by the embodiments of the invention, the data loaded by the second application system can be ensured to be consistent with data loaded by a main application system, so that normal operation of businesses is ensured.
Description
Technical field
The application is related to Internet technical field, more particularly to a kind of application system to load the method sum of data
According to storehouse, application system.
Background technology
Service provider in internet is, it is necessary to respond the request of terminal applies, there is provided corresponding service.With
The growth of business scale, the scope of business of service provider may be expanded to extensive region.
For example, internet electric business platform, search platform, payment platform etc., in order to meet the visit of different geographical
Demand is asked, application system can be set up in multiple regions.So, the terminal access application system of different geographical
When, the application system of locality can be selected to conduct interviews, so as to reduce network delay.Meanwhile, application system
The service of offer needs the data in loading of databases.For example, set up first in A cities (such as Hangzhou) should
With system and MDL；The second application system is set up in city B (such as Shenzhen) separated by a distance
And backup database.So, the terminal applies of city B can be initiated to access to the second local application system
Request, without to relatively far apart, first application system of the larger city A of network delay is initiated to access please
Ask.
Application system provides (or even per minute) per hour thousands of secondary access, and logarithm can usually occur
The operation such as read and write according to the data in storehouse.So, in order to the normal operation of operation system is, it is necessary to keep
Each backup database is consistent with the data in MDL.Generally, MDL is read/write database, i.e.,
The read/write operation that first application system is carried out can be provided；And backup database is from MDL synchrodata,
And the read operation of local second application system is provided, without providing write operation, with avoid with MDL and its
Data in his backup database are inconsistent.
A kind of method of application system loading data includes in the prior art：
A1：First application system carries out write operation to MDL；
A2：First application system sends to the second application system and broadcasts the message；
A3：The second application system for receiving the broadcast message loads data from local backup database.
Aforesaid way of the prior art, as previously described, because backup database and MDL be located at it is different
Region, after data can not be updated to carry out the write operation with MDL by backup database immediately
Data are completely the same.So, if the second application system loads this immediately after the broadcast message is received
Data in the backup database on ground, then be likely to occur the second application system after loading data and the first application
Database in system is inconsistent, and causes business mistake occur；Or, in fact it could happen that the second application system
The situation of loading backup database failure, also can traffic affecting operation.
The content of the invention
The purpose of the embodiment of the present application is to provide method and database, the application of a kind of application system loading data
System, is the data synchronous with MDL completion with the data in the Local backup data storehouse for causing loading,
So as to ensure being normally carried out for business.
In order to solve the above technical problems, the embodiment of the present application provide a kind of application system loading data method and
Database, application system are realized in：
A kind of method for updating the data, including：
First application system carries out write operation to MDL, and in increased sequence number table in MDL
The value of sequence number is carried out into increment operator；
First application system sends a notification message to the second application system, the notification message include it is described from
Increase the sequence number after operation.
A kind of method that application system loads data, including：
Application system receives notification message, and the sequence number after increasing is read from from the notification message of the reception,
And it is synchronous with the MDL to notify that local backup database is carried out；
Application system whether there is and the sequence numbers match of the reading in verifying local backup database
SYN；
If it does, the second application system loads the data in the backup database.
A kind of application system, including：
R/w cell, for carrying out write operation to MDL；
Operating unit, for carrying out the value of sequence number in increased sequence number table in MDL being grasped from increasing
Make；
Notification unit, for being sent a notification message to node application system, the notification message includes described
Sequence number after increment operator.
A kind of application system, including：
Receiving unit, for receiving notification message；
Reading unit, for reading from the sequence number after increasing in the notification message of the reception；
Notification unit, for notifying that it is synchronous with MDL that local backup database is carried out；
Matching unit, for whether there is the sequence number with the reading in the local backup database of checking of uniting
The SYN of matching；
Loading unit, in the presence of matching unit checking, loads the data in the backup database.
A kind of method that application system loads data, including：
First application system carries out write operation, and the increased sequence number in the MDL to MDL
The value of sequence number is carried out into increment operator in table；
First application system sends a notification message to the second application system, the notification message include it is described from
Increase the sequence number after operation；
Second application system receives the notification message, therefrom reads the sequence number from after increasing, and notify
Local backup database carries out synchronous with the MDL；
With the presence or absence of the sequence numbers match with the reading in the second application system checking backup database
SYN；If it does, the second application system loads the data in the backup database.
The technical scheme provided from above the embodiment of the present application, the embodiment of the present application judge whether with
The SYN of the sequence numbers match of reading, it can be determined that whether backup database is synchronously newest data,
So that the second application system is in backup database is synchronously newest rear loading backup database
Data, it is ensured that the data of the second application system loading are consistent with the data that the first application system is loaded, i.e.,
Ensure the normal operation of business.
Brief description of the drawings
In order to illustrate more clearly of the embodiment of the present application or technical scheme of the prior art, below will be to implementing
Example or the accompanying drawing to be used needed for description of the prior art are briefly described, it should be apparent that, describe below
In accompanying drawing be only some embodiments described in the application, for those of ordinary skill in the art,
Without having to pay creative labor, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is the flow chart that the application application system loads data method one embodiment；
Fig. 2 is a kind of schematic diagram that message transmission is carried out using message-oriented middleware technology；
Fig. 3 is to send record principle figure using the MOM message of publish-subscribe architecture；
Fig. 4 is a kind of flow chart of the embodiment of the method for updating the data of the application；
Fig. 5 is the embodiment of the method that a kind of application system of the application loads data；
Fig. 6 is a kind of module map of application system embodiment of the application；
Fig. 7 is a kind of module map of application system embodiment of the application.
Specific embodiment
The embodiment of the present application provides the method and database, application system that a kind of application system loads data.
In order that those skilled in the art more fully understand the technical scheme in the application, below in conjunction with this
Accompanying drawing in application embodiment, is clearly and completely described to the technical scheme in the embodiment of the present application,
Obviously, described embodiment is only some embodiments of the present application, rather than whole embodiments.Base
Embodiment in the application, those of ordinary skill in the art are obtained under the premise of creative work is not made
The every other embodiment for obtaining, should all belong to the scope of the application protection.
The method that a kind of application system of the application introduced below loads data, the step of Fig. 1 shows the method,
As shown in Figure 1：
S110：First application system carries out write operation to MDL, and increased in the MDL
The value of sequence number is carried out into increment operator in sequence number table.
There is provided the access request of extensive region application system could be arranged to the first application system and second should
With system, the 3rd application system etc..Here illustrated by taking the first application system and second system as an example.For
Offer access, each application system needs the data in loading of databases.Usually, database can be set
For cross-region access can not be carried out.So, the first application system typically loads local MDL；Second
Application system typically loads local backup database.Certainly, under some application scenarios, it is also possible to set
Three application systems can access the corresponding backup database of the second application system with cross-region, and the application is not precluded from
Such case.Mainly illustrated as a example by the former below.
As it was previously stated, application system provides the access of thousands of per hour times, can usually occur to database
In data the operation such as read and write.Generally, MDL is read/write database, you can to provide the
The read/write operation that one application system is carried out；Backup database is from MDL synchrodata, and offer second should
With the read operation of system, without providing write operation, with avoid with MDL and other backup databases
Data are inconsistent.
It is when the data in MDL occur write operation, such as right according to the write operation of the first application system
MDL carries out the write-in of data, when updating or the operation such as deleting, it is necessary to by data after operation is completed
It is synchronized to backup database.
In MDL data are carried out with the order of write operation in order to identify, sequence number table can be set, wherein
The sequence number (Seq) of mark write operation can be deposited.Seq in sequence number table can be one or more.
As a example by there is a Seq in sequence number table, in the embodiment of the present application, can be in the first application system to master
After database carries out write operation, the sequence number is carried out into increment operator.For example, the initial value of Seq values is
1000, after certain first application system carries out write operation to master data, the value of the Seq is carried out from increasing
Operation, such as Seq values after increment operator are updated to 1001.
In the sequence number table increased in MDL, it is also possible to multiple sequence numbers are set, are represented respectively
To the write operation of different pieces of information content.So, by sequence in the sequence number table increased in MDL
Number value carry out increment operator, specifically, can be in MDL in increased sequence number table by maximum
The value of value sequence number carries out increment operator.For example, have 3 different sequence numbers in sequence number table, Seq1=1100,
Seq2=1101, Seq3=1102.After certain first application system carries out write operation to master data, by this
The value of the sequence number Seq3 of maximum carries out increment operator, such as Seq3 after increment operator in sequence number table
Value is updated to 1103.Certainly, after certain first application system carries out write operation to master data, it is also possible to
The value of other sequence numbers in the sequence number table is carried out into increment operator, such as the Seq1 values after increment operator are more
Newly for 1101, Seq2 values are updated to 1102.
In addition it is also possible to after being the request that the first application system receives the second application system, to MDL
Carry out write operation.For example, the second application system needs to carry out write operation to database.As it was previously stated, the feelings
Under condition, the local backup database of the second application system is read from database, does not possess write permission.So,
Two application systems can send to the first application system and ask, i.e. request carries out write operation.First application system
After receiving the request of the second application system transmission, write operation further can be carried out to MDL.It is described
In request, the particular content that write operation is carried out to database can be typically included.First application system is to main number
The process of write operation is carried out according to storehouse, it is similar, as set forth above, it is possible to be carried out to the Seq values in MDL
Increment operator, repeats no more.
S120：First application system sends a notification message to the second application system, and the notification message includes
Sequence number after the increment operator.
After first application system carries out write operation to MDL, notice can be sent to the second application system and disappeared
Breath, to notify that the second application system updates local backup database.Usually, in addition to the second application system,
The 3rd application system, the 4th application system etc. are there is likely to be, therefore, the first application system can be to other
Application system sends a notification message in a broadcast manner.
First application system can be sent a notification message by message-oriented middleware technology to other application system.
Message-oriented middleware (Message Oriented Middleware, MOM, it is also referred to as message-oriented in
Between part) technology, there is provided a kind of middleware mechanism of message transmission is carried out with the flexi mode of loose couplings.
Fig. 2 shows a kind of schematic diagram that message transmission is carried out using message-oriented middleware technology.As shown in Fig. 2 should
With program A and application program B by using MOM application programming interface (Application
Programming Interface, API) send message communicated.So, MOM can be realized in difference
Communication between platform, it is often used to mask the characteristic between various platforms and agreement, and journey is applied in realization
Collaboration between sequence.The message-oriented middleware product of current main flow includes International Business Machine Corporation (IBM)
The MQSeries of (International Business Machines Corporation, IBM), Bank of East Asia Ltd.
The MessageQ of (Bank of East Asia, BEA) and the Java Message Service of Sun Company, Inc. (Sun)
(Java Message Service, JMS) etc..MOM is included between the application based on storage and forwarding
Asynchronous message transfer or synchronization message are transmitted.In Asynchronous message transfer, the not direct communication each other between,
But with the MOM server communications as intermediary.Asynchronous middleware Technology includes point-to-point mode and hair again
The class of cloth-subscribing manner two.
In Publish-subscribe mode as an example, as shown in Figure 3, utilized using the MOM of publish-subscribe architecture
The content of referred to as theme (topic) carrys out sending and receiving for completion message.Send application program (hereinafter referred to as
Publisher) issue the message of oneself, it is indicated that and message semantic definition is relevant certain topic (generally corresponding to the publisher)
Information.Wish that the application program (hereinafter referred to as subscriber) for receiving these message have subscribed this topic.
The subscriber for subscribing to the topic can receive the message on the theme.MOM servers play the work of agency
With the announced message of theme to be routed to all subscribers of the theme.
In embodiments herein, using MOM technologies, such as Publish-subscribe mode, the first application system
System can be publisher, and the second application system and other application systems can be subscriber.
S130：Second application system receives the notification message, therefrom reads the sequence number from after increasing, and
Notify that local backup database is carried out synchronous with the MDL.
As it was previously stated, the second application system typically reads local backup database.Second application system is received
To after the notification message, can notify that local backup database is carried out synchronous with MDL.It is described
It is synchronous, data syn-chronization and the sequence number table synchronization can be included.
Similar with MDL, the local backup database can increase SYN
(Copy_Seq).The Copy_Seq can identify the synchronous order of the local backup database.For example,
Before this is subsynchronous, the Copy_Seq of the backup database is 1000.Likewise, in local backup number
According to storehouse complete it is synchronous with MDL after, the Seq in MDL can be saved as local
Copy_Seq.For example in the sequence number table of MDL there is a Seq, the Seq values after increment operator
Be updated to 1001, then after backup database completes the data syn-chronization with MDL, can be by MDL
Seq values save as the value of local Copy_Seq, such as Copy_Seq=1001 after preservation.
Receive the second application system (and the 3rd application system, the 4th application system of the notification message
Deng), the sequence number from after increasing in the notification message, for example, Seq=1000 can be read.
Similar, the local backup database can increase multiple Copy_Seq, represent respectively to not
With the write operation of data content.For example, there is 3 different synchronizations in the SYN table of backup database
Sequence number, Copy_Seq1=1100, Copy_Seq2=1101, Copy_Seq3=1102.At certain one time
After two application systems receive the notification message, can notify that local backup database is carried out and master data
The synchronization in storehouse.Local backup database carry out it is synchronous with MDL after, MDL can be preserved
In maximum serial number, and as local SYN.The SYN can be existing same
Step sequence number, it is, for example, to cover the existing SYN to preserve operation, such as covering Copy_Seq3, is covered
Copy_Seq3=1103 after lid.In addition it is also possible to be newly-built operation, such as a newly-built Copy_Seq4,
The Copy_Seq4=1103, while the value of Copy_Seq3 can keep constant.
S140：With the presence or absence of the sequence number with the reading in the second application system checking backup database
The SYN of matching；If it does, the second application system loads the data in the backup database.
Second application system can be before the data in loading local well-behaved database, and checking is local standby
With the presence or absence of the SYN with the sequence numbers match of the reading in part database.
As it was previously stated, local backup database can increase multiple Copy_Seq, represent respectively to difference
The write operation of data content.After certain second application system receives the notification message, can notify
Local backup database carries out synchronous with MDL.Local backup database is carried out and MDL
Synchronization after, the sequence number in MDL can be preserved, and as local SYN.So,
In S140, by verifying in Local backup data storehouse with the presence or absence of synchronous with the sequence numbers match of the reading
Sequence number, it can be determined that it is synchronous with MDL whether backup database completes.
As it was previously stated, after the second application system receives the notification message, local backup number can be notified
Carried out according to storehouse synchronous with MDL.And local backup database is synchronized with MDL and typically needed
Will a period of time.Before the time, i.e., before local backup database is synchronous with MDL completion,
Because data not yet complete synchronization, then now second application system loads the number in the backup database
Cannot be loaded successfully according to possibly, it is impossible to which normal Operational Visit is provided；Or add only carried partial data, and
Data after being updated completely without loading, so, can not ensure correct Operational Visit.
Data can be loaded in application system using Service Component.The Service Component has in application system
There is wide application.Service Component is usually a series of functional module including indivisible business activities.
The advantage of Service Component largely possesses two correlations but completely different characteristic from it：First,
Linked by loose coupling method between component, possessed flexibly, the characteristics of response is fast, to be applicable ability strong；
Secondly, the cohesiveness of each activity is strong in component, can externally provide efficiency high, matter measured service.
Second application system loads the data in the backup database, specifically, can be second should
The data in the backup database are loaded with the Service Component in system.
By the above embodiments of the present application, the SYN with the sequence numbers match for reading is judged whether,
May determine that whether backup database is synchronously newest data, so that the second application system is standby
Part database synchronization is the data in newest rear loading backup database, it is ensured that the second application system is loaded
Data it is consistent with the data that the first application system is loaded, that is, ensure the normal operation of business.
After the S140, below step can also be included：
S150：If mismatched, the second application system every preset duration checking it is local whether there is with it is described
The SYN of the sequence numbers match of reading, and the number in the backup database is loaded after verifying presence
According to.
Synchronized in view of backup database and MDL it is synchronous to completion, substantially several ms to number
Hundred milliseconds, therefore, preset duration could be arranged to 5ms or 10ms etc.
So, by judging whether the SYN with the sequence numbers match for reading, it can be determined that standby
Whether part database is synchronously newest data, judged result for it is no be every judging again after certain hour,
And loaded in the presence of the result is, so that the second application system is synchronously in backup database
Data after newest in loading backup database, it is ensured that the data of the second application system loading should with first
Data with system loads are consistent.
A kind of embodiment of the method for updating the data of the application introduced below, such as Fig. 4, it is characterised in that including：
S410：First application system carries out write operation, and the increased sequence in MDL to MDL
The value of sequence number is carried out into increment operator in number table；
S420：First application system sends a notification message to the second application system, and the notification message includes
Sequence number after the increment operator.
The value of sequence number is carried out into increment operator in the sequence number table increased in MDL, including：
The value of maximum serial number is carried out into increment operator in increased sequence number table in MDL.
The main application system sends a notification message to node application system, including：
First application system is sent a notification message by message-oriented middleware to the second application system.
First application system sends a notification message to the second application system, including：
First application system is sent a notification message by message-oriented middleware to the second application system.
A kind of embodiment of the method for application system loading data of the application introduced below, such as Fig. 5, including：
S510：Application system receives notification message, and the sequence after increasing is read from from the notification message of the reception
Row number, and it is synchronous with MDL to notify that local backup database is carried out；
S520：With the presence or absence of the sequence with the reading in the local backup database of the application system checking
Number matching SYN；
S530：If it does, the application system loads the data in the backup database.
The application system loads the data in the backup database, can specifically include：
Service Component in the application system loads the data in the backup database.
Methods described can also include：
If it does not, the application system verifies that local backup database whether there is every preset duration
With the SYN of the sequence numbers match of the reading, and the result presence after load the backup number
According to the data in storehouse.
A kind of application system embodiment of the application introduced below, Fig. 6 shows the module map of the system embodiment,
As illustrated, including：
R/w cell 61, for carrying out write operation to MDL；
Operating unit 62, for carrying out from increasing the value of sequence number in increased sequence number table in MDL
Operation；
Notification unit 63, for being sent a notification message to the second application system, the notification message includes institute
State the sequence number after increment operator.
Preferably, the value of sequence number is carried out increment operator by the operating unit 62 in MDL, bag
Include：Operating unit 62 is carried out certainly the value of maximum serial number in increased sequence number table in MDL
Increase operation.
Preferably, the notification unit 63 is sent a notification message by message-oriented middleware to the second application system.
A kind of application system embodiment of the application introduced below, Fig. 7 shows the mould of the application system embodiment
Block figure, as illustrated, including：
Receiving unit 71, for receiving notification message；
Reading unit 72, for reading from the sequence number after increasing in the notification message of the reception；
Notification unit 73, for notifying that it is synchronous with MDL that local backup database is carried out；
Matching unit 74, for verifying in local backup database with the presence or absence of the sequence number with the reading
The SYN of matching；
Loading unit 75, in the presence of the result of matching unit 94 is, loads the backup database
In data.
Preferably, the loading unit 75 can include the Service Component in the application system.
Preferably, the result of the matching unit 74 be in the absence of when, every preset duration verify this
With the presence or absence of the SYN with the sequence numbers match of the reading in the backup database on ground.
In the nineties in 20th century, it is changing on hardware that can clearly be distinguished for the improvement of a technology
The improvement entered on (for example, the improvement to circuit structures such as diode, transistor, switches) or software is (right
In the improvement of method flow).However, with the development of technology, the improvement of current many method flows is
Through directly improving for hardware circuit can be considered as.Designer is nearly all by by improved method flow
It is programmed into hardware circuit to obtain corresponding hardware circuit.Therefore, it cannot be said that method flow
Improvement cannot be realized with hardware entities module.For example, PLD (Programmable
Logic Device, PLD) (for example field programmable gate array (Field Programmable Gate Array,
FPGA it is exactly)) such a integrated circuit, its logic function is determined by user to device programming.By setting
Meter personnel are voluntarily programmed a digital display circuit " integrated " on a piece of PLD, without asking chip manufacturing
Manufacturer designs and makes special IC chip.And, nowadays, substitution manually makes integrated electricity
Road chip, this programming also uses " logic compiler (logic compiler) " software instead to realize mostly, it
Software compiler used is similar when being write with program development, and the source code before compiling is also handy
Specific programming language is write, and this is referred to as hardware description language (Hardware Description
Language, HDL), and HDL is also not only a kind of, but have many kinds, such as ABEL (Advanced
Boolean Expression Language)、AHDL(Altera Hardware Description Language)、
Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL
(Ruby Hardware Description Language) etc., that most commonly use at present is VHDL
(Very-High-Speed Integrated Circuit Hardware Description Language) and Verilog.
Those skilled in the art also will be apparent to the skilled artisan that only need to by method flow with above-mentioned several hardware description languages slightly
Programming in logic is simultaneously programmed into integrated circuit, it is possible to be readily available the hardware for realizing the logical method flow
Circuit.
Controller can be implemented in any suitable manner, for example, controller can take such as microprocessor
Or processor and storage can be by computer readable program code (such as softwares of (micro-) computing device
Or firmware) computer-readable medium, gate, switch, application specific integrated circuit (Application Specific
Integrated Circuit, ASIC), the form of programmable logic controller (PLC) and embedded microcontroller, controller
Example include but is not limited to following microcontroller：ARC 625D、Atmel AT91SAM、Microchip
PIC18F26K20 and Silicone Labs C8051F320, Memory Controller is also implemented as depositing
A part for the control logic of reservoir.It is also known in the art that except with pure computer-readable program
Code means are realized beyond controller, can cause to control by the way that method and step is carried out into programming in logic completely
Device is with the shape of gate, switch, application specific integrated circuit, programmable logic controller (PLC) and embedded microcontroller etc.
Formula realizes identical function.Therefore this controller is considered a kind of hardware component, and to bag in it
The structure that the device for realizing various functions for including can also be considered as in hardware component.Or even, can be with
To be used to realizing that the device of various functions is considered as not only being the software module of implementation method but also can be hardware
Structure in part.
System, device, module or unit that above-described embodiment is illustrated, specifically can be by computer chip or reality
Body is realized, or is realized by the product with certain function.
For convenience of description, it is divided into various units with function during description apparatus above to describe respectively.Certainly,
The function of each unit can be realized in same or multiple softwares and/or hardware when the application is implemented.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or meter
Calculation machine program product.Therefore, the present invention can be using complete hardware embodiment, complete software embodiment or knot
Close the form of the embodiment in terms of software and hardware.And, the present invention can be used and wherein wrapped at one or more
Containing computer usable program code computer-usable storage medium (including but not limited to magnetic disk storage,
CD-ROM, optical memory etc.) on implement computer program product form.
The present invention is produced with reference to method according to embodiments of the present invention, equipment (system) and computer program
The flow chart and/or block diagram of product is described.It should be understood that can by computer program instructions realize flow chart and
/ or block diagram in each flow and/or the flow in square frame and flow chart and/or block diagram and/
Or the combination of square frame.These computer program instructions to all-purpose computer, special-purpose computer, insertion can be provided
The processor of formula processor or other programmable data processing devices is producing a machine so that by calculating
The instruction of the computing device of machine or other programmable data processing devices is produced for realizing in flow chart one
The device of the function of being specified in individual flow or multiple one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in can guide computer or the treatment of other programmable datas to set
In the standby computer-readable memory for working in a specific way so that storage is in the computer-readable memory
Instruction produce include the manufacture of command device, the command device realization in one flow of flow chart or multiple
The function of being specified in one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices, made
Obtain and series of operation steps is performed on computer or other programmable devices to produce computer implemented place
Reason, so as to the instruction performed on computer or other programmable devices is provided for realizing in flow chart one
The step of function of being specified in flow or multiple one square frame of flow and/or block diagram or multiple square frames.
In a typical configuration, computing device includes one or more processors (CPU), input/output
Interface, network interface and internal memory.
Internal memory potentially includes the volatile memory in computer-readable medium, random access memory
And/or the form, such as read-only storage (ROM) or flash memory (flash RAM) such as Nonvolatile memory (RAM).It is interior
Deposit be computer-readable medium example.
Computer-readable medium includes that permanent and non-permanent, removable and non-removable media can be by appointing
What method or technique realizes information Store.Information can be computer-readable instruction, data structure, program
Module or other data.The example of the storage medium of computer include, but are not limited to phase transition internal memory (PRAM),
It is static RAM (SRAM), dynamic random access memory (DRAM), other kinds of random
Access memory (RAM), read-only storage (ROM), Electrically Erasable Read Only Memory (EEPROM),
Fast flash memory bank or other memory techniques, read-only optical disc read-only storage (CD-ROM), digital multi light
Disk (DVD) or other optical storages, magnetic cassette tape, the storage of tape magnetic rigid disk or other magnetic storage apparatus
Or any other non-transmission medium, can be used to store the information that can be accessed by a computing device.According to herein
Define, computer-readable medium does not include temporary computer readable media (transitory media), such as modulates
Data-signal and carrier wave.
Also, it should be noted that term " including ", "comprising" or its any other variant be intended to non-row
His property is included, so that process, method, commodity or equipment including a series of key elements not only include
Those key elements, but also other key elements including being not expressly set out, or also include for this process,
Method, commodity or the intrinsic key element of equipment.In the absence of more restrictions, by sentence " including
One ... " key element that limits, it is not excluded that in the process including the key element, method, commodity or set
Also there is other identical element in standby.
It will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer journey
Sequence product.Therefore, the application can using complete hardware embodiment, complete software embodiment or combine software and
The form of the embodiment of hardware aspect.And, the application can be used and wherein include calculating at one or more
Machine usable program code computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM,
Optical memory etc.) on implement computer program product form.
The application can be described in the general context of computer executable instructions, example
Such as program module.Usually, program module includes performing particular task or realizes particular abstract data type
Routine, program, object, component, data structure etc..This can also in a distributed computing environment be put into practice
Application, in these DCEs, by the remote processing devices connected by communication network come
Execution task.In a distributed computing environment, program module may be located at including local including storage device
In remote computer storage medium.
Each embodiment in this specification is described by the way of progressive, identical phase between each embodiment
As part mutually referring to what each embodiment was stressed is the difference with other embodiment.
For especially for system embodiment, because it is substantially similar to embodiment of the method, so the comparing of description
Simply, the relevent part can refer to the partial explaination of embodiments of method.
Embodiments herein is the foregoing is only, the application is not limited to.For this area skill
For art personnel, the application can have various modifications and variations.All institutes within spirit herein and principle
Any modification, equivalent substitution and improvements of work etc., within the scope of should be included in claims hereof.
Claims (14)
1. a kind of method for updating the data, it is characterised in that including：
First application system carries out write operation to MDL, and in increased sequence number table in MDL
The value of sequence number is carried out into increment operator；
First application system sends a notification message to the second application system, the notification message include it is described from
Increase the sequence number after operation.
2. the method for claim 1, it is characterised in that first application system should to second
Sent a notification message with system, including：
First application system is sent a notification message with broadcast mode to the second application system.
3. the method for claim 1, it is characterised in that the sequence increased in MDL
The value of sequence number is carried out into increment operator in row number table, including：
The value of maximum serial number is carried out into increment operator in increased sequence number table in MDL.
4. method as claimed in claim 2, it is characterised in that first application system should to second
Sent a notification message with system, including：
First application system is sent a notification message by message-oriented middleware to the second application system.
5. a kind of method that application system loads data, it is characterised in that including：
Application system receives notification message, and the sequence number after increasing is read from from the notification message of the reception,
And it is synchronous with the MDL to notify that local backup database is carried out；
Application system whether there is and the sequence numbers match of the reading in verifying local backup database
SYN；
If it does, the second application system loads the data in the backup database.
6. method as claimed in claim 5, it is characterised in that the second application system loads the backup
Data in database, including：
Service Component in second application system loads the data in the backup database.
7. method as claimed in claim 5, it is characterised in that methods described also includes：
If mismatched, whether the second application system deposits in preset duration verifies local backup database
In the SYN with the sequence numbers match of the reading, and the Backup Data is loaded after presence is verified
Data in storehouse.
8. a kind of application system, it is characterised in that including：
R/w cell, for carrying out write operation to MDL；
Operating unit, for carrying out the value of sequence number in increased sequence number table in MDL being grasped from increasing
Make；
Notification unit, for being sent a notification message to node application system, the notification message includes described
Sequence number after increment operator.
9. system as claimed in claim 8, it is characterised in that the operating unit is in MDL
The value of sequence number is carried out into increment operator, including：Operating unit is in increased sequence number table in MDL
The value of maximum serial number is carried out into increment operator.
10. system as claimed in claim 8, it is characterised in that the notification unit is by the middle of message
Part sends a notification message to node application system.
A kind of 11. application systems, it is characterised in that including：
Receiving unit, for receiving notification message；
Reading unit, for reading from the sequence number after increasing in the notification message of the reception；
Notification unit, for notifying that it is synchronous with MDL that local backup database is carried out；
Matching unit, for whether there is the sequence number with the reading in the local backup database of checking of uniting
The SYN of matching；
Loading unit, in the presence of matching unit checking, loads the data in the backup database.
12. application systems as claimed in claim 11, it is characterised in that the loading unit includes institute
State the Service Component in application system.
13. application systems as claimed in claim 11, it is characterised in that the checking of the matching unit
Result be in the absence of when, whether the matching unit is deposited in preset duration verifies local backup database
In the SYN with the sequence numbers match of the reading.
The method that a kind of 14. application systems load data, it is characterised in that including：
First application system carries out write operation, and the increased sequence number in the MDL to MDL
The value of sequence number is carried out into increment operator in table；
First application system sends a notification message to the second application system, the notification message include it is described from
Increase the sequence number after operation；
Second application system receives the notification message, therefrom reads the sequence number from after increasing, and notify
Local backup database carries out synchronous with the MDL；
With the presence or absence of the sequence numbers match with the reading in the second application system checking backup database
SYN；If it does, the second application system loads the data in the backup database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510772107.2A CN106708842B (en) | 2015-11-12 | 2015-11-12 | Method for loading data by application system, database and application system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510772107.2A CN106708842B (en) | 2015-11-12 | 2015-11-12 | Method for loading data by application system, database and application system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106708842A true CN106708842A (en) | 2017-05-24 |
| CN106708842B CN106708842B (en) | 2021-02-09 |
Family
ID=58930119
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510772107.2A Active CN106708842B (en) | 2015-11-12 | 2015-11-12 | Method for loading data by application system, database and application system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106708842B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109033127A (en) * | 2018-05-31 | 2018-12-18 | 阿里巴巴集团控股有限公司 | A kind of synchrodata method of calibration, device and equipment |
| CN109298976A (en) * | 2018-10-17 | 2019-02-01 | 成都索贝数码科技股份有限公司 | Heterogeneous database cluster backup system and method |
| CN110300015A (en) * | 2019-05-09 | 2019-10-01 | 网宿科技股份有限公司 | Method of data synchronization and system |
| CN111522784A (en) * | 2020-04-20 | 2020-08-11 | 支付宝(杭州)信息技术有限公司 | Metadata synchronization method, device and equipment for unstructured data file |
| CN114531394A (en) * | 2020-11-20 | 2022-05-24 | 华为技术有限公司 | Data synchronization method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101064630A (en) * | 2006-04-24 | 2007-10-31 | 华为技术有限公司 | Data synchronization method and system |
| CN101291342A (en) * | 2008-06-18 | 2008-10-22 | 中兴通讯股份有限公司 | Data synchronizing method and system in distributed system |
| CN103561095A (en) * | 2013-11-04 | 2014-02-05 | 金蝶软件（中国）有限公司 | Data synchronous method and node and storage service cluster |
| CN103997525A (en) * | 2014-05-21 | 2014-08-20 | 北京紫光天禾软件系统技术有限公司 | Distributed data synchronization method and system |
-
2015
- 2015-11-12 CN CN201510772107.2A patent/CN106708842B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101064630A (en) * | 2006-04-24 | 2007-10-31 | 华为技术有限公司 | Data synchronization method and system |
| CN101291342A (en) * | 2008-06-18 | 2008-10-22 | 中兴通讯股份有限公司 | Data synchronizing method and system in distributed system |
| CN103561095A (en) * | 2013-11-04 | 2014-02-05 | 金蝶软件（中国）有限公司 | Data synchronous method and node and storage service cluster |
| CN103997525A (en) * | 2014-05-21 | 2014-08-20 | 北京紫光天禾软件系统技术有限公司 | Distributed data synchronization method and system |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109033127A (en) * | 2018-05-31 | 2018-12-18 | 阿里巴巴集团控股有限公司 | A kind of synchrodata method of calibration, device and equipment |
| CN109033127B (en) * | 2018-05-31 | 2021-10-29 | 创新先进技术有限公司 | Synchronous data verification method, device and equipment |
| CN109298976A (en) * | 2018-10-17 | 2019-02-01 | 成都索贝数码科技股份有限公司 | Heterogeneous database cluster backup system and method |
| CN109298976B (en) * | 2018-10-17 | 2022-04-12 | 成都索贝数码科技股份有限公司 | Heterogeneous database cluster backup system and method |
| CN110300015A (en) * | 2019-05-09 | 2019-10-01 | 网宿科技股份有限公司 | Method of data synchronization and system |
| CN111522784A (en) * | 2020-04-20 | 2020-08-11 | 支付宝(杭州)信息技术有限公司 | Metadata synchronization method, device and equipment for unstructured data file |
| CN111522784B (en) * | 2020-04-20 | 2023-11-21 | 支付宝(杭州)信息技术有限公司 | Metadata synchronization method, device and equipment for unstructured data files |
| CN114531394A (en) * | 2020-11-20 | 2022-05-24 | 华为技术有限公司 | Data synchronization method and device |
| CN114531394B (en) * | 2020-11-20 | 2023-11-17 | 华为技术有限公司 | Data synchronization method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106708842B (en) | 2021-02-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106708842A (en) | Data loading method for application system, database and application system | |
| CN102054021B (en) | Use WEB portal application method for customizing and the system of profile | |
| CN109634561A (en) | A kind of online visual programming method and device | |
| CN107040648A (en) | Information displaying method and device | |
| US20180152339A1 (en) | APPLICATION RESILIENCY USING APIs | |
| US8874587B2 (en) | Tenant placement in multitenant cloud databases with one-to-many data sharing | |
| CN103917972A (en) | System and method for providing session affinity and improved connectivity in clustered database environment | |
| TW201229795A (en) | Web service patterns for globally distributed service fabric | |
| US20140156598A1 (en) | Replication control using eventually consistent meta-data | |
| CN109492013A (en) | Data processing method, device and system applied to data-base cluster | |
| CN109508912B (en) | Service scheduling method, device, equipment and storage medium | |
| JP6975153B2 (en) | Data storage service processing method and equipment | |
| CN102306165A (en) | Ship electronic chart data multi-platform shared service device and construction method thereof | |
| EP4050850A1 (en) | Service upgrading method, device and system | |
| US20080126430A1 (en) | Intermediary document for critical change control | |
| CN108390914A (en) | A kind of service update method and device, system | |
| CN110223179A (en) | The data processing method of fund, device, system, medium | |
| CN109635020A (en) | A kind of processing method of business, device, equipment and system | |
| CN112598529A (en) | Data processing method and device, computer readable storage medium and electronic equipment | |
| CN110019131A (en) | A kind of method and apparatus of discs business | |
| CN108536447B (en) | Operation and maintenance management method | |
| CN110532243A (en) | Data processing method, device and electronic equipment | |
| JP3712984B2 (en) | Work progress control device and method, work progress control program, and recording medium recording the program | |
| US11775398B2 (en) | Rollback of services with a global variable change | |
| CN110502238A (en) | A kind of method and device of front and back end joint debugging |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200918 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200918 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |