CN109492051A - A kind of pipe network data synchronous method and device - Google Patents
A kind of pipe network data synchronous method and device Download PDFInfo
- Publication number
- CN109492051A CN109492051A CN201811224779.XA CN201811224779A CN109492051A CN 109492051 A CN109492051 A CN 109492051A CN 201811224779 A CN201811224779 A CN 201811224779A CN 109492051 A CN109492051 A CN 109492051A
- Authority
- CN
- China
- Prior art keywords
- pipe network
- former
- new
- data
- network
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/18—Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/14—Pipes
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Geometry (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- General Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present invention provides a kind of pipe network data synchronous method and device, it include: when subsynchronous at the beginning of former pipe network and new pipe network, device type information in former pipe network is synchronized to the classification metadata table of new pipe network, the pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network；The spatial data and attribute data of pipeline section element in the former pipe network are copied to the pipeline section table of new pipe network by the pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network；The topology information of new pipe network is safeguarded according to the topology information of former pipe network；When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and increment synchronization is carried out to new pipe network.Former pipe network data occur change need to carry out new and old pipe network data it is secondary or multiple synchronous when, the data changed in former pipe network only can be synchronized to new pipe network, avoid the repetition of persistent data synchronous.
Description
Technical field
The present embodiments relate to technical field of data processing, more particularly, to a kind of pipe network data synchronous method and
Device.
Background technique
Pipe net leakage rate is the network model for urban pipe network design, the geometry including establishing pipe network figure and geographic element
Topology is regular with logical topology and accurately expresses the various connection relationships of pipe network physical network, it is to establish underground pipe network message tube
The basis of reason system provides safeguard for system data inquiry, editor, modification, statistics and data analysis.
Currently, establishing there are mainly two types of the methods of pipe net leakage rate: one is figure and attribute data to be stored separately, passing through
The keyword of attribute field couples, and drawback is that the loose couplings of figure and attribute cause the maintenance of incidence relation more complicated, schemes
Topological relation between member can not be managed effectively；Another kind is to use layered model by attribute data, graph data and topological relation
Data are managed collectively, such as the network model of ARCGIS pipeline model (APDM) and MAPGIS, the shortcomings that such pipe net leakage rate
It is that attribute data structures immobilization, data number of levels are more, it is difficult to realize the Analysis of Policy Making and integrated management of complex grid.And
The network model of ARCGIS pipeline model (APDM) and MAPGIS and the data management mode of itself software platform are closely coupled, lack
Weary uniformity and interoperability support that the information integration and function being unfavorable between each geographical network are shared.
Therefore, in the prior art by establishing pipe net leakage rate, pipe network entity is abstracted into two class of pipe point and pipeline section, Guan Dian
It is uniformly stored in device class table with the device type of pipeline section, the field that equipment includes is stored in device field (DFLD) table, Guan Dian
It is associated with respectively by respective device class identification code dno with device class table with pipeline section, device class table and device field (DFLD) table
It is associated with by device class identification code dno；Pipe net leakage rate unifies the type of storage tube point and pipeline section equipment by device class table
Information realizes the virtual hierarchy of different type pipe network facilities, effectively reduces the number of plies of data, and when newly added equipment type is not required to
Pipe network is rebuild, the complexity of field maintenance is also reduced by device field (DFLD) table, can be used in water supply, combustion gas, heat supply, row
The optimization storage of the municipal industries pipe network facilities space such as water, blowdown, electric power and telecommunications and business information data and network are opened up
Flutter maintenance.However in practical application, the pipe network data of many pipeline ownership units is to utilize MapGIS or ArcGIS pipe net leakage rate
Storage shows and function services constructing unified basic platform using pipe net leakage rate and externally providing unified pipe network data
When, need to carry out the synchronization of pipe network data.
Summary of the invention
The embodiment of the present invention provides a kind of a kind of pipe network for overcoming the above problem or at least being partially solved the above problem
Method of data synchronization and device.
In a first aspect, the embodiment of the present invention provides a kind of pipe network data synchronous method, comprising:
When subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network is synchronized to the classification of new pipe network
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network by metadata table；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and carry out to new pipe network
Increment synchronization.
Preferably, the device type information in former pipe network is synchronized to when subsynchronous at the beginning of former pipe network and new pipe network
Before the classification metadata table of new pipe network, further includes:
The structural information for obtaining the former pipe network reads pipe network name, pipe network code from the former pipe network, and copies to new
In the spatial database of pipe network；
The pipe point field that pipe point element is read from the elementary factor class of former pipe network, creates the pipe point table of new pipe network, and build
Vertical spatial index；The pipeline section field that pipeline section element is read from the elementary factor class of former pipe network, creates the pipeline section table of new pipe network, and
Establish spatial index.
Preferably, the device type information in former pipe network to be synchronized to the classification metadata table of new pipe network, original is managed
The pipe network field information of net is synchronized to the device field (DFLD) metadata table of new pipe network, specifically includes:
Device class metadata table and device field (DFLD) metadata table are created in new pipe network, by GetBlob interface from original
The device type information of former pipe network is obtained in the network class of pipe network, and the device type information is copied into the device class
Metadata table；
Device field (DFLD) information is read from the elementary factor class or object class of former pipe network by att_GetStru interface, and
The device field (DFLD) information is copied into the device field (DFLD) metadata table.
Preferably, and after the device field (DFLD) information is copied to the device field (DFLD) metadata table, further includes:
Default value, whether read-only, whether visible, preset value in the device field (DFLD) information is synchronized to the equipment word
Section metadata table；
The class indication dno of each equipment, while to maintain equipment field member number are defined in the device class metadata table
According to the dno attribute value in table.
Preferably, the spatial data and attribute data of pipe point element in the former pipe network to be copied to the pipe of new pipe network
Point table, after the spatial data and attribute data of pipeline section element in the former pipe network are copied to the pipeline section table of new pipe network, further includes:
Oeid field is created in the pipe point table of the new pipe network, for saving the node recorded in former pipe network network class member
The element ID of element；
Oeid field, steid field and edeid field are created in the pipeline section table of the new pipe network, are respectively used to save
The element ID of the segmental arc element recorded in former pipe network network class, preceding point ID and after point ID.
Preferably, safeguarding the topology information of new pipe network according to the topology information of former pipe network, specifically include:
The element ID of element ID and segmental arc element based on the node element recorded in former pipe network network class, preceding point ID, after
Point ID updates the preceding point ID and rear point ID of the pipeline section table of new pipe network, to update the topological relation of new pipe network.
Preferably, identifying the change data in former pipe network, specifically include:
The element of the node element or segmental arc element that are recorded in the former pipe network network class recorded according to timestamp and new pipe network
ID identifies in former pipe network the pipe point for increasing newly, deleting and modifying, pipeline section.
Second aspect, the embodiment of the present invention provide a kind of pipe network data synchronizing device, comprising:
First module, for when subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network to be synchronized
To the classification metadata table of new pipe network, the pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
Second module, for when former pipe network carries out repeatedly synchronous with new pipe network, identifying the change data in former pipe network, and
Increment synchronization is carried out to new pipe network.
The third aspect, the embodiment of the present invention provides a kind of electronic equipment, including memory, processor and is stored in memory
Computer program that is upper and can running on a processor, is realized when the processor executes described program as first aspect provides
Pipe network data synchronous method the step of.
Fourth aspect, the embodiment of the present invention provide a kind of non-transient computer readable storage medium, are stored thereon with calculating
Machine program realizes the step of the pipe network data synchronous method as provided by first aspect when the computer program is executed by processor
Suddenly.
The embodiment of the present invention proposes a kind of pipe network data synchronous method and device, can be quickly and nondestructively by other
The pipe network data (MapGIS, ArcGIS pipe net leakage rate data) of GIS platform storage synchronizes unified pipe net leakage rate spatial database
In, former pipe network data occur change need to carry out new and old pipe network data it is secondary or multiple synchronous when, can be only by former pipe network
The data of middle change are synchronized to new pipe network, avoid the repetition of persistent data synchronous.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is this hair
Bright some embodiments for those of ordinary skill in the art without creative efforts, can be with root
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is the pipe network data synchronous method schematic diagram according to the embodiment of the present invention；
Fig. 2 is to safeguard schematic diagram according to the pipe network topology of the embodiment of the present invention；
Fig. 3 is the pipe network data synchronizing device schematic diagram according to the embodiment of the present invention；
Fig. 4 is the entity structure schematic diagram according to the electronic equipment of the embodiment of the present invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without creative efforts, shall fall within the protection scope of the present invention.
In the prior art by establishing pipe net leakage rate, pipe network entity is abstracted into two class of pipe point and pipeline section, pipe point and pipe
The device type of section is uniformly stored in device class table, and the field that equipment includes is stored in device field (DFLD) table, pipe point and pipe
Section is associated with by respective device class identification code dno with device class table respectively, and device class table passes through with device field (DFLD) table
Device class identification code dno association；Pipe net leakage rate unifies the type information of storage tube point and pipeline section equipment by device class table,
The virtual hierarchy for realizing different type pipe network facilities, effectively reduces the number of plies of data, and when newly added equipment type does not need weight
Pipe network is built, the complexity of field maintenance is also reduced by device field (DFLD) table, can be used in water supply, combustion gas, heat supply, draining, row
The optimization storage of the municipal industries pipe network facilities space such as dirty, electric power and telecommunications and business information data and network topology dimension
Shield.However in practical application, the pipe network data of many pipeline ownership units is stored using MapGIS or ArcGIS pipe net leakage rate,
Construct unified basic platform using pipe net leakage rate and externally provide unified pipe network data show with function services when, need
Carry out the synchronization of pipe network data.Therefore various embodiments of the present invention a kind of pipe network data synchronous method is provided can quickly and nondestructively
The pipe network data (MapGIS, ArcGIS pipe net leakage rate data) that other GIS platforms store is synchronized in pipe net leakage rate.Below will
Expansion explanation and introduction are carried out by multiple embodiments.
Fig. 1 is a kind of pipe network data synchronous method provided in an embodiment of the present invention, comprising:
When subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network is synchronized to the classification of new pipe network
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network by metadata table；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and carry out to new pipe network
Increment synchronization.
On the basis of the above embodiments, it is necessary first to judge former pipe network and new pipe network whether be it is just subsynchronous, be divided into new
Old pipe network (i.e. former pipe network with new pipe network) just subsynchronous and new and old pipe network secondary is multiple synchronous, changes in former pipe network data
Need to carry out new and old pipe network data it is secondary or multiple synchronous when, the data changed in former pipe network only can be synchronized to new pipe
Net avoids the repetition of persistent data synchronous.
On the basis of the above embodiments, when subsynchronous at the beginning of former pipe network and new pipe network, by the device type in former pipe network
Before synchronizing information to the classification metadata table of new pipe network, further includes:
The structural information for obtaining the former pipe network reads pipe network name, pipe network code from the former pipe network, and copies to new
In the spatial database of pipe network；
The pipe point field that pipe point element is read from the elementary factor class of former pipe network, creates the pipe point table of new pipe network, and build
Vertical spatial index；The pipeline section field that pipeline section element is read from the elementary factor class of former pipe network, creates the pipeline section table of new pipe network, and
Establish spatial index.
On the basis of the above embodiments, the device type information in former pipe network is synchronized to the classification metadata of new pipe network
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network, specifically included by table:
Device class metadata table and device field (DFLD) metadata table are created in new pipe network, by GetBlob interface from original
The device type information of former pipe network is obtained in the network class of pipe network, and the device type information is copied into the device class
Metadata table；
Device field (DFLD) information is read from the elementary factor class or object class of former pipe network by att_GetStru interface, and
The device field (DFLD) information is copied into the device field (DFLD) metadata table.
In the present embodiment, primarily to creation metadata table and synchronous metadata, create equipment point in new pipe network
Class metadata table and device field (DFLD) metadata table；The equipment of pipe network is obtained from the network class of former pipe network by GetBlob interface
The device type information of former pipe network, is copied to the device class metadata table of new pipe network by composition；Pass through att_GetStru interface
Pipe network field information is read from the elementary factor class or object class of former pipe network, copies to the device field (DFLD) metadata of new pipe network
Table.
On the basis of the above embodiments, and by the device field (DFLD) information device field (DFLD) metadata table is copied to
Afterwards, further includes:
Default value, whether read-only, whether visible, preset value in the device field (DFLD) information is synchronized to the equipment word
Section metadata table；
The class indication dno of each equipment, while to maintain equipment field member number are defined in the device class metadata table
According to the dno attribute value in table.
In the present embodiment, the default value in synchronizer field information, whether read-only, whether visible, preset value etc.；?
The class indication dno of each equipment is defined in the device class metadata table of pipe network, while in maintain equipment field metadata table
Dno attribute value.
In order to realize that spatial data is synchronous with attribute data, pass through ReadNodTable interface simply wanting from former pipe network
The spatial data and attribute data of the former pipe network pipe point element such as pressure tap, valve, touchdown point, pond, water source are read in plain class, it is multiple
Make the pipe point table of new pipe network；Former pipe network pipeline section is read from the elementary factor class of former pipe network by ReadLinTable interface to want
The spatial data and attribute data of element copy to the pipeline section table of new pipe network, according to equipment defined in pipe network equipment metadata table
Class indication code safeguards that the device class of pipe point table and pipeline section table identifies dno attribute.
On the basis of the above embodiments, the spatial data and attribute data of pipe point element in the former pipe network are copied to
The spatial data and attribute data of pipeline section element in the former pipe network are copied to the pipeline section table of new pipe network by the pipe point table of new pipe network
Afterwards, further includes:
Oeid field is created in the pipe point table of the new pipe network, for saving the node recorded in former pipe network network class member
The element ID of element；
Oeid field, steid field and edeid field are created in the pipeline section table of the new pipe network, are respectively used to save
The element ID of the segmental arc element recorded in former pipe network network class, preceding point ID and after point ID.
In the present embodiment, during spatial data is synchronous with attribute data, the pipe point element that is updated in new pipe network and
The exclusive identification code of pipeline section element will renumber in order, and what the database of new pipe network was taken records participation in pipeline section table
The exclusive identification code for constituting 2 pipe points of pipeline section will be reset with the topological connection relation safeguarded；During making information update
The topological relation of pipe network can be maintained automatically without being re-established by spatial relationship, spatial data of the embodiment of the present invention
In attribute data synchronizing process, oeid field is created in the pipe point table of the spatial database of new pipe network, for saving former pipe
The element ID of the node element recorded in net network class, to help to establish new pipe network pipe point unique identification and former pipe network node element
Element ID corresponding relationship；Oeid field, steid field and edeid are created in the pipeline section table in new Pipeline Network Spatial Data library
Field, be respectively used to save the element ID of former pipe network segmental arc element, preceding point ID and after point ID, to help to establish new pipe network pipeline section only
The corresponding relationship of one mark and the element ID of former pipe network segmental arc element, and new pipe network pipeline section element preceding point ID, rear point ID and
The corresponding relationship of the preceding point ID of former pipe network pipeline section element, rear point ID.
On the basis of the above embodiments, when just subsynchronous, opening up for new pipe network is safeguarded according to the topology information of former pipe network
Information is flutterred, is specifically included:
Based on the element ID of former pipe network node element, and element ID, preceding point ID, afterwards the point ID of former pipe network segmental arc element, more
The preceding point ID and rear point ID of the pipeline section table of new pipe network, to update the topological relation of new pipe network.
In the present embodiment, as shown in Figure 2, during the maintenance of pipe network topology, according to above-described embodiment spatial data
With the element ID of the element ID of former pipe network node element and segmental arc element that are saved in attribute data synchronizing process, preceding point ID, after
Point ID updates the preceding point ID and rear point ID of new pipe network data depositary management segment table element, to update the topological relation of pipe network, specifically
It is:
Pass through SQL statement (point ID=(select gid from pipe point table where pipeline section table before Update pipeline section table Set
.steid=pipe point table .oeid)) update pipeline section element preceding point ID, i.e., the steid of pipeline section table be equal to pipe point table oeid phase
The gid value for the pipe point table answered is assigned to the preceding point ID of pipeline section element as new value；Pass through SQL statement (point after Update pipeline section table Set
ID=(select gid from pipe point table where pipeline section table .edeid=pipe point table .oeid)) update pipeline section element rear point
ID, i.e., the gid value of corresponding pipe point table is assigned to pipeline section element as new value when the edeid of pipeline section table being equal to pipe point table oeid
After point ID.
On the basis of the above embodiments, the change data in former pipe network are identified, are specifically included:
The element ID of the former pipe network node element or former pipe network segmental arc element that are recorded according to timestamp and new pipe network, is identified
Pipe point, the pipeline section for increasing newly, deleting and modifying in former pipe network.
In the present embodiment, when former pipe network carries out repeatedly synchronous with new pipe network, that is, when carrying out secondary or multiple synchronous, packet
It includes:
(1) change data identification: according to the member of former pipe network node element or segmental arc element that timestamp and new pipe network record
Plain ID identifies in former pipe network the pipe point for increasing newly, deleting and modifying, pipeline section；If the member of former pipe network node element or segmental arc element
Plain ID is not saved in new pipe network pipe point table or pipeline section table oeid field, then determines the pipe point element or pipeline section element is former pipe network
Newly-increased element；If the upper hyposynchronous former pipe network node element of new pipe network record or the element ID of segmental arc element are in former pipe network
It is not present, then determines that the pipe point element or pipeline section element have been deleted in former pipe network；If new pipe network record is upper hyposynchronous
The renewal time of element corresponding to the former pipe network renewal time of former pipe network node element or segmental arc element is inconsistent, then determines the pipe
Point element or pipeline section element are modified in former pipe network.
(2) change data are synchronous: the spatial data and category of the newly-increased pipe point element of the former pipe network that will identify that, pipeline section element
Property data copy to the pipe point table and pipeline section table of new pipe network；The deleted pipe point element of former pipe network and pipeline section are deleted in new pipe network
The spatial data and attribute data of element；Will identify that former pipe network modification pipe point element and pipeline section element spatial data and
More new data of the attribute data as new pipe network pipe point table and the corresponding element of pipeline section table.
(3) topological relation is safeguarded: it is consistent with the topological relation maintenance in subsynchronous at the beginning of pipe network, pass through the pipe point in new pipe network
The element ID of the node element of former pipe network is saved in table and the member of the segmental arc element of former pipe network is saved in the pipeline section table of new pipe network
Plain ID, preceding point ID, afterwards point ID, establish preceding point ID, the rear point ID of new pipe network pipeline section element and the preceding point ID of original pipe network pipeline section element,
The corresponding relationship of point ID afterwards, the topological relation of standby maintenance pipeline section and pipe point.
Fig. 3 is a kind of pipe network data synchronizing device provided in an embodiment of the present invention, based on pipe described in the various embodiments described above
Network data synchronous method, comprising:
First module 30 is used for when subsynchronous at the beginning of former pipe network and new pipe network, and the device type information in former pipe network is same
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata of new pipe network by the classification metadata table for walking new pipe network
Table；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
Second module 40, for identifying the change data in former pipe network when former pipe network carries out repeatedly synchronous with new pipe network,
And increment synchronization is carried out to new pipe network.
Fig. 4 is the entity structure schematic diagram of electronic equipment provided in an embodiment of the present invention, as shown in figure 4, the electronic equipment
It may include: processor (processor) 810,820, memory communication interface (Communications Interface)
(memory) 830 and communication bus 840, wherein processor 810, communication interface 820, memory 830 pass through communication bus 840
Complete mutual communication.Processor 810 can call the meter that is stored on memory 830 and can run on processor 810
Calculation machine program, to execute the pipe network data synchronous method of the various embodiments described above offer, for example,
When subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network is synchronized to the classification of new pipe network
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network by metadata table；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and carry out to new pipe network
Increment synchronization.
In addition, the logical order in above-mentioned memory 830 can be realized by way of SFU software functional unit and conduct
Independent product when selling or using, can store in a computer readable storage medium.Based on this understanding, originally
The technical solution of the inventive embodiments substantially part of the part that contributes to existing technology or the technical solution in other words
It can be embodied in the form of software products, which is stored in a storage medium, including several fingers
It enables and using so that a computer equipment (can be personal computer, server or the network equipment etc.) executes the present invention respectively
The all or part of the steps of a embodiment the method.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory
(ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic or disk
Etc. the various media that can store program code.
The embodiment of the present invention also provides a kind of non-transient computer readable storage medium, is stored thereon with computer program,
The computer program is implemented to carry out the pipe network data synchronous method of the various embodiments described above offer when being executed by processor, such as wraps
It includes:
When subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network is synchronized to the classification of new pipe network
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network by metadata table；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and carry out to new pipe network
Increment synchronization.
The embodiment of the present invention also provides a kind of computer program product, and the computer program product is non-temporary including being stored in
Computer program on state computer readable storage medium, the computer program include program instruction, when described program instructs
When being computer-executed, computer is able to carry out such as above-mentioned pipe network data synchronous method, for example,
When subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network is synchronized to the classification of new pipe network
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network by metadata table；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, will be described
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in former pipe network；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and carry out to new pipe network
Increment synchronization.
In conclusion a kind of pipe network data synchronous method provided in an embodiment of the present invention and device, it can be quick and lossless
The pipe network data (MapGIS, ArcGIS pipe net leakage rate data) that other GIS platforms store is synchronized unified pipe net leakage rate sky by ground
In spatial database, former pipe network data occur change need to carry out new and old pipe network data it is secondary or multiple synchronous when, can only
The data changed in former pipe network are synchronized to new pipe network, avoid the repetition of persistent data synchronous.
The apparatus embodiments described above are merely exemplary, wherein described, unit can as illustrated by the separation member
It is physically separated with being or may not be, component shown as a unit may or may not be physics list
Member, it can it is in one place, or may be distributed over multiple network units.It can be selected according to the actual needs
In some or all of the modules achieve the purpose of the solution of this embodiment.Those of ordinary skill in the art are not paying creativeness
Labour in the case where, it can understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
It realizes by means of software and necessary general hardware platform, naturally it is also possible to pass through hardware.Based on this understanding, on
Stating technical solution, substantially the part that contributes to existing technology can be embodied in the form of software products in other words, should
Computer software product may be stored in a computer readable storage medium, such as ROM/RAM, magnetic disk, CD, including several fingers
It enables and using so that a computer equipment (can be personal computer, server or the network equipment etc.) executes each implementation
Method described in certain parts of example or embodiment.
Finally, it should be noted that the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although
Present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: it still may be used
To modify the technical solutions described in the foregoing embodiments or equivalent replacement of some of the technical features；
And these are modified or replaceed, technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution spirit and
Range.
Claims (10)
1. a kind of pipe network data synchronous method characterized by comprising
When subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network is synchronized to the classification member number of new pipe network
According to table, the pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, by the former pipe
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in net；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
When former pipe network carries out repeatedly synchronous with new pipe network, the change data in former pipe network are identified, and increment is carried out to new pipe network
It is synchronous.
2. pipe network data synchronous method according to claim 1, which is characterized in that subsynchronous at the beginning of the former pipe network and new pipe network
When, before the device type information in former pipe network to be synchronized to the classification metadata table of new pipe network, further includes:
The structural information for obtaining the former pipe network reads pipe network name, pipe network code from the former pipe network, and copies to new pipe network
Spatial database in；
The pipe point field that pipe point element is read from the elementary factor class of former pipe network, creates the pipe point table of new pipe network, and establish sky
Between index；The pipeline section field that pipeline section element is read from the elementary factor class of former pipe network, creates the pipeline section table of new pipe network, and establish
Spatial index.
3. pipe network data synchronous method according to claim 1, which is characterized in that by the device type information in former pipe network
It is synchronized to the classification metadata table of new pipe network, the pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata of new pipe network
Table specifically includes:
Device class metadata table and device field (DFLD) metadata table are created in new pipe network, by GetBlob interface from former pipe network
Network class in obtain the device type information of former pipe network, and the device type information is copied into the device class member number
According to table；
Device field (DFLD) information is read from the elementary factor class or object class of former pipe network by att_GetStru interface, and by institute
It states device field (DFLD) information and copies to the device field (DFLD) metadata table.
4. pipe network data synchronous method according to claim 3, which is characterized in that and replicate the device field (DFLD) information
To after the device field (DFLD) metadata table, further includes:
Default value, whether read-only, whether visible, preset value in the device field (DFLD) information is synchronized to the device field (DFLD) member
Tables of data；
The class indication dno of each equipment, while to maintain equipment field metadata table are defined in the device class metadata table
In dno attribute value.
5. pipe network data synchronous method according to claim 1, which is characterized in that by pipe point element in the former pipe network
Spatial data and attribute data copy to the pipe point table of new pipe network, by the spatial data and attribute of pipeline section element in the former pipe network
After data copy to the pipeline section table of new pipe network, further includes:
Oeid field is created in the pipe point table of the new pipe network, for saving the node element recorded in former pipe network network class
Element ID；
Oeid field, steid field and edeid field are created in the pipeline section table of the new pipe network, are respectively used to save former pipe
The element ID of the segmental arc element recorded in net network class, preceding point ID and after point ID.
6. pipe network data synchronous method according to claim 1, which is characterized in that safeguarded according to the topology information of former pipe network
The topology information of new pipe network, specifically includes:
Based on the segmental arc element recorded in the element ID of the node element recorded in former pipe network network class, and former pipe network network class
Element ID, preceding point ID, afterwards point ID update the preceding point ID and rear point ID of the pipeline section table of new pipe network, to update the topology of new pipe network
Relationship.
7. pipe network data synchronous method according to claim 1, which is characterized in that identify the change data in former pipe network,
It specifically includes:
The element ID of the node element or segmental arc element that record in the former pipe network network class recorded according to timestamp and new pipe network, knows
It Chu not be increased newly in former pipe network, pipe point, the pipeline section of deletion and modification.
8. a kind of pipe network data synchronizing device characterized by comprising
First module, for when subsynchronous at the beginning of former pipe network and new pipe network, the device type information in former pipe network to be synchronized to newly
The pipe network field information of former pipe network is synchronized to the device field (DFLD) metadata table of new pipe network by the classification metadata table of pipe network；
The pipe point table that the spatial data and attribute data of pipe point element in the former pipe network are copied to new pipe network, by the former pipe
The spatial data and attribute data of pipeline section element copy to the pipeline section table of new pipe network in net；
The topology information of new pipe network is safeguarded according to the topology information of former pipe network；
Second module, for identifying the change data in former pipe network, and to new when former pipe network carries out repeatedly synchronous with new pipe network
Pipe network carries out increment synchronization.
9. a kind of electronic equipment including memory, processor and stores the calculating that can be run on a memory and on a processor
Machine program, which is characterized in that the processor realizes method as described in any one of claim 1 to 7 when executing described program
The step of.
10. a kind of non-transient computer readable storage medium, is stored thereon with computer program, which is characterized in that the calculating
The step of machine program realizes method as described in any one of claim 1 to 7 when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811224779.XA CN109492051B (en) | 2018-10-19 | 2018-10-19 | Pipe network data synchronization method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811224779.XA CN109492051B (en) | 2018-10-19 | 2018-10-19 | Pipe network data synchronization method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109492051A true CN109492051A (en) | 2019-03-19 |
| CN109492051B CN109492051B (en) | 2021-10-22 |
Family
ID=65692496
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811224779.XA Active CN109492051B (en) | 2018-10-19 | 2018-10-19 | Pipe network data synchronization method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109492051B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100094802A1 (en) * | 2008-10-10 | 2010-04-15 | Abb Technology Ag | Method and a system for replicating databases |
| CN103441988A (en) * | 2013-08-02 | 2013-12-11 | 广东电网公司电力科学研究院 | Data migration method crossing GIS platforms |
| CN103914564A (en) * | 2014-04-18 | 2014-07-09 | 山东泰华电讯有限责任公司 | Method and system for updating and warehousing urban pipelines on basis of ArcGIS (geographic information system) |
-
2018
- 2018-10-19 CN CN201811224779.XA patent/CN109492051B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100094802A1 (en) * | 2008-10-10 | 2010-04-15 | Abb Technology Ag | Method and a system for replicating databases |
| CN103441988A (en) * | 2013-08-02 | 2013-12-11 | 广东电网公司电力科学研究院 | Data migration method crossing GIS platforms |
| CN103914564A (en) * | 2014-04-18 | 2014-07-09 | 山东泰华电讯有限责任公司 | Method and system for updating and warehousing urban pipelines on basis of ArcGIS (geographic information system) |
Non-Patent Citations (1)
| Title |
|---|
| 张新长 等: "《地理信息***工程》", 30 September 2015 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109492051B (en) | 2021-10-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105938448B (en) | Method and apparatus for data duplication | |
| WO2018082364A1 (en) | Method and device for analyzing power-off range of power distribution network, and computer storage medium | |
| CN107025242A (en) | The clone method and device of data between database | |
| Ma et al. | A classification of file placement and replication methods on grids | |
| CN103581231B (en) | UGC master/slave data synchronous method and its system | |
| CN106407308A (en) | Method and device for expanding capacity of distributed database | |
| CN105630919A (en) | Storage method and system | |
| CN105630571A (en) | Virtual machine creating method and device | |
| CN105389367A (en) | Power network graphic multi-tense and multi-level distributed storage method based on Mongo database | |
| US20160098494A1 (en) | Integration of analysis with multi-user cad | |
| CN102982186B (en) | Based on maintaining method and the system of the range partition table of oracle database system | |
| CN105302922A (en) | Realizing method for snapshot of distributed file system | |
| CN110909087A (en) | Method and device for modifying table structure of online DDL (distributed data storage) of relational database | |
| US9031905B2 (en) | Data synchronization | |
| CN104407932B (en) | A kind of data back up method and device | |
| CN109445989A (en) | A kind of file system data backup method and device | |
| CN106598990B (en) | Searching method and system | |
| CN109492051A (en) | A kind of pipe network data synchronous method and device | |
| Bakalov et al. | A network model for the utility domain | |
| CN103092947A (en) | Data version control method | |
| Goncalves et al. | DottedDB: Anti-entropy without merkle trees, deletes without tombstones | |
| JP2019066939A (en) | Transfer management device and transfer management method | |
| CN104765748B (en) | A kind of method and device that duplication table is converted to fragment table | |
| KR102356500B1 (en) | Geospatial information system-based modeling approach for leakage management in urban water distribution networks | |
| CN110569231B (en) | Data migration method, device, equipment and medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A pipeline network data synchronization method and device Effective date of registration: 20230613 Granted publication date: 20211022 Pledgee: Wuhan area branch of Hubei pilot free trade zone of Bank of China Ltd. Pledgor: WUHAN ZHONGZHI HONGTU TECHNOLOGY CO.,LTD. Registration number: Y2023420000231 |