[ summary of the invention ]
In order to solve the above problems in the prior art, the present invention provides a source data side management platform, where the management platform includes: one or more groups of source data end working combinations; the system is used for managing the source system and communicating with the vertical synchronization device to synchronize and manage the model data;
the source data end working combination comprises a source data end, an end database and a management workstation;
the source data end is directly connected with a source system; the system is used for receiving and processing metadata and dictionary data, coding and generating model identification, maintaining and circulating model information and verifying the model; the source data end is also used for longitudinally synchronizing the stock model and the incremental model and is a main source of model cloud platform foundation and business data;
the end database is used for managing model information;
the management workstation is used for inputting the model information into the source data terminal in a manual and automatic mode; and the method is also used for providing a web interface to manage the source data terminal.
Further, the management workstation comprises a web interface through which circulation personnel and advanced users operate.
Further, the entering of the model information into the source data end in a manual manner specifically includes: sequentially inputting model information through a web interface provided by a management workstation; and after clicking a 'submit' button, the source data end carries out primary processing on the input information, and stores the model information subjected to the primary processing into an end database.
Further, the model information is recorded into the source data end in an automatic manner, specifically: uploading a model name list, automatically acquiring model information based on the model name, performing primary processing on the automatically acquired model information, and storing the primarily processed model information into an end database.
Further, the automatically obtaining the model information based on the model name specifically includes: for each model name in the list of model names, the source data base requesting a source system based on the model name to obtain model information associated with the model name; in this way, the user can automatically perform batch import of all information only by inputting the list information.
Further, the performing of the preliminary treatment specifically includes: acquiring a model type based on a model name, acquiring a value range of each input information item based on the model type, and performing obvious exception removal on the input information items based on the value range; and performing obvious exception removal on the input information based on the incidence relation among the information.
Further, the removing of the obvious abnormality of the input information based on the incidence relation between the information specifically includes: and combining every two input information items to form a combination to be determined, determining a suspicious combination to be determined, determining one input information item in the suspicious combination to be determined as a suspicious input information item, and correcting the suspicious input information item.
Further, the determining the suspicious combinations to be determined specifically includes: and if the two input information items in the combination to be determined are inconsistent and/or inconsistent, determining that the combination to be determined is a suspicious combination to be determined.
Further, the determining that one item of input information in the suspicious combinations to be determined is a suspicious input information item specifically includes: and determining the suspicious index of each input item in the suspicious combination to be determined, and taking the input item with the high suspicious index as a suspicious input item.
The distributed integrated coordination control of power grid model management is realized, and the comprehensive management capability of a power grid equipment model is improved; the centralized automatic management of the source systems is realized by accessing the source data end management platforms to the source systems according to the geographic positions; the source data end can automatically carry out verification, self-estimation filling and correction on the input data, so that the input of the model information is greatly simplified, and the accuracy of the model information is improved through the self-estimation of the information.
[ detailed description ] embodiments
The present invention will now be described in detail with reference to the drawings and specific embodiments, wherein the exemplary embodiments and descriptions are provided only for the purpose of illustrating the present invention and are not to be construed as limiting the present invention.
The core of the invention is to provide a power grid equipment model unified management system based on a regulation and control cloud architecture, and in order to enable people in the technical field to better understand the scheme of the invention, the invention is further described in detail with reference to the accompanying drawings and the specific implementation modes.
As shown in fig. 1, the power grid equipment model unified management system based on the regulation cloud architecture provided in the embodiment of the present invention includes: the system comprises a model cloud platform, a longitudinal synchronization device, a source data end management platform and a source system;
the model cloud platform is used for performing model section management, storing and managing metadata and dictionary data and model versions, providing model data services for other model cloud platforms and application service layers in a service interface mode, and performing model information synchronization with other model cloud platforms through the longitudinal synchronization device;
as shown in fig. 2, the model cloud platform provided in the embodiment of the present invention includes a cloud database, a data verification device, a data synchronization interface, and a model data quality evaluation device;
preferably: the model cloud platform also comprises a service analysis application device used for carrying out provincial service analysis;
the cloud database comprises a model version database, a model section database and a metadata/dictionary database;
the cloud database is used for storing and managing model information and metadata/dictionary data; the model section is used for storing and managing model information and also used for storing and managing an equipment standard model; the model version library is used for carrying out version management on the longitudinally synchronized model information; the metadata/dictionary database is used for storing and managing metadata/dictionary data, specifically: the model information is backed up and stored in a metadata/dictionary database in the form of metadata or dictionary data, and the data is periodically checked to ensure the correctness of the model data;
the data checking device is used for periodically checking and updating the metadata/dictionary data;
the data synchronization interface is used for responding to a request of the source data terminal management platform to access the metadata/dictionary database so as to provide metadata/dictionary data; because the metadata/dictionary database is a one-way access database, different from the model section database, a special interface is required to be arranged for access so as to ensure the safety and the isolation type;
the model data quality evaluation device is used for periodically evaluating the quality of model information in the model section library; when the quality evaluation result is poor, adjusting a verification strategy and an input strategy of the source data end to improve the quality of the model information;
the source data end management platform comprises one or more groups of source data end working combinations; the system is used for managing the source system and communicating with the vertical synchronization device to synchronize and manage the model data;
the source data end working combination comprises a source data end, an end database and a management workstation;
the source data end is directly connected with a source system; the system is used for receiving and processing metadata and dictionary data, coding and generating model identification, maintaining and circulating model information and verifying the model; the source data end is also used for longitudinally synchronizing the stock model and the incremental model and is a main source of model cloud platform foundation and business data;
the end database is used for managing model information;
the management workstation is used for inputting the model information into the source data terminal in a manual and automatic mode; the system is also used for providing a web interface to manage the source data end;
preferably: the management workstation comprises a web interface, and circulation personnel and advanced users operate through the web interface;
preferably: the source data terminal is also used for providing subscription requirements for the verified model; the source data terminal responds to the subscription requirements of other source data terminals to perform the directional publishing of the model; the subscription right provided by the source data terminal to other source data terminals in the same source data terminal management platform is higher than the subscription right provided to other source data terminals in other source data terminal management platforms outside the same source data terminal management platform;
the longitudinal synchronization device is used for performing data synchronization between the source data end management platform and the model cloud platform; specifically, the method comprises the following steps: responding to a synchronous request of a source data end management platform, and uploading and downloading model data to a model cloud platform; the source data end management platform is used for responding to a metadata acquisition request of the source data end management platform and sending metadata or dictionary data in the model cloud platform to the source data end management platform;
preferably: the synchronization request and the metadata acquisition request comprise the identification of a source data end; the vertical synchronization device determines whether to allow the synchronization request and the metadata acquisition request based on the state and the authority of the source data terminal;
preferably: when the state of a source data end is abnormal, not allowing a synchronization request sent by the source data end but allowing a metadata acquisition request of the source data end so that the source data end can carry out abnormality removal according to metadata/dictionary data;
preferably: when the authority of a source data end is smaller than the minimum authority, model cloud platform access requests from the source data end are all refused; the source data end can only exist in an island form temporarily;
preferably: the minimum authority is a preset value;
the source system is used for managing bottom equipment and abstracting a model of the equipment; when equipment reconstruction and equipment new construction occur, the source system sends the model information of the equipment to a source data end to carry out unified management on the equipment model;
preferably: one or more source systems access the same source data terminal; the source data base manages the source system based on the geographic location;
the manual mode is used for inputting the model information into the source data terminal, and specifically comprises the following steps: sequentially inputting model information through a web interface provided by a management workstation; after clicking a 'submit' button, the source data end carries out primary processing on the input information, and stores the model information subjected to the primary processing into an end database;
the model information is input into the source data end in an automatic mode, and the method specifically comprises the following steps: uploading a model name list, automatically acquiring model information based on the model name, performing primary processing on the automatically acquired model information, and storing the primarily processed model information into an end database;
the automatic acquisition of the model information based on the model name specifically includes: for each model name in the list of model names, the source data base requesting a source system based on the model name to obtain model information associated with the model name; by the mode, a user can automatically carry out full-information batch import only by inputting list information;
the preliminary treatment specifically comprises the following steps: acquiring a model type based on a model name, acquiring a value range of each input information item based on the model type, and performing obvious exception removal on the input information items based on the value range; removing obvious abnormality of input information based on the incidence relation among the information;
the obvious abnormal elimination of the input information based on the incidence relation among the information specifically comprises the following steps: combining every two items of input information items to form a combination to be determined, determining a suspicious combination to be determined, determining one item of input information in the suspicious combination to be determined as a suspicious input information item, and correcting the suspicious input information item;
the determination of the suspicious combination to be determined specifically comprises the following steps: if the two input information items in the combination to be determined are inconsistent and/or inconsistent, determining that the combination to be determined is a suspicious combination to be determined;
the method for determining the suspicious combination to be determined comprises the following steps of: determining the suspicious index of each input item in the suspicious combination to be determined, and taking the input item with high suspicious index as a suspicious input item;
the determining the suspicious index of each input item in the suspicious combination to be determined specifically comprises: taking the total number of the combinations to be determined, related to the input information items, which are determined as suspicious combinations to be determined as suspicious indexes of the input items;
preferably: when the suspicious indexes of the two input items are the same, taking the input information item with high importance as a suspicious input information item, and requesting arbitration to determine whether the input information item is the suspicious input information item and obtain correct input information of the input information item based on feedback; for example: requesting the senior user to carry out arbitration and feedback;
preferably: the importance of the input information item is a preset value;
the correcting of the suspicious input information item specifically comprises: correcting the suspicious input information items based on other input information items except the suspicious input information items;
preferably: if the times of the other input information item in the same suspicious to-be-determined combination with the suspicious input information item appearing in the suspicious to-be-determined combination exceed a second quantity threshold, the other input information item is the other input item; otherwise, the other information items are all other input information items in the input information items except the suspicious input information item;
preferably: calculating the total number of suspicious combinations to be determined in all combinations to be determined, and prompting re-input if the total number is greater than a first number threshold;
preferably: the model name comprises model type information;
after a source system is accessed to a model cloud platform, a stock equipment model in the system is synchronized to the model cloud platform through a longitudinal synchronization device in a full-quantity mode and an increment mode;
preferably: before the model cloud platform is synchronized in a full-volume mode and an incremental mode, a source data end needs to verify a stock equipment model;
the checking comprises internal circulation, examination and approval and checking; problem records such as error records, garbage records and the like in the stock equipment model do not enter the model cloud platform; alternatively, the process requires manual involvement in inspection and verification;
preferably: the internal circulation comprises that according to the circulation sequence, after each stage or each department chamber maintains the model, the model is clicked to submit to be automatically circulated to the next stage or next department chamber, and finally submitted to a general auditor, the general auditor is provided with a checking tool for auxiliary auditing, after the auditing is passed, the model is written into an end database of a source data end, and a flag bit of a model record corresponding to the model is changed into effective; maintenance of the model is performed by a management workstation; the advanced user carries out configuration of the circulation sequence through the management workstation;
preferably: the check is based on uniqueness;
the uniqueness-based check specifically includes: creating a model identifier according to the model information; the longitudinal synchronization device stores a model identification mapping table and a model information table; the identification mapping table is used for storing the model identification which is longitudinally synchronized; the model information table is used for storing model identifications and corresponding model information; before synchronization, the source data terminal queries the model identifier mapping table to determine whether a model identifier needing synchronization exists in the identifier mapping table, and if so, further determines whether the model is deleted and reconstructed; otherwise, determining the model as a model corresponding to the newly added equipment; creating and filling new records in the identification mapping table and the model information table according to the model identification corresponding to the newly added equipment and the model information corresponding to the newly added equipment;
the judging whether the model is deleted reconstruction specifically includes: the judgment is carried out according to the connection relation between the model information and the equipment corresponding to the model; if the model information is the same and the connection relation is similar, judging that the model is deleted and reconstructed; updating the model information table according to the model information; otherwise, judging the model to be the original model without modifying the identification mapping table and the model information table;
preferably: the model information includes first information and second information; the first information comprises a model name, a source system type and a source system identifier; the second information includes extension information; during verification, the first information is completely unique information, and the second information is partially unique information;
preferably: the model information is the same, specifically: the first information is completely the same, and the second information is at least partially the same;
the power grid equipment model unified management system based on the regulation and control cloud architecture provided by the invention is introduced in detail above. The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.
It is further noted that, in the present specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The above description is only a preferred embodiment of the present invention, and all equivalent changes or modifications of the structure, characteristics and principles described in the present invention are included in the scope of the present invention.