KR20150012741A - System for constructing integrated database - Google Patents

System for constructing integrated database Download PDF

Info

Publication number
KR20150012741A
KR20150012741A KR1020130088656A KR20130088656A KR20150012741A KR 20150012741 A KR20150012741 A KR 20150012741A KR 1020130088656 A KR1020130088656 A KR 1020130088656A KR 20130088656 A KR20130088656 A KR 20130088656A KR 20150012741 A KR20150012741 A KR 20150012741A
Authority
KR
South Korea
Prior art keywords
module
data
communication
database
integrated database
Prior art date
Application number
KR1020130088656A
Other languages
Korean (ko)
Inventor
손진경
Original Assignee
현대중공업 주식회사
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 현대중공업 주식회사 filed Critical 현대중공업 주식회사
Priority to KR1020130088656A priority Critical patent/KR20150012741A/en
Publication of KR20150012741A publication Critical patent/KR20150012741A/en

Links

Images

Classifications

    • 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/10—Services

Landscapes

  • Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Health & Medical Sciences (AREA)
  • Economics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • Primary Health Care (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Remote Monitoring And Control Of Power-Distribution Networks (AREA)

Abstract

The present application relates to a system for constructing an integrated database and, more specifically, to a system for constructing an integrated database capable of constructing an integrated database for an integrated system in which two or more systems among a power monitoring system, a transformer prevention diagnosis system, and a GIS prevention diagnosis system are combined. The system for constructing the integrated database comprises: a DB configuration module to configure a database for a device; a data mapping module to perform data mapping for source data inputted from the device; a tag generation and management module to perform mapping and to generate a tag for data mapped by the data mapping module; and a communications module to provide an interface with an external system.

Description

[0001] SYSTEM FOR CONSTRUCTING INTEGRATED DATABASE [0002]

The present invention relates to an integrated database construction system, and more particularly, to an integrated database construction system capable of building an integrated DB for an integrated system in which two or more of a power monitoring system, a transformer prevention diagnosis system, .

Power monitoring systems and power equipment preventive diagnosis systems include power monitoring systems, transformer prevention diagnosis systems, and GIS (Gas Insulated Switchgear) preventive diagnosis systems.

The power monitoring system is a system for monitoring voltage, current, and power in real time. The transformer prevention diagnosis system is a system for monitoring the load of the transformer, the OLTC condition, the gas in the gas and the real time partial discharge. Real-time partial discharge, gas pressure and leakage rate, and lightning arrestor leak current.

Each of these systems has been developed and applied to the site as a separate system, and a database (DB) for each system has been constructed separately.

However, in recent years, there has been an increasing demand for an integrated system in which two or more of the above-described systems are combined. Accordingly, there is a growing need for an integrated DB for an integrated system.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems, and it is an object of the present invention to provide an integrated database building system capable of building an integrated DB for an integrated system in which two or more of a power monitoring system, a transformer prevention diagnosis system, .

The integrated database building system according to an embodiment of the present invention includes a DB configuration module that configures a database for a target device; A data mapping module for performing data mapping on the source data input from the target device; A tag generation management module that performs tag generation and mapping for data mapped by the data mapping module; And a communication module for providing an interface with an external system.

In the integrated database construction system according to an embodiment of the present invention, the DB configuration module can set a communication relay device to which the target device is connected, and set a communication protocol and the target device.

In the integrated database building system according to an embodiment of the present invention, the communication module can support SOAP (Simple Object Access Protocol) and OLE (OLE for Process Control) communication.

The integrated database building system according to an embodiment of the present invention may further include a download module for downloading data constructed in a database.

In the integrated database building system according to an embodiment of the present invention, the database constructed by the integrated database building system may include a resource table defining a communication relay device; A DAS table defining a communication frame of a DAS, which is a terminal device for transmitting data collected from PD sensors and actuators of the GIS to the communication relay device; A Device_PD table (Device_PD table) defining PD sensors connected to the DAS; And a relay table defining a communication table of the relay.

According to an embodiment of the present invention, an integrated database building system capable of building an integrated DB for an integrated system in which two or more of a power monitoring system, a transformer prevention diagnosis system, and a GIS prevention diagnosis system are combined can be provided.

1 is a block diagram illustrating an integrated database building system according to an embodiment of the present invention.
2 is a diagram illustrating an example of a user interface of an integrated database building system according to an embodiment of the present invention.
3 is a diagram illustrating a method of configuring a system DB by an integrated database building system according to an embodiment of the present invention.
4 is a flowchart illustrating a process of configuring a system DB by an integrated database building system according to an embodiment of the present invention.

It is noted that the technical terms used herein are used only to describe specific embodiments and are not intended to limit the invention. It is also to be understood that the technical terms used herein are to be interpreted in a sense generally understood by a person skilled in the art to which the present invention belongs, Should not be construed to mean, or be interpreted in an excessively reduced sense. Further, when a technical term used herein is an erroneous technical term that does not accurately express the spirit of the present invention, it should be understood that technical terms that can be understood by a person skilled in the art are replaced. In addition, the general terms used in the present invention should be interpreted according to a predefined or prior context, and should not be construed as being excessively reduced.

Also, the singular forms "as used herein include plural referents unless the context clearly dictates otherwise. In the present application, the term "comprises," "comprising," or " comprising ", etc. should not be construed as necessarily including the various components or steps described in the specification, Or some steps may not be included, or may be interpreted to include additional components or steps.

Also, suffixes "module", "unit" and "part" for the components used in the present specification are given or mixed in consideration of ease of specification, and each component having its own distinct meaning or role no.

Furthermore, terms including ordinals such as first, second, etc. used in this specification can be used to describe various elements, but the elements should not be limited by the terms. The terms are used only for the purpose of distinguishing one component from another. For example, without departing from the scope of the present invention, the first component may be referred to as a second component, and similarly, the second component may also be referred to as a first component.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings, wherein like reference numerals refer to like or similar elements throughout the several views, and redundant description thereof will be omitted.

In the following description, well-known functions or constructions are not described in detail since they would obscure the invention in unnecessary detail. It is to be noted that the accompanying drawings are only for the purpose of facilitating understanding of the present invention, and should not be construed as limiting the scope of the present invention with reference to the accompanying drawings.

1 is a block diagram illustrating an integrated database building system according to an embodiment of the present invention.

Referring to FIG. 1, an integrated database construction system 100 according to an embodiment of the present invention includes an integrated DB for an integrated system in which two or more of a power monitoring system, a transformer prevention diagnosis system, and a GIS prevention diagnosis system are combined And may include a DB configuration module 110, a data mapping module 120, a tag generation management module 130, a download module 140, and a communication module 150.

The DB configuration module 110 is for configuring a database for a target device to which a database is to be constructed. The DB configuration module 110 sets a communication relay device to which a target system is connected, and sets a communication protocol and a device.

Specifically, the DB configuration module 110 generates a resource by selecting the name (resource name) and redundancy of the communication relay device when setting the communication relay device, and receives information such as the IP address of the communication relay device . Here, redundancy refers to a function of arranging two communication repeaters having the same function as a master and a reserve so that the reserve device operates as a master when a master device fails.

The setting-related information of the communication relay device can be stored in a PCM (Process Control Module) table and a resource table.

The data mapping module 120 is for performing data mapping on the source data received from the target device. Here, the data mapping means to select necessary data among the source data inputted from the target device. This is because it is not necessary to perform operations such as monitoring and logging on all data received from the target device.

The tag generation management module 130 is for performing tag generation and mapping for data mapped by the data mapping module 120. The data selected in accordance with the data mapping by the data mapping module 120 is data on the target device. Therefore, in order to monitor and log this data in the host system, an identifier that is commonly known by the target device and the host system is required. Therefore, a tag for the corresponding data is generated, and the data and the tag are mapped and stored in the database so that the corresponding data can be shared.

The data mapping and tag mapping performed by the data mapping module 120 and the tag generation management module 130 may be stored in a database as a table having a predefined structure as described later.

The download module 140 is for downloading data constructed in the database.

The communication module 150 is for interfacing with an external system and supports SOAP (Simple Object Access Protocol) and OPC (OLE for Process Control) communication. Here, the SOAP and OPC communication are well known to those of ordinary skill in the art, and a detailed description thereof will be omitted.

2 is a diagram illustrating an example of a user interface of an integrated database building system according to an embodiment of the present invention.

2, each component of the integrated database building system according to an embodiment of the present invention, that is, a DB configuration module 110, a data mapping module 120, a tag generation management module 130 and the download module 140 may be provided.

In addition, information on the DB configuration according to the present invention can be displayed in a tree form in a part of the user interface screen, and detailed information on items selected on the tree can be displayed in a part of the user interface screen.

3 is a diagram illustrating a method of configuring a system DB by an integrated database building system according to an embodiment of the present invention.

Referring to FIG. 3, in the tree structure of the DB configuration, the PAS, RES 31 indicates the set communication relay device, and the lower item 32 indicates the set communication protocol and device. 33 is a standard configuration file (e.g., ICD, SCD and WSDL), 34 is a template table, and 35 is a user selected / defined item.

The database constructed by the integrated database building system according to an embodiment of the present invention includes a resource table, a DAS table, a Device_PD table, a HDataBCS table, and the like can do.

The resource table is a table defining a communication relay apparatus, and may include a field as shown in Table 1. [

field data Resource_Id Resource-specific unique ID Name Resource Name Type Resource type PCM1_Id, PCM2_Id Actual communication relay device ID

The DAS table is a template table defining a communication frame of the DAS as a terminal device. DAS collects various data including PD, SF6 GAS and CB Oil from PD sensor and actuator of GIS and transfers it to the communication relay device. The DAS table may include fields as shown in Table 2.

field data Data Data name Descript detailed description No Data order Pos Location in data frame Length Data Size Bit For Bit type Bit position

The device_PD table is a table that defines the PD sensors connected to the DAS, and may include fields as shown in Table 3.

field data Device_ID DAS ID with sensor Sensor_ID Sensor ID Event_Threshold Event Level Detection_Threshold Detection level PD_Phasor Phase shift PD_Max_Count Maximum event value PD_EvThCnt Event level number PD_DtThCnt Detection level number PD_QAlarm_Value Average PD size Alarm check PD_NAlarm_Value Average PD number / 15Min PD_MC_Alarm PD event alarm check PD_N_Alarm Average PD number Alarm check Filter_Mode Noise sensor presence

The relay table is a template table of the relay, for example, in the case of HiMAP-BCS which is a relay supporting the IEC 61850 protocol, it can be expressed as HDataBCS Table. If the IEC 61850 protocol is not supported, the Modbus protocol is also provided. Generally, the Modebus data frame configuration should be specified by the user, but it can be automatically generated if the relay has a fixed type of data frame. The relay table may include fields as shown in Table 4.

field data Category Type of data (Measurement, Harmonic, CB Control) Fcode Function Code Data Data name Descript Explanation Type Data type (U32, L32, U16, I16, BIT) Length Data length No order POS Data frame location Bit When the data type is Bit Bit position

4 is a flowchart illustrating a process of configuring a system DB by an integrated database building system according to an embodiment of the present invention.

Referring to FIG. 4, first, a communication relay apparatus is set by a DB configuration module of an integrated database construction system, and a communication protocol and a device are set (S41).

Thereafter, data selection and mapping are performed by the data mapping module of the integrated database construction system (S42).

Thereafter, tag creation and mapping are performed on the mapped data by the tag generation management module of the integrated database construction system (S43).

Thereafter, if necessary, the data constructed in the database can be downloaded by the download module of the integrated database construction system (S44).

While the present invention has been particularly shown and described with reference to exemplary embodiments thereof, it is to be understood that the invention is not limited to the disclosed exemplary embodiments, but, on the contrary, Those skilled in the art will appreciate that various modifications, additions and substitutions are possible, without departing from the scope and spirit of the invention as disclosed in the accompanying claims.

Therefore, the spirit of the present invention should not be construed as being limited to the above-described embodiments, and all of the equivalents or equivalents of the claims, as well as the following claims, I will say.

100: Integrated database building system
110: DB configuration module
120: Data mapping module
130: Tag generation management module
140: Download module
150: Communication module

Claims (5)

A DB configuration module for configuring a database for the target device;
A data mapping module for performing data mapping on the source data input from the target device;
A tag generation management module that performs tag generation and mapping for data mapped by the data mapping module; And
And a communication module for providing an interface with an external system. The method according to claim 1,
Wherein the DB configuration module sets a communication relay device to which the target device is connected, and sets a communication protocol and the target device. The method according to claim 1,
Wherein the communication module supports SOAP (Simple Object Access Protocol) and OPC (OLE for Process Control) communication. The method according to claim 1,
Further comprising a download module for downloading data built into the database. The method according to claim 1,
Wherein the database constructed by the integrated database building system comprises:
A resource table defining a communication relay device;
A DAS table defining a communication frame of a DAS, which is a terminal device for transmitting data collected from PD sensors and actuators of the GIS to the communication relay device;
A Device_PD table (Device_PD table) defining PD sensors connected to the DAS; And
A relay table defining a communication table of the relay;
≪ / RTI >
KR1020130088656A 2013-07-26 2013-07-26 System for constructing integrated database KR20150012741A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
KR1020130088656A KR20150012741A (en) 2013-07-26 2013-07-26 System for constructing integrated database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
KR1020130088656A KR20150012741A (en) 2013-07-26 2013-07-26 System for constructing integrated database

Publications (1)

Publication Number Publication Date
KR20150012741A true KR20150012741A (en) 2015-02-04

Family

ID=52488713

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020130088656A KR20150012741A (en) 2013-07-26 2013-07-26 System for constructing integrated database

Country Status (1)

Country Link
KR (1) KR20150012741A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107045517A (en) * 2016-10-13 2017-08-15 南京协鑫新能源发展有限公司 The method that new energy manufacturing operation analyzes integral system
US11102088B2 (en) 2017-02-14 2021-08-24 Lsis Co., Ltd. Communication data modeling method

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107045517A (en) * 2016-10-13 2017-08-15 南京协鑫新能源发展有限公司 The method that new energy manufacturing operation analyzes integral system
US11102088B2 (en) 2017-02-14 2021-08-24 Lsis Co., Ltd. Communication data modeling method

Similar Documents

Publication Publication Date Title
US9021431B2 (en) System and method for developing, deploying and implementing power system computer applications
US10506460B2 (en) Self-organizing network mechanism for energy saving during an outage
CN103067206A (en) Internet of things across-machine room distributed type full automatic hot standby server switching system
US9448286B2 (en) Preventive diagnostic system for GIS based on IEC 61850
CN104637265A (en) Dispatch-automated multilevel integration intelligent watching alarming system
KR101700697B1 (en) Wireless remote monitoring and control system and its method
JP7001133B2 (en) Information processing equipment, information processing system, display control method, and program
CN106301926A (en) A kind of method shown based on WEB environment machine room lower various dimensions and monitor in real time
KR20110066695A (en) Multi-functional gataway system for providing power information
KR20150012741A (en) System for constructing integrated database
EP2814224B1 (en) Apparatus and method for measuring and reporting redundant wireless connectivity over time
CN105207367B (en) A kind of electric power remote monitoring and control system
CN101986658A (en) Video matrix remote monitoring management system based on simple network management protocol (SNMP)
KR20170053445A (en) IoT server for monitoring electric control equipment
KR101447031B1 (en) System for searching emergency operating procedure in nuclear power plant and method thereof
CA3150968C (en) Method of and system for monitoring civil air defense equipment maintenance
CN106717047B (en) Ad-hoc network mechanism for saving energy during power outages
KR20110078964A (en) Apparatus for rtu of substation automation system with iec-61850 function and method for controlling thereof
CN103391556A (en) WLAN (wireless local area network) access system, power supply injector device and antenna device
CN107426009B (en) Subway communication network management system
CN106803804A (en) The method and apparatus of transmitting message
CN104166386A (en) High altitude photovoltaic power station power grid disturbance simulation detection device and background operation monitor system
CN104901938A (en) Method for switching control of physical link of network
US20240055857A1 (en) Method and system using virtual networks with power substation networks and control servers
CN104995987B (en) The topological construction method and wireless site of WLAN grid network

Legal Events

Date Code Title Description
WITN Withdrawal due to no request for examination