CN113835776B - Method for accessing booster station data into large data platform of energy enterprise - Google Patents

Method for accessing booster station data into large data platform of energy enterprise Download PDF

Info

Publication number
CN113835776B
CN113835776B CN202110948227.9A CN202110948227A CN113835776B CN 113835776 B CN113835776 B CN 113835776B CN 202110948227 A CN202110948227 A CN 202110948227A CN 113835776 B CN113835776 B CN 113835776B
Authority
CN
China
Prior art keywords
data
information model
asset
layer
booster station
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202110948227.9A
Other languages
Chinese (zh)
Other versions
CN113835776A (en
Inventor
李欢欢
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Everbright Envirotech China Ltd
Everbright Environmental Protection Research Institute Nanjing Co Ltd
Everbright Environmental Protection Technology Research Institute Shenzhen Co Ltd
Original Assignee
Everbright Envirotech China Ltd
Everbright Environmental Protection Research Institute Nanjing Co Ltd
Everbright Environmental Protection Technology Research Institute Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Everbright Envirotech China Ltd, Everbright Environmental Protection Research Institute Nanjing Co Ltd, Everbright Environmental Protection Technology Research Institute Shenzhen Co Ltd filed Critical Everbright Envirotech China Ltd
Priority to CN202110948227.9A priority Critical patent/CN113835776B/en
Publication of CN113835776A publication Critical patent/CN113835776A/en
Application granted granted Critical
Publication of CN113835776B publication Critical patent/CN113835776B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/445Program loading or initiating
    • G06F9/44505Configuring for program initiating, e.g. using registry, configuration files
    • G06F9/4451User profiles; Roaming
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0631Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • G06Q10/06311Scheduling, planning or task assignment for a person or group
    • G06Q10/063112Skill-based matching of a person or a group to a task
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • YGENERAL 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
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS 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/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems 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)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • Software Systems (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Educational Administration (AREA)
  • Marketing (AREA)
  • Game Theory and Decision Science (AREA)
  • Development Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for accessing booster station data into a big data platform of an energy enterprise, which comprises the following steps: the Edge gateway data receiving module receives the data forwarded by the SCADA data forwarding module and transmits the data to the Edge gateway data protocol conversion module; the data forwarded by the SCADA data forwarding module are measurement point level data of an original point table of the booster station based on the IEC104 protocol; the Edge gateway data protocol conversion module is internally provided with a standardized configuration file, the original point table measuring point data of the booster station based on the IEC104 protocol is converted into standard object information model data according to the standardized configuration file, and the standard object information model data is sent to the enterprise big data platform through the Edge gateway data uploading and forwarding module; the scheme of the invention obviously improves the standardization level of the data access of the booster station of the big data platform of the power generation enterprise.

Description

Method for accessing booster station data into large data platform of energy enterprise
Technical Field
The invention belongs to the field of automatic communication of power systems.
Background
Under the background that the current energy power generation industry enters stock competition, enterprises pay more attention to cost reduction and efficiency improvement of production operation processes, a unified big data platform of the enterprises is constructed by utilizing the Internet of things and big data technology, and the urgent demands of the energy power generation enterprises under the current new situation are realized by constructing upper-layer applications based on the unified big data platform, such as universal interconnection, unified data, centralized monitoring, transparent performance, auxiliary decision making and the like.
The unified data access requirement of the energy power generation enterprises mainly comprises power generation equipment data access and power transmission and transformation equipment (booster station) data access. The data of the booster station is generally forwarded to a monitoring master station (such as SCADA) of a centralized control center through a booster station power remote unit (RTU), and further data are acquired through the SCADA to enter an enterprise unified big data platform. The data of the booster stations of each power generation enterprise are transmitted to the SCADA system of the main station of the monitoring center from the RTU, and the communication process of the data transmitted to the big data platform from the SCADA system is currently mainly carried out by adopting an IEC104 communication protocol, the IEC104 communication protocol adopts a measurement point-oriented information description method, and the data types mainly comprise four-remote (remote signaling, remote measuring, remote control and remote regulation) data. Because the asset details and the connection modes of each booster station are different, the four-remote data acquisition details of each booster station are almost impossible to be the same. The IEC104 protocol distinguishes different information elements by applying the public address and the information body address in the service data unit, and the information body address is pre-allocated by the teleengineer of each booster station, with a certain degree of randomness, so that the data information transmitted to the SCADA by each booster station through the IEC104 protocol is also different. In the prior art, a measuring point level data access mode of an IEC104 protocol mode is directly adopted, real-time data of a large number of four remote points of each booster station is directly stored into a time sequence database of a large data platform according to a method of ordering original information addresses, and subsequent monitoring analysis and calculation are carried out based on the data. The method leads the application program to face the data point ID and the data name of each booster station which are different from each other, so that a great deal of manpower is consumed to carry out the subsequent adaptation work of the application program and the heterogeneous data source on each booster station, and the expansibility and the universality of the application program are seriously restricted. At present, only simple configuration monitoring and alarming applications and the like can be deployed at an application layer, the configuration process is time-consuming and labor-consuming, the overall informatization level is low, more manpower is required to be input for software upgrading and maintenance when the condition of subsequent projects is changed, the cost of the whole informatization full life cycle is high, and the effect is general, so that the promotion of informatization strategy of enterprises is severely restricted.
Disclosure of Invention
The invention aims to: in order to solve the problems in the prior art, the invention provides a method for accessing booster station data into a large data platform of an energy enterprise.
The technical scheme is as follows: the invention provides a method for accessing booster station data into a big data platform of an energy enterprise, which comprises the following steps: the Edge gateway data receiving module receives the data forwarded by the SCADA data forwarding module and transmits the data to the Edge gateway data protocol conversion module; the data forwarded by the SCADA data forwarding module are measurement point level data of an original point table of the booster station based on the IEC104 protocol; the Edge gateway data protocol conversion module is internally provided with a standardized configuration file, the measuring point level data of the booster station based on the IEC104 protocol original point table is converted into standard object information model data in the standardized configuration file according to the standardized configuration file, and the standard object information model data is uploaded to the forwarding module through the Edge gateway data and is forwarded to the enterprise big data platform;
the generation of the standardized configuration file specifically comprises the following steps:
step 1: establishing a standard object information model based on an electric interval plus booster station information model system of the equipment; the standard object information model comprises n general layer information models and n item layer information models of inheritance general layers; taking the measuring points in the n project layer information models as standard measuring points;
step 2: obtaining the asset details of each booster station according to the IEC104 original point table of the booster station; asset instantiation is carried out on asset objects belonging to the project layer information model in each booster station according to the standard object information model;
step 3: generating a mapping template and an offset configuration file: taking the measurement point detail of any one asset object in an IEC104 original point table corresponding to the asset object as an actual measurement point detail of the asset object, and taking the arrangement sequence of the measurement point detail as the arrangement sequence of the actual measurement point detail of the asset object; type classification is carried out on all asset objects in the ith project layer information model: taking two or more asset objects with the same actual measurement point details and the same arrangement sequence of the actual measurement point details as the same asset type; setting a mapping template for each asset type according to the actual measuring point detail corresponding to each asset type in the ith project layer information model and the standard measuring point in the ith project layer information model, and setting an offset configuration file for each asset object corresponding to the mapping template according to the mapping template, wherein i=1, 2, … and n.
Furthermore, after the standard object information model is established in the step 1, a big data platform storage strategy is set for all standard measuring points in the n project layer models according to actual requirements.
Further, the step 1 of establishing the generic layer information model specifically includes: the general layer information model is used for defining general classes, wherein the general classes comprise booster station field stations, electric energy meters, switching equipment, switch intervals, transformer intervals, bus intervals, SVG, direct current and public systems and protection systems; taking a class as a general layer information model and defining four elements of each class, wherein the four elements comprise: attributes, standard measurement points, operations, and events; leading the defined four elements into a corresponding universal layer information model so as to complete the construction of the universal layer information model;
the step 1 of establishing the project layer information model specifically comprises the following steps: the method comprises the steps of obtaining an initial project layer information model in a mode of inheriting a general layer information model, and expanding the number of four elements of the initial project layer information model according to actual requirements.
Further, the step 2 further includes creating an asset structure, and sorting the asset objects after asset instantiation according to the asset structure; the asset structure comprises first to fourth layers from top to bottom, wherein the first layer is a station layer and is used for mounting a booster station; the second layer is a main transformer, an electric energy meter and a voltage class layer, and is connected with the corresponding first layer and used for mounting the voltage class, the electric energy meter and main transformer equipment; the third layer is a spacing layer, and is connected with a corresponding second layer for mounting various switch intervals, bus intervals and SVGs; the fourth layer is an equipment layer, and the fourth layer is connected with a corresponding third layer and is used for mounting various switch equipment.
Further, the setting a mapping template in the step 3 specifically includes: for any asset type J, establishing an initial mapping template B with all standard measuring points in the project layer information model A according to the standard measuring points in the project layer information model A corresponding to the asset type; and establishing an access point table file Z according to the actual measurement point detail corresponding to the asset type J and the arrangement sequence of the actual measurement point detail, sequentially numbering each measurement point in the actual measurement point detail according to the arrangement sequence of the actual measurement point detail in the access point table file Z, and importing the access point table file Z into an initial mapping template B to obtain a mapping template B corresponding to the asset type J.
Further, the setting of the offset configuration file in the step 3 specifically includes: for a certain measuring point in the actual measuring point detail of any asset object, calculating the difference value between the original number and the standard number of the measuring point, and setting an offset configuration file for the asset object by taking the difference value as an offset; the original number is the number of the measuring point in the corresponding IEC104 original point table, and the standard number is the number of the measuring point in the corresponding mapping template.
The beneficial effects are that: according to the method, the original measurement point-oriented information model data based on the IEC104 protocol is converted into the object-oriented information model data based on the big data platform of the Internet of things. By constructing a standard object information model of the booster station of the power generation enterprise, four elements of attributes, measuring points, operations and events are standardized and normalized, standard elements, calculation logic, storage strategy definition and protocol conversion mapping modes of all objects are defined, isolation of an application layer interface and an access layer heterogeneous data source is achieved, standardization and normalization of acquired data of the booster station are greatly improved, differentiated configuration workload of a large number of heterogeneous data sources is remarkably reduced, development, implementation and deployment efficiency of standard application are improved, maintenance cost is reduced, upgrading and expanding capacity of application software of the standard booster station of the large data platform of the Internet of things is greatly improved, and information strategy of the enterprise is guaranteed to be continuously advanced.
Drawings
FIG. 1 is a flow chart of the method of the present invention;
FIG. 2 is a flow chart for generating a standard object information model and a standardized configuration file;
FIG. 3 is a frame diagram of a standard object information model design of a booster station;
FIG. 4 is a schematic diagram of an object information model structure;
FIG. 5 is a block diagram of a standard object information model of the present invention in a big data platform;
FIG. 6 is a diagram of a standard information model in json format;
FIG. 7 is a flow chart for creation of asset objects and asset structures;
FIG. 8 is a tabular diagram of IEC104 protocol access points;
FIG. 9 is a schematic diagram of an asset object hierarchy.
Detailed Description
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention.
As shown in fig. 1, the conventional workflow of accessing booster station data to the internet of things big data platform of the power generation enterprise in real time mainly comprises an SCADA data source data forwarding service (module), an Edge gateway data receiving service (module), an Edge gateway data protocol conversion service (module), an Edge gateway data uploading forwarding service and a big data platform data receiving service; or the system can also comprise a big data platform data computing service, a big data platform data storage service and the like; the most core content is Edge gateway data receiving and protocol conversion step, namely, generating a standardized configuration file by using the embodiment, and executing Edge gateway data protocol conversion service according to the configuration file specification.
As shown in fig. 2, the overall implementation flow of accessing booster station data to the large data platform of the internet of things of energy enterprise mainly comprises basic preparation work (including user account number and authority configuration), booster station standard object information model design, booster station standard object information model creation based on the large data platform, booster station asset instance and asset structure creation based on the standard object information model, booster station acquisition data storage strategy configuration, original measuring point and standard object information model data measuring point mapping relation creation based on IEC104 protocol, edge gateway data connection relation configuration and data acquisition process execution.
(1) Basic preparation work
The step is used for completing basic preparation work of the big data platform, including work such as project creation, initialization configuration of various storage and computing resources, configuration of various personnel account numbers and rights, and the like.
(2) Design scheme of standard object information model of booster station
Different from the condition that an IEC61850 standardized protocol is widely used for unification in the informatization and intellectualization process of the enterprise platform of the domestic power grid, the large data platform of the power generation enterprise is generally constructed and incompatible with the IEC61850 system standard due to different service requirements. And a large data platform based on an IEC61850 system is independently built for the system, so that the cost is high, and the system is unnecessary. Therefore, the modeling thought and strategy of the part IEC61850 are adopted, and a simplified standard object information model construction mode for adapting the service requirements of the power generation enterprises and the current situation of the large data platform is provided, so that the step-up station SCADA forwarding data based on the IEC104 protocol is quickly accessed to the large data platform, and standardized data service is provided for the upper-layer service application of the power generation enterprises.
By classifying typical booster station equipment and analyzing a measuring point table, a booster station object information model framework is designed to be a booster station three-level information model system based on electrical intervals (containers) +equipment, and as shown in fig. 3, the booster station three-level information model system comprises the following important object classes:
booster station class: describing a booster station body, including attributes (such as name, voltage level, longitude and latitude, etc.), original access points (such as total accident signals, total grid-connected power/electric quantity, AGC/AVC set values, etc.), statistical calculation points (such as power calculation points, electric energy calculation points, state calculation points, etc.), important events (such as important accidents), etc.;
electric energy meters: describing all electric energy meters of the booster station, including attributes (such as name, type, precision and multiplying power), original access points (such as reading of all the tables, reading of the time-sharing tables, state and the like), important events (such as important alarms) and the like;
switching equipment class: describing all switch equipment such as switches, disconnecting switches, trolleys and the like of the booster station, wherein the switch equipment comprises attributes (such as names, types and the like), original access points (such as opening and closing states), operations (such as opening and closing operations) and important events (such as action alarm information);
switch interval class: all switch class intervals of the booster station are described, such as an incoming line interval, an outgoing line interval, a bus connection or bus section interval and the like. Including its attributes (e.g., name, type, associated switching device, etc.), original access point (e.g., important AI amount, status, etc.), computation point, important event, etc.;
transformer spacing class: all transformer apparatus bodies of the booster station and the high-medium-low side switch intervals thereof are described as a whole. Including its attributes (e.g., name, type, form, high, medium, low voltage levels, etc.), original access point, computation point (e.g., status), operation (e.g., gear adjustment), events (e.g., faults and alarms);
bus bar spacing class: describing various types of bus equipment of the booster station and the switch equipment attached to the booster station, wherein the bus equipment comprises attributes (such as voltage class and type), original access points (such as bus voltage), calculation points (such as running state) and events (such as faults and alarms);
SVG class: describing all SVG equipment of the booster station, including the attribute (such as type, rated voltage and the like) and main electric measuring point information;
direct current and utility system classes: describing a booster station direct current and public system;
protection system class: describing all secondary protection systems of the booster station;
class to be expanded: describing other types of equipment models which need to be expanded subsequently, such as relays, synchronous motors, capacitors and the like;
other classes: all access data objects except the standardized objects described above generally carry a large number of non-standardized stations of lower importance and of lower frequency.
Each type is an object information model;
the construction of each object information model needs to determine metadata of four element details of each object class identifier, chinese and English names, description, types, inherited father models (optional) and information models, wherein the metadata comprises information such as identifiers, chinese and English names, data types, data units, data value fields, data formats, various operations, event rules and the like, and once the models are determined and constructed, the metadata is globally unified and cannot be changed. The schematic structure is shown in fig. 4.
(3) Standard object information model creation of booster station based on big data platform
The three-layer information model system in the second step refers to a model design idea, namely three layers from coarse to fine on a macroscopic level, and proper information model design schemes can be selected according to different equipment or system types of the booster station. Therefore, the three-level information model system is used for providing service for the information model design and is used for guiding which types of booster station information models and four elements corresponding to the booster station information models are designed; after the information model design is completed based on the ideas, a specific information model object needs to be created on a big data platform. The problem of universalization and suitability of the information model considered during practice landing is focused on, so that the universalization of various types of booster stations can be realized, and personalized information expansion of various booster stations can be met. At this time, two layers (a general layer and a project layer) of model management systems are created from the practical point of view to meet the requirements of real projects.
As shown in fig. 5, the present embodiment adopts a generic layer+project layer two-layer object information model structure as a standard object information model. In the double-layer information model structure, the upper layer is a general layer information model which defines the most general basic model object information (in the embodiment, the model object information comprises a booster station field station class, an electric energy meter class, a switch equipment class, a switch interval class, a transformer interval class, a bus interval class, a SVG class, a direct current and public system class and a protection system class), and the general layer model can be used for general purpose among different cloud platforms/deployment environments and has wide cross-item suitability. The lower layer is an item layer information model, which is generally inherited from the general layer model, can contain all elements of the inherited general layer information model, can carry out self-defined expansion on the inherited model elements on the basis, and can newly add object attributes, measuring points, algorithms and the like of item individuation so as to obtain individuation information model objects suitable for various items.
The standard object information model creation process of the booster station comprises the following steps: firstly, constructing all kinds of general layer information models based on a big data platform, defining identifiers, names, types and descriptions of each general layer information model, and creating four elements for the information model, wherein the four elements comprise: and importing the four element information of the defined general layer information model into the corresponding general layer information model to finish the creation of the general layer information model. After the general layer information model is built, an item layer initial information model is obtained in an inheritance mode, four elements of the item layer initial information model which needs to be expanded are expanded according to actual requirements of the item, and a final standard object information model which is suitable for the condition of the item is obtained. A detailed standard object information model is created in the platform through a visual interface or a standard program interface, a part of json format description content of the detailed standard object information model is shown in fig. 6, and the schematic diagram shows the description information of one measuring point 'active power P' of the switch interval type information model.
(4) Booster station asset instance and asset structure creation based on standard object information model
And carrying out booster station asset object instantiation based on the project layer information models, and constructing a detailed asset object set corresponding to different types of each booster station. The booster station assets are various devices or systems defined by a booster station information model, such as a field station, a 110kV outlet switch interval, a 35kV inlet switch interval, a main transformer interval or an electric energy meter; the creation of a specific asset object and the instantiation of the asset object are completed by setting specific attribute values, calculation logic of calculation points, measurement point storage strategies, operation logic, event triggering conditions and the like.
As shown in fig. 7, according to the data source system of each booster station, the important asset details (switch interval, switch equipment, transformer interval, bus interval, direct current and public system, protection system, SVG, etc.) of each booster station are obtained based on the original point table analysis of the IEC104 protocol, and the information format of the IEC104 original point table is shown in fig. 8 and includes information such as four remote types, address codes, description of the measuring points, etc. of each measuring point. And marking, summarizing and arranging the main assets according to the access point table of each booster station, and defining the asset creation range and detail. After all the booster stations create all the types of asset objects, the asset objects of each type need to be classified according to a hierarchical structure so as to facilitate the subsequent effective management of the assets and the development of application interfaces. The embodiment divides the booster station asset structure into a first layer from top to bottom to four layers, namely a station layer, a main transformer/electric energy meter/voltage class layer, a spacer layer and a device layer, as shown in fig. 9.
Station layer: a first layer for mounting a booster yard object;
main transformer/electric energy meter/voltage class layer: the second layer is connected with the corresponding first layer, and is used for mounting each voltage class, the electric energy meter, the main transformer equipment and the like; the corresponding first layer means: each booster station is mounted on the first layer, and the main transformer/electric energy meter/voltage level belonging to the booster station is mounted under the booster station on the first layer;
a spacer layer: the third layer is connected with the corresponding second layer, and is used for mounting various switch intervals, bus intervals, SVGs and the like;
device layer: a fourth layer, which is connected with a corresponding third layer, and is used for mounting various switch devices and the like;
(5) Booster station acquisition data storage policy configuration
And setting a big data platform storage strategy for all standard measuring points in all project layer information models according to actual requirements. The storage strategy comprises a storage mode and a storage duration.
(6) IEC104 protocol and standard object information model data point mapping relation creation
In order to convert the original measurement point level data information accessed based on the IEC104 protocol into object level data information created based on the standard information model, a mapping relation between each type of information model and an IEC104 protocol original point table (i.e. an IEC104 original point table) needs to be created. The embodiment realizes the conversion process by creating the mapping template, and the template has the full platform universality of cross items.
For the same item layer information model, standard measurement point details are defined, but the point details of the asset objects corresponding to the item layer information model may not be the same, such as the difference of measurement point sequence and measurement point details. Taking the measurement point detail of any one asset object in an IEC104 original point table corresponding to the asset object as an actual measurement point detail of the asset object, and taking the arrangement sequence of the measurement point detail as the arrangement sequence of the actual measurement point detail of the asset object; type classification is carried out on all asset objects in the ith project layer information model: taking two or more asset objects with the same actual measurement point details and the same arrangement sequence of the actual measurement point details as the same asset type; for example, instantiating the asset by the project layer information model A to obtain a1, a2, a3, a4, and a5 asset objects, each asset object having its own corresponding IEC104 origin specification as shown in Table 1:
TABLE 1
Figure BDA0003217601550000081
From table 1, it can be known that the asset objects a1 and a4 have the same measurement point details m, t, p, q and s in the corresponding IEC104 origin table, and the arrangement order of the 5 measurement point details is the same, and a1 and a4 are the same asset type, a2 and a5 are the same asset type, and a3 is a single asset type.
Three types of mapping templates need to be configured for the project layer information model a to adapt to the three asset types, respectively. The configured mapping template can be applied to all the asset objects of the access measuring point type, and only different offset ranges of the objects are required to be set according to the address code range of the original point table.
The specific creation of the mapping template is as follows: creating an initial mapping template aiming at any one of the three asset types, wherein the information model A needs to be selected when the mapping template is created, so that the created mapping template automatically has standard measuring point information defined by the information model A;
establishing an access point table file according to the actual measurement point detail corresponding to the asset type and the arrangement sequence of the actual measurement point detail, sequentially numbering each measurement point in the actual measurement point detail according to the arrangement sequence of the actual measurement point detail of the asset type in the access point table file, and importing the access point table file into an initial mapping template corresponding to the access point table file so as to obtain a mapping template corresponding to the asset type; in this embodiment, the access point table file is an example table, taking a1 and a4 as examples, and the corresponding access point table file includes measurement point details m, t, p, q, s ordered in sequence, and numbered in sequence, m-0; n-1; p-2; q-3; s-4;
when the configured mapping templates are used for all asset objects corresponding to the mapping templates, offset configuration files are set for the corresponding asset objects, and the specific setting method is as follows: for a certain measuring point in the actual measuring point detail of the asset object, calculating the difference value between the original number and the standard number of the measuring point, and setting an offset configuration file for the asset object by taking the difference value as an offset; the original number is the number of the measuring point in the corresponding IEC104 original point table, and the standard number is the number of the measuring point in the corresponding mapping template. For example, the numbers of 5 measuring points in the measuring point detail of a1 in an IEC104 original point table corresponding to a1 are respectively m-3; t-4; p-5; q-6; s-7, the offset of the measurement point m is 3-0=3, and because the actual measurement points in the asset object are all arranged in sequence and the measurement points in the mapping template are also numbered in sequence, if the offset of m is 3, the offsets of t, p and s are also 3, so that the offset of the asset object is also 3. For example, the numbers of 5 measuring points in the measuring point detail of a4 in an IEC104 original point table corresponding to a1 are respectively m-20; t-21; p-22; q-23; s-24, the asset object a4 has an offset of 20; in the actual application process, for asset objects with only different original measurement point sequences and detailed measurement points, the same template can be applied to perform measurement point conversion mapping, but a certain adjustment on the sequence is needed when the offset range of the access object is configured. The mapping template and the offset configuration file are used as standardized configuration files.
Taking a switch interval class information model as an example, the abstract of the point table of the part of the instantiated assets (outgoing line, incoming line 1, incoming line 2 and bus) is shown in table 2.
TABLE 2
Figure BDA0003217601550000101
/>
Figure BDA0003217601550000111
For the four asset objects, the mapping relationship between the original access measurement point and the standard information model measurement point can be completed by constructing two templates M1 and M2, as shown in tables 3 and 4, wherein the access points and the access modes can be set more in need.
TABLE 3 Table 3
Access point Mapping information model points Access mode
A phase voltage Ua E.g. timing 5s up-feed
B-phase voltage Ub E.g. timing 5s up-feed
C-phase voltage Uc E.g. timing 5s up-feed
Active power P E.g. timing 5s up-feed
Reactive power Q E.g. timing 5s up-feed
Accident total signal Fault For example, variable up-feed
Accident
1 signal Fault1 For example, variable up-feed
Accident 2 signal Fault2 For example, variable up-feed
TABLE 4 Table 4
Figure BDA0003217601550000112
Figure BDA0003217601550000121
Wherein U is voltage, ua is A phase voltage, ub is B phase voltage, uc is C phase voltage, P is sign of active power, Q is sign of reactive power, F is frequency, and Fault is accident signal.
(7) Edge gateway data connection relationship configuration and data acquisition process execution
The connection relation between the Edge gateway and each booster station data source is configured based on the big data platform, and the Edge gateway is helped to establish TCP/IP connection with the SCADA data forwarding server by setting the IP address, the port number and the access account number of the opposite end and the detailed configuration information of the IEC104 protocol.
And then configuring access address offset of all asset objects of each booster station based on a protocol conversion mapping template thereof to realize accurate correspondence between the address of the measuring point accessed based on IEC104 and the standardized measuring point of the standard information model asset object, wherein the access address offset needs to configure four remote data of each asset object one by one.
After all the configuration processes are completed, all the configuration processes are stored and synchronized to the corresponding Edge access gateways, the Edge access gateways read the corresponding configuration, execute application services after detecting no errors, and realize the processes of connection, data reading access, data protocol conversion mapping, data uploading large data platform storage and the like of the corresponding IEC104 data source servers.
In addition, the specific features described in the above embodiments may be combined in any suitable manner without contradiction. The various possible combinations of the invention are not described in detail in order to avoid unnecessary repetition.

Claims (6)

1. A method for accessing booster station data into large data platform of energy enterprise is characterized in that Edge gateway data receiving module receives data forwarded by SCADA data forwarding module and transmits the data to Edge gateway data protocol conversion module; the data forwarded by the SCADA data forwarding module is measurement point level data of the booster station based on an IEC104 original point table; the Edge gateway data protocol conversion module is internally provided with a standardized configuration file, the measuring point level data of the booster station based on the IEC104 original point table is converted into standard object information model data in the standardized configuration file according to the standardized configuration file, the data is uploaded to the SCADA data forwarding module through the Edge gateway, and the standard object information model data is forwarded to an enterprise big data platform;
the generation of the standardized configuration file specifically comprises the following steps:
step 1: establishing a standard object information model based on an electric interval plus booster station information model system of the equipment; the standard object information model comprises n general layer information models and n project layer information models inheriting the general layer information models; taking the measuring points in the n project layer information models as standard measuring points;
step 2: obtaining the asset details of each booster station according to the IEC104 original point table of the booster station; asset instantiation is carried out on asset objects belonging to the project layer information model in each booster station according to the standard object information model;
step 3: generating a mapping template and an offset configuration file: taking the measurement point detail of any one asset object in an IEC104 original point table corresponding to the asset object as an actual measurement point detail of the asset object, and taking the arrangement sequence of the measurement point detail as the arrangement sequence of the actual measurement point detail of the asset object; type classification is carried out on all asset objects in the ith project layer information model: taking two or more asset objects with the same actual measurement point details and the same arrangement sequence of the actual measurement point details as the same asset type; setting a mapping template for each asset type according to the actual measurement point detail corresponding to each asset type in the ith project layer information model and the standard measurement point in the ith project layer information model, setting an offset configuration file for each asset object corresponding to the mapping template according to the mapping template, wherein i=1, 2.
2. The method for accessing booster station data to an energy enterprise big data platform of claim 1, wherein the method comprises the steps of: and (3) after the standard object information model is established in the step (1), setting a big data platform storage strategy for all standard measuring points in the n project layer models.
3. The method for accessing booster station data to an energy enterprise big data platform of claim 1, wherein the method comprises the steps of: the step 1 of establishing a general layer information model specifically comprises the following steps: the general layer information model is used for defining general classes, wherein the general classes comprise booster station field stations, electric energy meters, switching equipment, switch intervals, transformer intervals, bus intervals, SVG, direct current and public systems and protection systems; taking a class as a general layer information model and defining four elements of each class, wherein the four elements comprise: attributes, standard measurement points, operations, and events; leading the defined four elements into a corresponding universal layer information model so as to complete the construction of the universal layer information model;
the step 1 of establishing the project layer information model specifically comprises the following steps: and obtaining an initial project layer information model in a mode of inheriting the general layer information model, and expanding the number of four elements of the initial project layer information model.
4. The method for accessing booster station data to an energy enterprise big data platform of claim 1, wherein the method comprises the steps of: the step 2 further includes creating an asset structure, and sorting asset objects after asset instantiation according to the asset structure; the asset structure comprises first to fourth layers from top to bottom, wherein the first layer is a station layer and is used for mounting a booster station; the second layer is a main transformer, an electric energy meter and a voltage class layer, and is connected with the corresponding first layer and used for mounting the voltage class, the electric energy meter and main transformer equipment; the third layer is a spacing layer, and is connected with a corresponding second layer for mounting a switch interval, a bus interval and SVG; the fourth layer is an equipment layer, and the fourth layer is connected with a corresponding third layer for mounting switch equipment.
5. The method for accessing booster station data to an energy enterprise big data platform of claim 1, wherein the method comprises the steps of: the mapping template setting in the step 3 specifically comprises the following steps: for any asset type J, establishing an initial mapping template B with all standard measuring points in the project layer information model A according to the standard measuring points in the project layer information model A corresponding to the asset type; and establishing an access point table file Z according to the actual measurement point detail corresponding to the asset type J and the arrangement sequence of the actual measurement point detail, sequentially numbering each measurement point in the actual measurement point detail according to the arrangement sequence of the actual measurement point detail in the access point table file Z, and importing the access point table file Z into an initial mapping template B to obtain a mapping template B corresponding to the asset type J.
6. The method for accessing booster station data to an energy enterprise big data platform of claim 5, wherein: the offset configuration file setting in the step 3 specifically includes: for a certain measuring point in the actual measuring point detail of any asset object, calculating the difference value between the original number and the standard number of the measuring point, and setting an offset configuration file for the asset object by taking the difference value as an offset; the original number is the number of the measuring point in the corresponding IEC104 original point table, and the standard number is the number of the measuring point in the corresponding mapping template.
CN202110948227.9A 2021-08-18 2021-08-18 Method for accessing booster station data into large data platform of energy enterprise Active CN113835776B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110948227.9A CN113835776B (en) 2021-08-18 2021-08-18 Method for accessing booster station data into large data platform of energy enterprise

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110948227.9A CN113835776B (en) 2021-08-18 2021-08-18 Method for accessing booster station data into large data platform of energy enterprise

Publications (2)

Publication Number Publication Date
CN113835776A CN113835776A (en) 2021-12-24
CN113835776B true CN113835776B (en) 2023-05-02

Family

ID=78960745

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110948227.9A Active CN113835776B (en) 2021-08-18 2021-08-18 Method for accessing booster station data into large data platform of energy enterprise

Country Status (1)

Country Link
CN (1) CN113835776B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103413248A (en) * 2013-06-09 2013-11-27 国家电网公司 Wind power equipment management information system
EP2687925A1 (en) * 2012-07-16 2014-01-22 ABB Technology AG Master intelligent electronic device for high level application
CN106130188A (en) * 2016-08-30 2016-11-16 江苏大唐国际吕四港发电有限责任公司 A kind of power plant high voltage station monitoring system and monitoring method thereof
CN110941656A (en) * 2019-09-23 2020-03-31 新奥数能科技有限公司 Internet of things data access method and device based on universal energy CIM

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP2687925A1 (en) * 2012-07-16 2014-01-22 ABB Technology AG Master intelligent electronic device for high level application
CN103413248A (en) * 2013-06-09 2013-11-27 国家电网公司 Wind power equipment management information system
CN106130188A (en) * 2016-08-30 2016-11-16 江苏大唐国际吕四港发电有限责任公司 A kind of power plant high voltage station monitoring system and monitoring method thereof
CN110941656A (en) * 2019-09-23 2020-03-31 新奥数能科技有限公司 Internet of things data access method and device based on universal energy CIM

Also Published As

Publication number Publication date
CN113835776A (en) 2021-12-24

Similar Documents

Publication Publication Date Title
CN101944770B (en) Communication implementation method of virtual station grade IED mode between primary station and substation in fault information system 61850
CN104239059B (en) Intelligence based on full model matches somebody with somebody the construction method of electricity consumption unified information support platform
CN101710735A (en) Sharing modeling method of intelligent substation and primary station
CN103440367A (en) Panoramic data modeling method for transformer substation
CN104348254A (en) Transformer substation monitoring system framework facing services
CN102929911A (en) All-in-one modeling method for transformer substation and dispatching master station
CN104504485A (en) Integrative power system relay protection setting calculation method
CN201518429U (en) Electric energy qualitative data concentrator for digitalization transforming plant
CN109038579B (en) Automatic splicing method for plant model computers
EP2633600A2 (en) Method for short-cyclic data capture for energy monitoring and for system control in the smart metering/smart grid using a piece of distributed, intelligent middleware
CN111340327A (en) Main and auxiliary integrated load analysis platform and implementation method thereof
CN104967115B (en) Distributed cluster type network topology coloring method for power system
CN106356850A (en) Safety and stability control device fault offline control strategy model generation method
CN103489139A (en) Comprehensive analysis and management system for urban distribution network planning
CN105743870A (en) Design method of intelligent substation integrated business platform service interfaces
CN116628937A (en) Automatic fusion maintenance method, device, equipment and medium for power grid equipment model
CN102647027A (en) Method for realizing construction of power quality data exchanging interface
CN109871566B (en) Loop construction method based on power grid topology technology and storage medium
CN113902583A (en) Distribution network side operation and maintenance method and system using low-voltage network equipment data
CN109829612A (en) A kind of dispatching automation device information check method and device
CN113835776B (en) Method for accessing booster station data into large data platform of energy enterprise
CN107591802A (en) A kind of abstract method of calibration of distribution network model
CN116826709A (en) Automatic matching method, device and storage medium for adjustable load resource and scheduling master station model
CN109683571B (en) Modeling method and device for hydropower station monitoring system
CN106657282A (en) Integration method and device for equipment operation state information of convertor station

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