CN100375972C - Method for implementing allochthonic administrative date synchronous exchange of cable equipment in geographical information system - Google Patents
Method for implementing allochthonic administrative date synchronous exchange of cable equipment in geographical information system Download PDFInfo
- Publication number
- CN100375972C CN100375972C CNB031415121A CN03141512A CN100375972C CN 100375972 C CN100375972 C CN 100375972C CN B031415121 A CNB031415121 A CN B031415121A CN 03141512 A CN03141512 A CN 03141512A CN 100375972 C CN100375972 C CN 100375972C
- Authority
- CN
- China
- Prior art keywords
- data
- gis
- cms
- management system
- geographic information
- 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.)
- Expired - Lifetime
Links
Images
Abstract
The present invention relates to an information and communication technology, particularly to a method for realizing the management data synchronous exchange of electric cable equipment at different places in a geographical information system. The method comprises: (1) a data list for recording transaction processing and a storing procedure are established in a content management system (CM for short) of the electric cable equipment; (2) a relation list trigger and a sequence are established in the CM; (3) a data synchronization (Insync) tool and a customization program are loaded into a geographic information management system (GIS for short); (4) a segment mapping script is established in the GIS; (5) a user interface for user to manually synchronize data is established in the GIS. the present invention solves the technical problem that because information data sources in the content management system and the geographic information management system are different, the data are not be shared. Under the condition of the bandwidth of a network is insufficient, the unified management and the data sharing of electric cable machine accounts at the different places and the electrical network geographical information system are realized.
Description
Technical field:
The present invention is relevant with information and mechanics of communication, particularly realizes the method for cable machinery strange land management data synchronous exchange in a kind of Geographic Information System.
Background technology:
In the production management infosystem of electric company, plant asset management is considerable Back ground Information management.Common plant asset management, with regard to the electrical network that electric company administers, mainly be divided into converting equipment, overhead transmission line equipment, three parts of underground cable equipment, these three parts interconnect physically, therefore in infosystem, exist the annexation of attribute, and based on the topological relation of geographical information platform.Three large equipment administrative authoritys of electric company finish three partial data maintenance works respectively in same LAN (Local Area Network).Even cable management in the strange land, also is by fiber optic network, be as good as with the local client processing mode.
Shanghai City south cable management place cable machinery operation management system (hereinafter to be referred as: CMS) develop by Shenzhen Tai Ji softcom limited, and in the end of the year in 2002 formally by the project acceptance inspection.System's major function comprises: engineering management, cable body information management, the management of cable auxiliary device and electric cable stoppage, fault, maintenance and tour management, and support the inquiry of WEB webpage.
The architecture that this system has adopted C/S, B/S to combine, the mode of taking database server and WEB server to set up respectively.Adopt the commercial relevant database of Oracle 8.1.6 as data storing platform.Have 49 of tables of data, as follows with Minhang geographic information management system relevant data table:
| Table name | Chinese is explained | Table name | Chinese is explained |
| ora_linecode | Cable line | ora_cblpart | The cable entity |
| ora_intrhead | Cable splice | ora_cable_bridge | Cable bridge |
| ora_track | Worker's well | cable_bridge_linecode | The cable bridge corresponding line |
| ducts_linecode | The ditch well passes through cable line | ora_ducts | Comb |
| ora_branch_box | Feeder pillar | ora_manufactory | Manufacturer |
The Minhang geographic information management system (hereinafter to be referred as: MHGIS) develop by Shanghai City south power information engineering company limited, and with in November, 2002 by city electric power company functional acceptance.System mainly comprises: functions such as circuit, power transformation and cable machinery management, graphical query statistics.System adopts GE Smallworld as the GIS platform, and VMDS is as the data storage warehouse.Because this system adopts open data store organisation, for other infosystems have been reserved data-interface, and in this systemic software development process, carry out repeatedly exchange of technology with regard to cable machinery operation management system data structure and the slip-stick artist of Taiji, aspect exchanges data, had certain technical foundation.
At present, existing part cable service data (as: part cable line, Gong Jing, comb etc.) in the MHGIS system, these data are at that time from the disposable importing MHGIS of old cable operation management system (adopt Foxpro2.6 develop), and fundamental purpose is for guaranteeing that project is smoothly by checking and accepting.The cable service data of considering this system does not obtain upgrading for a long time, and suggestion adopts the method for synchronization to do data initialization earlier, and then begins to carry out data typing work.
Summary of the invention:
The present invention to solve information data source in cable machinery operation management system and the geographic information management system different and data can not the share technique problem, under the unappeasable situation of the bandwidth of network, to the cable machine account in strange land and the unified management and the data sharing of electrical network Geographic Information System.
The technical scheme that solves the problems of the technologies described above is:
Realize cable machinery strange land management data synchronous exchange method in a kind of Geographic Information System, it is characterized in that it comprises the steps:
1. in cable machinery operation management system (hereinafter to be referred as CMS), set up tables of data and the storing process that is used to write down issued transaction;
2. in CMS, set up correlation table trigger and sequence;
3. synchronously (Insync) instrument and customization program of loading data in geographic information management system (hereinafter to be referred as GIS):
4. in GIS, set up the field mappings script;
But 5. in GIS, set up the user interface that makes user's manual data synchronization.
When the user increased in CMS, upgrades or deletes relative recording, the table trigger was informed transaction processing facility record corresponding information and is kept in the database; Wait to move when synchronous, system then carries out data sync according to field mappings script and issued transaction table; This GIS is made up of database server and permission agreement server, is connected to the client of CMS by interchanger, and in client the GIS image file is housed.
Database server among this GIS is installed among the CMS.
Technique effect of the present invention is:
The realization of cable machinery strange land management data switching technology in the electrical network Geographic Information System can make the electrical network geography information user who does not possess high-speed channel, realizes data sharing in same system, and can guarantee the uniqueness of data inlet; Simultaneously, make system data that the mechanism of a remote backup arranged, strengthened the safety guarantee of system data.
Description of drawings:
The system configuration scheme one of the present invention of Fig. 1.
The system configuration scheme two of the present invention of Fig. 2.
Embodiment:
Data sync scheme of the present invention is determined as follows: increase transaction processing facility in CMS, promptly increase the operation transaction journal, and set up data table related trigger etc.In GIS, increase data synchronization processing mechanism.The attribute data of cable machinery is benchmark with CMS, and every day, morning, automaticdata was synchronous.The specific implementation method is as follows:
1. in CMS, set up tables of data and the storing process that is used to write down issued transaction;
2. in CMS, set up correlation table trigger and sequence;
3. in GIS, load Insync element and customization program;
4. in GIS, set up the field mappings script;
5. user interface is provided in GIS, but makes user's manual data synchronization.
When the user increases in CMS, upgrades or deletes relative recording (if increase record, system at first obtains a unique serial number sign indicating number from serial device), the table trigger is informed transaction processing facility record corresponding information and is kept in the database.Wait to move when synchronous, system then carries out data sync according to field mappings script and issued transaction table.
Adopt this scheme to allow the user both can in CMS, import data, also can in GIS, import data.If but clash, promptly the user has revised identical record in different system, then needs certain intervention.GE Smallworld supports following three kinds of settling modes at present, please the user select a kind of method to implement according to actual conditions:
When clashes, be as the criterion with the CMS data;
When clashes, be as the criterion with the GIS data;
When clashes, determine correct data by the mode of manual intervention;
System configuration scheme of the present invention is:
Scheme one (as shown in Figure 1):
Do not set up database server and permission agreement server in the cable machinery operation management system (CMS) 2, the client 21 of cable machinery operation management system 2 is by the database server 11 and the permission agreement server 12 of network switch 13,22 visit geographic information management systems (GIS) 1.And, also comprise redundant array of inexpensive disks 14 in the geographic information management system 1.
Use after the suitable network rebuilding of this scheme.If adopt this scheme at present, can the GIS image file be installed in the client 21 of cable machinery operation management system 2, and, determine whether again to adopt behind the observation flowing of access to on-the-spot test.
Scheme two (as shown in Figure 2):
Installation database server 23 ' in the cable machinery operation management system 2 ', client 21 ' the direct access local database of cable machinery operation management system 2 ', simultaneously, by the permission agreement server 11 ' in network switch 13 ', 22 ' the visit geographic information management system 1 '.
The suitable interim excessive usefulness of this scheme, placed apart in database server 23 ', the power transformation among the GIS, circuit and cable data need manually import and export.
Claims (2)
1. realize cable machinery strange land management data synchronous exchange method in a Geographic Information System, it is characterized in that it comprises the steps:
1. in cable machinery operation management system CMS, set up tables of data and the storing process that is used to write down issued transaction;
2. in CMS, set up correlation table trigger and sequence;
3. loading data synchronization means and customization program in geographic information management system GIS;
4. in GIS, set up the field mappings script;
But 5. in GIS, set up the user interface that makes user's manual data synchronization;
When the user increased in CMS, upgrades or deletes relative recording, the table trigger was informed transaction processing facility record corresponding information and is kept in the database; Wait to move when synchronous, system then carries out data sync according to field mappings script and issued transaction table; This GIS is made up of database server and permission agreement server, is connected to the client of CMS by interchanger, and in client the GIS image file is housed.
2. realize cable machinery strange land management data synchronous exchange method in the Geographic Information System according to claim 1, it is characterized in that the database server among the GIS is installed among the CMS.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031415121A CN100375972C (en) | 2003-07-10 | 2003-07-10 | Method for implementing allochthonic administrative date synchronous exchange of cable equipment in geographical information system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031415121A CN100375972C (en) | 2003-07-10 | 2003-07-10 | Method for implementing allochthonic administrative date synchronous exchange of cable equipment in geographical information system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1567302A CN1567302A (en) | 2005-01-19 |
| CN100375972C true CN100375972C (en) | 2008-03-19 |
Family
ID=34470949
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB031415121A Expired - Lifetime CN100375972C (en) | 2003-07-10 | 2003-07-10 | Method for implementing allochthonic administrative date synchronous exchange of cable equipment in geographical information system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100375972C (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105844546B (en) * | 2016-04-20 | 2019-12-31 | 国网四川省电力公司 | GIS mirror image technology-based power distribution network information interaction method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1999023509A1 (en) * | 1997-11-03 | 1999-05-14 | Wireless Systems International Limited | Simultaneous triggering of remote units |
| CN1336598A (en) * | 2001-09-07 | 2002-02-20 | 清华大学 | Quasi-synchronous master-slave remote education information management system and its implementation method |
| WO2003040925A1 (en) * | 2001-10-22 | 2003-05-15 | Aisin Aw Co., Ltd. | Information control system, server for information control system, and information terminal for information control system |
-
2003
- 2003-07-10 CN CNB031415121A patent/CN100375972C/en not_active Expired - Lifetime
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1999023509A1 (en) * | 1997-11-03 | 1999-05-14 | Wireless Systems International Limited | Simultaneous triggering of remote units |
| CN1336598A (en) * | 2001-09-07 | 2002-02-20 | 清华大学 | Quasi-synchronous master-slave remote education information management system and its implementation method |
| WO2003040925A1 (en) * | 2001-10-22 | 2003-05-15 | Aisin Aw Co., Ltd. | Information control system, server for information control system, and information terminal for information control system |
Non-Patent Citations (1)
| Title |
|---|
| 面向窄带环境的异地同步协同设计方法. 张敬谊，张申生，陈纯，王波.上海交通大学学报，第37卷第6期. 2003 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1567302A (en) | 2005-01-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102932062B (en) | Intelligent optical fiber connects distribution system and adapter port state information identification method | |
| CN102722764B (en) | Integration network optimization computer-aided decision support System | |
| CN103095504B (en) | A kind of wired network infrastructure resource management system | |
| CN105022769A (en) | Data interaction system of urban underground pipeline, and method thereof | |
| CN109710696B (en) | System and method for power equipment checking and transaction moving operation | |
| CN101860078B (en) | Electric power integrated communication resource management system | |
| CN103458022A (en) | Multi-user different-place concurrent collaborative system | |
| CN107527079A (en) | A kind of communication line resource management platform and communication line resource administration method | |
| CN112232635A (en) | Wisdom water affairs data middling platform based on distributing type cloud framework | |
| CN111488634A (en) | Railway survey design delivery result management method based on 3DGIS + BIM | |
| CN109245923A (en) | Communications optical cable route resource management method and system | |
| CN102104492A (en) | Telecommunication equipment network management server and system | |
| CN102624096A (en) | Intelligent supervisory system for power distribution field operation | |
| CN100375972C (en) | Method for implementing allochthonic administrative date synchronous exchange of cable equipment in geographical information system | |
| CN105743693A (en) | Communication network line topology-building and updating method and communication network line topology-building and updating system based on GIS | |
| CN111881198B (en) | Contact net building site management system towards intelligence is built | |
| US20160202737A1 (en) | Real-time data acquisition and management equipment | |
| CN107967301B (en) | Method and device for storing and inquiring monitoring data of power cable tunnel | |
| CN105471926A (en) | Diagnostic data cloud model constructing system based on autonomous decentralized system | |
| CN202535166U (en) | Power distribution on-site work intelligent supervision system | |
| CN110675283B (en) | Power distribution equipment synchronous management system and method | |
| CN114186950A (en) | Optical cable resource management method and system | |
| CN102508926A (en) | Catalog data parsing method and system | |
| CN111915152B (en) | Task allocation method and system applied to intelligent contact network construction site | |
| CN106528811B (en) | Method for migrating overall data of PMS (permanent magnet synchronous motor) |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: SHANGHAI HENGRUI INFORMATION TECHNOLOGY CO. Free format text: FORMER OWNER: SOUTH SHANGHAI ELECTRIC POWER INFORMATION ENGINEERING TECHNOLOGY CO., LTD. Effective date: 20080516 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20080516 Address after: 5 floor, No. 222 Jiang Jiang Road, Shanghai Patentee after: SHANGHAI HENGRUI INFORMATION TECHNOLOGY Co.,Ltd. Address before: No. 2 health Road, Shanghai Patentee before: South Shanghai Electric Power Information Engineering Technology Co.,Ltd. |
|
| ASS | Succession or assignment of patent right |
Owner name: SHANGHAI MUNICIPAL ELECTRIC POWER COMPANY Free format text: FORMER OWNER: SHANGHAI HENGRUI INFORMATION TECHNOLOGY CO., LTD. Effective date: 20120614 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 200233 XUHUI, SHANGHAI TO: 200122 PUDONG NEW AREA, SHANGHAI |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20120614 Address after: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Patentee after: SHANGHAI MUNICIPAL ELECTRIC POWER Co. Address before: 200233. 5 building, 222 Chiang Jiang Road, Shanghai Patentee before: SHANGHAI HENGRUI INFORMATION TECHNOLOGY Co.,Ltd. |
|
| CX01 | Expiry of patent term |
Granted publication date: 20080319 |
|
| CX01 | Expiry of patent term |