CN106528811B - Method for migrating overall data of PMS (permanent magnet synchronous motor) - Google Patents
Method for migrating overall data of PMS (permanent magnet synchronous motor) Download PDFInfo
- Publication number
- CN106528811B CN106528811B CN201611013690.XA CN201611013690A CN106528811B CN 106528811 B CN106528811 B CN 106528811B CN 201611013690 A CN201611013690 A CN 201611013690A CN 106528811 B CN106528811 B CN 106528811B
- Authority
- CN
- China
- Prior art keywords
- data
- library
- pms
- production
- migration
- 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.)
- Active
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 a method for overall data migration of a PMS system, which comprises a PMS reference library, a PMS production library, an intermediate library, an engineering library, a primary production system, a support platform and an integrated system, wherein the intermediate library is used for collecting, checking and storing physical media used by data; the invention has the advantages that: according to the method, data of a primary production system and GIS system data are firstly migrated to an intermediate library, data cleaning and auditing are realized through the intermediate library, then digital display data are imported to a PMS production library, verification of the data and auditing of final data in the migration process are guaranteed, the migration data are complete and accurate, normal system application and safe production service are not affected, basic team workload is not increased, system data are not reworked repeatedly, and finally practical requirements of a production management system are met.
Description
Technical Field
The invention relates to a method for migrating overall data of a PMS system.
Background
The current power-off PMS system application covers 11 places and cities and 64 county companies of each direct-attach unit, the system registers 18759 users, and the average number of people on line on the daily basis is 4614. The system already covers a full-voltage-class transmission and transformation secondary and automation device from 1000 kilovolts to 400 volts, and is provided with a plurality of functional points of each key business meter 330 such as operation, maintenance, planning, project management, on-line monitoring, distribution network scheduling operation, distribution network emergency repair command, technical supervision, state maintenance, analysis center and the like. Meanwhile, the Zhejiang power PMS system and a plurality of professional information systems realize integrated sharing of data and business: integrating with ERP to realize equipment asset linkage; integrating with OMS to realize the management of the application of stopping service; integrating with a marketing system to realize marketing and distribution communication; integrated with an intelligent public transformer monitoring and electricity acquisition system to realize active rush-repair; the method is integrated with power distribution automation, so that automatic generation of a distribution and adjustment thematic map and production-distribution and adjustment closed-loop management of a PMS (permanent magnet synchronous) map module are realized; integrating with an electric energy quality on-line monitoring system, integrating with a sea information mass real-time database system and integrating with an operation monitoring center management module, and realizing operation detection data sharing and index monitoring. The PMS is not only an operation and check service information system but also an enterprise-level management information system in the Zhejiang company, so that basic information such as power grid topology, graphics, equipment accounts and the like is provided for other professional information systems, and as the PMS system is upgraded, a large amount of service data is required to be stored in the existing PMS system, and a large difference exists between the new PMS system and the existing Zhejiang electric PMS system, so that the new PMS system cannot be directly applied to the existing construction results.
Disclosure of Invention
The invention aims to solve the technical problem of providing a method for migrating overall data of a PMS system, and solves the problem that the original stored data cannot be directly applied in the prior PMS system.
In order to solve the technical problems, the invention is realized by the following technical scheme: the method for migrating the whole data of the PMS system comprises a PMS reference library, a PMS production library, a middle library, an engineering library, a primary production system, a supporting platform and an integrated system, wherein the primary production system comprises GIS system data, the PMS reference library comprises a PMS reference library table structure, basic and public code data sets, an application program and initialization data required by the supporting platform, the engineering library replicates data in the primary production management system, and meanwhile, a comparison relation of basic data of organization, personnel and codes is established in the engineering library, and the middle library is used for collecting, checking and storing the physical media used by the data, and comprises the following steps:
step one: copying the data of the original production system and the GIS system data into an engineering library;
step two: initializing and configuring the data in the PMS reference library into the intermediate library;
step three: synchronizing part of basic data in the engineering warehouse in the first step to a supporting platform;
step four: importing basic data necessary for data migration in the support platform processed in the step three into an intermediate library;
step five: generating a comparison relation between the original production system and the integrated system by the basic data necessary for data migration in the fourth step, and generating the comparison relation into an engineering library;
step six: mapping, converting and migrating power grid resources and business data from a primary production system into an intermediate library;
step seven: data in the GIS system is transferred and migrated to a data migration intermediate library through a space geometric object;
step eight: collecting, filling and storing the missing data in the original production system to an Excel intermediate file carrier by a user;
step nine: initializing and configuring a PMS reference library into a support platform and a PMS production library;
step ten: the PMS production library relates to an organization mechanism of a supporting platform and personnel authority for reference update;
step eleven: checking and verifying the data in the intermediate library, and migrating the data into a PMS production library through a tool;
step twelve: according to the data migration condition, summarizing and forming a new and old system coding corresponding table and a related change data album to provide a related integrated system so as to update interface data of the integrated system;
step thirteen: and integrating the change data in the freezing period and the data of the newly added service function which is not contained in the original system into the system through manual supplementary recording.
Preferably, the physical medium in the intermediate library comprises a database and a file, so that different types of data collection verification can be realized.
Preferably, the data of the original production system comprises structured data, graphic data, unstructured data and an intermediate file, the structured data and the graphic data are migrated in a direct database connection mode, the unstructured data are migrated through an uploading interface, the intermediate file is imported through an excel tool, migration can be carried out according to different types of data, and auditing of final data is guaranteed.
In summary, the invention has the advantages that: 1. the data of the original production system and the GIS system data are firstly migrated to an intermediate library, the data are cleaned and checked through the intermediate library, then the digital display data are imported to the PMS production library, the verification of the data and the check of final data in the migration process are ensured, the migration data are complete and accurate, the system application is normal, the safe production business is not affected, the workload of basic teams is not increased, the system data are not repeatedly reworked, and finally the practical requirement of the production management system is met;
2. the setting of the reference library can realize the initialization work of the data of the support platform, the PMS production library and the integrated system;
3. the arrangement of the engineering library can avoid influencing the normal operation of the original production system, realize the duplication of the data in the original production system and the GIS system and be used for further migration to the intermediate library;
4. the setting of the intermediate library can ensure that physical media for data collection, verification and storage are provided in the data migration process.
Detailed Description
The method for migrating the whole data of the PMS system comprises a PMS reference library, a PMS production library, a middle library, an engineering library, a primary production system, a supporting platform and an integrated system, wherein the primary production system comprises GIS system data, the PMS reference library comprises a PMS reference library table structure, basic and public code data sets, an application program and initialization data required by the supporting platform, the supporting platform is ISC or BPM or UDS, the engineering library copies the data in the primary production management system, and meanwhile, a comparison relation of basic data of organization, personnel and codes is established in the engineering library, and the middle library is used for physical media used for data collection, verification and storage and comprises the following steps:
step one: copying the data of the original production system and the GIS system data into an engineering library;
step two: initializing and configuring the data in the PMS reference library into an intermediate library;
step three: synchronizing part of basic data in the engineering warehouse in the first step to a supporting platform;
step four: importing basic data necessary for data migration in the support platform processed in the step three into an intermediate library;
step five: generating a comparison relation between the original production system and the integrated system by the basic data necessary for data migration in the fourth step, and generating the comparison relation into an engineering library;
step six: mapping, converting and migrating power grid resources and business data from a primary production system into an intermediate library;
step seven: data in the GIS system is transferred and migrated to a data migration intermediate library through a space geometric object;
step eight: collecting, filling and storing the missing data in the original production system to an Excel intermediate file carrier by a user;
step nine: initializing and configuring a PMS reference library into a support platform and a PMS production library;
step ten: the PMS production library relates to an organization mechanism of a supporting platform and personnel authority for reference update;
step eleven: checking and verifying the data in the intermediate library, and migrating the data into a PMS production library through a tool;
step twelve: according to the data migration condition, summarizing and forming a new and old system coding corresponding table and a related change data album to provide a related integrated system so as to update interface data of the integrated system;
step thirteen: and integrating the change data in the freezing period and the data of the newly added service function which is not contained in the original system into the system through manual supplementary recording.
The physical medium in the intermediate library comprises a database and a file, so that data collection and verification of different types can be realized, the data of the original production system comprises structured data, graphic data, unstructured data and an intermediate file, the structured data and the graphic data are migrated in a direct connection mode of the database, the unstructured data are subjected to data migration through an uploading interface, the intermediate file is subjected to data import through an excel tool, migration can be performed according to the data of different types, and auditing of final data is ensured.
The migration of structured data includes the steps of: 1. creating a database chain in the PMS production library to point to the original production library; 2. writing a mapping conversion program to convert the data structure of the original production system into a data format required by a PMS production library; 3. running a mapping conversion program, and extracting data to a PMS production library; 4. and comparing the result of the check data extraction after the data extraction is finished.
The migration of the graphics data includes the steps of: 1. creating a database chain in a PMS database to point to an original GIS production library; 2. developing a graph conversion tool to perform space coordinate conversion and space geometric conversion on the original GIS data; 3. after data conversion, migrating to a PMS production library; 4. and comparing the result of the check data extraction after the data extraction is finished.
The migration of unstructured data includes the steps of: 1. extracting unstructured data to an unstructured data platform by a tool for storage, and writing back a storage address of corresponding data in the unstructured platform into a system; 2. and migrating the stored unstructured data platform address into a PMS production library, and adapting to migration of unstructured data such as pictures, drawing data, accessories, test reports and the like.
The migration of the intermediate file comprises the following steps: 1. inputting the data into a standard excel template provided by a PMS production library; 2. data is imported into the PMS production library by an excel import tool.
In addition to the above preferred embodiments, the present invention has other embodiments, and various changes and modifications may be made by those skilled in the art without departing from the spirit of the invention, which is defined in the appended claims.
Claims (3)
1. A method for overall data migration of a PMS system, which is characterized in that: the method comprises a PMS reference library, a PMS production library, an intermediate library, an engineering library, a primary production system, a supporting platform and an integrated system, wherein the primary production system comprises GIS system data, the PMS reference library comprises a PMS reference library table structure, a basic and public code data set, an application program and initialization data required by the supporting platform, the engineering library copies data in a primary production management system, and meanwhile, a comparison relation of basic data of organization, personnel and codes is established in the engineering library, and the intermediate library is used for collecting, checking and storing data and comprises the following steps:
step one: copying the data of the original production system and the GIS system data into an engineering library;
step two: initializing and configuring the data in the PMS reference library into the intermediate library;
step three: synchronizing part of basic data in the engineering warehouse in the first step to a supporting platform;
step four: importing basic data necessary for data migration in the support platform processed in the step three into an intermediate library;
step five: generating a comparison relation between the original production system and the integrated system by the basic data necessary for data migration in the fourth step, and generating the comparison relation into an engineering library;
step six: mapping, converting and migrating power grid resources and business data from a primary production system into an intermediate library;
step seven: data in the GIS system is transferred and migrated to a data migration intermediate library through a space geometric object;
step eight: collecting, filling and storing the missing data in the original production system to an Excel intermediate file carrier by a user;
step nine: initializing and configuring a PMS reference library into a support platform and a PMS production library;
step ten: the PMS production library relates to an organization mechanism of a supporting platform and personnel authority for reference update;
step eleven: checking and verifying the data in the intermediate library, and migrating the data into a PMS production library through a tool;
step twelve: according to the data migration condition, summarizing and forming a new and old system coding corresponding table and a related change data album to provide a related integrated system so as to update interface data of the integrated system;
step thirteen: and integrating the change data in the freezing period and the data of the newly added service function which is not contained in the original system into the system through manual supplementary recording.
2. A method for PMS system overall data migration according to claim 1 and wherein: the physical media within the intermediate library includes databases and files.
3. A method for PMS system overall data migration according to claim 1 and wherein: the data of the original production system comprises structured data, graphic data, unstructured data and an intermediate file, the structured data and the graphic data are migrated in a database direct connection mode, the unstructured data are subjected to data migration through an uploading interface, and the intermediate file is subjected to data import through an excel tool.
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 CN106528811A (en) | 2017-03-22 |
CN106528811B true 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) |
Families Citing this family (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 |
Also Published As
Publication number | Publication date |
---|---|
CN106528811A (en) | 2017-03-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
CN112260331B (en) | Extra-high voltage alternating current-direct current power grid simulation platform and construction method | |
CN109146089A (en) | A kind of life period of an equipment management method based on BIM | |
CN103093024A (en) | Web geographic information system (WEBGIS)-based visualized showing method for planning power grid | |
CN103955789A (en) | Power supply path analysis method based on allocation-used integrated model | |
CN104504485A (en) | Integrative power system relay protection setting calculation method | |
CN111585349B (en) | Power grid model management and monitoring system | |
CN107590749A (en) | A kind of processing method and system with electricity consumption data | |
CN111524027B (en) | Electric power information statistical method, device, equipment and storage medium | |
CN104778551A (en) | Designing and analyzing method of visualization grid | |
CN103606032B (en) | A kind of method in two dimension power grid GIS data set | |
CN107067161B (en) | Automatic checking implementation system and method for information point table in smart power grid | |
CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
CN106528811B (en) | Method for migrating overall data of PMS (permanent magnet synchronous motor) | |
Cheng et al. | Design and implementation of GIS basic data quality management tools for power network | |
CN111597166B (en) | Power database model construction method, device, computer equipment and storage medium | |
CN104463462A (en) | Power grid future state model maintenance tool | |
CN103294878A (en) | Unified modeling method of multidimensional grid models based on DMS (database management system) | |
CN102867273B (en) | A kind of distribution dual coding system based on SOA | |
CN112446619A (en) | Power distribution network emergency repair processing method and device | |
Zhang et al. | Research and Implementation of the State Grid Transmission Planning Simulation Platform | |
Wuergler et al. | Use of CIM for workflows across network operation, asset management and Network planning systems at a distribution utility | |
Wang et al. | Research on Simulation of Distribution Network Engineering Scene Based on 3D GIS Technology | |
CN112381500B (en) | BPA model parameter maintenance method and system based on Web service | |
Seenath Beevi et al. | Smart Grid and Utility Challenges |
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 |