CN105677885A - Receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization - Google Patents
Receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization Download PDFInfo
- Publication number
- CN105677885A CN105677885A CN201610024669.3A CN201610024669A CN105677885A CN 105677885 A CN105677885 A CN 105677885A CN 201610024669 A CN201610024669 A CN 201610024669A CN 105677885 A CN105677885 A CN 105677885A
- Authority
- CN
- China
- Prior art keywords
- synchronous
- data
- standard
- documents
- database
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention relates to a receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization. The sending method comprises the steps that when a database is updated, changed data in the database is stored in a synchronization sheet; the synchronization sheet is monitored, and the changed data, in an unprocessed state, in the synchronization sheet is compressed in a user-defined format to form a synchronized file; the synchronized file is sent in a selected transmission mode so that data synchronization can be conducted by a receiving terminal; a feedback result sent by the receiving terminal is received, and the state of the corresponding changed data in the synchronization sheet is updated to be the processed state according to the feedback result. The user-defined format is adopted to conduct compression, so that synchronous data is formed, the data size of the synchronous data is decreased, the communication cost of a shore base and a ship terminal is reduced, and the traffic is better saved.
Description
Technical field
The present invention relates to data field of synchronization, refer in particular to a kind of shipping business data synchronous transceiver and sideMethod and synchro system.
Background technology
It is synchronous that traditional database synchronization needs database software mutually to shake hands can to complete data; OnceThere is wrong necessary manual intervention; And the data volume of transmission is excessive, cause synchronous often failure and ship endCommunication fee is too high.
Summary of the invention
The object of the invention is to overcome the defect of prior art, provide a kind of shipping business data synchronousTransmitting apparatus and method, receiving equipment and method and synchro system, solve traditional database synchronousTime occur wrong must manual intervention, transmitted data amount causes greatly synchronous frequent failure and ship end communication expenseBy too high problem.
The technical scheme that realizes above-mentioned purpose is:
The invention provides the synchronous sending method of a kind of shipping business data, described sending method comprises:
In the time that database occurs to upgrade, the data that change in described database are deposited in synchronous meter;
Monitoring described synchronous meter, is that untreated delta data is with self-defined by state in described synchronous meterForm compresses and forms synchronous documents;
Described synchronous documents is sent with the transmission means of selecting, carry out data together for receiving terminalStep; And
Receive the feedback result that described receiving terminal sends, according to described feedback result and by described synchronous meterThe state of the delta data of middle correspondence is updated to processed.
Adopt user-defined format compress to form synchronous documents, and transmission when synchronous documents to synchronouslyFile further compresses, and reduces the data volume of synchronous documents, and then reduction bank base and ship endCommunication fee, saves flow preferably.
The further improvement of the synchronous sending method of shipping business data of the present invention is, by described synchronous meterMiddle state is that untreated delta data compresses and forms synchronous documents with user-defined format, comprising:
Set user-defined format, described user-defined format comprises the first standard and the second standard, described theOne standard is that the gauge outfit in described delta data is defined once, separates record between field value with colonIn the ranks separate with plus sige; Described the second standard is that the gauge outfit in described delta data is defined once, wordBetween segment value, separate with colon, record in the ranks separates with plus sige, and in described the second standard, data arrange partOnly definition needs synchronous field;
According to selected user-defined format, the table name of delta data and field value compression are formed to synchronous literary compositionPart is also marked order for formed synchronous documents; And
Whether the size that judges the synchronous documents forming exceeds setting threshold, at definite described synchronous documentsSize while exceeding setting threshold, described synchronous documents is carried out to bundling compression with the compressed value of setting,And the divided data forming for bundling compression is encrypted.
The further improvement of the synchronous sending method of shipping business data of the present invention is, by described synchronous literary compositionPart sends with the transmission means of selecting, and comprising:
Be that untreated delta data writes local literary composition by table name and Major key by state in synchronous meterIn part, transmit described synchronous documents according to third party transfer mode;
Be that untreated delta data writes local literary composition by table name and Major key by state in synchronous meterIn part, transmit described synchronous documents by lettergram mode;
Be that untreated delta data writes local literary composition by table name and Major key by state in synchronous meterIn part, transmit described synchronous documents by HTTP mode; Or
Directly transmit described synchronous documents by lettergram mode.
The present invention also provides a kind of shipping business data synchronous method of reseptance, comprising:
The synchronous documents that receiving end/sending end sends, and received synchronous documents is entered with user-defined formatRow decompress(ion), to obtain delta data;
By synchronous to realize data in described delta data write into Databasce, complete synchronous rear transmission of dataFeedback result, upgrades synchronous meter for described transmitting terminal;
When by described delta data write into Databasce, if can not find described in correspondence in described databaseWhen the Major key of delta data, the Major key of described delta data is inserted in described database; IfCan not find the external key associated data comprising in corresponding described delta data in described database time, to instituteState transmitting terminal and send the request that transmits relevant external key associated data to wait to receive relevant external key incidence numberAccording to after to carry out data synchronous again.
The further improvement of the synchronous method of reseptance of shipping business data of the present invention is, described self-defined latticeFormula comprises the first standard and the second standard, and described the first standard is that the gauge outfit in described delta data is fixedJustice once, separates with colon between field value, and record in the ranks separates with plus sige; Described the second standard is willGauge outfit in described delta data defines once, between field value, separates with colon, and record is in the ranks with plus sigeSeparate, in described the second standard, data arrange the part field that only definition need to be synchronous.
The present invention also provides a kind of shipping business data synchronous transmitting apparatus, comprising:
Trigger, is connected with database, in the time that described database occurs to upgrade, produce trigger and incite somebody to actionIn described database, delta data is deposited in synchronous meter;
Monitor, is connected with described synchronous meter, is untreated for monitoring described synchronous meter stateDelta data, and untreated delta data is compressed and forms synchronous documents with user-defined format;
The first transmitter, is connected with described monitor, the synchronous literary composition forming for sending described monitorPart is to receiving terminal; And
The first receiver, is connected with described synchronous meter, the feedback knot sending for receiving described receiving terminalReally, and the state that upgrades in described synchronous meter corresponding delta data according to described feedback result for locatingReason.
The further improvement of the synchronous transmitting apparatus of shipping business data of the present invention is, described monitor bagDraw together format module, file generating module, judge module and bundling module;
In described format module, store user-defined format, described user-defined format comprise the first standard andThe second standard, described the first standard defines the gauge outfit of synchronous meter waiting for transmission once, between field value withColon separates, and record in the ranks separates with plus sige; Described the second standard is by the gauge outfit of synchronous meter waiting for transmissionDefinition once, separates with colon between field value, and record in the ranks separates with plus sige, in described the second standardData arrange the part field that only definition need to be synchronous;
Described file generating module is connected with described format module, for the described form mould according to selectedIn piece the user-defined format of storage by the table name of delta data and field value writing in files content with shapeBecome synchronous documents, and mark order for formed synchronous documents;
Described judge module is connected with described file generating module, for judging the large of described synchrodataThe little setting threshold that whether exceeds, in the time that definite described synchrodata exceeds setting threshold, forms bundling and refers toOrder is to described bundling module, in the time that definite described synchrodata does not exceed setting threshold, by described synchronousFile is sent to described the first transmitter; And
Described bundling module is connected with described judge module, described in inciting somebody to action in the time receiving bundling instructionSynchronous documents carries out bundling compression with the compressed value of setting, and carries out for bundling compresses the divided data formingEncrypt.
The present invention also provides a kind of shipping business data synchronous receiving equipment, comprising:
The second receiver, the synchronous documents sending for receiving end/sending end;
Resolver, is connected with described the second receiver, synchronous for what described the second receiver was receivedFile resolves to obtain delta data with user-defined format;
Upgrade actuator, be connected with described resolver, for the variation number that described resolver resolves is gone outAccording to synchronous to realize data in write into Databasce, complete the synchronous rear feedback result that forms of data; And
The second transmitter, is connected with described renewal actuator, for what described renewal actuator was formedFeedback result is sent to described transmitting terminal, upgrades synchronous meter for described transmitting terminal.
The further improvement of the synchronous receiving equipment of shipping business data of the present invention is, described self-defined latticeFormula comprises the first standard and the second standard, and described the first standard is that the gauge outfit in described delta data is fixedJustice once, separates with colon between field value, and record in the ranks separates with plus sige; Described the second standard is willGauge outfit in described delta data defines once, between field value, separates with colon, and record is in the ranks with plus sigeSeparate, in described the second standard, data arrange the part field that only definition need to be synchronous.
The present invention also provides a kind of shipping business data synchronous synchro system, comprising:
The synchronous transmitting apparatus of aforesaid shipping business data, described transmitting apparatus is located at transmitting terminal and receptionEnd; And
The synchronous receiving equipment of aforesaid shipping business data, described receiving equipment is located at transmitting terminal and receptionEnd, the described receiving equipment that is positioned at receiving terminal communicates to connect with the described transmitting apparatus that is positioned at transmitting terminal,Be positioned at the described receiving equipment and the described transmitting apparatus communication connection that is positioned at receiving terminal of transmitting terminal.
Brief description of the drawings
Fig. 1 is the system diagram of the synchronous transmitting apparatus of shipping business data of the present invention.
Fig. 2 is the system diagram of the synchronous receiving equipment of shipping business data of the present invention.
Fig. 3 is the system diagram of the synchronous synchro system of shipping business data of the present invention.
Fig. 4 is the flow chart of the synchronous sending method of shipping business data of the present invention.
Fig. 5 is the flow chart of the synchronous method of reseptance of shipping business data of the present invention.
Fig. 6 is that synchro system of the present invention is applied between bank base data storehouse and ship client database and synchronizesThe flow chart of preferred embodiment.
Detailed description of the invention
Below in conjunction with the drawings and specific embodiments, the invention will be further described.
The invention provides the synchronous transmitting apparatus of a kind of shipping business data and method, receiving equipment and sideMethod and synchro system, preferred application is synchronizeed with the data between ship client database in bank base data storehouse,Can solve the too high problem of bank base and the long-time communication fee of ship end, solving database synchronization can not be certainlyThe moving problem of processing frequent fault. Data synchronous system of the present invention and method adopt database to triggerDevice starts trigger in the time that database changes, and utilizes trigger that the data of variation are written to sameIn step table, recycling mail protocol technology, enters the synchrodata in synchronous meter by the mode of mailAfter row compression, transmit, to save delivery flow rate, reduce the communication fee of boats and ships. Solution of the present inventionThe unstable of bank base and ship end communication link of having determined, reduces user's bank base and ship end communication expense, subtractsFew manual intervention database synchronization process, the means of communication of more compatible various ships, as FBB, 3G,VSTA, Neptunian satellite is led to or F station. Below in conjunction with accompanying drawing to shipping business data of the present invention synchronous transmission establishStandby and method, receiving equipment and method and synchro system describe.
Consult Fig. 1, shown the system diagram of the synchronous transmitting apparatus of shipping business data of the present invention. BelowIn conjunction with Fig. 1, the synchronous transmitting apparatus of shipping business data of the present invention is described.
As shown in Figure 1, the synchronous transmitting apparatus 10 of shipping business data of the present invention comprise trigger 11,Monitor 12, the first transmitter 13 and the first receiver 14, trigger 11 and transmitting terminalDatabase 31 connects, for generation triggering in the time that database 31 occurs to upgrade and by database 31Delta data is deposited in synchronous meter 32; Monitor 12 is connected with synchronous meter 32, same for monitoringIn step table 32, state is untreated delta data, and by untreated delta data with self-defined latticeFormula is compressed and is formed synchronous documents; The first transmitter 13 is connected with monitor 12, for sending prisonListen synchronous documents that device 12 forms to receiving terminal, carry out database synchronization for receiving terminal; First connectsReceive device 14 and be connected with synchronous meter 32, the feedback result sending for receiving receiving terminal, and according to feedbackThe state that result is upgraded delta data corresponding in synchronous meter 32 is processed.
Monitor 12 comprises format module, file generating module, judge module and bundling module,In format module, store user-defined format, user-defined format comprises the first standard and the second standard twoKind, being configured selection for user, the first standard regulation file content form is: all waiting for transmissionThe gauge outfit of synchronous meter only defines once, can save like this flow, data arrange part field value withBetween field value, separate with colon, between record row and record row, separate with plus sige. The second standard regulationFile content form is: the gauge outfit of all synchronous meters waiting for transmission only defines once, can save like thisFlow, data arrange between field value partly and field value and separate with colon, and record row is gone with recordBetween separate with plus sige, in the second standard data arrange part only definition need synchronous field, do not needWant synchronous field not define, and in the first standard by whole all data fields in synchronous meterDefinition, so adopt the second standard more to save flow. File generating module is connected with format module,Be used for according to the user-defined format of storing in selected format module the table name of delta data and fieldValue compression forms synchronous documents, marks order, when transmission in the time forming synchronous documents and for synchronous documentsMay have multiple files, file generating module can be compressed into compressed package by the All Files once sendingSending, can save further flow. Judge module is connected with file generating module, usesWhether exceed setting threshold in the size that judges synchronous documents, namely judge whether mistake of synchronous documentsIn the time that judgement determines that the size of synchronous documents exceeds setting threshold, form bundling instruction to bundling mould greatly,Piece, in the time that judgement determines that the size of synchronous documents does not exceed setting threshold, is sent to the by synchronous documentsOne transmitter 13, is sent to receiving terminal by the first transmitter 13. Bundling module is connected with judge module,In the time receiving the bundling instruction of judge module transmission, will carry out with the compressed value of setting synchronous documentsBundling compression forms multiple divided data, and the divided data forming for bundling compression is encrypted. CompressedAnd the divided data of encrypting is sent to receiving terminal by the first transmitter 13, in process of transmitting without examiningThe order of considering divided data, receives after divided data at receiving terminal, can decompress to divided data, and rootMark order according to the synchronous documents obtaining after decompressing is resolved according to the order of sequence successively. Setting threshold wherein andCompressed value can independently be set according to user's needs, and the setting of this setting threshold and compressed value needsConsider the communication fee of ship end, make the data volume of synchronous documents as far as possible little, and then reduce communication expenseWith.
As shown in Figure 2, the synchronous receiving equipment 20 of shipping business data of the present invention comprises the second receptionDevice 21, resolver 22, renewal actuator 23 and the second transmitter 24, the second receivers 21The synchrodata sending for receiving end/sending end, resolver 22 is connected with the second receiver 21, forThe synchronous documents that the second receiver 21 is received resolves to obtain changing number with user-defined formatAccording to; Upgrade actuator 23 and be connected with the database 41 of resolver 22 and receiving terminal, for resolvingIn the delta data write into Databasce 41 that device 22 parses, to realize database and the transmission of receiving terminalThe database of end synchronous, forms feedback result after synchronous completing data; The second transmitter 24 withUpgrade actuator 23 and connect, for the feedback result of upgrading actuator formation is sent to transmitting terminal,Upgrade synchronous meter for transmitting terminal. User-defined format wherein comprises the first standard and the second standard, theOne standard specifies that file content form is: the gauge outfit of all synchronous meters waiting for transmission only defines once, thisSample can be saved flow, and data arrange between field value partly and field value and separate with colon, recordBetween row and record row, separate with plus sige. The second standard regulation file content form is: all to be transmittedThe gauge outfit of synchronous meter only define once, can save like this flow, data arrange the field value of partAnd between field value, separate with colon, between record row and record row, separate with plus sige, in the second standardData arrange the part field that only definition need to be synchronous, do not need synchronous field not define, andIn the first standard all data fields in synchronous meter are all defined, so adopt the second standard moreSave flow. The file format specifying according to the first standard and the second standard is entered the synchrodata of receptionRow is resolved with formation and modification data.
As shown in Figure 3, the synchronous synchro system of shipping business data of the present invention comprises transmitting terminal and receptionEnd, is provided with transmitting apparatus 10 and receiving equipment 20 at transmitting terminal, is provided with transmitting apparatus at receiving terminal10 ' and receiving equipment 20 ', transmitting apparatus 10 and receiving equipment 20 ' is connected, receiving equipment 20 andSend equipment 10 ' connection. The structure of transmitting terminal and receiving terminal is identical, this synchro system for transmitting terminal andIt is synchronous that the database of receiving terminal keeps, and in the time that the database of transmitting terminal changes, passes through transmitting apparatusDelta data is sent to receiving equipment 20 ' synchronously to upgrade the database of receiving terminal, at receiving terminal by 10Database while changing, by transmitting apparatus 10 ' delta data is sent to receiving equipment 20Synchronously to upgrade the database of transmitting terminal. Preferably, transmitting terminal and receiving terminal can correspond to bank base andShip end, realizes bank base data storehouse and synchronizes with the data of ship client database.
Preferably, in the time that transmitting apparatus 10 and receiving equipment 20 are located at transmitting terminal, transmitting apparatus 10Can share transmitter and receiver with receiving equipment 20, save as transmitting apparatus 10 and receiving equipment20 have arranged respectively transmitter and receiver. Below synchro system of the present invention is described.
As shown in figures 1 and 3, at the trigger 11 of transmitting terminal and the database 31 of transmitting terminal and sameStep table 32 connects, and trigger 11 occurs to be triggered also while renewal for the database 31 at transmitting terminalDelta data is deposited in the synchronous meter 32 of transmitting terminal. In the time that database changes, namelyWhen tabular value in database is upgraded, trigger trigger 11, make trigger 11 by delta dataTable name and Major key be inserted in synchronous meter 32, the data in this synchronous meter 32 are used for sending to and connectIt is synchronous that receiving end is carried out data. Preferably, needing synchronous delta data is not in database 31All data, need synchronous delta data only to carry out for the data of service needed, like this canReduce and need synchronous data volume, correspondingly also reduced data volume.
Be connected at the monitor 12 of transmitting terminal and the synchronous meter 32 of transmitting terminal, for monitoring synchronous meterUntreated delta data in 32 also compresses untreated delta data with user-defined formatForm synchronous documents. This monitor 12 comprise format module, file generating module, judge module,And bundling module, in format module, storing user-defined format, user-defined format comprises the first standardWith two kinds of the second standards, be configured selection for user, the first standard regulation file content form is:The gauge outfit of all synchronous meters waiting for transmission only defines once, can save like this flow, data setting unitBetween the field value dividing and field value, separate with colon, between record row and record row, separate with plus sige.The second standard specifies that file content form is: the gauge outfit of all synchronous meters waiting for transmission only defines once,Can save like this flow, data arrange between field value partly and field value and separate with colon, noteBetween record row and record row, separate with plus sige, in the second standard, data arrange partly only definition needs synchronousField, do not need synchronous field not define, and in the first standard will be in synchronous meter allData field all defines, so adopt the second standard more to save flow. File generating module dativeFormula module connects, for the user-defined format according to storing in selected format module by delta dataTable name and field value compression form synchronous documents and mark order for synchronous documents, when transmission, may haveMultiple files, file generating module can be compressed into compressed package by the All Files once sending and send outSend, can save further flow. Judge module is connected with file generating module, same for judgingWhether the size of step file exceeds setting threshold, namely judges that whether synchronous documents is excessive, in judgementWhen the size of determining synchronous documents exceeds setting threshold, form bundling instruction to bundling module, in judgementWhen the size of determining synchronous documents does not exceed setting threshold, synchronous documents is sent to transmitter (thisSend device and receiving equipment to share), be sent to receiving terminal by transmitter. Bundling module and judge module connectConnect, in the time receiving the bundling instruction of judge module transmission, by the compressed value to set to synchronous documentsCarry out bundling compression and form multiple divided data, and the divided data forming for bundling compression is encrypted. WarpThe divided data of encrypting is sent to receiving terminal by transmitter, in process of transmitting without considering divided data suitableOrder, receives after divided data at receiving terminal, can decompress to divided data, after decompressing, obtainsThe mark order of the synchronous documents obtaining is resolved according to the order of sequence successively. Setting threshold wherein and compressed value can rootsNeeds according to user are independently set, and the setting of this setting threshold and compressed value need to be considered ship endCommunication fee, makes the data volume of synchrodata as far as possible little, and then reduces communication cost.
The transmitter of transmitting terminal is connected with the monitor of transmitting terminal 12, for what monitor 12 was formedSynchronous documents transfers to receiving terminal and upgrades according to synchrodata with the database root that makes receiving terminal. ReceiveAfter the database update of end completes, the transmitter of receiving terminal will send feedback result to transmitting terminal. SendThe transmitter of end is for sending synchronous documents to receiving terminal, and this synchronous documents can be that monitor 12 is pressedThe synchronous documents that contracting forms can be also the divided data that monitor 12 bundling compressions form. TransmitterSend mode be multifarious, can utilize mail form to carry out transfer of data, can utilizeHTTP mode is transmitted, and can also allow user oneself select transmission means, with third party transfer sideFormula, such as carrying out transfer of data by third party's systems such as GlobeRydex. In transmitter, includeThe first sending module, the second sending module, the 3rd sending module and the 4th sending module, sendDevice is by the first sending module, the second sending module, the 3rd sending module or the 4th sending moduleTransmitting synchronous data are to receiving terminal, and user can set transmitter and send with any module, itsIn the first sending module be the first transmission means, this kind of transmission means is to generate synchronous documents but notTransmitting synchronous file, does not namely adopt mail to form transmitting synchronous file, and the first sending module is used forAt transmitting terminal, untreated delta data in synchronous meter is write to transmitting terminal by table name and field valueIn local file, and the selected transmission means of foundation transfers to synchronous documents the database of receiving terminal.This selected transmission means is the selected transmission means of user oneself, for user provides own configurationFunction. The second sending module is the second transmission means, generates synchronous documents and uses mail transmission,The second sending module at transmitting terminal by the untreated delta data of synchronous meter by table name andField value is written in the local file of transmitting terminal, and by mail, synchronous documents is transferred to receiving terminalDatabase. The 3rd sending module is the third transmission means, generates synchronous documents and usesHTTP mode is transmitted, and the 3rd sending module is used at transmitting terminal the untreated variation of synchronous meterData are written in the local file of transmitting terminal by table name and field value, and incite somebody to action by HTTP modeSynchronous data transmission is to the database of receiving terminal. The 4th sending module is the 4th kind of transmission means, straightConnect and use mail transmission but do not generate synchronous documents, synchronous documents can be generated by other management softwares, sends outSending end only plays mail transmission effect, and not responsible generation synchronous documents. The 4th sending module is for straightConnected mail by synchronous data transmission to receiving terminal. In transmitter, be also provided with and supply user to selectThe 5th sending module, the 5th sending module, for only receiving file data, is closed sending function.
The receiver of transmitting terminal and the synchronous meter of transmitting terminal 32, receiver is used for receiving receiving terminal and sendsFeedback result, and upgrade synchronous meter 32 according to feedback result, by corresponding feedback knot in synchronous meter 32The delta data of fruit is labeled as processed. The receiving equipment 20 of transmitting terminal also receives by receiverThe synchrodata that receiving end sends, resolves synchrodata and then be sent to by resolver to upgrade and holdRow device writes the database 31 of transmitting terminal, realizes synchronously and upgrading.
Also be provided with backup device at transmitting terminal, backup device is connected with the database 31 of transmitting terminal, forDB Backup is carried out at the BACKUP TIME interval of setting. Database is carried out to automated back-up, be convenient to disasterRecover.
The transmitting apparatus 10 of receiving terminal ' and receiving equipment 20 ' with the transmitting apparatus 10 of transmitting terminal with connectThe structure of receiving unit 20 is identical, and operation principle is also identical, and the receiver of receiving terminal receives transmitting terminalAfter the synchronous documents sending, the resolver that synchronous documents is sent to receiving terminal is resolved and then is sentCarry out database update to renewal actuator, the database of receiving terminal and the database of transmitting terminal are protectedHold synchronous. After renewal completes, will form feedback result, the transmitter by receiving terminal is by feedback resultBe sent to transmitting terminal. In the renewal actuator of receiving terminal, be provided with fault-tolerant module, for the treatment of databaseUpgrade unsuccessfully, this fault-tolerant module can not find the master in receiving terminal synchronous documents in the database of receiving terminalWhen key assignments, the Major key in synchronous documents is inserted in the database of receiving terminal, is about to upgrade operationBecome update. Fault-tolerant module can not find in corresponding synchronous documents and comprises in the database of receiving terminalExternal key associated data time, send the request that transmits relevant external key associated data to transmitting terminal. To be sentEnd will be correlated with after external key associated data sends over, then carry out the renewal of database. Fault-tolerant module is being metWhile arriving the problem of other database update failures, error message is write and is presented in Log daily record,Being convenient to keeper searches problem.
Data synchronous system of the present invention has automatic synchronizing function and manual synchronization function, for user establishesPut the selection key of automatic synchronizing function and manual synchronization function, freely selected for carrying out.When synchronizeing with ship end and bank base data storehouse, in the situation that ship end and bank base have network, Ke YikaiOpen automatic synchronizing function, the time interval transmitting and receive data by human configuration, sending and receivingMode of operation and Email address; When needing after synchronous data in transmitting terminal change database,The data that change can be saved as local file, and automatic synchronizing function can be looked into the monitor in systemLook for the synchronous documents that comprises delta data, and send to receiving terminal by transmitter, receiving terminal receivesAfter synchronous documents, upgrade local data base, the data that realize transmitting terminal and receiving terminal database are synchronous.In the situation that there is no network, can close automatic synchronizing function, when needing in transmitting terminal change databaseAfter data that will be synchronous, the data of variation can be saved as local file, in the time having network, and handThe moving lockage button of clicking, triggers transmitter the data of variation is sent to receiving terminal, realizes manual synchronization.
Below taking ship end change database synchronization to bank base as example, to data synchronous system of the present inventionThe course of work describes.
Ship end has been initiated alter operation, such as amendment work order, proposes spare part application etc., this alter operationShip client database is upgraded, and ship client database has triggered ship end trigger, ship in the time changingEnd trigger is inserted into the table name of delta data in database and field value in synchronous meter, new insertionThe state of delta data in synchronous meter is untreated. The monitor of ship end listens in synchronous meter to be had notProcess synchrodata time, by table name and field value, synchrodata is write in local file, thisThe path of ground file can be specified and change according to user, and monitor is writing after local file, willDelta data compression forms synchronous documents, and then sends to the form of mail by the transmitter of ship endIn the mailbox of bank base. What now the monitor of ship end adopted is the second pattern, generates synchronous documentsAnd use mail transmission. User can be the mailbox ground that ship end and bank base configure respectively sending and receivingLocation. The receiver monitor network mailbox of bank base, has found the mail of synchrodata will read mailAnd download the compressed package that comprises synchronous documents, receiver is issued resolver after compressed package is downloaded, by separatingCompressed package is carried out decompress(ion) by parser, and decompress(ion) obtains synchronous documents, may obtain one or more synchronousFile, resolves the content of synchronous documents successively by files-designated order, and by the content parsing namely withStep data sends to renewal actuator, by upgrading actuator, synchrodata is updated to database, makesObtain the database of bank base and the database synchronization of ship end. After renewal completes, will upgrade result and form feedback knotReally, write with specific format under the file of appointment, by the transmitter by bank base by feedback result with postalThe transmission means that part form or user specify is sent to ship end, and ship termination will connect after receiving feedback resultThe file of receiving is write in the file of appointment, and the synchronous meter of ship end is upgraded, and bank base is upgradedThe state of the delta data in the synchronous meter completing is updated to processed, has so just completed one synchronouslyFlow process.
Sending method, method of reseptance and the synchronous method synchronous to shipping business data of the present invention belowDescribe.
As shown in Figure 4, the synchronous sending method of shipping business data of the present invention comprises: execution step S11,When database occurs to upgrade, the data of variation are deposited in synchronous meter, then perform step S12.Execution step S12, monitors synchronous meter, is that untreated delta data is to make by oneself by state in synchronous meterJustice form compresses and forms synchronous documents, then performs step S13. Execution step S13, will be withStep file sends with the transmission means of selecting, and carries out synchronously, then execution step for receiving terminalS14. Execution step S14, receives the feedback result that receiving terminal sends, and upgrades same according to feedback resultStep table, is updated to processed by the state of delta data corresponding in synchronous meter.
Wherein compressing formation synchronization packets with user-defined format draws together: set user-defined format, and shouldUser-defined format comprises the first standard and the second standard, and the first standard is by the gauge outfit of synchronous meter waiting for transmissionDefinition once, can save like this flow, between field value, separate with colon, record in the ranks with plus sige everyOpen; The second standard defines the gauge outfit of synchronous meter waiting for transmission once, between field value, separates with colon,Record in the ranks separates with plus sige, and in described the second standard, data arrange the part word that only definition need to be synchronousSection, do not need synchronous field not define, and the first standard is by all data words in synchronous meterSection is definition all, and therefore the second standard is saved flow more; To change according to selected user-defined formatThe table name of data and field value compression form synchronous documents and synchronous documents are marked to order; Judgement formsThe size of synchronous documents whether exceed setting threshold, exceed setting threshold in the size of determining synchronous documentsWhen value, synchronous documents is carried out to bundling compression with the compressed value of setting, and be dividing that bundling compression formsData are encrypted.
In the time sending, may there be multiple synchronous documents, multiple synchronous documents boil down to compressed packages are being carried outMail sends, and so can save further flow. Data by synchronous data transmission to receiving terminalStorehouse can adopt various ways, can untreated delta data in synchronous meter be passed through to table at transmitting terminalName and Major key write in local file, according to selected transmission means, synchronous documents are transferred to receiving terminalDatabase, transmit in third party transfer mode; Can also transmitting terminal by synchronous meter notProcess delta data write in local file by table name and Major key, by mail by synchronous documentsTransfer to the database of receiving terminal; Can also be at transmitting terminal, untreated delta data in synchronous meter is logicalCross table name and Major key and write in local file, by HTTP mode, synchronous documents is transferred to receptionThe database of end; Or can directly synchronous documents be transferred to by mail to the database of receiving terminal.Method of data synchronization of the present invention provides multiple transmission means, allows user freely select, and can utilizeMethod of data synchronization carries out transfer of data by mailing system, also can allow user oneself select transmission sideFormula, such as carrying out transfer of data by third party's systems such as GlobeRydex.
As shown in Figure 5, the synchronous method of reseptance of shipping business data of the present invention comprises: execution step S21,The synchronous documents that receiving end/sending end sends, and the synchronous documents receiving is separated with user-defined formatPress, to obtain delta data, then perform step S22. Execution step S22, writes delta dataEnter in database synchronously to realize data, complete data and send feedback result to transmitting terminal after synchronous, withUpgrade synchronous meter for transmitting terminal. By in delta data write into Databasce time, if database update becomesMerit, forms feedback result and is sent to transmitting terminal to notify transmitting terminal database synchronization to complete, if numberUpgrade unsuccessfully according to storehouse, if can not find the Major key of receiving terminal synchrodata in database time, willMajor key in synchronous documents is inserted in the database of receiving terminal; If it is right to can not find in databaseWhile answering the external key associated data that synchronous documents comprises, the database of receiving terminal is sent out to the database of transmitting terminalSend the request that transmits relevant external key associated data, carry out again receiving after relevant external key associated dataThe renewal of synchrodata; If other mistakes show error message in Log daily record, be convenient toKeeper searches problem.
Below the synchronous method of shipping business data of the present invention is described.
The synchronous method of shipping business data of the present invention comprises above-mentioned sending method and method of reseptance, canBe applied to synchronous between the database of bank base and ship end, below the process of this synchronous method saidBright.
In the time that the database of transmitting terminal occurs to upgrade, delta data is deposited into the synchronous meter of transmitting terminalIn. Database to transmitting terminal is monitored in real time, in the time that database changes, just will change numberAccording to being deposited in the synchronous meter of transmitting terminal, synchronous to treat the follow-up data of carrying out. Preferably, can pass throughRealize aforesaid operations for database arranges trigger, trigger is connected with database, at databaseWhile changing, trigger trigger, to make trigger that the table name of delta data and Major key are inserted into sameIn step table.
Untreated delta data in the synchronous meter of transmitting terminal is compressed to formation with user-defined formatSynchronous documents. Synchronous meter to transmitting terminal is monitored, and in discovery synchronous meter, has untreated variationWhen data, this untreated delta data is compressed and forms synchronous documents, compression is in order to reduceThe data volume of synchronous documents, to reduce the communication fee of bank base and ship end. Wherein by described synchronous meterIn untreated delta data with user-defined format compress form synchronous documents, comprising: sendEnd is set unified user-defined format with receiving terminal, and this user-defined format comprises the first standard and the second systemFormula, the first standard defines the gauge outfit of synchronous meter waiting for transmission once, can save like this flow, wordBetween segment value, separate with colon, record in the ranks separates with plus sige; The second standard is by synchronous meter waiting for transmissionGauge outfit defines once, between field value, separates with colon, and record in the ranks separates with plus sige, described the second systemIn formula, data arrange the part field that only definition need to be synchronous, do not need synchronous field not determineJustice, and the first standard is that all data fields in synchronous meter are all defined, therefore the second standard is moreSave flow; According to selected user-defined format, the table name of delta data and Major key compression are formed sameStep file is also marked order for formed synchronous documents; Whether judge the size of the synchronous documents formingExceed setting threshold, in the time determining that the size of synchronous documents exceeds setting threshold, by synchronous documents to establishFixed compressed value carries out bundling compression, and the divided data forming for bundling compression is encrypted.
Synchronous data transmission to the database of receiving terminal is upgraded with the database that makes receiving terminal; ?When transmission, may there be multiple synchronous documents, multiple synchronous documents boil down to compressed packages are sent out carrying out mailSend, so can save further flow. The database that synchronous documents is transferred to receiving terminal is passableAdopt various ways, can transmitting terminal by untreated delta data in synchronous meter by table name and masterKey assignments writes in local file, according to selected transmission means, synchronous documents is transferred to the data of receiving terminalStorehouse, i.e. third party transfer mode; Can also be at transmitting terminal, untreated delta data in synchronous meter is logicalCross table name and Major key and write in local file, by mail, synchronous documents is transferred to the number of receiving terminalAccording to storehouse; Can also untreated delta data in synchronous meter be write by table name and Major key at transmitting terminalEnter in local file, by HTTP mode, synchronous documents is transferred to the database of receiving terminal; OrCan directly synchronous documents be transferred to by mail to the database of receiving terminal. Data of the present invention are synchronousMethod provides multiple transmission means, allows user freely select, and can utilize method of data synchronization to pass throughMailing system is carried out transfer of data, also can allow user oneself select transmission means, such as useThird party's systems such as GlobeRydex are carried out transfer of data.
After the database update of receiving terminal completes, transmission feedback result is to the database of transmitting terminal; ReceivingWhen end carries out database update, if database update success forms feedback result and is sent to transmissionEnd completes with notice transmitting terminal database synchronization, if database update failure, if in databaseWhile can not find the Major key of receiving terminal synchronous documents, the Major key in synchronous documents is inserted into receptionIn the database of end; If can not find the external key associated data that corresponding synchronous documents comprises in databaseTime, the database of receiving terminal sends and transmits asking of relevant external key associated data to the database of transmitting terminalAsk, receiving the renewal of carrying out again synchrodata after relevant external key associated data; If other mistakesMistake shows error message in Log daily record, is convenient to keeper and searches problem.
The database root of transmitting terminal upgrades synchronous meter according to feedback result, by the shape of delta data in synchronous meterState is labeled as processed. The state of the synchronous meter data that the synchronous meter of transmitting terminal has upgraded receiving terminalBe updated to and complete, so just complete a subsynchronous flow process.
Synchronous method of the present invention also comprise to the data of transmitting terminal and receiving terminal with set backup timeBetween interval carry out the backup of database, be convenient to disaster recovery.
Method of data synchronization of the present invention, in the situation that having network to connect, can be opened automatic synchronization meritCan, in the situation that not having network to connect, can close automatic synchronizing function, unlatching manual synchronizationFunction. In the situation that automatic synchronizing function is opened, transmit and receive data by human configuration timeBetween interval, the mode of operation of sending and receiving and Email address; When needing in ship end change databaseAfter data that will be synchronous, the data of variation can be saved as local file, and synchronous method can be according to settingAutomatically start, search the data file of variation, and send to bank base, bank base receives after variation, moreNew local data base, the data that realize ship end and bank base data storehouse are synchronous. Open in manual synchronization functionSituation under, when needing after synchronous data in ship end change database, the data of variation can be savedFor local file, in the time having network, click lockage button, the data that change are sent to bank base,Realize artificial synchronous.
Method of data synchronization of the present invention is also set with the waiting receipt time, is exceeding the waiting receipt timeAlso do not receive feedback result, resend synchrodata to receiving terminal, this waiting receipt time canSet according to user's needs, default setting is 3 days.
As shown in Figure 6, upgrade synchronous bank base data as example, to of the present invention taking ship client database belowMethod of data synchronization describes.
Execution step S301, ship client database is upgraded, and initiates database alter operation at ship end, thanAs revise work order, and spare part application is proposed, all can make the database of ship end change. Then carry out stepRapid S302.
Execution step S302, is inserted into synchronous meter by delta data, the table name of delta data and masterKey assignments is inserted in synchronous meter. Then perform step S303.
Execution step S303, writes untreated delta data in synchronous meter in local file, logicalCross table name and Major key is write synchrodata in local file. Then perform step S304.
Execution step S304, forms synchronous documents by delta data compression, carries out with user-defined formatCompression. Then perform step S305.
Execution step S305, is sent to bank base, synchronous documents by synchronous documents by the form of mailSend to by mail in the mailbox of bank base. Then perform step S306.
Execution step S306, bank base reads mail and downloads synchronous documents. Then perform step S307.
Execution step S307, bank base writes the delta data in synchronous documents in local file. ConnectExecution step S308.
Execution step S308, the delta data that writes local file is resolved also more new database by bank base,Then perform step S309.
Execution step S309, bank base sends feedback result to ship end, and this feedback result is with specific formatWrite under specified folder, feedback result is sent to ship end by the mailing system of bank base. Then carry out stepRapid S310.
Execution step S310, feedback result is write specified folder by ship end. Then execution step S311。
Execution step S311, ship end upgrades synchronous meter data mode, and what bank end had been upgraded is synchronousThe state of table data has upgraded, and whole synchronous flow process finishes.
The beneficial effect of data synchronous system of the present invention and method is:
The SMTP and the POP3 protocol transmission data file that adopt FBB or 3G to be interrupted, simultaneouslySupport Socket and Http breakpoint transmission data file.
Adopt the feature of database trigger to catch the data of variation, and use unformatted file to depositStore up, use self-defining data interaction form to carry out transfer of data. With this ensure data volume minimum andThe data of transmission arrive named place of destination.
Adopt self-defining fault-tolerant processing for the feature of relevant database, lose for main external key relationMistake, data file are lost, database is inconsistent and the function of long-range performing database, reach unmanned dutyThe intelligent fault-tolerance processing of keeping.
Below embodiment has been described in detail the present invention by reference to the accompanying drawings, ordinary skill people in this areaMember can make many variations example to the present invention according to the above description. Thereby, some details in embodimentShould not form limitation of the invention, the present invention by the scope defining using appended claims as thisThe protection domain of invention.
Claims (10)
1. the synchronous sending method of shipping business data, is characterized in that, described sending method bagDraw together:
In the time that database occurs to upgrade, the data that change in described database are deposited in synchronous meter;
Monitoring described synchronous meter, is that untreated delta data is with self-defined by state in described synchronous meterForm compresses and forms synchronous documents;
Described synchronous documents is sent with the transmission means of selecting, carry out data together for receiving terminalStep; And
Receive the feedback result that described receiving terminal sends, according to described feedback result and by described synchronous meterThe state of the delta data of middle correspondence is updated to processed.
2. the synchronous sending method of shipping business data as claimed in claim 1, is characterized in that,Be that untreated delta data compresses and forms together with user-defined format by state in described synchronous meterStep file, comprising:
Set user-defined format, described user-defined format comprises the first standard and the second standard, described theOne standard is that the gauge outfit in described delta data is defined once, separates record between field value with colonIn the ranks separate with plus sige; Described the second standard is that the gauge outfit in described delta data is defined once, wordBetween segment value, separate with colon, record in the ranks separates with plus sige, and in described the second standard, data arrange partOnly definition needs synchronous field;
According to selected user-defined format, the table name of delta data and field value compression are formed to synchronous literary compositionPart is also marked order for formed synchronous documents; And
Whether the size that judges the synchronous documents forming exceeds setting threshold, at definite described synchronous documentsSize while exceeding setting threshold, described synchronous documents is carried out to bundling compression with the compressed value of setting,And the divided data forming for bundling compression is encrypted.
3. the synchronous sending method of shipping business data as claimed in claim 1, is characterized in that,Described synchronous documents is sent with the transmission means of selecting, comprising:
Be that untreated delta data writes local literary composition by table name and Major key by state in synchronous meterIn part, transmit described synchronous documents according to third party transfer mode;
Be that untreated delta data writes local literary composition by table name and Major key by state in synchronous meterIn part, transmit described synchronous documents by lettergram mode;
Be that untreated delta data writes local literary composition by table name and Major key by state in synchronous meterIn part, transmit described synchronous documents by HTTP mode; Or
Directly transmit described synchronous documents by lettergram mode.
4. the synchronous method of reseptance of shipping business data, is characterized in that, comprising:
The synchronous documents that receiving end/sending end sends, and received synchronous documents is entered with user-defined formatRow decompress(ion), to obtain delta data;
By synchronous to realize data in described delta data write into Databasce, complete synchronous rear transmission of dataFeedback result, upgrades synchronous meter for described transmitting terminal;
When by described delta data write into Databasce, if can not find described in correspondence in described databaseWhen the Major key of delta data, the Major key of described delta data is inserted in described database; IfCan not find the external key associated data comprising in corresponding described delta data in described database time, to instituteState transmitting terminal and send the request that transmits relevant external key associated data to wait to receive relevant external key incidence numberAccording to after to carry out data synchronous again.
5. the synchronous method of reseptance of shipping business data as claimed in claim 4, is characterized in that,Described user-defined format comprises the first standard and the second standard, and described the first standard is by described variation numberAccording in gauge outfit define once, between field value, separate with colon, record in the ranks separate with plus sige; DescribedThe second standard is that the gauge outfit in described delta data is defined once, separates note between field value with colonRecord in the ranks separates with plus sige, and in described the second standard, data arrange the part word that only definition need to be synchronousSection.
6. the synchronous transmitting apparatus of shipping business data, is characterized in that, comprising:
Trigger, is connected with database, in the time that described database occurs to upgrade, produce trigger and incite somebody to actionIn described database, delta data is deposited in synchronous meter;
Monitor, is connected with described synchronous meter, is untreated for monitoring described synchronous meter stateDelta data, and untreated delta data is compressed and forms synchronous documents with user-defined format;
The first transmitter, is connected with described monitor, the synchronous literary composition forming for sending described monitorPart is to receiving terminal; And
The first receiver, is connected with described synchronous meter, the feedback knot sending for receiving described receiving terminalReally, and the state that upgrades in described synchronous meter corresponding delta data according to described feedback result for locatingReason.
7. the synchronous transmitting apparatus of shipping business data as claimed in claim 6, is characterized in that,Described monitor comprises format module, file generating module, judge module and bundling module;
In described format module, store user-defined format, described user-defined format comprise the first standard andThe second standard, described the first standard defines the gauge outfit of synchronous meter waiting for transmission once, between field value withColon separates, and record in the ranks separates with plus sige; Described the second standard is by the gauge outfit of synchronous meter waiting for transmissionDefinition once, separates with colon between field value, and record in the ranks separates with plus sige, in described the second standardData arrange the part field that only definition need to be synchronous;
Described file generating module is connected with described format module, for the described form mould according to selectedIn piece the user-defined format of storage by the table name of delta data and field value writing in files content with shapeBecome synchronous documents, and mark order for formed synchronous documents;
Described judge module is connected with described file generating module, for judging the large of described synchrodataThe little setting threshold that whether exceeds, in the time that definite described synchrodata exceeds setting threshold, forms bundling and refers toOrder is to described bundling module, in the time that definite described synchrodata does not exceed setting threshold, by described synchronousFile is sent to described the first transmitter; And
Described bundling module is connected with described judge module, described in inciting somebody to action in the time receiving bundling instructionSynchronous documents carries out bundling compression with the compressed value of setting, and carries out for bundling compresses the divided data formingEncrypt.
8. the synchronous receiving equipment of shipping business data, is characterized in that, comprising:
The second receiver, the synchronous documents sending for receiving end/sending end;
Resolver, is connected with described the second receiver, synchronous for what described the second receiver was receivedFile resolves to obtain delta data with user-defined format;
Upgrade actuator, be connected with described resolver, for the variation number that described resolver resolves is gone outAccording to synchronous to realize data in write into Databasce, complete the synchronous rear feedback result that forms of data; And
The second transmitter, is connected with described renewal actuator, for what described renewal actuator was formedFeedback result is sent to described transmitting terminal, upgrades synchronous meter for described transmitting terminal.
9. the synchronous receiving equipment of shipping business data as claimed in claim 8, is characterized in that,Described user-defined format comprises the first standard and the second standard, and described the first standard is by described variation numberAccording in gauge outfit define once, between field value, separate with colon, record in the ranks separate with plus sige; DescribedThe second standard is that the gauge outfit in described delta data is defined once, separates note between field value with colonRecord in the ranks separates with plus sige, and in described the second standard, data arrange the part word that only definition need to be synchronousSection.
10. the synchronous synchro system of shipping business data, is characterized in that, comprising:
As claim 6 or the synchronous transmitting apparatus of shipping business data claimed in claim 7, described inTransmitting apparatus is located at transmitting terminal and receiving terminal; And
The synchronous receiving equipment of shipping business data as claimed in claim 8 or claim 9, described inReceiving equipment is located at transmitting terminal and receiving terminal, is positioned at the described receiving equipment of receiving terminal and is positioned at transmitting terminalThe communication connection of described transmitting apparatus, be positioned at the described receiving equipment and the institute that is positioned at receiving terminal of transmitting terminalState transmitting apparatus communication connection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610024669.3A CN105677885A (en) | 2016-01-14 | 2016-01-14 | Receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610024669.3A CN105677885A (en) | 2016-01-14 | 2016-01-14 | Receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105677885A true CN105677885A (en) | 2016-06-15 |
Family
ID=56300846
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610024669.3A Pending CN105677885A (en) | 2016-01-14 | 2016-01-14 | Receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105677885A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107679195A (en) * | 2017-10-09 | 2018-02-09 | 杭州安恒信息技术有限公司 | Half master-slave database synchronous method and system based on the transmission of HTTPS agreements |
| CN110557370A (en) * | 2019-07-30 | 2019-12-10 | 视联动力信息技术股份有限公司 | method, system, electronic equipment and storage medium for pamir synchronization of terminal information |
| CN112163037A (en) * | 2020-09-17 | 2021-01-01 | 彩讯科技股份有限公司 | Data synchronization method and device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080140692A1 (en) * | 2006-12-11 | 2008-06-12 | Scott Gehring | System and method of data movement between a data source and a destination |
| CN101325478A (en) * | 2008-08-06 | 2008-12-17 | 北京北纬通信科技股份有限公司 | Method and system for data synchronization |
| CN102929946A (en) * | 2012-09-27 | 2013-02-13 | 山东中创软件工程股份有限公司 | Data synchronization method, device and system |
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
-
2016
- 2016-01-14 CN CN201610024669.3A patent/CN105677885A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080140692A1 (en) * | 2006-12-11 | 2008-06-12 | Scott Gehring | System and method of data movement between a data source and a destination |
| CN101325478A (en) * | 2008-08-06 | 2008-12-17 | 北京北纬通信科技股份有限公司 | Method and system for data synchronization |
| CN102929946A (en) * | 2012-09-27 | 2013-02-13 | 山东中创软件工程股份有限公司 | Data synchronization method, device and system |
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107679195A (en) * | 2017-10-09 | 2018-02-09 | 杭州安恒信息技术有限公司 | Half master-slave database synchronous method and system based on the transmission of HTTPS agreements |
| CN110557370A (en) * | 2019-07-30 | 2019-12-10 | 视联动力信息技术股份有限公司 | method, system, electronic equipment and storage medium for pamir synchronization of terminal information |
| CN110557370B (en) * | 2019-07-30 | 2022-06-17 | 视联动力信息技术股份有限公司 | Method, system, electronic equipment and storage medium for pamir synchronization of terminal information |
| CN112163037A (en) * | 2020-09-17 | 2021-01-01 | 彩讯科技股份有限公司 | Data synchronization method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2021121370A1 (en) | Message loss detection method and apparatus for message queue | |
| CN104539690B (en) | A kind of Server remote method of data synchronization detected based on feedback mechanism and MD5 codes | |
| CN104063353B (en) | The method of synchronizing information between master-slave equipment | |
| CN103595559A (en) | System and method for transmitting big data and service system thereof | |
| CN102456052A (en) | Method for data synchronization between embedded device and database | |
| CN101883142A (en) | Method for backing up information of terminal user | |
| CN105530220B (en) | The interface method of two kinds of different agreement system communications is realized based on OPC | |
| CN103440142A (en) | GPRS (General Packet Radio Service)-based remote upgrade and dynamic loading method | |
| CN105677885A (en) | Receiving and sending device and method and synchronizing system for achieving shipping industry data synchronization | |
| KR100728076B1 (en) | Method, device and system for synchronizing of data providing for the handling of an interrupted synchronization process | |
| CN105580334A (en) | Data transmission method, terminal and server | |
| US6724896B1 (en) | Event-driven servers for data extraction and merge for EDI transaction processing using the internet | |
| CN101778134A (en) | Data synchronization method and mobile communication terminal | |
| CN109597716A (en) | A kind of asynchronous remote copying method and system | |
| JP2000307624A (en) | Transmission information repeating system and its repeating device | |
| CN112764696A (en) | Cloud printing server, and intelligent printing method and system of remote printing equipment | |
| CN1798322B (en) | Data transmission system and method thereof | |
| CN112583937A (en) | Visual convenient cloud resource deployment system combining public cloud and private cloud | |
| CN116782165B (en) | System and method for transmitting cross-network short message | |
| CN107168748A (en) | A kind of method that multinomial upgrading task is realized by a upgrade file bag | |
| CN110266808A (en) | A kind of method and system uploaded based on vehicle mounted remote communicating module file | |
| CN106302605A (en) | Real-time messages repeater system based on OpenFire server and implementation method | |
| JPH10289172A (en) | Data transfer system | |
| CN100463393C (en) | Device and method for data safety share between isomerous system | |
| CN111711581A (en) | Communication method, carrier wave proxy module and station area convergence terminal |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160615 |
|
| WD01 | Invention patent application deemed withdrawn after publication |