CN106528811A - Integrated data migration method for PMS - Google Patents
Integrated data migration method for PMS Download PDFInfo
- Publication number
- CN106528811A CN106528811A CN201611013690.XA CN201611013690A CN106528811A CN 106528811 A CN106528811 A CN 106528811A CN 201611013690 A CN201611013690 A CN 201611013690A CN 106528811 A CN106528811 A CN 106528811A
- Authority
- CN
- China
- Prior art keywords
- data
- pms
- original production
- support platform
- migrated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Control Of Electric Motors In General (AREA)
Abstract
The invention relates to an integrated data migration method for a PMS. The method comprises a PMS reference library, a PMS production library, a middle library, an engineering library, an original production system, a support platform and an integrated system. The middle library is used for physical media which are used for data collection, check and storage. The method has the advantages that the data of the original production system and the data of a GIS system are firstly migrated to the middle library; the data is cleared and checked through the middle library; digital display data is imported into the PMS production library; the data verification in the migration process and the final data check are ensured; the migrated data is complete and accurate; system applications are normal, the safe production service is not influenced; the workload of a basic level team or group is not increased; the system data is not reworked repeatedly; and a practical demand of the production management system is satisfied.
Description
Technical field
The present invention relates to a kind of method of PMS systems overall data migration.
Background technology
Zhejiang electricity PMS system applications at present cover each subordinate unit and administrative 11 districts and cities, 64 companies of county, system registry
18759 people of user, per day 4614 people of online number of system.System has covered the full voltage grade from 1000 kilovolts to 400 volts
It is defeated to become with one or two times and automation equipment, possess operation, maintenance, plan, project management, on-line monitoring, distribution scheduling and run, match somebody with somebody
More than 330 function points of every key business meter such as net repairing commander, technical supervision, repair based on condition of component, analysis center.Meanwhile, Zhejiang electricity
PMS systems realize data with multiple professional information systeies and the integrated of business is shared：It is integrated with ERP, realize asset of equipments
Linkage；Integrated with OMS, realization stops the management such as labour application；It is integrated with marketing system, realize battalion with insertion；It is public with intelligence to become monitoring
It is integrated with electricity consumption acquisition system, realize actively rushing to repair；It is integrated with power distribution automation, realize that auxiliary tone thematic map is automatically generated and PMS
The production of artwork-auxiliary tone closed loop management；It is integrated with Electric Power Quality On-line Monitor System, and sea news magnanimity real-time dataBase system collection
It is integrated into, monitoring operation center management module, realize fortune inspection data sharing and index monitoring.PMS in Zhejiang company not only
Only be fortune inspection operating information system, but the management information system of enterprise-level, for other special information systems provide power network topology,
The Back ground Informations such as figure, equipment account, and with PMS system upgrades, need to save substantial amounts of business in existing PMS systems
Data, and there is larger difference with existing Zhejiang electricity PMS systems in new PMS systems, it is impossible to it is directly applied to existing construction into
Really.
The content of the invention
The technical problem to be solved in the present invention is just to provide a kind of method of PMS systems overall data migration, solves existing
The data that PMS system upgrades were preserved originally cannot direct applied problem.
In order to solve above-mentioned technical problem, the present invention is achieved by the following technical solutions：A kind of PMS systems are integrally counted
According to the method for migration, including PMS pattern libraries, PMS storage facility located at processing plants, middle database, engineering storehouse, original production system, support platform and integrated
System, original production system include generalized information system data, and PMS pattern libraries include PMS benchmark database table structures, basis and common code number
According to the initialization data needed for collection, application program, support platform, the data in original production management system are replicated in engineering storehouse, while
Set up the contrast relationship of organization, personnel, the basic data of code in engineering storehouse, middle database be used for data collection, verification,
Storage physical medium used, comprises the following steps:
Step one：The data and generalized information system data duplication of original production system are in engineering storehouse；
Step 2：In PMS pattern libraries, data initialization is configured in middle database；
Step 3：By the part basis data syn-chronization in engineering storehouse in step one to support platform；
Step 4：In in support platform after step 3 is processed, necessary to Data Migration, basic data imports to middle database
It is interior；
Step 5：Basic data necessary to Data Migration in step 4 is generated into original production system right with integrated system
According to relation, and contrast relationship is generated in engineering storehouse；
Step 6：Power network resources, business datum from original production system are passed through map, change, moving in middle database；
Step 7：In generalized information system, data are moved in Data Migration middle database by geometric objects transfer；
Step 8：By the data lacked in original production system by user collect, make a report on be saved in Excel intermediate files load
Body；
Step 9：PMS pattern libraries initial configuration is in support platform and PMS storage facility located at processing plants；
Step 10：PMS storage facility located at processing plants are related to the organization of support platform, personnel's authority carries out reference renewal；
Step 11：Data in middle database are carried out inspection to examine, and is migrated to PMS storage facility located at processing plants by instrument；
Step 12：According to Data Migration situation, collect to form new-old system coding correspondence table and related change data are clear
Volume provides related integrated system, so that integrated system updates interface data；
Step 13：The data of the Added Business function of not including in the incremental data in freezing period, original system are passed through
In manual amended record integrated system.
Preferably, the physical medium in middle database includes data base and file, can realize different types of data collection school
Test.
Preferably, the data of original production system include structural data, graph data, unstructured data, intermediate file,
And structural data and graph data are migrated by the direct-connected mode of data base, unstructured data is entered by uploading interface
Row Data Migration, intermediate file carry out data importing by excel instruments, can be migrated according to different types of data, protect
The examination ＆ verification of card final data.
In sum, advantages of the present invention：1. the data of original production system and generalized information system data are first migrated to middle database
In, cleaning, the examination ＆ verification of data are realized by middle database, then digital display data are directed in PMS storage facility located at processing plants, it is ensured that migrated
The checking of data and the examination ＆ verification of final data in journey, migrating data complete and accurate, system application are normal, safety in production business is not received
Affect, do not increase teams and groups of basic unit workload, system data does not repeat to do over again, and be finally reached production management system it is practical will
Ask；
2. the setting of pattern library, can realize carrying out initial chemical industry to the data of support platform, PMS storage facility located at processing plants, integrated system
Make；
3. the setting in engineering storehouse, is avoided that impact original production system is normally run, realizes to original production system and generalized information system
The duplication of interior data, for carrying out migration further to middle database；
4. the setting of middle database, carries out the thing used by offer data collection, verification, storage in can guarantee that data migration process
Reason medium.
Specific embodiment
A kind of method of PMS systems overall data migration, including PMS pattern libraries, PMS storage facility located at processing plants, middle database, engineering storehouse,
Original production system, support platform and integrated system, original production system include generalized information system data, and PMS pattern libraries include PMS benchmark
Database table structure, basis and the initialization data needed for common code data set, application program, support platform, support platform is ISC
Or BPM or UDS, engineering storehouse replicate original production management system in data, while set up in engineering storehouse organization, personnel,
The contrast relationship of the basic data of code, middle database are used for the physical medium used by data collection, verification, storage, including following
Step：
Step one：The data and generalized information system data duplication of original production system are in engineering storehouse；
Step 2：Data initialization in PMS pattern libraries is configured in middle database；
Step 3：By the part basis data syn-chronization in engineering storehouse in step one to support platform；
Step 4：In in support platform after step 3 is processed, necessary to Data Migration, basic data imports to middle database
It is interior；
Step 5：Basic data necessary to Data Migration in step 4 is generated into original production system right with integrated system
According to relation, and contrast relationship is generated in engineering storehouse；
Step 6：Power network resources, business datum from original production system are passed through map, change, moving in middle database；
Step 7：In generalized information system, data are moved in Data Migration middle database by geometric objects transfer；
Step 8：By the data lacked in original production system by user collect, make a report on be saved in Excel intermediate files load
Body；
Step 9：PMS pattern libraries initial configuration is in support platform and PMS storage facility located at processing plants；
Step 10：PMS storage facility located at processing plants are related to the organization of support platform, personnel's authority carries out reference renewal；
Step 11：Data in middle database are carried out inspection to examine, and is migrated to PMS storage facility located at processing plants by instrument；
Step 12：According to Data Migration situation, collect to form new-old system coding correspondence table and related change data are clear
Volume provides related integrated system, so that integrated system updates interface data；
Step 13：The data of the Added Business function of not including in the incremental data in freezing period, original system are passed through
In manual amended record integrated system.
Physical medium in middle database includes data base and file, can realize different types of data collection verification, primary
The data of product system include structural data, graph data, unstructured data, intermediate file, and structural data and figure
Data are migrated by the direct-connected mode of data base, and unstructured data carries out Data Migration, middle text by uploading interface
Part carries out data importing by excel instruments, can be migrated according to different types of data, it is ensured that the examination ＆ verification of final data.
The migration of structural data is comprised the following steps：1. data basd link is created in PMS storage facility located at processing plants point to primary product storehouse；
2. Mapping and Converting program is write, the data structure of original production system is converted into the data form of PMS storage facility located at processing plants needs；3. run
Mapping and Converting program, by data pick-up to PMS storage facility located at processing plants；4. the result that contrast verification data is extracted after data pick-up terminates.
The migration of graph data is comprised the following steps：1. data basd link is created in PMS data bases point to original GIS productions
Storehouse；2. develop figure crossover tool carries out space coordinate conversion, space geometry conversion to former GIS data；3. after data conversion
Move to PMS storage facility located at processing plants；4. the result that contrast verification data is extracted after data pick-up terminates.
The migration of non-institutional data is comprised the following steps：1. unstructured data is drawn into by destructuring by instrument
Data platform is stored, and storage address of the corresponding data in destructuring platform is written back in system；2. by storage
Unstructured data platform address transfer adapts to the non-structural such as picture, drawing data, adnexa, test report to PMS storage facility located at processing plants
Change the migration of data.
The migration of intermediate file is comprised the following steps：1. the standard excel template for data inputting to PMS storage facility located at processing plants being provided
In；2. by excel import tools importing data in PMS storage facility located at processing plants.
In addition to above preferred embodiment, the present invention also has other embodiments, and those skilled in the art can be according to this
Invention is variously modified and deforms, and without departing from the spirit of the present invention, all should belong to claims of the present invention determined
The scope of justice.
Claims (3)
1. a kind of method that PMS systems overall data is migrated, it is characterised in that：Including PMS pattern libraries, PMS storage facility located at processing plants, centre
Storehouse, engineering storehouse, original production system, support platform and integrated system, original production system include generalized information system data, PMS pattern library bags
Include PMS benchmark database table structures, basis and common code data set, application program, support platform needed for initialization data, engineering
The data in original production management system are replicated in storehouse, while organization, personnel, the basic data of code are set up in engineering storehouse
Contrast relationship, middle database are used for the physical medium used by data collection, verification, storage, comprise the following steps：
Step one：The data and generalized information system data duplication of original production system are in engineering storehouse；
Step 2：In PMS pattern libraries, data initialization is configured in middle database；
Step 3：By the part basis data syn-chronization in engineering storehouse in step one to support platform；
Step 4：In in support platform after step 3 is processed, necessary to Data Migration, basic data is imported in middle database；
Step 5：Pass is compareed by what basic data necessary to the Data Migration in step 4 generated original production system and integrated system
System, and contrast relationship is generated in engineering storehouse；
Step 6：Power network resources, business datum from original production system are passed through map, change, moving in middle database；
Step 7：In generalized information system, data are moved in Data Migration middle database by geometric objects transfer；
Step 8：The data lacked in original production system are collected, made a report on and be saved in Excel intermediate file carriers by user；
Step 9：PMS pattern libraries initial configuration is in support platform and PMS storage facility located at processing plants；
Step 10：PMS storage facility located at processing plants are related to the organization of support platform, personnel's authority carries out reference renewal；
Step 11：Data in middle database are carried out inspection to examine, and is migrated to PMS storage facility located at processing plants by instrument；
Step 12：According to Data Migration situation, collect to form new-old system coding correspondence table and related change data inventory is carried
For related integrated system, so that integrated system updates interface data；
Step 13：By the data of the Added Business function of not including in the incremental data in freezing period, original system by manual
In amended record integrated system.
2. the method that a kind of PMS systems overall data according to claim 1 is migrated, it is characterised in that：In middle database
Physical medium includes data base and file.
3. the method that a kind of PMS systems overall data according to claim 1 is migrated, it is characterised in that：Original production system
Data include structural data, graph data, unstructured data, intermediate file, and structural data and graph data are logical
Cross the direct-connected mode of data base to be migrated, unstructured data carries out Data Migration by uploading interface, and intermediate file passes through
Excel instruments carry out data importing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611013690.XA CN106528811B (en) | 2016-11-15 | 2016-11-15 | Method for migrating overall data of PMS (permanent magnet synchronous motor) |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611013690.XA CN106528811B (en) | 2016-11-15 | 2016-11-15 | Method for migrating overall data of PMS (permanent magnet synchronous motor) |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106528811A true CN106528811A (en) | 2017-03-22 |
| CN106528811B CN106528811B (en) | 2023-05-30 |
Family
ID=58352351
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611013690.XA Active CN106528811B (en) | 2016-11-15 | 2016-11-15 | Method for migrating overall data of PMS (permanent magnet synchronous motor) |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106528811B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959205A (en) * | 2018-06-27 | 2018-12-07 | 成都泰盟软件有限公司 | A kind of method of ERP system export data fast transferring |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246955A (en) * | 2013-04-29 | 2013-08-14 | 云南电网公司 | Visible production planning and scheduling information system |
| CN103606032A (en) * | 2013-11-05 | 2014-02-26 | 广东电网公司电力科学研究院 | Two-dimensional grid GIS data concentration method |
| CN103927385A (en) * | 2014-04-25 | 2014-07-16 | 国家电网公司 | Unifying method and device of data model |
| WO2014207558A2 (en) * | 2013-06-27 | 2014-12-31 | Scope Technologies Holdings Limited | Onboard vehicle accident detection and damage estimation system and method of use |
| CN105447611A (en) * | 2014-11-21 | 2016-03-30 | 国家电网公司 | OMS equipment transaction management and control information system supported by GID platform |
-
2016
- 2016-11-15 CN CN201611013690.XA patent/CN106528811B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246955A (en) * | 2013-04-29 | 2013-08-14 | 云南电网公司 | Visible production planning and scheduling information system |
| WO2014207558A2 (en) * | 2013-06-27 | 2014-12-31 | Scope Technologies Holdings Limited | Onboard vehicle accident detection and damage estimation system and method of use |
| EP3013643A2 (en) * | 2013-06-27 | 2016-05-04 | Scope Technologies Holdings Limited | Onboard vehicle accident detection and damage estimation system and method of use |
| CN103606032A (en) * | 2013-11-05 | 2014-02-26 | 广东电网公司电力科学研究院 | Two-dimensional grid GIS data concentration method |
| CN103927385A (en) * | 2014-04-25 | 2014-07-16 | 国家电网公司 | Unifying method and device of data model |
| CN105447611A (en) * | 2014-11-21 | 2016-03-30 | 国家电网公司 | OMS equipment transaction management and control information system supported by GID platform |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959205A (en) * | 2018-06-27 | 2018-12-07 | 成都泰盟软件有限公司 | A kind of method of ERP system export data fast transferring |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106528811B (en) | 2023-05-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104598376B (en) | The layering automatization test system and method for a kind of data-driven | |
| CN112036766B (en) | Gridding distribution network service management method, gridding distribution network service management device, computer equipment and storage medium | |
| CN106327087A (en) | Test task assignment method | |
| CN102903063A (en) | Integral electricity market operation system | |
| CN105574593B (en) | Track state static detection and control system and method based on cloud computing and big data | |
| CN101908176A (en) | Method for modeling on basis of power information data and applying metadata management | |
| CN103473672A (en) | System, method and platform for auditing metadata quality of enterprise-level data center | |
| CN107526804B (en) | Railway investment project data statistics system and method | |
| CN103605512A (en) | System and method for data verification based on GTechnology platform | |
| CN115496337A (en) | Data system for supporting brain of enterprise | |
| CN102663008A (en) | Government integrated business platform business library and construction method of base library | |
| CN107301498A (en) | Generalized information management system for the military service monitoring of high-speed railway wheel rail relation | |
| CN106296038A (en) | Test assignment triggering method | |
| CN109656909A (en) | A kind of transmission of electricity expert data management system | |
| CN116150408A (en) | Energy information management method, system, equipment and storage medium based on identification analysis | |
| CN103606032A (en) | Two-dimensional grid GIS data concentration method | |
| Gardian et al. | Data harmonisation for energy system analysis–Example of multi-model experiments | |
| CN115203163A (en) | SSC (sequence checking) and equipment data acquisition method for nuclear power plant | |
| CN103106555B (en) | Maintaining-managing system based on the integration of online off-line and method | |
| CN106528811A (en) | Integrated data migration method for PMS | |
| Walford et al. | Thirty years of geographical (in) consistency in the British population census: steps towards the harmonisation of small‐area census geography | |
| Bao et al. | Travel demand forecasting using activity‐based modeling framework FEATHERS: an extension | |
| Karasev et al. | Integral assessment of the level of innovative development of the railway industry companies | |
| Yueksel-Erguen et al. | Lessons learned from gas network data preprocessing | |
| CN114238525A (en) | Carbon emission factor management method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |