CN111597166A - Power database model construction method, device, computer equipment and storage medium - Google Patents
Power database model construction method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111597166A CN111597166A CN202010410723.4A CN202010410723A CN111597166A CN 111597166 A CN111597166 A CN 111597166A CN 202010410723 A CN202010410723 A CN 202010410723A CN 111597166 A CN111597166 A CN 111597166A
- Authority
- CN
- China
- Prior art keywords
- power
- data
- model
- general
- grid
- 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
Images
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/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/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- 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)
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Public Health (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
Description
技术领域technical field
本申请涉及电力数据处理技术领域,特别是涉及一种电力数据库模型构建方法、装置、计算机设备和存储介质。The present application relates to the technical field of power data processing, and in particular, to a method, apparatus, computer equipment and storage medium for constructing a power database model.
背景技术Background technique
随着电力业务应用的不断发展,各电力部门的协同维护与信息共享的需求日益增强,而为了更好的管理电力信息,电力部门通常采用构建电网公共信息数据库的方式实现信息共享。例如,生产部门通常会对配网设备构建配网数据库以实现配网设备数据在其他电力部门,如营销部门的数据流通。With the continuous development of power business applications, the demand for collaborative maintenance and information sharing in various power departments is increasing. In order to better manage power information, power departments usually implement information sharing by building a public grid information database. For example, the production department usually builds a distribution network database for the distribution network equipment to realize the data flow of the distribution network equipment data in other power departments, such as the marketing department.
然而,目前不同的电力部门对电力信息的存储通常采用不同的存储方式,例如,生产部门与营销部门对配网设备的描述方式和存储字段格式并不相同,因此,难以构建电力信息统一化的电力数据库。However, at present, different power departments usually use different storage methods for the storage of power information. For example, the description methods and storage field formats of distribution network equipment are different between the production department and the marketing department. Therefore, it is difficult to build a unified power information system. Electricity database.
发明内容SUMMARY OF THE INVENTION
基于此,有必要针对上述技术问题,提供一种电力数据库模型构建方法、装置、计算机设备和存储介质。Based on this, it is necessary to provide a method, apparatus, computer equipment and storage medium for constructing a power database model in view of the above technical problems.
一种电力数据库模型构建方法,所述方法包括:A method for constructing a power database model, the method comprising:
获取多个电力业务系统采集的多个电力数据,以及所述多个电力数据的数据字段;acquiring multiple power data collected by multiple power service systems, and data fields of the multiple power data;
按照预设的字段映射表将所述数据字段转换为电网通用模型的通用字段;其中,所述字段映射表中存储有所述电力数据的数据字段与所述电网通用模型的通用字段之间的对应关系;The data fields are converted into general fields of the general grid model according to a preset field mapping table; wherein, the field mapping table stores the data fields of the power data and the general fields of the general grid model. Correspondence;
将所述电力数据按照所述通用字段写入所述电网通用模型,形成多个电网通用业务模型;Writing the power data into the general grid model according to the general field to form a plurality of general grid business models;
将所述多个电网通用业务模型的电力数据进行数据拼接,建立所述多个电网通用业务模型的关联关系;performing data splicing on the power data of the multiple power grid general business models, and establishing an association relationship of the multiple power grid general business models;
基于所述关联关系,构建电力数据库模型。Based on the association relationship, a power database model is constructed.
在其中一个实施例中,所述多个电网通用业务模型包括第一电网通用业务模型和第二电网通用业务模型;所述将所述多个电网通用业务模型的电力数据进行数据拼接,建立所述多个电网通用业务模型的关联关系,包括:获取拼接字段,以及所述拼接字段下的拼接数据;所述拼接字段为所述电网通用模型的通用字段中,用于对多个电网通用业务模型的电力数据进行数据拼接的字段;若所述第一电网通用业务模型中存储有与所述第二电网通用业务模型中存储的第二拼接数据相匹配的第一拼接数据,则将所述第一电网通用业务模型与所述第二电网通用业务模型进行数据拼接,建立所述第一电网通用业务模型与所述第二电网通用业务模型的关联关系。In one embodiment, the plurality of grid general business models include a first grid general business model and a second grid general business model; the power data of the plurality of grid general business models are data spliced to establish all the grid general business models. The association relationship of the multiple power grid general business models includes: obtaining a splicing field and splicing data under the splicing field; the splicing field is a general field of the power grid general model, used for multiple power grid general services The field for data splicing of the power data of the model; if the first splicing data that matches the second splicing data stored in the second grid general business model is stored in the first power grid general business model, the The first power grid general business model and the second power grid general business model are data spliced, and an association relationship between the first power grid general business model and the second power grid general business model is established.
在其中一个实施例中,所述拼接字段包括:所述电力数据对应的电力设备编码;所述电力设备编码包括第一电力设备编码和第二电力设备编码;所述若所述第一电网通用业务模型中存储有与所述第二电网通用业务模型中存储的第二拼接数据相匹配的第一拼接数据,则将所述第一电网通用业务模型与所述第二电网通用业务模型进行数据拼接,建立所述第一电网通用业务模型与所述第二电网通用业务模型的关联关系,包括:若所述第一电网通用业务模型中存储有与所述第二电网通用业务模型中存储的所述第二电力设备编码相同的所述第一电力设备编码,则将所述第一电网通用业务模型与所述第二电网通用业务模型进行数据拼接,建立所述第一电网通用业务模型与所述第二电网通用业务模型的关联关系。In one embodiment, the splicing field includes: a power device code corresponding to the power data; the power device code includes a first power device code and a second power device code; the if the first power grid is common The first splicing data that matches the second splicing data stored in the second power grid general business model is stored in the business model, and the first power grid general business model and the second power grid general business model are used for data analysis. splicing, and establishing an association relationship between the first power grid general business model and the second power grid general business model, including: if the first power grid general business model stores data stored in the second power grid general business model The code of the second power equipment is the same as the code of the first power equipment, then the data splicing of the general business model of the first power grid and the general business model of the second power grid is performed, and the general business model of the first power grid and the general business model of the power grid are established. The association relationship of the general business model of the second power grid.
在其中一个实施例中,所述拼接字段包括:所述电力数据对应的电力设备名称;所述电力设备名称包括第一电力设备名称和第二电力设备名称;所述若所述第一电网通用业务模型中存储有与所述第二电网通用业务模型中存储的第二拼接数据相匹配的第一拼接数据,则将所述第一电网通用业务模型与所述第二电网通用业务模型进行数据拼接,建立所述第一电网通用业务模型与所述第二电网通用业务模型的关联关系,包括:若所述第一电网通用业务模型中存储有与所述第二电网通用业务模型中存储的所述第二电力设备名称的关键字匹配的所述第一电力设备名称,则将所述第一电网通用业务模型与所述第二电网通用业务模型进行数据拼接,建立所述第一电网通用业务模型与所述第二电网通用业务模型的关联关系。In one embodiment, the splicing field includes: a name of an electric device corresponding to the electric power data; the name of the electric device includes a name of a first electric device and a name of a second electric device; the name of the electric device if the first power grid is common The first splicing data that matches the second splicing data stored in the second power grid general business model is stored in the business model, and the first power grid general business model and the second power grid general business model are used for data analysis. splicing, and establishing an association relationship between the first power grid general business model and the second power grid general business model, including: if the first power grid general business model stores data stored in the second power grid general business model For the first power device name that matches the keyword of the second power device name, the first power grid general business model and the second power grid general business model are data spliced to establish the first power grid general business model. The relationship between the business model and the general business model of the second power grid.
在其中一个实施例中,还包括:若所述字段映射表中未存储有与所述电力数据的数据字段对应的电网通用模型的通用字段,则将所述电力数据的数据字段作为所述电网通用模型的通用字段存储入所述字段映射表。In one of the embodiments, the method further includes: if the general field of the grid general model corresponding to the data field of the power data is not stored in the field mapping table, using the data field of the power data as the grid Common fields of the common model are stored in the field mapping table.
在其中一个实施例中,所述电力业务系统包括:电网调度系统、地理信息系统、生产系统、营销系统或计量自动化系统中的至少一种。In one of the embodiments, the power service system includes at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system or a metering automation system.
在其中一个实施例中,所述电力数据包括:主网模型数据、第一地理信息数据、第二地理信息数据、生产数据、营销数据或电力计量数据中的至少一种;所述获取多个电力业务系统采集的多个电力数据,包括:按照调度系统文件传输协议从所述电网调度系统中获取所述主网模型数据;通过数据同步抽取方式从所述地理信息系统中获取所述第一地理信息数据,以及通过监听系统监听所述地理信息系统的电子化移交接口,获取所述第二地理信息数据;通过总部数据中心的数据复制工具从所述生产系统的生产数据库中获取所述生产数据,以及从所述营销系统的营销数据库中获取所述营销数据;和/或按照计量系统文件传输协议从所述计量自动化系统中获取所述电力计量数据。In one embodiment, the power data includes: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data or power metering data; the acquiring multiple The multiple power data collected by the power service system includes: acquiring the main network model data from the power grid dispatching system according to the dispatching system file transfer protocol; acquiring the first data from the geographic information system by means of data synchronization extraction Geographic information data, and monitoring the electronic handover interface of the geographic information system through the monitoring system to obtain the second geographic information data; obtaining the production data from the production database of the production system through the data replication tool of the headquarters data center data, and obtaining the marketing data from a marketing database of the marketing system; and/or obtaining the electricity metering data from the metering automation system in accordance with a metering system file transfer protocol.
一种电力数据库模型构建装置,所述装置包括:An apparatus for constructing a power database model, the apparatus comprising:
电力数据获取模块,用于获取多个电力业务系统采集的多个电力数据,以及所述多个电力数据的数据字段;an electric power data acquisition module, configured to acquire a plurality of electric power data collected by a plurality of electric power service systems, and data fields of the plurality of electric power data;
通用字段转换模块,用于按照预设的字段映射表将所述数据字段转换为电网通用模型的通用字段;其中,所述字段映射表中存储有所述电力数据的数据字段与所述电网通用模型的通用字段之间的对应关系;A general field conversion module, configured to convert the data field into a general field of the grid general model according to a preset field mapping table; wherein, the data field storing the power data in the field mapping table is general to the grid The correspondence between the common fields of the model;
通用模型写入模块,用于将所述电力数据按照所述通用字段写入所述电网通用模型,形成多个电网通用业务模型;a general model writing module, configured to write the power data into the general grid model according to the general field to form a plurality of general grid business models;
电力数据拼接模块,用于将所述多个电网通用业务模型的电力数据进行数据拼接,建立所述多个电网通用业务模型的关联关系;a power data splicing module, configured to perform data splicing on the power data of the multiple power grid general business models, and establish an association relationship of the multiple power grid general business models;
电力模型构建模块,用于基于所述关联关系,构建电力数据库模型。The power model building module is used for building a power database model based on the association relationship.
一种计算机设备,包括存储器和处理器,所述存储器存储有计算机程序,所述处理器执行所述计算机程序时实现上述方法的步骤。A computer device includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method when the processor executes the computer program.
一种计算机可读存储介质,其上存储有计算机程序,所述计算机程序被处理器执行时实现上述的方法的步骤。A computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, implements the steps of the above-mentioned method.
上述电力数据库模型构建方法、装置、计算机设备和存储介质,获取多个电力业务系统采集的多个电力数据,以及多个电力数据的数据字段;按照预设的字段映射表将数据字段转换为电网通用模型的通用字段;其中,字段映射表中存储有电力数据的数据字段与电网通用模型的通用字段之间的对应关系;将电力数据按照通用字段写入电网通用模型,形成多个电网通用业务模型;将多个电网通用业务模型的电力数据进行数据拼接,建立多个电网通用业务模型的关联关系;基于关联关系,构建电力数据库模型。本申请通过将多个电力业务系统采集的电力数据的数据字段转换为电网通用模型的通用字段,形成电网通用业务模型后通过数据拼接的方式建立通用业务模型的关联关系,并基于关联关系构建电力数据库,从而实现电力信息统一化的电力数据库的构建。The above power database model construction method, device, computer equipment and storage medium, obtain multiple power data collected by multiple power business systems, and data fields of multiple power data; convert the data fields into power grids according to a preset field mapping table The general field of the general model; wherein, the field mapping table stores the corresponding relationship between the data field of the power data and the general field of the grid general model; the power data is written into the grid general model according to the general field to form multiple grid general services Model; splicing the power data of multiple power grid general business models to establish the association relationship of multiple power grid general business models; based on the association relationship, build a power database model. The present application converts the data fields of the power data collected by multiple power business systems into the common fields of the power grid general model, after forming the power grid general business model, the association relationship of the general business model is established by data splicing, and the power grid is constructed based on the association relationship. Database, so as to realize the construction of a unified power database of power information.
附图说明Description of drawings
图1为一个实施例中电力数据库模型构建方法的流程示意图;1 is a schematic flowchart of a method for constructing a power database model in one embodiment;
图2为一个实施例中将所述多个电网通用业务模型的电力数据进行数据拼接,建立所述多个电网通用业务模型的关联关系的流程示意图;2 is a schematic flowchart of data splicing of the power data of the multiple power grid general business models to establish the association relationship of the multiple power grid common business models in one embodiment;
图3为另一个实施例中电力数据库模型构建方法的流程示意图;3 is a schematic flowchart of a method for constructing a power database model in another embodiment;
图4为一个应用示例中基于CIM的电网资源服务设计方法的流程示意图;4 is a schematic flowchart of a CIM-based grid resource service design method in an application example;
图5为一个应用示例中接入电网调度系统、GIS平台、生产数据库、营销数据库、计量自动化系统中的数据的流程示意图;FIG. 5 is a schematic flow chart of accessing data in a power grid dispatching system, a GIS platform, a production database, a marketing database, and a metering automation system in an application example;
图6为一个实施例中电力数据库模型构建装置的结构框图;6 is a structural block diagram of an apparatus for constructing a power database model in one embodiment;
图7为一个实施例中计算机设备的内部结构图。FIG. 7 is a diagram of the internal structure of a computer device in one embodiment.
具体实施方式Detailed ways
为了使本申请的目的、技术方案及优点更加清楚明白,以下结合附图及实施例,对本申请进行进一步详细说明。应当理解,此处描述的具体实施例仅仅用以解释本申请,并不用于限定本申请。In order to make the purpose, technical solutions and advantages of the present application more clearly understood, the present application will be described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application.
在一个实施例中,如图1所示,提供了一种电力数据库模型构建方法,本实施例以该方法应用于电力系统服务器进行举例说明,可以理解的是,该方法也可以应用于电力系统终端,还可以应用于包括终端和服务器的系统,并通过终端和服务器的交互实现。本实施例中,该方法包括以下步骤:In one embodiment, as shown in FIG. 1 , a method for constructing a power database model is provided. In this embodiment, the method is applied to a power system server as an example. It can be understood that the method can also be applied to a power system. The terminal can also be applied to a system including a terminal and a server, and is realized through interaction between the terminal and the server. In this embodiment, the method includes the following steps:
步骤S101,电力系统服务器获取多个电力业务系统采集的多个电力数据,以及多个电力数据的数据字段。Step S101, the power system server acquires multiple power data collected by multiple power service systems, and data fields of the multiple power data.
其中,电力数据为电力业务系统采集的数据,可以是某个电力业务系统所使用的变压器的工作电压或者变压器型号以及变压器的购置成本等等,而电力数据的数据字段则是上述电力数据在该电力业务系统中存储的数据字段。例如:电力业务系统中存储有变压器A的工作电压为a1,型号为a2以及购置成本为a3,变压器B的工作电压为b1,型号为b2以及购置成本为b3,那么电力业务系统则存储有电力数据a1、a2、a3、b1、b2、b3,存储的电力数据的数据字段则包括有工作电压、型号以及购置成本。Among them, the power data is the data collected by the power service system, which can be the working voltage of the transformer used by a power service system or the model of the transformer and the purchase cost of the transformer, etc., and the data field of the power data is the above-mentioned power data. Data fields stored in the power business system. For example, if the working voltage of transformer A is a1, the model is a2 and the purchase cost is a3, the working voltage of transformer B is b1, the model is b2 and the purchase cost is b3, then the power service system stores the power Data a1, a2, a3, b1, b2, b3, and the data fields of the stored power data include operating voltage, model, and purchase cost.
步骤S102,电力系统服务器按照预设的字段映射表将数据字段转换为电网通用模型的通用字段;其中,字段映射表中存储有电力数据的数据字段与电网通用模型的通用字段之间的对应关系。Step S102, the power system server converts the data fields into the general fields of the general grid model according to the preset field mapping table; wherein, the field mapping table stores the correspondence between the data fields of the power data and the general fields of the general grid model .
其中,电网通用模型可以是南方电网公司颁布的企业公共信息模型,包含了电网资源、设备、客户、量测等核心数据模型标准规范,存储有对应的通用字段。由于不同业务系统采用的电力数据的数据字段有可能并不相同,电力系统服务器可以通过预存的存储有电力数据的数据字段与电网通用模型的通用字段之间的对应关系的字段映射表,将多个电力业务系统中不同的电力数据的数据字段转换为统一的电网通用模型的通用字段。The power grid general model may be an enterprise public information model promulgated by China Southern Power Grid Corporation, which includes standard specifications for core data models such as power grid resources, equipment, customers, and measurements, and stores corresponding common fields. Since the data fields of the power data used by different business systems may be different, the power system server can use the pre-stored field mapping table that stores the correspondence between the data fields of the power data and the general fields of the general model of the power grid. The data fields of different power data in each power business system are converted into common fields of a unified grid general model.
例如:同样是某个变压器的生产厂家,对于电力业务系统A,所采用的数据字段可以为生产厂家,而对于电力业务系统B而言,采用的数据字段则可能是变压器厂家,两个电力业务系统虽然都是针对变压器的生产厂家数据进行记录,却采用了不同的数据字段。此时,电力系统服务器则可以通过字段映射表将不同的数据字段转换为电网通用模型的通用字段,该通用字段可以是变压器生产厂家,那么字段映射表则存储有生产厂家与变压器生产厂家字段的映射以及变压器厂家与变压器生产厂家字段之间的映射,从而实现将电力业务系统A的生产厂家以及电力业务系统B中的变压器厂家都转化为电网通用模型的通用字段变压器生产厂家。For example: the same manufacturer of a certain transformer, for the power service system A, the data field used may be the manufacturer, while for the power service system B, the data field used may be the transformer manufacturer, and the two power services Although the system records the data of the manufacturer of the transformer, it uses different data fields. At this time, the power system server can convert different data fields into common fields of the general model of the power grid through the field mapping table. The common field can be the transformer manufacturer, and the field mapping table stores the fields of the manufacturer and the transformer manufacturer. Mapping and mapping between transformer manufacturer and transformer manufacturer fields, so as to convert the manufacturer of power business system A and the transformer manufacturer in power business system B into the general field transformer manufacturer of the power grid general model.
步骤S103,电力系统服务器将电力数据按照通用字段写入电网通用模型,形成多个电网通用业务模型。Step S103, the power system server writes the power data into the general grid model according to the general field to form a plurality of general grid business models.
具体地,电力业务系统中的数据字段转换为电网通用模型的通用字段后,电力系统服务器可以按照通用字段模型将对应的电力数据写入电网通用模型中,例如将电力业务系统A中生产厂家字段下存储的电力数据写入电网通用模型中变压器生产厂家的这一通用字段下。Specifically, after the data fields in the power business system are converted into the common fields of the power grid general model, the power system server can write the corresponding power data into the power grid general model according to the common field model, for example, the manufacturer field in the power business system A The stored power data is written under this general field of the transformer manufacturer in the general model of the power grid.
步骤S104,电力系统服务器将多个电网通用业务模型的电力数据进行数据拼接,建立多个电网通用业务模型的关联关系。In step S104, the power system server performs data splicing of the power data of the multiple grid general business models, and establishes an association relationship of the multiple grid general business models.
电网通用业务模型的关联关系指的是不同电网通用业务模型之间数据的关联关系,具体来说,某个电力数据可以存储于不同的两个电力业务系统中,例如:某个变压器的变压器数据可能部分存储于电力业务系统A,如生产系统中,也可以部分存储于电力业务系统B,如营销系统中,而变压器的编号已经通过步骤S103将可能存在的生产系统以及营销系统进行数据字段统一化,因此电力系统服务器可以将统一化数据字段后的变压器数据按照相同的变压器编号进行相关数据拼接,从而建立起生产系统以及营销系统之间的关联关系。The relationship of the general business model of the power grid refers to the relationship of data between different general business models of the power grid. Specifically, a certain power data can be stored in two different power business systems, for example: the transformer data of a certain transformer It may be partially stored in the power business system A, such as the production system, or partially stored in the power business system B, such as the marketing system, and the number of the transformer has been unified through the data fields of the production system and the marketing system that may exist in step S103. Therefore, the power system server can splicing the relevant data of the transformer data after the unified data field according to the same transformer number, so as to establish the relationship between the production system and the marketing system.
步骤S105,电力系统服务器基于关联关系,构建电力数据库模型。Step S105, the power system server builds a power database model based on the association relationship.
步骤S104中电力系统服务器得到多个电力业务系统的关联关系后,可以基于上述关联关系,对电力数据库模型进行构建,例如可以根据生产系统与营销系统的对应关系,构建对应的生产营销模型,从而成功构建了既包含生产系统数据又包含营销系统数据的生产营销模型,作为电力信息统一化的电力数据库的信息模型。In step S104, after the power system server obtains the association relationships of the plurality of electric power business systems, it can construct a power database model based on the above association relationships. For example, a corresponding production and marketing model can be constructed according to the correspondence between the production system and the marketing system, thereby A production and marketing model including both production system data and marketing system data has been successfully constructed, as the information model of the power database for the unified power information.
上述电力数据库模型构建方法中,电力系统服务器获取多个电力业务系统采集的多个电力数据,以及多个电力数据的数据字段;按照预设的字段映射表将数据字段转换为电网通用模型的通用字段;其中,字段映射表中存储有电力数据的数据字段与电网通用模型的通用字段之间的对应关系;将电力数据按照通用字段写入电网通用模型,形成多个电网通用业务模型;将多个电网通用业务模型的电力数据进行数据拼接,建立多个电网通用业务模型的关联关系;基于关联关系,构建电力数据库模型。本申请通过电力系统服务器将多个电力业务系统采集的电力数据的数据字段转换为电网通用模型的通用字段,形成电网通用业务模型后通过数据拼接的方式建立通用业务模型的关联关系,并基于关联关系构建电力数据库,从而实现电力信息统一化的电力数据库的构建。In the above method for constructing a power database model, the power system server obtains multiple power data collected by multiple power service systems, and data fields of the multiple power data; and converts the data fields into the general power grid model according to the preset field mapping table. fields; wherein, the corresponding relationship between the data fields of the power data stored in the field mapping table and the general fields of the power grid general model is stored; the power data is written into the power grid general model according to the common fields to form multiple power grid general business models; The power data of each power grid general business model is spliced, and the association relationship of multiple power grid general business models is established; based on the association relationship, a power database model is constructed. The present application converts the data fields of the power data collected by multiple power business systems into the common fields of the general grid model through the power system server, and after forming the general business model of the power grid, establishes the association relationship of the general business model by means of data splicing, and based on the association The power database is constructed by relational relationship, so as to realize the construction of the power database with the unified power information.
在一个实施例中,如图2所示,多个电网通用业务模型可以包括第一电网通用业务模型和第二电网通用业务模型,步骤S104可以包括:In one embodiment, as shown in FIG. 2 , the multiple grid general business models may include a first grid general business model and a second grid general business model, and step S104 may include:
步骤S201,电力系统服务器获取拼接字段,以及拼接字段下的拼接数据;拼接字段为电网通用模型的通用字段中,用于对多个电网通用业务模型的电力数据进行数据拼接的字段;Step S201, the power system server obtains the splicing field and the splicing data under the splicing field; the splicing field is a field in the general fields of the general power grid model, used to perform data splicing on the power data of a plurality of general business models of the power grid;
其中,拼接字段为电网通用模型的通用字段中,用于对多个电网通用业务模型的电力数据进行数据拼接的字段。具体地,拼接字段可以通过电力系统服务器根据不同的电力业务系统进行相关选取,例如:对于生产系统与营销系统而言,拼接字段可以选取为共有的设备编号等,作为用于对生产系统与营销系统形成的电网通用业务模型的电力数据进行数据拼接的字段。Wherein, the splicing field is a field used for data splicing of the power data of the multiple grid general business models among the general fields of the power grid general model. Specifically, the splicing field can be selected according to different power business systems through the power system server. For example, for the production system and the marketing system, the splicing field can be selected as a common equipment number, etc. The field for data splicing of the power data of the grid general business model formed by the system.
步骤S202,若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二拼接数据相匹配的第一拼接数据,则电力系统服务器将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系。Step S202, if the first power grid general service model stores the first splicing data that matches the second stitching data stored in the second power grid general service model, the power system server compares the first power grid general service model with the second power grid. The general business model performs data splicing to establish an association relationship between the first power grid general business model and the second power grid general business model.
步骤S201中电力系统服务器得到拼接字段后,首先可以从该拼接字段中分别从电力业务系统A转化得到的第一电网通用业务模型中提取该拼接字段下的电力数据,作为第一拼接数据,同时从电力业务系统B转化得到的第二电网通用业务模型中提取该接字段下的电力数据,作为第二拼接数据,如果存在第二拼接数据与第一拼接数据相匹配,则基于该拼接数据对第一电网通用业务模型以及第二电网通用业务模型中存储的数据进行数据拼接,从而建立起第一电网通用业务模型与第二电网通用业务模型的关联关系。In step S201, after the power system server obtains the splicing field, firstly, the power data under the splicing field can be extracted from the first power grid general business model transformed from the power service system A from the splicing field, as the first splicing data, and at the same time. The power data under the connection field is extracted from the second power grid general business model transformed by the power service system B as the second splicing data. If the second splicing data matches the first splicing data, then based on the splicing data, the The data stored in the general business model of the first power grid and the data stored in the general business model of the second power grid are spliced to establish an association relationship between the general business model of the first power grid and the general business model of the second power grid.
进一步地,拼接字段可以包括:电力数据对应的电力设备编码;电力设备编码包括第一电力设备编码和第二电力设备编码,步骤S202可以进一步包括:Further, the splicing field may include: a power device code corresponding to the power data; the power device code includes a first power device code and a second power device code, and step S202 may further include:
若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二电力设备编码相同的第一电力设备编码,则电力系统服务器将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系。If the first power grid general service model stores the same first power equipment code as the second power equipment code stored in the second power grid general service model, the power system server stores the first power grid general service model with the second power grid general service model. The model performs data splicing, and establishes an association relationship between the general business model of the first power grid and the general business model of the second power grid.
电力系统服务器采取的拼接字段可以是电力数据对应的电力设备编码,对于变压器设备而言,则可以采用变压器编码的形式进行多个电网通用业务模型之间的数据拼接。具体来说,电力系统服务器可以从第一电网通用业务模型中提取出存储于第一电网通用业务模型中所有的变压器设备的第一变压器编码,同时从第二电网通用业务模型中提取出存储于第二电网通用业务模型中所有的变压器设备的第二变压器编码,从第一变压器编码中选取出与第二变压器编码相同的第一变压器编码,作为用于数据拼接的电力数据,并从第一电网通用业务模型中选取与第一变压器编码对应的电力数据与第二电网通用业务模型中第二变压器编码对应的电力数据进行数据拼接,从而建立起第一电网通用业务模型与第二电网通用业务模型。The splicing field adopted by the power system server may be the code of the power equipment corresponding to the power data. For the transformer equipment, the form of the transformer code may be used to perform data splicing between multiple general business models of the power grid. Specifically, the power system server may extract the first transformer codes of all transformer equipment stored in the first power grid general business model from the first power grid general business model, and extract the first power grid codes stored in the second power grid general business model from the second power grid general business model. For the second transformer codes of all transformer devices in the second power grid general business model, select the first transformer codes that are the same as the second transformer codes from the first transformer codes, and use them as power data for data splicing. The power data corresponding to the first transformer code in the power grid general business model and the power data corresponding to the second transformer code in the second power grid general business model are selected for data splicing, thereby establishing the first power grid general business model and the second power grid general business. Model.
而对于无法用数字编码形式只能通过文字进行表示的电力数据,例如,拼接字段还可以包括,电力数据对应的电力设备名称,电力设备名称还可以包括第一电力设备名称和第二电力设备名称,那么步骤S202还可以进一步包括:As for the power data that cannot be represented in the form of digital encoding but can only be represented by text, for example, the splicing field may also include the name of the power device corresponding to the power data, and the name of the power device may also include the name of the first power device and the name of the second power device , then step S202 may further include:
若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二电力设备名称的关键字匹配的所述第一电力设备名称,则将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系。If the first power grid general business model stores the first power equipment name that matches the keyword of the second power equipment name stored in the second power grid general business model, then the first power grid general business model is stored with the second power grid. The general business model performs data splicing to establish an association relationship between the first power grid general business model and the second power grid general business model.
具体地,电力系统服务器可以从第一电网通用业务模型中提取出第一电力设备名称,并提取出第一电力设备名称中的关键字,通过关键字模糊匹配的方式,选取与第一电力设备名称关键字匹配的第二电力设备名称,并基于该设备名称对第一电网通用业务模型与第二电网通用业务模型进行数据拼接,进而建立第一电网通用业务模型与第二电网通用业务模型的关联关系。Specifically, the power system server can extract the name of the first power equipment from the general business model of the first power grid, and extract the keywords in the name of the first power equipment, and select the name of the first power equipment by means of fuzzy matching of keywords. The name of the second power equipment that matches the name keyword, and based on the device name, data splicing is performed on the general business model of the first power grid and the general business model of the second power grid, and then the general business model of the first power grid and the general business model of the second power grid are established. connection relation.
上述实施例中,电力系统服务器实现了基于统一的电网通用模型的通用字段对不同电网通用业务模型存储的电力数据进行数据拼接,进而建立起了多个电网通用业务模型的关联关系,另外,还通过选取不同拼接字段以及不同的拼接方式,提供了多种数据拼接方式,进一步提高了构建电力数据库模型的可实现性。In the above embodiment, the power system server implements data splicing of power data stored in different grid general business models based on the general fields of the unified grid general model, thereby establishing an association relationship between multiple grid general business models. By selecting different splicing fields and different splicing methods, a variety of data splicing methods are provided, which further improves the achievability of building a power database model.
在一个实施例中,若字段映射表中未存储有与电力数据的数据字段对应的电网通用模型的通用字段,则电力系统服务器将电力数据的数据字段作为电网通用模型的通用字段存储入字段映射表。In one embodiment, if the general field of the general grid model corresponding to the data field of the power data is not stored in the field mapping table, the power system server stores the data field of the power data as the general field of the general grid model into the field map surface.
由于字段映射表是用于电力数据的数据字段与电网通用模型的通用字段之间的对应关系的映射表,因此可能存在映射表中欠缺与某个电力数据的数据字段对应的电网通用模型的通用字段的情况。因此在这种情形下,电力系统服务器可以将映射表中欠缺的电力数据的数据字段直接作为电网通用模型的通用字段,并将该字段存储入字段映射表中,同时将该数据字段的电力数据写入电网通用模型中新增的通用字段下。Since the field mapping table is a mapping table used for the correspondence between the data fields of the power data and the general fields of the general power grid model, there may be a general lack of the general power grid model corresponding to the data field of a certain power data in the mapping table. field conditions. Therefore, in this case, the power system server can directly use the data field of the missing power data in the mapping table as the common field of the grid general model, and store the field in the field mapping table, and at the same time, the power data of the data field can be stored in the field mapping table. Write under the new general field in the general model of the grid.
上述实施例,通过将字段映射表中未包含的电力数据的数据字段写入字段映射表中,实现了将该数据字段下的电力数据也可写入对应的电网通用模型,保证了电力数据的完整性,从而保证了构建的电力数据库模型的数据完整性。In the above embodiment, by writing the data field of the power data not included in the field mapping table into the field mapping table, it is realized that the power data under the data field can also be written into the corresponding power grid general model, and the power data is guaranteed. Integrity, thus ensuring the data integrity of the constructed power database model.
在一个实施例中,电力业务系统包括:电网调度系统、地理信息系统、生产系统、营销系统或计量自动化系统中的至少一种。In one embodiment, the power business system includes at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system, or a metering automation system.
其中,电网调度系统主要用于采集主网信息,并对主网信息进行数据监控以及安全分析等等,地理信息系统,即为GIS系统,主要是用于采集地理位置信息,例如电力设备的位置等等,而生产系统以及营销系统则分别存储了电力设备的生产信息以及营销信息,例如物理设备信息以及客户信息等,计量自动化系统则存储了计量信息,用于记录描述客户与电能表的计量关系信息。Among them, the power grid dispatching system is mainly used to collect the main network information, data monitoring and security analysis of the main network information, etc. The geographic information system, namely the GIS system, is mainly used to collect geographic location information, such as the location of power equipment And so on, while the production system and marketing system store the production information and marketing information of power equipment, such as physical equipment information and customer information, etc., while the metering automation system stores metering information, which is used to record and describe the measurement of customers and electric energy meters. relationship information.
进一步地,电力数据可以包括:主网模型数据、第一地理信息数据、第二地理信息数据、生产数据、营销数据或电力计量数据中的至少一种;步骤S101,可以进一步包括:电力系统服务器按照调度系统文件传输协议从电网调度系统中获取主网模型数据;通过数据同步抽取方式从地理信息系统中获取第一地理信息数据,以及通过监听系统监听地理信息系统的电子化移交接口,获取第二地理信息数据;通过总部数据中心的数据复制工具从生产系统的生产数据库中获取生产数据,以及从营销系统的营销数据库中获取营销数据;和/或按照计量系统文件传输协议从计量自动化系统中获取电力计量数据。Further, the power data may include: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data or power metering data; step S101, may further include: a power system server Obtain the main network model data from the power grid dispatching system according to the dispatching system file transfer protocol; obtain the first geographic information data from the geographic information system through data synchronization extraction, and monitor the electronic handover interface of the geographic information system through the monitoring system to obtain the first geographic information data. 2. Geographic information data; obtain production data from the production database of the production system through the data replication tool of the headquarters data center, and obtain marketing data from the marketing database of the marketing system; and/or from the metering automation system in accordance with the metering system file transfer protocol Get power metering data.
其中,第一地理信息数据代表从地理信息系统中首期获取的地理信息数据,而第二地理信息数据则代表从地理信息系统中后期获取的地理信息数据。具体来说,电力系统服务器可以分别通过不同的方式从不同的电力业务系统中获取多种电力数据,例如,可通过文件传输协议方式(FTP),以读取E文件的方式对电网调度系统的主网信息以及计量自动化系统的计量信息进行获取更新;通过数据同步抽取的方式从GIS平台中读取首期GIS数据,并通过监听系统监听电子化移交接口,同步获取后期GIS数据;还可以通过总部数据中心的数据复制工具从生产系统的生产数据库中获取生产数据,以及从营销系统的营销数据库中获取营销数据。The first geographic information data represents the geographic information data acquired from the geographic information system in the first phase, and the second geographic information data represents the geographic information data acquired from the geographic information system in the later period. Specifically, the power system server can obtain various power data from different power business systems in different ways. The main network information and the metering information of the metering automation system are obtained and updated; the first-phase GIS data is read from the GIS platform through data synchronization extraction, and the electronic handover interface is monitored through the monitoring system to obtain the later GIS data synchronously; The data replication tool of the headquarters data center obtains production data from the production database of the production system, and obtains the marketing data from the marketing database of the marketing system.
上述实施例中,电力系统服务器分别获取不同电力业务系统采集的电力数据,并在此基础上运用不同的数据获取方式从不同电力业务系统同步获取电力数据,有利于提高得到的电力数据的实时性以及准确性,进而可以提高构建的电力数据库存储的电力数据的准确性。In the above embodiment, the power system server obtains the power data collected by different power service systems respectively, and on this basis, uses different data acquisition methods to obtain power data synchronously from different power service systems, which is beneficial to improve the real-time performance of the obtained power data. and accuracy, thereby improving the accuracy of the power data stored in the constructed power database.
在一个实施例中,如图3所示,提供了一种电力数据库模型构建方法,本实施例以该方法应用于电力系统服务器进行举例说明,本实施例中,该方法包括以下步骤:In one embodiment, as shown in FIG. 3, a method for constructing a power database model is provided. This embodiment is illustrated by applying the method to a power system server. In this embodiment, the method includes the following steps:
步骤S301,电力系统服务器获取多个电力业务系统采集的多个电力数据,以及多个电力数据的数据字段;Step S301, the power system server acquires multiple power data collected by multiple power service systems, and data fields of multiple power data;
步骤S302,电力系统服务器按照预设的字段映射表将数据字段转换为电网通用模型的通用字段;其中,字段映射表中存储有电力数据的数据字段与电网通用模型的通用字段之间的对应关系;Step S302, the power system server converts the data fields into the general fields of the general grid model according to the preset field mapping table; wherein, the field mapping table stores the correspondence between the data fields of the power data and the general fields of the general grid model ;
步骤S303,若字段映射表中未存储有与电力数据的数据字段对应的电网通用模型的通用字段,则电力系统服务器将电力数据的数据字段作为电网通用模型的通用字段存储入字段映射表;Step S303, if the general field of the grid general model corresponding to the data field of the power data is not stored in the field mapping table, the power system server stores the data field of the power data as the general field of the grid general model into the field mapping table;
步骤S304,电力系统服务器将电力数据按照通用字段写入电网通用模型,形成多个电网通用业务模型;Step S304, the power system server writes the power data into the general grid model according to the general field to form a plurality of general grid business models;
步骤S305,电力系统服务器获取拼接字段,以及拼接字段下的拼接数据;拼接字段为所述电网通用模型的通用字段中,用于对多个电网通用业务模型的电力数据进行数据拼接的字段;拼接字段包括:电力数据对应的电力设备编码以及电力数据对应的电力设备名称;Step S305, the power system server obtains the splicing field and the splicing data under the splicing field; the splicing field is a field in the general fields of the general power grid model, which is used to perform data splicing on the power data of a plurality of general business models of the power grid; splicing The fields include: the power device code corresponding to the power data and the power device name corresponding to the power data;
步骤S306,若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二电力设备编码相同的第一电力设备编码,则电力系统服务器将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系;Step S306, if the first power grid general business model stores the first power equipment code that is the same as the second power equipment code stored in the second power grid general business model, the power system server compares the first power grid general business model with the second power equipment code. The grid general business model performs data splicing, and establishes an association relationship between the first grid general business model and the second grid general business model;
步骤S307,若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二电力设备名称的关键字匹配的第一电力设备名称,则电力系统服务器将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系;Step S307, if the first power grid general business model stores a first power equipment name that matches the keyword of the second power equipment name stored in the second power grid general business model, the power system server stores the first power grid general business model. performing data splicing with the general business model of the second power grid to establish an association relationship between the general business model of the first power grid and the general business model of the second power grid;
步骤S308,基于关联关系,电力系统服务器构建电力数据库模型。Step S308, based on the association relationship, the power system server builds a power database model.
上述实施例提供的电力数据库模型构建方法,电力系统服务器通过将多个电力业务系统采集的电力数据的数据字段转换为电网通用模型的通用字段,形成电网通用业务模型后通过数据拼接的方式建立通用业务模型的关联关系,并基于关联关系构建电力数据库,从而实现电力信息统一化的电力数据库的构建。另外,还通过选取不同拼接字段以及不同的拼接方式,提供了多种数据拼接方式,进一步提高了构建电力数据库模型的可实现性以及过将字段映射表中未包含的电力数据的数据字段写入字段映射表中,实现了将该数据字段下的电力数据也可写入对应的电网通用模型,保证了电力数据的完整性,从而保证了构建的电力数据库模型的数据完整性。In the method for constructing a power database model provided by the above embodiment, the power system server converts the data fields of the power data collected by multiple power business systems into the common fields of the power grid general model, and then forms the power grid general business model by data splicing. The relationship between the business model and the power database are constructed based on the relationship, so as to realize the construction of a power database with unified power information. In addition, by selecting different splicing fields and different splicing methods, a variety of data splicing methods are provided, which further improves the achievability of building a power database model and writes the data fields of power data that are not included in the field mapping table. In the field mapping table, the power data under the data field can also be written into the corresponding power grid general model, which ensures the integrity of the power data and thus the data integrity of the constructed power database model.
在一个应用示例中,提供了一种基于CIM的电网资源服务设计方法,如图4所示,该应用示例可以包括如下步骤:In an application example, a CIM-based grid resource service design method is provided, as shown in Figure 4, the application example may include the following steps:
步骤s1,接入电网调度系统、GIS平台、生产数据库、营销数据库、计量自动化系统中的数据,包括:从调度系统中获取主网模型数据,从GIS平台中获取输电、中低压设备图层和属性数据,从生产数据库中获取功能位置和物理设备数据,从营销数据库中获取客户、计量点、电能表数据,从计量自动化系统中获取户、表、终端关系数据。Step s1, access the data in the grid dispatching system, GIS platform, production database, marketing database, and metering automation system, including: obtaining the main network model data from the dispatching system, and obtaining power transmission, medium and low voltage equipment layers and layers from the GIS platform. Attribute data, obtain functional location and physical equipment data from the production database, obtain customer, metering point, energy meter data from the marketing database, and obtain household, meter, and terminal relationship data from the metering automation system.
具体地,如图5所示,调度系统中的调度模型数据与计量自动化系统中的计量模型数据,通过FTP读取E文件的方式进行获取更新;GIS平台中的GIS数据首期通过数据库进行同步获取,后期通过SOA监听电子化移交接口,实现实时同步获取;生产与营销数据通过总部数据中心的OGG复制进行同步获取,数据均接入电网资源模型数据库中。Specifically, as shown in Figure 5, the scheduling model data in the scheduling system and the metering model data in the metering automation system are obtained and updated by reading the E file through FTP; the GIS data in the GIS platform is first synchronized through the database In the later stage, the electronic handover interface is monitored through SOA to achieve real-time synchronous acquisition; production and marketing data are synchronously acquired through OGG replication in the headquarters data center, and the data are all connected to the power grid resource model database.
步骤s2,对模型数据进行转换,消除不同数据源之间数据语义和格式的差异,包括:将主网模型数据转换为主网电网资源,将输电、中低压设备图层和属性数据转换为输电、中低压电网资源,将功能位置和物理设备数据转换为电网资源和设备资产,将客户、计量点、电能表数据转换为客户、计量点、电能表模型,将户、表、终端关系数据转换为采集终端、计量点模型。Step s2, convert the model data to eliminate differences in data semantics and formats between different data sources, including: converting the main network model data into main network power grid resources, and converting power transmission, medium and low voltage equipment layers and attribute data into power transmission , medium and low voltage grid resources, convert functional location and physical equipment data into grid resources and equipment assets, convert customer, metering point, energy meter data into customer, metering point, energy meter models, and convert household, meter, terminal relationship data Models for collection terminals and measurement points.
具体地,调度系统中的CIM文件经过初始化和增量同步程序,转换为变电站及设备(含输电线路)的CIM数据表,CIM中的测点转换为测点表,存入CIM库;GIS系统中的配电线路、输电线路、配电站房内部设备、低压线路和落火点,推送到GIS图层表中,通过存储过程转换到CIM库中;生产、营销数据通过存储过程,转换到CIM库中。Specifically, the CIM file in the dispatching system is converted into a CIM data table of substations and equipment (including transmission lines) through initialization and incremental synchronization procedures, and the measuring points in the CIM are converted into a measuring point table, which is stored in the CIM database; GIS system The distribution lines, transmission lines, internal equipment, low-voltage lines and fire-fall points in the distribution station are pushed to the GIS layer table, and converted to the CIM database through stored procedures; production and marketing data are converted to in the CIM library.
步骤s3,对调度数据、GIS数据、生产数据、营销数据、计量数据进行匹配、拼接。经过模型转换后形成符合统一信息融合语义和格式要求的模型,以名称和ID实现在全网统一模型上的挂接。Step s3, matching and splicing scheduling data, GIS data, production data, marketing data, and measurement data. After model conversion, a model that meets the requirements of unified information fusion semantics and format is formed, and the connection to the unified model of the whole network is realized by name and ID.
具体地,分别实现主网调度和生产的电网资源对应,主网变电站和配网馈线间的拓扑拼接,GIS配变与营销的中压用户,落火点下的表计信息与营销的低压用户进行关联,打通调度、配网、营销的拓扑关系,建立主变、线路、配变与计量自动化的测量点关系。Specifically, the grid resources corresponding to the main network scheduling and production, the topology splicing between the main network substations and the distribution network feeders, the medium-voltage users of GIS distribution transformers and marketing, the metering information under the fire point and the low-voltage users of marketing are realized respectively. Carry out correlation, open up the topological relationship of scheduling, distribution network, and marketing, and establish the relationship between measurement points of main transformer, line, distribution transformer and metering automation.
步骤s4,构建电网统一资源模型。基于IEC61970,61968标准,整合所述调度系统中的主网模型、以所述GIS平台数据为骨架的配网模型、营销用户和计量点模型,构建包含电源、电网和客户信息的全电压等级电网统一模型。In step s4, a unified resource model of the power grid is constructed. Based on IEC61970, 61968 standards, integrate the main network model in the dispatching system, the distribution network model with the GIS platform data as the skeleton, the marketing user and metering point models, and build a full-voltage power grid including power supply, power grid and customer information. Unified model.
具体地,围绕电网资源、资产、客户、量测等四条主线,优化模型设计,构建统一的拓扑模型、电网资源模型、设备资产模型、客户模型、计量点模型、测量点模型。Specifically, around the four main lines of grid resources, assets, customers, and measurement, optimize the model design and build a unified topology model, grid resource model, equipment asset model, customer model, metering point model, and measurement point model.
上述基于CIM的电网资源服务设计方法,设计了基于模型拼接的全电网标准化统一模型,各业务系统均可以基于该模型开展业务应用,实现了统一电网模型数据在全电网范围内的共享,健全了相关标准体系,打通了各环节、各业务间的数据链路,实现了数据横向集成、纵向贯通,进一步提升了电网内部数据共享利用水平和一体化管理水平。The above-mentioned CIM-based power grid resource service design method designs a unified model of the entire power grid based on model splicing, and each business system can carry out business applications based on this model, which realizes the sharing of unified power grid model data in the entire power grid. The relevant standard system has opened up the data link between each link and each business, realized the horizontal integration and vertical connection of data, and further improved the level of data sharing and utilization and integrated management within the power grid.
应该理解的是,虽然图1-5的流程图中的各个步骤按照箭头的指示依次显示,但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明,这些步骤的执行并没有严格的顺序限制,这些步骤可以以其它的顺序执行。而且,图1-5中的至少一部分步骤可以包括多个步骤或者多个阶段,这些步骤或者阶段并不必然是在同一时刻执行完成,而是可以在不同的时刻执行,这些步骤或者阶段的执行顺序也不必然是依次进行,而是可以与其它步骤或者其它步骤中的步骤或者阶段的至少一部分轮流或者交替地执行。It should be understood that although the steps in the flowcharts of FIGS. 1-5 are shown in sequence according to the arrows, these steps are not necessarily executed in the sequence shown by the arrows. Unless explicitly stated herein, the execution of these steps is not strictly limited to the order, and these steps may be performed in other orders. Moreover, at least a part of the steps in FIGS. 1-5 may include multiple steps or multiple stages. These steps or stages are not necessarily executed and completed at the same time, but may be executed at different times. The execution of these steps or stages The order is also not necessarily sequential, but may be performed alternately or alternately with other steps or at least a portion of the steps or phases within the other steps.
在一个实施例中,如图6所示,提供了一种电力数据库模型构建装置,包括:电力数据获取模块601、通用字段转换模块602、通用模型写入模块603、电力数据拼接模块604和电力模型构建模块605,其中:In one embodiment, as shown in FIG. 6, an apparatus for constructing a power database model is provided, including: a power
电力数据获取模块601,用于获取多个电力业务系统采集的多个电力数据,以及多个电力数据的数据字段;A power
通用字段转换模块602,用于按照预设的字段映射表将数据字段转换为电网通用模型的通用字段;其中,字段映射表中存储有电力数据的数据字段与电网通用模型的通用字段之间的对应关系;The general
通用模型写入模块603,用于将电力数据按照所通用字段写入电网通用模型,形成多个电网通用业务模型;The general
电力数据拼接模块604,用于将多个电网通用业务模型的电力数据进行数据拼接,建立多个电网通用业务模型的关联关系;The power
电力模型构建模块605,用于基于关联关系,构建电力数据库模型。The power
在一个实施例中,多个电网通用业务模型包括第一电网通用业务模型和第二电网通用业务模型;电力数据拼接模块604,进一步用于获取拼接字段,以及拼接字段下的拼接数据;拼接字段为电网通用模型的通用字段中,用于对多个电网通用业务模型的电力数据进行数据拼接的字段;若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二拼接数据相匹配的第一拼接数据,则将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系。In one embodiment, the multiple power grid general business models include a first power grid general business model and a second power grid general business model; the power
在一个实施例中,拼接字段包括:电力数据对应的电力设备编码;电力设备编码包括第一电力设备编码和第二电力设备编码;电力数据拼接模块604,进一步用于若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二电力设备编码相同的第一电力设备编码,则将第一电网通用业务模型与所第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系。In one embodiment, the splicing field includes: a power device code corresponding to the power data; the power device code includes a first power device code and a second power device code; the power
在一个实施例中,拼接字段包括:电力数据对应的电力设备名称;电力设备名称包括第一电力设备名称和第二电力设备名称;电力数据拼接模块604,进一步用于若第一电网通用业务模型中存储有与第二电网通用业务模型中存储的第二电力设备名称的关键字匹配的第一电力设备名称,则将第一电网通用业务模型与第二电网通用业务模型进行数据拼接,建立第一电网通用业务模型与第二电网通用业务模型的关联关系。In one embodiment, the splicing field includes: the name of the electric device corresponding to the electric power data; the name of the electric device includes the name of the first electric device and the name of the second electric device; the electric power
在一个实施例中,通用字段转换模块602,还用于若字段映射表中未存储有与电力数据的数据字段对应的电网通用模型的通用字段,则将电力数据的数据字段作为电网通用模型的通用字段存储入字段映射表。In one embodiment, the general
在一个实施例中,电力业务系统包括:电网调度系统、地理信息系统、生产系统、营销系统或计量自动化系统中的至少一种。In one embodiment, the power business system includes at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system, or a metering automation system.
在一个实施例中,电力数据包括:主网模型数据、第一地理信息数据、第二地理信息数据、生产数据、营销数据或电力计量数据中的至少一种;电力数据获取模块601,进一步用于按照调度系统文件传输协议从电网调度系统中获取主网模型数据;通过数据同步抽取方式从地理信息系统中获取第一地理信息数据,以及通过监听系统监听地理信息系统的电子化移交接口,获取第二地理信息数据;通过总部数据中心的数据复制工具从生产系统的生产数据库中获取生产数据,以及从营销系统的营销数据库中获取营销数据;按照计量系统文件传输协议从计量自动化系统中获取电力计量数据。In one embodiment, the power data includes: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data, or power metering data; the power
关于电力数据库模型构建装置的具体限定可以参见上文中对于电力数据库模型构建方法的限定,在此不再赘述。上述电力数据库模型构建装置中的各个模块可全部或部分通过软件、硬件及其组合来实现。上述各模块可以硬件形式内嵌于或独立于计算机设备中的处理器中,也可以以软件形式存储于计算机设备中的存储器中,以便于处理器调用执行以上各个模块对应的操作。For the specific limitation of the power database model building apparatus, reference may be made to the above limitations on the power database model building method, which will not be repeated here. Each module in the above-mentioned power database model building apparatus can be implemented in whole or in part by software, hardware and combinations thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.
在一个实施例中,提供了一种计算机设备,该计算机设备可以是电力系统服务器,其内部结构图可以如图7所示。该计算机设备包括通过系统总线连接的处理器、存储器和网络接口。其中,该计算机设备的处理器用于提供计算和控制能力。该计算机设备的存储器包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统、计算机程序和数据库。该内存储器为非易失性存储介质中的操作系统和计算机程序的运行提供环境。该计算机设备的数据库用于存储电力数据。该计算机设备的网络接口用于与外部的终端通过网络连接通信。该计算机程序被处理器执行时以实现一种电力数据库模型构建方法。In one embodiment, a computer device is provided, and the computer device may be a power system server, and its internal structure diagram may be as shown in FIG. 7 . The computer device includes a processor, memory, and a network interface connected by a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The nonvolatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the execution of the operating system and computer programs in the non-volatile storage medium. The computer equipment's database is used to store power data. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for constructing a power database model is implemented.
本领域技术人员可以理解,图7中示出的结构,仅仅是与本申请方案相关的部分结构的框图,并不构成对本申请方案所应用于其上的计算机设备的限定,具体的计算机设备可以包括比图中所示更多或更少的部件,或者组合某些部件,或者具有不同的部件布置。Those skilled in the art can understand that the structure shown in FIG. 7 is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. Include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.
在一个实施例中,还提供了一种计算机设备,包括存储器和处理器,存储器中存储有计算机程序,该处理器执行计算机程序时实现上述各方法实施例中的步骤。In one embodiment, a computer device is also provided, including a memory and a processor, where a computer program is stored in the memory, and the processor implements the steps in the foregoing method embodiments when the processor executes the computer program.
在一个实施例中,提供了一种计算机可读存储介质,其上存储有计算机程序,该计算机程序被处理器执行时实现上述各方法实施例中的步骤。In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, implements the steps in the foregoing method embodiments.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程,是可以通过计算机程序来指令相关的硬件来完成,所述的计算机程序可存储于一非易失性计算机可读取存储介质中,该计算机程序在执行时,可包括如上述各方法的实施例的流程。其中,本申请所提供的各实施例中所使用的对存储器、存储、数据库或其它介质的任何引用,均可包括非易失性和易失性存储器中的至少一种。非易失性存储器可包括只读存储器(Read-Only Memory,ROM)、磁带、软盘、闪存或光存储器等。易失性存储器可包括随机存取存储器(Random Access Memory,RAM)或外部高速缓冲存储器。作为说明而非局限,RAM可以是多种形式,比如静态随机存取存储器(Static Random Access Memory,SRAM)或动态随机存取存储器(Dynamic Random Access Memory,DRAM)等。Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage In the medium, when the computer program is executed, it may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other media used in the various embodiments provided in this application may include at least one of non-volatile and volatile memory. The non-volatile memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, and the like. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, the RAM may be in various forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM).
以上实施例的各技术特征可以进行任意的组合,为使描述简洁,未对上述实施例中的各个技术特征所有可能的组合都进行描述,然而,只要这些技术特征的组合不存在矛盾,都应当认为是本说明书记载的范围。The technical features of the above embodiments can be combined arbitrarily. In order to make the description simple, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features It is considered to be the range described in this specification.
以上所述实施例仅表达了本申请的几种实施方式,其描述较为具体和详细,但并不能因此而理解为对发明专利范围的限制。应当指出的是,对于本领域的普通技术人员来说,在不脱离本申请构思的前提下,还可以做出若干变形和改进,这些都属于本申请的保护范围。因此,本申请专利的保护范围应以所附权利要求为准。The above-mentioned embodiments only represent several embodiments of the present application, and the descriptions thereof are specific and detailed, but should not be construed as a limitation on the scope of the invention patent. It should be pointed out that for those skilled in the art, without departing from the concept of the present application, several modifications and improvements can be made, which all belong to the protection scope of the present application. Therefore, the scope of protection of the patent of the present application shall be subject to the appended claims.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010410723.4A CN111597166B (en) | 2020-05-15 | 2020-05-15 | Power database model construction method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010410723.4A CN111597166B (en) | 2020-05-15 | 2020-05-15 | Power database model construction method, device, computer equipment and storage medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111597166A true CN111597166A (en) | 2020-08-28 |
CN111597166B CN111597166B (en) | 2023-10-27 |
Family
ID=72191034
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010410723.4A Active CN111597166B (en) | 2020-05-15 | 2020-05-15 | Power database model construction method, device, computer equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111597166B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112306990A (en) * | 2020-10-29 | 2021-02-02 | 广东电网有限责任公司 | Power grid data acquisition method, device, equipment and storage medium |
CN115133532A (en) * | 2022-09-01 | 2022-09-30 | 南方电网数字电网研究院有限公司 | Management and control method, device, equipment and storage medium for power system |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5848426A (en) * | 1993-03-05 | 1998-12-08 | Metanetics Corporation | Automatic data translation between different business systems |
US20050086199A1 (en) * | 1998-03-31 | 2005-04-21 | Champagne Darryl G. | Transferring records between two databases |
CN102063509A (en) * | 2011-01-12 | 2011-05-18 | 南京南瑞继保电气有限公司 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
CN102495850A (en) * | 2011-11-18 | 2012-06-13 | 中国南方电网有限责任公司 | Method for splicing multi-stage multi-region interconnected power grid relay protection model |
CN103365960A (en) * | 2013-06-18 | 2013-10-23 | 国家电网公司 | Off-line searching method of structured data of electric power multistage dispatching management |
CN104484738A (en) * | 2014-11-24 | 2015-04-01 | 广东电网有限责任公司电力科学研究院 | Method and system for centralized management of power grid data |
US20150113025A1 (en) * | 2013-10-17 | 2015-04-23 | Sap Ag | System for customizing specific database models using specific database views |
WO2018005666A8 (en) * | 2016-06-29 | 2018-02-08 | Amazon Technologies, Inc. | Network-accessible data volume modification |
US10509764B1 (en) * | 2015-06-19 | 2019-12-17 | Amazon Technologies, Inc. | Flexible remote direct memory access |
-
2020
- 2020-05-15 CN CN202010410723.4A patent/CN111597166B/en active Active
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5848426A (en) * | 1993-03-05 | 1998-12-08 | Metanetics Corporation | Automatic data translation between different business systems |
US20050086199A1 (en) * | 1998-03-31 | 2005-04-21 | Champagne Darryl G. | Transferring records between two databases |
CN102063509A (en) * | 2011-01-12 | 2011-05-18 | 南京南瑞继保电气有限公司 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
CN102495850A (en) * | 2011-11-18 | 2012-06-13 | 中国南方电网有限责任公司 | Method for splicing multi-stage multi-region interconnected power grid relay protection model |
CN103365960A (en) * | 2013-06-18 | 2013-10-23 | 国家电网公司 | Off-line searching method of structured data of electric power multistage dispatching management |
US20150113025A1 (en) * | 2013-10-17 | 2015-04-23 | Sap Ag | System for customizing specific database models using specific database views |
CN104484738A (en) * | 2014-11-24 | 2015-04-01 | 广东电网有限责任公司电力科学研究院 | Method and system for centralized management of power grid data |
US10509764B1 (en) * | 2015-06-19 | 2019-12-17 | Amazon Technologies, Inc. | Flexible remote direct memory access |
WO2018005666A8 (en) * | 2016-06-29 | 2018-02-08 | Amazon Technologies, Inc. | Network-accessible data volume modification |
Non-Patent Citations (1)
Title |
---|
任开银;孔震;叶敏;: "通用数据交换系统架构设计与实现", 电力系统自动化, no. 20 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112306990A (en) * | 2020-10-29 | 2021-02-02 | 广东电网有限责任公司 | Power grid data acquisition method, device, equipment and storage medium |
CN115133532A (en) * | 2022-09-01 | 2022-09-30 | 南方电网数字电网研究院有限公司 | Management and control method, device, equipment and storage medium for power system |
Also Published As
Publication number | Publication date |
---|---|
CN111597166B (en) | 2023-10-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107357856B (en) | Implementation method of data integration and data service based on grid panorama business model | |
CN106203890B (en) | Battalion's auxiliary tone integration data modeling method based on CIM | |
US20180132015A1 (en) | Integrated Solution of Internet of Things and Smart Grid Network Pertaining to Communication, Data and Asset Serialization, and Data Modeling Algorithms | |
Ravikumar et al. | A common information model oriented graph database framework for power systems | |
CN107835107B (en) | Measurement display system based on power grid measurement topology and WebGis | |
CN108090165B (en) | Method for acquiring map change difference based on embedded graph database | |
CN102611199A (en) | Design and configuration integrated system for intelligent substation | |
CN108446396B (en) | Power data processing method based on improved CIM model | |
CN111524027B (en) | An electric power information statistical method, device, equipment and storage medium | |
CN104881739B (en) | Data consistency verification method is matched somebody with somebody by a kind of battalion based on IEC61970/61968 CIM standards | |
CN103647805A (en) | Method for accessing data to IEC61850 fault recording master station from converter station fault recording system | |
CN111597166B (en) | Power database model construction method, device, computer equipment and storage medium | |
CN117009357A (en) | Internet of things data management method, device, system and medium for smart city | |
Xiong et al. | Modelling the high-voltage grid using open data for Europe and beyond | |
CN106686146A (en) | A network planning GIS graphic information collection and splicing system based on TCP‑IP protocol | |
CN112286884B (en) | Method, system and medium for automatically generating topology of ring main unit of power distribution network | |
Shahid et al. | Handling incomplete and erroneous grid topology information for low voltage grid observability | |
CN103294878A (en) | Unified modeling method of multidimensional grid models based on DMS (database management system) | |
Paludetto et al. | MESP-an interoperable platform for multi-energy systems | |
CN107194010A (en) | The management information system of power-consuming and its method of a kind of object-oriented | |
CN117453690A (en) | Data processing method, device and computer medium for power grid data warehouse | |
CN117273632A (en) | Intelligent substation secondary equipment testing method, device, equipment and medium | |
CN116738772A (en) | Power supply path tracing methods, devices, equipment and media based on digital twins | |
Srinivasan et al. | GIS as a tool for enhancing the optimization of demand side management in residential microgrid | |
CN105184676A (en) | Power utilization data processing method and apparatus |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |