CN108536743A - A kind of Combat Command System database in phase system - Google Patents
A kind of Combat Command System database in phase system Download PDFInfo
- Publication number
- CN108536743A CN108536743A CN201810194031.3A CN201810194031A CN108536743A CN 108536743 A CN108536743 A CN 108536743A CN 201810194031 A CN201810194031 A CN 201810194031A CN 108536743 A CN108536743 A CN 108536743A
- Authority
- CN
- China
- Prior art keywords
- data
- synchronization
- module
- destination
- message
- 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
Abstract
The invention discloses a kind of Combat Command System database in phase system, database synchronous system includes software modules and the databases such as data synchronization service module, data publication subscribing module, data communication module and data management by synchronization module.Data synchronization service module supports synchronization synchronous with asynchronous data to execute data simultaneously operating；Fresh information is encapsulated into message by the data publication subscribing module to capture the update status of database；Data communication module is to functions such as compression, encryption, coding, transmission, decryption and the assemblings of realizing message, to realize the transmission demand of low network quality；Data management by synchronization module is realizing the inquiry of the establishment of synchronization rules, the subscription of demand data and synchronization log.The present invention solves the deficiencies of synchronization granularity existing for existing simultaneous techniques is thick, network environment requirement is high.
Description
Technical field
The invention belongs to Information Technology Agreement field more particularly to a kind of Combat Command System database in phase systems.
Background technology
Data are the bases of multistage Combat Command System stable operation, with the continuous expansion of Combat Command System scale, lower system
It needs to obtain corresponding data in real time from superior system, the data synchronization problems between system also highlight therewith.The variation energy of data
Progress data synchronization is needed to be had to as Combat Command System data service by other system senses at different levels and according to corresponding in time
The key technical problem of solution.Since the nineties in last century, scholars carry out data synchronization technology between multilevel system
Numerous studies sum up several common methods of multi-stage data synchronization:(1) manual method.The method of this most original is to work
The professional standards requirement for making personnel is very high, and workload is also very big in the case where the more data of website are relative complex.(2)
The method of synchronization based on Email.Refer to the intermediate conveyor tool for using mail server to be synchronized as data, to keep data
Synchronization.But occurring that mail is lost and mail sends and receives the inconsistent situation of sequence, data can be made, which to synchronize, to be become more
For complexity.(3) it is based on the data method of synchronization of FTP (File Transfer Protocol).Ftp server monitors the variation of file under each catalogue
Synchronous result is simultaneously placed under distribution catalogue by timely merging data, is downloaded for each website.But the catalogue of this FTP is swept
Retouch, organization and management it is considerably complicated, and the case where disconnect there are transmission process and synchronizing process, while there is also FTP services
The capacity limitation problem of device.(4) mode based on log scan push.This method mainly passes through the update of scan database daily record
Come the SQL statement generated during capturing, to realize the push toward distal end.The drawbacks of this method is due to being solved in journal file
The SQL statement of precipitation is too simple, cannot support further semantic analysis, it is difficult to realize the requirement of distribution data on demand.This
Outside, relatively poor for the network communication condition of Combat Command System, how to ensure that data synchronize effective to greatest extent
Property be also to need the technical barrier that solves.Many solutions in the field at present, more or less that there is timeliness is low, same
It walks granularity greatly and communication network requires high limitation.
Therefore, synchronize that existing timeliness is low, synchronization granularity is big and communication network requirement for existing Combat Command System data
High technical problem, it is necessary to available data synchronous method is improved, and propose that a kind of novel multilevel system data are same
One step process reaches synchronous timeliness height, fine size, the advantageous effect for adapting to low bandwidth.
Invention content
In view of the drawbacks of the prior art, the invention aims to provide a kind of improved Combat Command System data synchronous system
And method, the method for distribution subscription is used to obtain user data demand and realizes that fine-grained data synchronize, and is supported to sons at different levels
The on-demand synchrodata of system；By forming the multimode that automatic real-time and with audit near real-time is combined based on event trigger mechanism
Formula data simultaneously operating mechanism, by carrying out fragment compression, the adaptive Netowrk tape for adjusting transmitting data file to data file
Width has ensured the efficiency of transmission and success rate of data sync message.The technical problem to be solved by the present invention is to Combat Command System numbers
According to synchronizing the deficiencies of existing timeliness is low, synchronization granularity is big and communication network requirement is high
The present invention adopts the following technical scheme that for achieving the above object：A kind of Combat Command System database in phase system
System, including application program module, data synchronization service module, data publication subscribing module, data communication module, data lock-in tube
Manage module and database；
The application program module shows source for executing database manipulation, including inquiry, deletion and update operation
The notification information of data variation；
The data synchronization service module is deployed in the source and destination of data synchronous system, is responsible for executing data synchronization
Operation includes export and the storage work of database file；
The data publication subscribing module is deployed in the source of data synchronous system, capture originating mobile subscriber to database more
Data update situation, is packaged by new operational circumstances, and the data subscription rule stored in reading database in conjunction with subscription rules
For corresponding data sync message, data communication module is submitted to；
The data communication module is deployed in the source and destination of data synchronous system, the responsible compression for realizing message,
Fragment, encryption, transmission, assembling and decryption function；The data transfer demands of low-bandwidth network are adapted to sliced transmission by compressing；
The data management by synchronization module is for realizing the establishment of synchronization rules, the subscription of demand data and synchronization log
Inquiry.
Subscription rules data of the database for the operation data and synchronization system of storage system.
The subscription of the demand data of the data management by synchronization module supports data according to the whole table and data of database
Two kinds of granularities of record are subscribed to, and wherein data record granularity needs to submit SQL query condition
The synchronization rules are the patterns synchronized for data for every subscription rules, including Class1 actively pushes away in real time
It send and pulls both of which near real-time of the type 2 with audit；
The real-time active push pattern refers to the data-pushing that is directly needed destination by source to destination, and by
Data management by synchronization module automatically updates the database of destination；
Near real-time pull mode with audit refers to by destination after receiving source data update notice message, by mesh
End subscriber simultaneously operating is triggered by data synchronization service module after, obtained from source and corresponding data and be deposited into database.
The data sync message includes four types, respectively：
Class1：Real-time synchronization message；
Type 2：Data update notice report；
Type 3：Request of data report；
Type 4：Data response report.
The source workflow of system includes the following steps：
Step A1：Data update person carries out database manipulation by application program module, and application program module will be grasped accordingly
It is sent to data publication subscribing module；
Step A2：Data publication subscribing module captures application program module data manipulation；
Step A3：Data publication subscribing module is analyzed data manipulation and is carried out with the subscription rules that are stored in database
Match, step A4 is turned to if having matching, otherwise, turns to step A7；
Step A4：The synchronous mode of data publication subscribing module analysis matching subscription rules, actively pushes away in real time if Class1
It send, then turns to step A5, otherwise turn to step A6；
Step A5, data publication subscribing module read the subscription condition of matching subscription rules, are spliced to form SQL statement, hand over
Database data export is carried out by source data synchronization service module, and export is encapsulated into SYSDATA messages, message
Type is 1, and data communication module is transferred to be sent；
Step A6：Data publication subscribing module encapsulate SYSDATA messages, type of message 2, transfer to data communication module into
Row is sent；
Step A7：Ends with system source workflow.
The destination workflow of system includes the following steps：
Step B1：Destination data communication module receives the message that source is sent, and is assembled, is decrypted, and transfers to data
Synchronous service module；
Step B2：Destination data synchronization service module issues data synchronization notice to user and judges type of message, right
It is 1 in type, then goes to step B2-1, if type is 2, goes to step B2-2；
Step B2-1：Destination data synchronization service module directly parses data file, and executes in-stockroom operation, and update is same
Step notice library, and synchronization log is written, go to step B3；
Step B2-2：For the message of type 2, update status is written into synchronization notice library and synchronization log, and to application
Program module sends notice and reports SYNATT, goes to step B4；
Step B3：Administrator passes through the data update situation of destination data synchronization service module polls source, choosing
The data set for needing to synchronize at this time is selected, data simultaneously operating is carried out；
Step B3-1：Destination data synchronization service module assembled synchronization request message SYNDATA messages, type of message are
3, and encapsulation needs synchronous subscription condition in message text data field, transfers to data communication module；
Step B3-2：Destination data communication module is encrypted SYNDATA, compresses, fragment, and is transferred to synchronisation source
End；
Step B3-3：Source data communication module receives the SYNDATA messages that destination is sent and is sent to if type 3
Data simultaneous module；
Step B3-4：Source data synchronization service module carries out data export according to the subscription condition of SYNDATA and produces
SYNDATA messages, type 4, transfer to data communication module to be sent to destination；
Step B3-5：Destination data communication module parses the SYNDATA messages received, extracts type and is
Data file in 4 message, and notification data synchronous service module；
Step B3-6：Destination data synchronization service module carries out data loading operation, and update synchronization notice library, write-in is together
Daily record is walked, and notice is synchronously completed to application program transmission data；
Step B4：Ends with system destination workflow.
Advantageous effect：Technical scheme of the present invention can overcome existing Combat Command System data synchronize existing timeliness it is low,
Synchronization granularity is big and communication network requires high technical problem, has real-time active push synchronization and the near real-time with audit pulls
The synchronizing function being combined is synchronized, supports the whole table of tables of data and two kinds of synchronization granularities of set of records ends, there is synchronous timeliness height, granularity
Carefully, the advantageous effects such as low bandwidth are adapted to.
Description of the drawings
The present invention is done with reference to the accompanying drawings and detailed description and is further illustrated, it is of the invention above-mentioned or
Otherwise advantage will become apparent.
Fig. 1 is the multistage Combat Command System architectural framework schematic diagram according to one embodiment of the invention；
Fig. 2 is to form structural schematic diagram according to the function of the data synchronous system of one embodiment of the invention；
Fig. 3 is the system composed structure schematic diagram according to the data synchronous system of one embodiment of the invention；
Fig. 4 is to synchronize flow diagram according to the source data of one embodiment of the invention；
Fig. 5 is to synchronize flow diagram according to the purpose end data of one embodiment of the invention.
Specific implementation mode
To make those skilled in the art more fully understand technical scheme of the present invention, below in conjunction with the accompanying drawings and specific embodiment party
Present invention is further described in detail for formula.Embodiments of the present invention are described in more detail below, the embodiment is shown
Example is shown in the accompanying drawings, and in which the same or similar labels are throughly indicated same or similar element, component, module or tools
There are the element, component, module of same or like function.It is exemplary below with reference to the embodiment of attached drawing description, only
For explaining the present invention, and it is not construed as limiting the claims.
Those skilled in the art of the present technique are appreciated that unless expressly stated, singulative " one " used herein, " one
It is a ", " described " and "the" may also comprise plural form.It is to be further understood that is used in the specification of the present invention arranges
Diction " comprising " refers to that there are the feature, integer, step, operation, element, component and/or modules, but it is not excluded that in the presence of or
Other one or more features of addition, integer, step, operation, element, component, module and/or their group.It is used herein
Wording "and/or" includes any cell of one or more associated list items and all combines.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein (including technology art
Language and scientific terminology) there is meaning identical with the general understanding of the those of ordinary skill in fields of the present invention.Should also
Understand, those terms such as defined in the general dictionary, which should be understood that, to be had and the meaning in the context of the prior art
The consistent meaning of justice, and unless defined as here, will not be with idealizing or the meaning of too formal be explained.
As shown in Figure 1, the architectural framework figure of the multistage Combat Command System for the embodiment of the present invention, main system is commanded as global
The complete or collected works of central store data, each subsystem possess the data in respective range as the command node in respective compass of competency
Subset；The data of each subsystem are the subsets of centring system data, when centring system corresponding data, which is sent, to be changed, subsystem
It needs to synchronize required data, and having differences property of data needed for each subsystem from centring system.Combat Command System includes basis
Data and characteristic two parts, basic data refer to that all subsystems data for being required for using (such as match by system operation
Set data etc.), after centring system modification, need real-time synchronization subsystem；Characteristic refers to that centring system and subsystem are gathered around
The data (such as the local radar layout data of each subsystem, weapon performance data etc.) for having modification authority, feel concerned about in the middle
After system modification, corresponding subsystem can be just synchronized to after needing subsystem to confirm.Combat Command System uses to ensure stable operation
Double centring systems mutually redundant High Availabitity structures；When main center, which is broken down, to work, spare centring system will connect
It works for main center, so backup center system needs and main centring system data are consistent.In order to meet above-mentioned number
According to synchronisation requirement, need that subsystems is supported to subscribe to required characteristic and basic data on demand, backup center system needs
The total data of main centring system is synchronized, and carries out real-time synchronization.
As shown in Fig. 2, the present invention provides a kind of novel database in phase system includes：Application program module, number
According to software modules such as synchronous service module, data publication subscribing module, data communication module and data management by synchronization modules and
Database.
Shown application program module refers to the business processing program of Combat Command System, is responsible for executing database manipulation and (including look into
The operations such as inquiry, deletion and update), and show the notification information of source data variation；
The data synchronization service module is respectively deployed in the source and destination of data synchronous system, is responsible for executing data
Simultaneously operating includes export and the storage work of database file；
The data publication subscribing module is deployed in the source of data synchronous system, capture originating mobile subscriber to database more
Data update situation, is packaged by new operational circumstances, and the data subscription rule stored in reading database in conjunction with subscription rules
For corresponding message, data communication module is submitted to；
The data communication module is deployed in the source and destination of data synchronous system, the responsible compression for realizing message,
The functions such as fragment, encryption, transmission, assembling and decryption reduce the network transmission volume of data by compressing, to adapt to low strap with fragment
The data transfer demands of broad network；
The data management by synchronization module is realizing the establishment of synchronization rules, the subscription of demand data and synchronization log
Inquiry；
The demand data of the management by synchronization module subscribes to the whole table and data record two of supporting data according to database
Kind granularity is subscribed to, and wherein data record granularity needs to submit SQL query condition；
The synchronization rules are the pattern synchronized for data for every subscription rules, including real-time active push
(Class1) and near real-time with audit pull (type 2) both of which；
The active push pattern refers to the data-pushing that is directly needed destination by source to destination, and by synchronizing
Module automatically updates the database of destination；Near real-time pull mode with audit refers to receiving source number by destination
After update notification message, after triggering simultaneously operating by synchronous service module by purpose end subscriber, respective counts are obtained from source
According to and be put in storage.
As shown in figure 3, inter-system data synchronization system includes source and destination two parts, wherein source and destination be all
By application terminal, the composition of database server and management terminal, application terminal is deployed with application program, mainly
Operation is written and read to database, database server disposes data synchronization service module, data communication module and distribution subscription
Module (only source end system deployment), management terminal dispose data management by synchronization module.Wherein installing DB is in database service
On device.
The user of data synchronous system includes data update person and data administrator, and user role divides as shown in table 1 below：
1 data synchro angle color table of table
The message of inter-system data synchronization includes mainly data sync message SYNDATA and data synchronization notice message
SYNATT.Data sync message is message between system, to the source messaging synchronous with purpose end data, message source
Data update file, message interface are as shown in table 2；It should be noted that the extreme length of text is 5120, when what is transmitted
When content is not achieved 5120, physical length will be only transmitted, to reduce Internet traffic, adapts to the low-bandwidth network of Combat Command System,
When TransType values are 2, text field storages need the address of transmission data file.
2 data sync message of table
Data update message interface is as shown in table 3, and the data for being mainly used for receiving Class1 and type 2 in destination are same
After walking message, prompted in application terminal in a manner of alarm.The interface of data synchronization notice message is as shown in table 3,
Title and modification abstract person are mainly used for prompting the user with the summary situation of this data update.The extreme length of text is 512,
When the content transmitted is not achieved 512, physical length will be only transmitted, to reduce Internet traffic, adapts to the low of Combat Command System
Broadband network
The notice message that 3 data of table synchronize
For the data synchronization process of data synchronous system, the workflow of source as shown in figure 4, synchronize work accordingly
It is as follows to make flow：
Step 1：Source data update person carries out database manipulation by application program module；
Step 2：Source data publication subscribing module captures application program module data manipulation；
Step 3：Source data publication subscribing module analyze data manipulation and with the subscription condition in subscription rules library carry out
Match, form matching set X, judges whether set X is empty, if being not sky, turns to step 4, otherwise, turns to step 7；
Step 4, source data publication subscribing module judges the synchronous mode of subscription rules in set X one by one, if synchronous
Pattern is Class1, and data publication subscribing module reads the subscription condition of matching subscription rules, is spliced to form SQL statement, transfers to count
Database data export is carried out according to synchronization module, and export is encapsulated into SYSDATA messages (type of message is：1) it, hands over
It is sent by communication module；If synchronous mode is type 2, data publication subscribing module reads the subscription of matching subscription rules
Condition is spliced to form SQL statement, transfers to data simultaneous module to carry out database data export, and export is encapsulated into
(type of message is SYSDATA messages：2), communication module is transferred to be sent；
Step 5：Destination data communication module receives the message that source is sent, and is assembled, is decrypted, and transfers to data same
Walk module；
Step 6：Destination data simultaneous module directly parses data file, and executes in-stockroom operation, updates synchronization notice
Library, and synchronization log is written；
Step 7：Terminate.
For the data synchronization process between centring system (source) and subsystem (destination), system will be its subscription base
Data (Class1) and characteristic (type 2), wherein basic data and characteristic will be as needed for a plurality of subscription rules.
The course of work of its destination is as shown in figure 5, synchronous working flow is as follows accordingly：
Step A：Destination data communication module receives the message that source is sent, and is assembled, is decrypted, and transfers to data same
Walk module；
Step B：Data simultaneous module issues data synchronization notice to user and judges type of message, is 1 for type, then
Step B-1 is gone to, if type is 2, goes to step B-2；
Step B-1：Data simultaneous module directly parses data file, and executes in-stockroom operation, update synchronization notice library, and
Synchronization log is written, goes to step D；
Step B-2：For the message of type 2, synchronization notice library and synchronization log is written into update status, and to using journey
Sequence module transmission data update notification report (SYNATT), goes to step C；
Step C：Administrator is selected as needed by destination data synchronization service module polls synchronization notice report
Data set is synchronized, data simultaneously operating is carried out；
Step C-1：Destination data simultaneous module assembles synchronization request message SYNDATA messages (type of message 3), and
Encapsulation needs synchronous subscription condition in message text data field, transfers to data communication module；
Step C-2：Destination data communication module is encrypted SYNDATA, compresses, fragment, and is transferred to synchronisation source
End；
Step C-3：Source data communication module receives the SYNDATA messages that destination is sent and is sent to if type 3
Data simultaneous module；
Step C-4：Source data simultaneous module carries out data export according to the subscription condition of SYNDATA and produces
SYNDATA messages (type 4), transfer to data communication module to be sent to destination；
Step C-5：Destination communication module parses the SYNDATA messages received, extracts the report that type is 4
Data file in text, and notify destination data simultaneous module；
Step C-6：Destination data simultaneous module carries out data loading operation, and synchronous day is written in update synchronization notice library
Will, and synchronously complete notice to application program transmission data.
Step D：Terminate.
System carries out synchronizing the data of type 2 operation for user by synchronous service module offer operation interface,
It supports to synchronize message inquiry according to regular group, sending time, the conditions such as message status.Wherein message status includes：It is not same
Walk, synchronize successfully, synchronization failure and synchronous four states such as expired.A plurality of data synchronisation requirement, one key of system supports user are held
The a plurality of synchronization of row.Data synchronous system provides synchronization log inquiry service by data management by synchronization module, supports user, synchronization
The conditions such as rule, operating time, action type and operating result inquire daily record, and provide daily record and delete function.Its
In, action type includes：SYN and DELETE, the former perform simultaneously operating, and the latter indicates to delete synchronization notice report
Text.
The specific implementation example of the present invention is given below:
Assuming that source (SNODE) database and destination (TNODE) database have tables of data A, tables of data B and tables of data
C, destination have subscribed tables of data A, wherein the use wheel synchronization type 2 of tables of data A, and tables of data B uses wheel synchronization type 2.Work as source
Application program to data Table A carry out data modification after, source data publication subscribing module will capture application program module logarithm
According to operation, while being matched to the data that TNODE has subscribed the table；Source data publication subscribing module encapsulation of data update notification report
(type of message is by literary SYSDATA：2), and data communication module is transferred to be sent.TNODE receives what SNODE was sent
SYSDATA messages, synchronization notice library and synchronization log is written in update status, and sends notice report to application program module
(SYNATT)；Administrator selects to execute the same of tables of data A by data synchronization service module polls synchronization notice report
Step；Destination data simultaneous module assembles synchronization request message SYNDATA messages (type of message 3), and transfers to destination
Data communication module is sent to SNODE.After the data communication module of SNODE receives the SYNDATA messages of TNODE transmissions, turn
The data simultaneous module of SNODE is issued, the data simultaneous module of NODE carries out data export according to subscription condition and produces
SYNDATA messages (type 4), transfer to SNODE data communication modules to be sent to TNODE；The data communication module of TONDE receives
Data file therein is extracted after to message, and notifies the data simultaneous module of TNODE, and in-stockroom operation is carried out by it, is completed whole
Change data synchronization.
Those skilled in the art of the present technique are appreciated that the present invention can be related to for executing in operation described herein
The equipment of one or more operations.The equipment can specially be designed and be manufactured for required purpose, or can also include
Known device in all-purpose computer, the all-purpose computer are activated or are reconstructed with having the procedure selection being stored in it.This
The computer program of sample can be stored in equipment (for example, computer) readable medium or be stored in be referred to suitable for storage electronics
It enables and is coupled to respectively in any kind of medium of bus, the computer-readable medium is including but not limited to any kind of
Disk (including floppy disk, hard disk, CD, CD-ROM and magneto-optic disk), immediately memory (RAM), read-only memory (ROM), electricity can be compiled
Journey ROM, electrically erasable ROM (EPROM), electrically erasable ROM (EEPROM), flash memory, magnetic card or light card.It is readable
Medium includes for by any mechanism by equipment (for example, computer) storage or transmission information in the form of readable.For example, readable
Medium include immediately memory (RAM), read-only memory (ROM), magnetic disk storage medium, optical storage medium, flash memory device, with
The signal (such as carrier wave, infrared signal, digital signal) etc. that electricity, light, sound or other forms are propagated.
Those skilled in the art of the present technique be appreciated that can with computer program instructions come realize these structure charts and/or
The combination of each frame and these structure charts and/or the frame in block diagram and/or flow graph in block diagram and/or flow graph.It can be by this
A little computer program instructions are supplied to the processor of all-purpose computer, special purpose computer or other programmable data processing methods
Machine is generated, is used for be performed instruction by the processor of computer or other programmable data processing methods and create
Realize the method specified in the frame or multiple frames of structure chart and/or block diagram and/or flow graph.
Those skilled in the art of the present technique are appreciated that in the various operations crossed by discussion in the present invention, method, flow
Steps, measures, and schemes can be replaced, changed, combined or be deleted.Further, each with having been crossed by discussion in the present invention
Other steps, measures, and schemes in kind operation, method, flow may also be alternated, changed, rearranged, decomposed, combined or deleted.
Further, in the prior art to have and step, measure, the scheme in various operations, method, flow disclosed in the present invention
It may also be alternated, changed, rearranged, decomposed, combined or deleted.
The above is only some embodiments of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (6)
1. a kind of Combat Command System database in phase system, which is characterized in that including application program module, data synchronization service
Module, data publication subscribing module, data communication module, data management by synchronization module and database；
The application program module shows source data for executing database manipulation, including inquiry, deletion and update operation
The notification information of variation；
The data synchronization service module is deployed in the source and destination of data synchronous system, is responsible for executing data synchronization behaviour
Make, includes export and the storage work of database file；
The data publication subscribing module is deployed in the source of data synchronous system, and capture originating mobile subscriber grasps the update of database
The data subscription rule made situation, and stored in reading database, phase is encapsulated into conjunction with subscription rules by data update situation
The data sync message answered, submits to data communication module；
The data communication module is deployed in the source and destination of data synchronous system, be responsible for realizing the compression of message, fragment,
Encryption, transmission, assembling and decryption function；The data transfer demands of low-bandwidth network are adapted to sliced transmission by compressing；
The data management by synchronization module is looked into for realizing the establishment of synchronization rules, the subscription of demand data and synchronization log
It askes；
Subscription rules data of the database for the operation data and synchronization system of storage system.
2. system according to claim 1, which is characterized in that the subscription of the demand data of the data management by synchronization module
Support that data are subscribed to according to two kinds of granularities of whole table and data record of database, wherein data record granularity needs to submit
SQL query condition.
3. system according to claim 2, which is characterized in that the synchronization rules are for every subscription rules for number
Both of which is pulled according to synchronous pattern, including the near real-time of the real-time active push of Class1 and type 2 with audit；
The real-time active push pattern refers to the data-pushing that is directly needed destination by source to destination, and by data
Management by synchronization module automatically updates the database of destination；
Near real-time pull mode with audit refers to by destination after receiving source data update notice message, by destination
After user triggers simultaneously operating by data synchronization service module, obtains corresponding data from source and be deposited into database.
4. system according to claim 3, which is characterized in that the data sync message includes four types, respectively：
Class1：Real-time synchronization message；
Type 2：Data update notice report；
Type 3：Request of data report；
Type 4：Data response report.
5. system according to claim 4, which is characterized in that the source workflow of system includes the following steps：
Step A1：Data update person carries out database manipulation by application program module, and application program module sends out corresponding operating
Give data publication subscribing module；
Step A2：Data publication subscribing module captures application program module data manipulation；
Step A3：Data publication subscribing module is analyzed data manipulation and is matched with the subscription rules stored in database, if
There is matching then to turn to step A4, otherwise, turns to step A7；
Step A4：The synchronous mode of data publication subscribing module analysis matching subscription rules, if the real-time active push of Class1,
Step A5 is then turned to, step A6 is otherwise turned to；
Step A5, data publication subscribing module read the subscription condition of matching subscription rules, are spliced to form SQL statement, transfer to source
End data synchronous service module carries out database data export, and export is encapsulated into SYSDATA messages, type of message
It is 1, data communication module is transferred to be sent；
Step A6：Data publication subscribing module encapsulates SYSDATA messages, and type of message 2 transfers to data communication module to be sent out
It send；
Step A7：Ends with system source workflow.
6. system according to claim 5, which is characterized in that the destination workflow of system includes the following steps：
Step B1：Destination data communication module receives the message that source is sent, and is assembled, is decrypted, and data is transferred to synchronize
Service module；
Step B2：Destination data synchronization service module issues data synchronization notice to user and judges type of message, for class
Type is 1, then goes to step B2-1, if type is 2, goes to step B2-2；
Step B2-1：Destination data synchronization service module directly parses data file, and executes in-stockroom operation, and update synchronizes logical
Know library, and synchronization log is written, goes to step B3；
Step B2-2：For the message of type 2, update status is written into synchronization notice library and synchronization log, and to application program
Module sends notice and reports SYNATT, goes to step B4；
Step B3：Administrator selects this by the data update situation of destination data synchronization service module polls source
When need the data set that synchronizes, carry out data simultaneously operating；
Step B3-1：Destination data synchronization service module assembled synchronization request message SYNDATA messages, type of message 3, and
Encapsulation needs synchronous subscription condition in message text data field, transfers to data communication module；
Step B3-2：Destination data communication module is encrypted SYNDATA, compresses, fragment, and is transferred to synchronous source；
Step B3-3：Source data communication module receives the SYNDATA messages that destination is sent and is sent to data if type 3
Synchronization module；
Step B3-4：Source data synchronization service module carries out data export according to the subscription condition of SYNDATA and produces
SYNDATA messages, type 4, transfer to data communication module to be sent to destination；
Step B3-5：Destination data communication module parses the SYNDATA messages received, and it is 4 to extract type
Data file in message, and notification data synchronous service module；
Step B3-6：Destination data synchronization service module carries out data loading operation, and synchronous day is written in update synchronization notice library
Will, and synchronously complete notice to application program transmission data；
Step B4：Ends with system destination workflow.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810194031.3A CN108536743A (en) | 2018-03-09 | 2018-03-09 | A kind of Combat Command System database in phase system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810194031.3A CN108536743A (en) | 2018-03-09 | 2018-03-09 | A kind of Combat Command System database in phase system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108536743A true CN108536743A (en) | 2018-09-14 |
Family
ID=63486748
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810194031.3A Pending CN108536743A (en) | 2018-03-09 | 2018-03-09 | A kind of Combat Command System database in phase system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108536743A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109408692A (en) * | 2018-09-25 | 2019-03-01 | 安徽灵图壹智能科技有限公司 | A kind of data archive system based on block chain |
| CN109815290A (en) * | 2018-12-24 | 2019-05-28 | 天翼电子商务有限公司 | Real time data synchronization device and synchronous method |
| CN110362632A (en) * | 2019-07-22 | 2019-10-22 | 无限极（中国）有限公司 | A kind of method of data synchronization, device, equipment and computer readable storage medium |
| CN111209332A (en) * | 2019-12-20 | 2020-05-29 | 中国铁路上海局集团有限公司 | Database synchronization method based on self-made serialization algorithm |
| CN111339184A (en) * | 2020-02-16 | 2020-06-26 | 苏州浪潮智能科技有限公司 | Hive synchronization method, system, equipment and medium |
| CN111460038A (en) * | 2020-04-07 | 2020-07-28 | 中国建设银行股份有限公司 | Quasi-real-time data synchronization method and device |
| CN113626423A (en) * | 2021-06-29 | 2021-11-09 | 欧电云信息科技(江苏)有限公司 | Log management method, device and system of service database |
| CN114449030A (en) * | 2021-12-27 | 2022-05-06 | 天翼云科技有限公司 | Internet service system, method, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102843432A (en) * | 2012-08-30 | 2012-12-26 | 西可通信技术设备（河源）有限公司 | Network communication system applicable to sharing and synchronous updating of data at multiple clients |
| CN104954482A (en) * | 2015-06-29 | 2015-09-30 | 上海瀚之友信息技术服务有限公司 | Configuration management system and method |
| CN104506496B (en) * | 2014-12-10 | 2017-09-29 | 山大地纬软件股份有限公司 | The method of near-realtime data increment distribution based on Oracle Streams technologies |
| CN107301196A (en) * | 2017-05-03 | 2017-10-27 | 北京小度信息科技有限公司 | Method of data synchronization, device, equipment and monitoring server |
-
2018
- 2018-03-09 CN CN201810194031.3A patent/CN108536743A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102843432A (en) * | 2012-08-30 | 2012-12-26 | 西可通信技术设备（河源）有限公司 | Network communication system applicable to sharing and synchronous updating of data at multiple clients |
| CN104506496B (en) * | 2014-12-10 | 2017-09-29 | 山大地纬软件股份有限公司 | The method of near-realtime data increment distribution based on Oracle Streams technologies |
| CN104954482A (en) * | 2015-06-29 | 2015-09-30 | 上海瀚之友信息技术服务有限公司 | Configuration management system and method |
| CN107301196A (en) * | 2017-05-03 | 2017-10-27 | 北京小度信息科技有限公司 | Method of data synchronization, device, equipment and monitoring server |
Non-Patent Citations (2)
| Title |
|---|
| 用户1177503: "分布式系统的消息&服务模式简单总结", 《腾讯云》 * |
| 金紫蘅: "多级系统间数据同步的解决方案", 《指挥信息系统与技术》 * |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109408692A (en) * | 2018-09-25 | 2019-03-01 | 安徽灵图壹智能科技有限公司 | A kind of data archive system based on block chain |
| CN109815290A (en) * | 2018-12-24 | 2019-05-28 | 天翼电子商务有限公司 | Real time data synchronization device and synchronous method |
| CN110362632A (en) * | 2019-07-22 | 2019-10-22 | 无限极（中国）有限公司 | A kind of method of data synchronization, device, equipment and computer readable storage medium |
| CN110362632B (en) * | 2019-07-22 | 2022-11-15 | 无限极（中国）有限公司 | Data synchronization method, device, equipment and computer readable storage medium |
| CN111209332A (en) * | 2019-12-20 | 2020-05-29 | 中国铁路上海局集团有限公司 | Database synchronization method based on self-made serialization algorithm |
| CN111209332B (en) * | 2019-12-20 | 2024-02-09 | 中国铁路上海局集团有限公司 | Database synchronization method based on homemade serialization algorithm |
| CN111339184A (en) * | 2020-02-16 | 2020-06-26 | 苏州浪潮智能科技有限公司 | Hive synchronization method, system, equipment and medium |
| CN111460038A (en) * | 2020-04-07 | 2020-07-28 | 中国建设银行股份有限公司 | Quasi-real-time data synchronization method and device |
| CN113626423A (en) * | 2021-06-29 | 2021-11-09 | 欧电云信息科技(江苏)有限公司 | Log management method, device and system of service database |
| CN113626423B (en) * | 2021-06-29 | 2024-01-30 | 欧电云信息科技(江苏)有限公司 | Log management method, device and system of business database |
| CN114449030A (en) * | 2021-12-27 | 2022-05-06 | 天翼云科技有限公司 | Internet service system, method, electronic equipment and storage medium |
| CN114449030B (en) * | 2021-12-27 | 2024-03-12 | 天翼云科技有限公司 | Internet service system, method, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108536743A (en) | A kind of Combat Command System database in phase system | |
| CN106156359B (en) | A kind of data synchronization updating method under cloud computing platform | |
| CN102193899B (en) | System and method for the data of the multiple environment of management spanning | |
| CN101188627B (en) | Transaction accelerator for client-server communication systems | |
| CN101155296B (en) | Method for transmitting data | |
| CN106131123B (en) | The remote resource synchronous method and system of three-tier architecture | |
| CN106126407A (en) | A kind of performance monitoring Operation Optimization Systerm for distributed memory system and method | |
| CN107239521A (en) | Recycle bin application process and system on a kind of distributed type assemblies | |
| CN106648903A (en) | Method and system for calling distributed file system | |
| CN109582381A (en) | File type configuration information synchronization system, method and storage medium | |
| CN106850761A (en) | Journal file storage method and device | |
| CN103237063B (en) | Cloud storage method, cloud control server, cloud storage server and system | |
| CN108282396B (en) | Multi-level message broadcasting method and system in IM (instant Messaging) cluster | |
| CN104202431B (en) | With personalized unit address book synchronization method, device and intelligent communication system | |
| CN107979498A (en) | A kind of mesh network clusters and the big document transmission method based on the cluster | |
| CN109714222A (en) | The distributed computer monitoring system and its monitoring method of High Availabitity | |
| CN106843760A (en) | It is a kind of based on the asynchronous remote copy system deleted and method again | |
| CN105872731A (en) | Data processing method and device | |
| CN103856724B (en) | It is a kind of to make emergency system | |
| CN108228756A (en) | Data based on the PG databases of daily record analytic technique to Hadoop platform synchronize clone method | |
| CN108897497B (en) | Centerless data management method and device | |
| Matray et al. | Building a prototype for network measurement virtual observatory | |
| CN104869056A (en) | Institution personnel data synchronization method based on relational data separation | |
| CN109815292A (en) | A kind of concerning taxes data collection system based on asynchronous message mechanism | |
| CN101478437A (en) | Network resource management method, system and network management server |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180914 |
|
| RJ01 | Rejection of invention patent application after publication |