CN102185379B - Method for exchanging information between distribution measuring and controlling device and upper computer - Google Patents
Method for exchanging information between distribution measuring and controlling device and upper computer Download PDFInfo
- Publication number
- CN102185379B CN102185379B CN201110119376.0A CN201110119376A CN102185379B CN 102185379 B CN102185379 B CN 102185379B CN 201110119376 A CN201110119376 A CN 201110119376A CN 102185379 B CN102185379 B CN 102185379B
- Authority
- CN
- China
- Prior art keywords
- control device
- testing control
- distribution testing
- host computer
- distribution
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention relates to a method for exchanging information between a distribution measuring and controlling device and an upper computer, belonging to the technical field of DA (distribution automation). In the method, each physical quantity required to measure and control in a distribution system is abstracted as a relational database, a UDP (user datagram protocol) mode is adopted to deliver a communication order and parameters in the format of SQL (structured query language), and differences and communication details of the distribution measuring and controlling device are shielded. Upper computer software is supported by the relational databases; the distribution measuring and controlling device comprises a control program, a data sheet on the logical meaning, an NVM (nonvolatile memory) and a random storage. The whole information exchange process comprises six communication processes, namely the access configuration of the distribution measuring and controlling device, the polling on the distribution measuring and controlling device by using the upper computer, the control or configuration of the distribution measuring and controlling device by using the upper computer, the initiative report of the physical quantity changes by the distribution measuring and controlling device, the initiative report of SOE (sequence of event) records by the distribution measuring and controlling device and the soft reset of the distribution measuring and controlling device by using the upper computer. The method is used to improve the transportability of the upper computer software and eliminate fussy adjustment and configuration processes when the distribution measuring and controlling device is accessed and replaced.
Description
Technical field:
The present invention relates to power distribution automation field, be specifically related to the information switching method between a kind of distribution testing control device and host computer.
Background technology:
Power distribution automation, is that to utilize electronics, communication, network technology that distribution real time information is carried out integrated, and the automated management system of complete realizes monitoring, protection, control and the distribution management of distribution system.
Distribution testing control device, for distribution system transformer, circuit breaker, ring main unit, on-pole switch, pressure regulation and reactive-load compensation capacitor, distribution line etc. are measured, controlled, provide distribution system operation to control and manage necessary data to host computer, the device of remote signalling that response host computer provides, remote measurement, remote control, remote regulating instruction.
The distribution testing control device of widely applying at present, in the electrical power distribution automatization system that is mainly used in networking among a small circle, customizing, the information exchange between itself and host computer, major part is to adopt MODBUS communication protocol or off-gauge self-defining communication protocol.MODBUS communication protocol adopts the mode exchange message of read-write register, coil value, but the distribution testing control device that different manufacturers is produced is different for the defined register of same physical amount or coil address, and data format is also self-defining; Adopt the distribution testing control device of non-standard self-defining communication protocol, physical quantity sign, register or coil address and just more not identical with the information switching method of host computer.Thereby realizing in electrical power distribution automatization system process, for different communication protocol, host computer must be developed different signal procedures from the information exchange of distribution testing control device, this causes in the construction of power distribution network, optimization, maintenance, the variation that the communication of host computer and data processor and configuration must be followed distribution testing control device is constantly adjusted, and this to follow timely adjustment be almost to accomplish in actual applications.And thisly follow adjustment, not only increased the complexity of upper software, also can introduce new security breaches and hidden danger.
Summary of the invention:
For overcoming the deficiencies in the prior art, the object of the invention is to propose the information switching method between a kind of distribution testing control device and host computer, make upper software to carry out information exchange with unified signal procedure and dissimilar distribution testing control device, in the time changing distribution testing control device, upper software is without adjusting or change configuration.
Information switching method between distribution testing control device of the present invention and host computer, be relational database needing to measure each physical quantity of controlling in distribution system abstract, the measurement to these physical quantitys and control realize by sending between distribution testing control device and host computer and respond with communications command and the parameter of the encapsulation of SQL SQL grammer.Other functional module of upper software will be processed these needs the physical quantity of measuring, controlling, and only needs access relational databases, and the difference of distribution testing control device and communication details are shielded completely.
Between distribution testing control device and host computer, send and respond communications command and the parameter with the encapsulation of SQL grammer, be not to adopt existing database connected mode, but adopting UDP mode directly to send and respond command text, the result set of SELECT order adopts XML to describe.This mode is compared with existing database connected mode, can realize the plug and play of distribution testing control device, be convenient to newly-increased and replacing distribution testing control device, no matter be upper software or the control program of distribution testing control device, take resource still less, can not cause upper layer software (applications) abnormal because of bottom communication mistake, the control program of distribution testing control device be realized more simple.
Between host computer and distribution testing control device, adopt Ethernet or virtual private network to be connected, form a local area network (LAN), host computer is as the default gateway of this local area network (LAN).Communication protocol stack adopts ICP/IP protocol stack, and transport layer adopts UDP mode, with SQL grammer encapsulation communications command and parameter.
The order that host computer and distribution testing control device send and replying, comprise that the result set that XML describes is all expressly, if need to encrypt for fail safe, adopt the cryptographic protocol of IPSEC or SSL lower floor to realize, this encryption is transparent for the application layer protocol of setting up according to this method.
The upper software moving on host computer of the present invention needs relational database management system RDBMS to support, upper software conducts interviews to relational database by RDBMS.When distribution testing control device of the present invention accesses new system, need to be by outside dynamic host configuration protocol DHCP service acquisition the machine and the IP address of default gateway.Relational database management system RDBMS, relational database, Dynamic Host Configuration Protocol server can be placed on host computer, also can be placed on the server of separately establishing.
In distribution testing control device of the present invention, comprise control program, tables of data, nonvolatile storage, random asccess memory.The tables of data here refers to the relation database table on logical meaning, and its physical store implementation and access method are by distribution testing control device development person self-defining.
Information switching method between distribution testing control device of the present invention and host computer, comprises distribution testing control device access configuration, host computer poll distribution testing control device, PC control or distribution testing control device, the variation of distribution testing control device active reporting physical quantity, distribution testing control device active reporting SOE record, six communication processs of host computer warm reset distribution testing control device is set.The concrete steps of each communication process are:
1. distribution testing control device access configuration communication process
A., when distribution testing control device accesses a new grid first, in factory state, to Dynamic Host Configuration Protocol server application IP address and gateway address, DHCP service can operate on host computer, also can operate on other servers.
The request of b.DHCP server response distribution testing control device, informs IP address and gateway address that distribution testing control device distributes.
C. distribution testing control device obtains IP address and gateway address, and deposits in nonvolatile storage.
D. distribution testing control device sends a CREATE TABLE order based on SQL syntax format to host computer, informs the physical quantity that this device of host computer can be measured.
E. host computer is received after the CREATE TABLE order from distribution testing control device, directly submit to database server as sql command by this order and carry out, the result of execution be in database, created one characterize institute's distribution testing control device that accesses the tables of data of energy measure physical quantities.
F. host computer sends UPDATE order based on SQL syntax format to distribution testing control device, informs that distribution testing control device needs the variation switching value of active reporting, out-of-limit analog quantity and each analog quantity threshold value.
G. distribution testing control device receives after the UPDATE order that host computer sends, resolve this order and parameter, execution arranges the operation of relevant parameter, and the state of self is changed and changes operating state into from factory state, and set parameter, state are all saved in nonvolatile memory.
2. host computer poll distribution testing control device communication process
A. host computer, according to the polling cycle of upper software set, sends a SELECT order based on SQL syntax format to distribution testing control device, informs which physical quantity data distribution testing control device will gather.
B. distribution testing control device is received after SELECT order, with the current collection value structure result set of desired physical quantity, and result set is described to text response to host computer with XML.
C. host computer receives after the XML result set of distribution testing control device loopback, submits to data base management system by XML result set, by data base management system, result set is converted to corresponding data record, deposits in database.
3. PC control or distribution testing control device parameter communication process is set
A. in the time that host computer need to be controlled distribution testing control device or host computer the relevant parameter of distribution testing control device need to be set, host computer sends UPDATE order based on SQL syntax format to distribution testing control device, by the physical quantity of required control or need the parameter of setting to inform distribution testing control device.
B. distribution testing control device receives after the UPDATE order that host computer sends, and resolves this order and corresponding physical quantity is made to action response or parameter that wish is set modifies.
4. distribution testing control device active reporting physical quantity change communication process
A. when the switching value reporting when distribution testing control device monitoring to needs changes or analog quantity is out-of-limit, while meeting the active reporting data qualification setting in above-mentioned layoutprocedure, send a UPDATE order based on SQL syntax format to host computer, required switching value variation or the out-of-limit state of analog quantity reporting informed to host computer.
B. host computer receives after the UPDATE order that distribution testing control device sends, and directly submits to database server as sql command carry out by this order, and the result of execution is to revise corresponding record in the corresponding data table of database.
5. distribution testing control device active reporting SOE record communication process
A. the switching value that need to carry out SOE record when distribution testing control device monitoring to changes or analog quantity when out-of-limit, sends an INSERT order based on SQL syntax format to host computer, and the required SOE recorded information reporting is informed to host computer.
B. host computer receives after the INSERT order that distribution testing control device sends, and directly submits to database server as sql command carry out by this order, and the result of execution is to insert new record in the corresponding data table of database.
6. host computer warm reset distribution testing control device communication process
A. host computer sends a UPDTAE order based on SQL syntax format, informs that distribution testing control device carries out warm reset operation.
B. distribution testing control device receives after UPDTAE order, resolves this order, carries out warm reset operation, and the result of execution is that current each magnitude of physical quantity is saved in nonvolatile storage, and restarts.
Distribution testing control device of the present invention has reset function, and homing action is divided into hard reset and warm reset.Hard reset is triggered by the reset key on installing, and after hard reset, distribution testing control device returns to factory state.Before a new system of access, if distribution testing control device, not at factory state, need to first carry out hard reset operation.The UPDATE order that warm reset is sent by host computer is revised warm reset setting option and is triggered, and warm reset only causes distribution testing control device to be restarted.
In the present invention, no matter be host computer or measure and control device, the command execution of receiving is enabled to the mechanism of similar transaction,, before command execution, first record the value that this order will have influence on, if implementation is made mistakes, recover original value.Implementation status to order will be responded, and response mode is:
After the success of 1.SELECT command execution, respond the result set of describing into XML;
After 2.SELECT command execution is made mistakes, respond and be:
The command text that ERROR:[receives]
3. after non-SELECT command execution success, reply mode is:
The command text that OK:[receives]
4., after non-SELECT command execution is made mistakes, reply mode is:
The command text that ERROR:[receives]
Order transmit leg is sending after an order, starts timer and monitors the reply to this order, does not receive reply, or receive the reply of carrying out after makeing mistakes if overtime, resends this order.Continuous 3 times overtime or receive and carry out the reply that makes mistakes, carry out miscue and processing.
Compared with prior art, the method of the invention is meeting under the prerequisite of the open system interconnection (OSI) osi model stipulating in ISO7498, adopt SQL grammer to build communications command, realize the information exchange between host computer and distribution testing control device, provide a kind of convenient, flexible data to read, control and new tool more.The present invention can improve the portability of host computer procedure, in the time of the access of distribution testing control device and replacing, save comparatively loaded down with trivial details adjustment, layoutprocedure, improve the interchangeability of distribution testing control device, promote standardization, the ease-of-use ability of information exchange between host computer and distribution testing control device.
Accompanying drawing explanation:
Fig. 1 is host computer and distribution testing control device syndeton schematic diagram.
Fig. 2 is the information switching method logical construction schematic diagram of host computer and distribution testing control device.
Fig. 3 is distribution testing control device access configuration communication process schematic diagram.
Fig. 4 is host computer poll distribution testing control device communication process schematic diagram.
Fig. 5 is PC control or distribution testing control device parameter communication process schematic diagram is set.
Fig. 6 is distribution testing control device active reporting host computer communication process schematic diagram.
Fig. 7 is distribution testing control device active reporting SOE record communication process schematic diagram.
Fig. 8 is host computer warm reset distribution testing control device communication process schematic diagram.
Embodiment:
As shown in Figure 1, information switching method between a kind of distribution testing control device and host computer, described host computer is connected by Ethernet or VPN with distribution testing control device, form a local area network (LAN), protocol stack adopts TCP/IP, host computer is as the default gateway of local area network (LAN), the text of communication based on UDP mode transmission command and response.
As shown in Figure 2, moving upper software, DHCP service, DataBase management system in host computer, relational database DB_PD is also placed on host computer, and upper software conducts interviews to the tables of data in DB_PD by DBMS.Distribution testing control device comprises control program, tables of data, nonvolatile storage, random asccess memory, and control program and T_SELF, T_CKL tables of data are kept in nonvolatile storage, and T_AL is kept in random asccess memory.
In the relational database DB_PD of host computer, comprise table T_WLL, table T_SOE, table T_PID1 to showing T_PIDn tables of data, upper software conducts interviews to it by DBMS.
Table T_WLL is the tables of data of the definition distribution testing control device physical quantity of monitoring, controlling, and the essential field of this table is as shown in the table:
Field | Field type | Field implication |
F_WLL | Character type | The physical quantity that needs in distribution system or can measure, control can not be empty |
F_ZDM | Character type | To the criteria field name of F_WLL definition, major key, can not be empty |
F_LB | Character type, shaping | Being used for characterizing F_WLL is analog quantity or digital quantity, can not be empty |
F_IO | Character type, shaping | Being used for characterizing F_WLL is input variable or output variable, can not be empty |
F_MS | Character type, text-type | By the implication of text description F_WLL, can be empty |
F_UNIT | Character type | The linear module of this physical quantity can be empty |
Table T_WLL can will need the physical quantity kind of measuring and controlling all to list in distribution system, be a well-determined criteria field name of every kind of physical quantity definition.When field type is realized under different Database Systems, data type is difference to some extent, can be by compatible data type.The data dictionary that table T_WLL knows altogether as upper software and all distribution testing control devices, is kept in DB_PD.T_WLL is not unalterable, first need the physical quantity of measuring, controlling all to list present stage as far as possible, while needing the newly-increased physical quantity of measuring, control, as long as add the new T_WLL that is recorded to, existing upper software and distribution testing control device can continue to use later.But should avoid revising the record of T_WLL, if really need to revise the record of T_WLL, the software of upper software and distribution testing control device also will be revised accordingly as far as possible.
Table T_SOE is for recording the sequence of events recording SOE of distribution testing control device, and field and implication that this table comprises are as shown in the table:
Field name | Field type | Field implication |
F_DateTime | Date time type | The time on date that event occurs |
F_PIDC | Character type | The EIC equipment identification code of distribution testing control device |
F_ZDM | Character type | The criteria field name of the physical quantity of firing event |
F_PVALUE | Floating type | The value of this physical quantity before event |
F_CVALUE | Character type | The value of this physical quantity after event |
When distribution testing control device monitoring to need record event time, send Insert order to host computer, upper software receives orders after text, this command text is submitted to DBMS and carry out, after running succeeded, in T_SOE, insert record, upper software execution result response to distribution testing control device.
In distribution testing control device, also according to tables of data T_SELF and T_CKL on two logical meanings of the formal definition of relation database table, be stored in the nonvolatile storage of distribution testing control device, the physics realization mode of these two tables is by developer's self-defining of distribution testing control device.
Table T_SELF is the tables of data of a definition distribution testing control device configuration parameter, at least comprises setting option F_SETTING_ITEM, two fields of settings F_ITEM_VALUE.These two fields are all character type or text-type field.In table T_SELF, at least comprise following record:
PIDC be each distribution testing control device while dispatching from the factory with a globally unique EIC equipment identification code, this identification code can obtain by the administrative mechanism of similar MAC Address, also can obtain by a website application, and this EIC equipment identification code to the table name of showing T_PIDn, is linked different distribution testing control device host computer in order to differentiation with tabulation T_PID1.The order that distribution testing control device sends to host computer, does not overtimely receive reply continuous 3 times, and TIMEOUT_COUNT adds 1.The order that distribution testing control device sends to host computer, continuous reply of receiving execution error for 3 times, ERROR_COUNT adds 1.TIMEOUT_COUNT and ERROR_COUNT can be read with SELECT order by host computer, set to 0 with UPDATE order.
Table T_CKL is the tables of data that a definition distribution testing control device needs the variation of active reporting switching value, out-of-limit analog quantity and each analog quantity threshold value, at least comprises following field:
In the random access memory ram of distribution testing control device, there is a tables of data T_AL on logical meaning, for depositing the currency of physical quantity of this device observing and controlling.Table T_AL comprises field name F_ZDM, F_VALUE.Each Field Definition is as follows:
The magnitude of physical quantity of this distribution testing control measurement device of host computer poll is just by sending sql command: select * fromT_AL where F_ZDM=[xxxx] be converted into the query manipulation of his-and-hers watches T_AL, to the control of certain physical quantity just by transmission sql command: update T_AL set F_VALUE=[xxxx] where F_ZDM=[xxxx] renewal that is converted into his-and-hers watches T_AL inquires about.T_AL is only the table on logical meaning, and the specific implementation of its storage is by developer's self-defining of measure and control device control program.
Distribution testing control device is with reset function, and homing action is divided into hard reset and warm reset.
Hard reset is triggered by the reset key on installing, and after hard reset, to record full recovery be factory-said value for T_SELF, T_CKL all.Before a new system of access, if distribution testing control device, not at factory state, need to first carry out hard reset operation.
The UPDATE order that warm reset is sent by host computer is revised RESET setting option and is triggered, and warm reset only causes device to be restarted, and does not revise the value of the each record of T_SELF and T_CKL, and regenerate T_AL according to T_CKL after restarting.
Table T_PID1 to show T_PIDn be respectively the distribution testing control device 1 that is connected to system to distribution testing control device N for storing the tables of data of each distribution testing control device monitoring information, list structure is consistent with T_CKL.The corresponding table of each distribution testing control device, after the first connecting system of distribution testing control device, send CREATE TABLE order to host computer by distribution testing control apparatus control program, trigger this table of upper software creation, the table name of this table is the EIC equipment identification code PIDC of corresponding distribution testing control device.T_PID1 is as follows to showing the each Field Definition of T_PIDn for table:
The information exchange course of work of the method for the invention comprises: distribution testing control device accesses configuration communication process, host computer poll distribution testing control device communication process, PC control or distribution testing control device parameter communication process, distribution testing control device active reporting host computer physical quantity change communication process, distribution testing control device active reporting host computer SOE record communication process, host computer warm reset distribution testing control device communication process are set.
As shown in Figure 3, the concrete steps of distribution testing control device access layoutprocedure are:
A. distribution testing control device, first when connecting system network, distributes IP address and the gateway address of this device to host computer DHCP service request.
B. host computer DHCP service response request, informs the IP address and the gateway address that distribute to distribution testing control device.
C. distribution testing control device obtains IP address and gateway address, gives respectively SELF_IP and DEFAULT_GW field in T_SELF table, and is deposited in this distribution testing control device nonvolatile storage.
D. distribution testing control device obtains after IP address and gateway address, take this IP address as source address, gateway address is destination address, send a CREATE TABLE order based on SQL syntax format to host computer, the EIC equipment identification code PIDC that the table name creating is this device, structure is identical with table T_CKL with content, informs with this physical quantity that this device of host computer can detect, control.Distribution testing control device starts to wait for the implementation status response of CREATE TABLE order afterwards.
E. host computer is received after the CREATE TABLE order from distribution testing control device, directly submitting to database server as sql command by this order carries out, in database D B_PD, create table T_PIDx, can measure physical quantities data for preserving corresponding distribution testing control device.According to the implementation status of CREATE TABLE order, distribution testing control device is responded.
F. host computer sends a UPDATE order based on SQL syntax format to distribution testing control device, and distribution testing control device is set needs the threshold value of the variation switching value of active reporting, out-of-limit analog quantity and each analog quantity.Slave computer starts to wait for the implementation status response of UPDATE order afterwards.
G. distribution testing control device receives after the UPDATE order that host computer sends, resolve command, execution arranges relevant parameter operation in T_CKL table, in RAM, generate T_AL table, and current state in T_SELF table is changed to operating state from factory state, the data of table T_CKL and table T_SELF table are all saved in nonvolatile memory.Respond to host computer according to the implementation status of UPDATE order.If power down in distribution testing control device busy process, after re-powering, detects that in T_SELF table, current state is operating state, regenerate T_AL table according to the content in T_CKL.
As shown in Figure 4, the concrete steps of host computer poll distribution testing control device communication process are:
A. host computer is according to the polling cycle of upper software set, send a SELECT order based on SQL syntax format to distribution testing control device, parameter is specified relative recording and the field obtained in table T_AL, informs that with this distribution testing control device host computer will gather the currency of which physical quantity.
B. distribution testing control device is received after SELECT order, resolves this order, the currency of corresponding physical quantity in command parameter is extracted and forms XML from table T_AL and describe text, and loopback is to host computer.If can not form the desired result set of SELECT order, respond by the state of SELECT command execution mistake.
C. host computer receives after the XML result set of distribution testing control device loopback, revises corresponding data record in table T_PIDx according to this result set.
As shown in Figure 5, PC control or concrete steps that distribution testing control device parameter communication process is set are:
A. in the time that host computer need to be controlled distribution testing control device or host computer the relevant parameter of distribution testing control device need to be set, host computer sends a UPDATE order based on SQL syntax format to distribution testing control device, comprises criteria field name and controlling value or the settings of the physical quantity of required control or setting in parameter.Host computer starts to wait for the implementation status response of UPDATE order afterwards.
B. distribution testing control device receives after the UPDATE order that host computer sends, resolve this order, according to parameter, the respective record of T_SELF in this device or T_CKL is modified, table T_AL in RAM is synchronizeed and is revised with T_CKL, triggers the control action of its corresponding physical quantity or the modification of corresponding parameter action.And according to the implementation status of UPDATE order, host computer is responded.
As shown in Figure 6, the concrete steps of distribution testing control device active reporting physical quantity change communication process are:
A. according to table T_CKL, when distribution testing control device monitoring changes or when analog quantity is out-of-limit, sends a UPDATE order based on SQL syntax format to host computer to the switching value that need to report, in parameter, comprise switching value variation or the out-of-limit analog quantity that need to report.Distribution testing control device starts to wait for the implementation status response of UPDATE order afterwards.
B. host computer receives after the UPDATE order that distribution testing control device sends, and directly submits to database server DBMS as sql command carry out by this order, and the result of execution is to revise respective record in database D B_PD corresponding data table T_PIDx.And according to the implementation status of UPDATE order, distribution testing control device is responded.
As shown in Figure 7, the concrete steps of distribution testing control device active reporting SOE record communication process are:
C. according to table T_CKL, when distribution testing control device monitoring changes or analog quantity when out-of-limit to the switching value that need to carry out SOE record, send an INSERT order based on SQL syntax format to host computer, in parameter, comprise each value that the SOE that need to report records.Distribution testing control device starts to wait for the implementation status response of INSERT order afterwards.
A. host computer receives after the INSERT order that distribution testing control device sends, and directly submits to database server DBMS as sql command carry out by this order, and the result of execution is to insert new record in database D B_PD corresponding data table T_SOE.And according to the implementation status of INSERT order, distribution testing control device is responded.
As shown in Figure 8, the concrete steps of host computer warm reset distribution testing control device communication process are:
A. host computer sends a UPDTAE order based on SQL form, and the RESET setting option in parameter specified modification T_SELF is TRUE, informs that distribution testing control device carries out warm reset operation.Host computer starts to wait for the implementation status response of UPDATE order afterwards.
B. distribution testing control device receives after this order, resolves and carries out this order, triggers warm reset operation, the currency of each physical quantity in T_AL is deposited in T_CKL, the RESET putting in T_SELF is set to FALSE again, and responds the implementation status of UPDATE order to host computer, then restarts.
Claims (2)
1. the method for exchange message between a distribution testing control device and host computer, it is characterized in that the method is by abstract in relational database the physical quantity that needs in distribution system to measure and control, between host computer and distribution testing control device, adopt Ethernet or VPN to be connected, communication protocol adopts the UDP communication mode in ICP/IP protocol stack, transmit the communications command and the response that build with SQL grammer, realize measurement and control to physical quantity; Whole information exchanging process comprises distribution testing control device access configuration, host computer poll distribution testing control device, PC control or distribution testing control device, the variation of distribution testing control device active reporting physical quantity, distribution testing control device active reporting SOE record, six communication processs of host computer warm reset distribution testing control device is set, wherein
Described distribution testing control device access configuration communication process comprises: when 1. distribution testing control device accesses a new grid first, in factory state, to Dynamic Host Configuration Protocol server application IP address and gateway address, DHCP service can operate on host computer, also can operate on other servers; 2. dhcp server response distribution testing control device request, informs IP address and gateway address that distribution testing control device distributes; 3. distribution testing control device obtains IP address and gateway address, and deposits in nonvolatile storage; 4. distribution testing control device sends a CREATE TABLE order based on SQL syntax format to host computer, informs the physical quantity that this device of host computer can be measured; 5. host computer is received after the CREATE TABLE order from distribution testing control device, directly submit to database server as sql command by this order and carry out, the result of execution be in database, created one characterize institute's distribution testing control device that accesses the tables of data of energy measure physical quantities; 6. host computer sends UPDATE order based on SQL syntax format to distribution testing control device, informs that distribution testing control device needs the variation switching value of active reporting, out-of-limit analog quantity and each analog quantity threshold value; 7. distribution testing control device receives after the UPDATE order that host computer sends, resolve this order and parameter, execution arranges the operation of relevant parameter, and the state of self is changed and changes operating state into from factory state, and set parameter, state are all saved in nonvolatile memory;
Described host computer poll distribution testing control device communication process comprises: 1. host computer is according to the polling cycle of upper software set, send a SELECT order based on SQL syntax format to distribution testing control device, inform which physical quantity data distribution testing control device will gather; 2. distribution testing control device is received after SELECT order, with the current collection value structure result set of desired physical quantity, and result set is described to text response to host computer with XML; 3. host computer receives after the XML result set of distribution testing control device loopback, submits to data base management system by XML result set, by data base management system, result set is converted to corresponding data record, deposits in database;
Described PC control or distribution testing control device communication process is set comprises: 1. in the time that host computer need to be controlled distribution testing control device or host computer the relevant parameter of distribution testing control device need to be set, host computer sends UPDATE order based on SQL syntax format to distribution testing control device, by the physical quantity of required control or need the parameter of setting to inform distribution testing control device; 2. distribution testing control device receives after the UPDATE order that host computer sends, and resolves this order and corresponding physical quantity is made to action response or parameter that wish is set modifies;
Described distribution testing control device active reporting physical quantity change communication process comprises: when the switching value 1. reporting when distribution testing control device monitoring to needs changes or analog quantity is out-of-limit, while meeting the active reporting data qualification setting in above-mentioned layoutprocedure, send a UPDATE order based on SQL syntax format to host computer, required switching value variation or the out-of-limit state of analog quantity reporting informed to host computer; 2. host computer receives after the UPDATE order that distribution testing control device sends, and directly submits to database server as sql command carry out by this order, and the result of execution is to revise corresponding record in the corresponding data table of database;
Described distribution testing control device active reporting SOE record communication process comprises: the switching value that 1. need to carry out SOE record when distribution testing control device monitoring to changes or analog quantity when out-of-limit, send an INSERT order based on SQL syntax format to host computer, the required SOE recorded information reporting is informed to host computer; 2. host computer receives after the INSERT order that distribution testing control device sends, and directly submits to database server as sql command carry out by this order, and the result of execution is to insert new record in the corresponding data table of database;
Described host computer warm reset distribution testing control device communication process comprises: 1. host computer sends a UPDTAE order based on SQL syntax format, informs that distribution testing control device carries out warm reset operation; 2. distribution testing control device receives after UPDTAE order, resolves this order, carries out warm reset operation, and the result of execution is that current each magnitude of physical quantity is saved in nonvolatile storage, and restarts.
2. the method for exchange message between distribution testing control device according to claim 1 and host computer, is characterized in that: in upper computer software, comprise data base management system and application data base; In distribution testing control device, comprise control program, tables of data, nonvolatile storage and random asccess memory; Wherein: tables of data is the relation database table on logical meaning, its physical store implementation and access method are by distribution testing control device development person self-defining.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201110119376.0A CN102185379B (en) | 2011-05-10 | 2011-05-10 | Method for exchanging information between distribution measuring and controlling device and upper computer |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201110119376.0A CN102185379B (en) | 2011-05-10 | 2011-05-10 | Method for exchanging information between distribution measuring and controlling device and upper computer |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102185379A CN102185379A (en) | 2011-09-14 |
CN102185379B true CN102185379B (en) | 2014-06-11 |
Family
ID=44571472
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201110119376.0A Expired - Fee Related CN102185379B (en) | 2011-05-10 | 2011-05-10 | Method for exchanging information between distribution measuring and controlling device and upper computer |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102185379B (en) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106201627B (en) * | 2016-07-21 | 2019-05-24 | 南京大全自动化科技有限公司 | A kind of new energy photovoltaic case becomes TT&C system and its teleprogram method for edition management |
CN106375126A (en) * | 2016-09-06 | 2017-02-01 | 南京大全自动化科技有限公司 | Onsite batch equipment maintenance method of photovoltaic box transformer substation measurement and control device |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1303522C (en) * | 2004-08-19 | 2007-03-07 | 西安交通大学 | Design method for switch equipment on-line state monitor special chip |
CN101026315A (en) * | 2006-02-22 | 2007-08-29 | 上海茂索机电设备有限公司 | Low voltage distribution microcomputer integrated management device and method |
-
2011
- 2011-05-10 CN CN201110119376.0A patent/CN102185379B/en not_active Expired - Fee Related
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1303522C (en) * | 2004-08-19 | 2007-03-07 | 西安交通大学 | Design method for switch equipment on-line state monitor special chip |
CN101026315A (en) * | 2006-02-22 | 2007-08-29 | 上海茂索机电设备有限公司 | Low voltage distribution microcomputer integrated management device and method |
Non-Patent Citations (4)
Title |
---|
低压配电智能监控***的产品化设计;迟岩等;《集美大学学报》;20040630;第9卷(第2期);138-142 * |
基于PLC的能源设备监控管理***;王巧巧等;《网络信息技术》;20031231;第22卷(第4期);36-37 * |
王巧巧等.基于PLC的能源设备监控管理***.《网络信息技术》.2003,第22卷(第4期),36-37. |
迟岩等.低压配电智能监控***的产品化设计.《集美大学学报》.2004,第9卷(第2期),138-142. |
Also Published As
Publication number | Publication date |
---|---|
CN102185379A (en) | 2011-09-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10992494B2 (en) | Gateway round-robin system | |
US9954968B2 (en) | Remote access gateway configurable control system | |
CN104394008B (en) | A kind of method and its system of unified configuration different type interchanger | |
US9705962B2 (en) | Asynchronous reporting system | |
CN108989358B (en) | Method for acquiring running data of textile machine based on TCP/IP protocol | |
CN102434478B (en) | Remote intelligent control system and control method for fan | |
CN106936831A (en) | System, method and/or equipment for realizing the communication between the equipment using different communication protocol | |
CN103733148A (en) | Energy management gateways and processes | |
CN112600891A (en) | Edge cloud cooperation system based on information physical fusion and working method | |
CN102957568B (en) | A kind of method for managing and monitoring of multi node server | |
US20140082068A1 (en) | Mailbox data storage system | |
CN113890830A (en) | IEC104 main station simulation system | |
CN115622986A (en) | Sensor communication protocol analysis method, system, storage medium and electronic equipment | |
CN102185379B (en) | Method for exchanging information between distribution measuring and controlling device and upper computer | |
US9304963B2 (en) | Data table structure for self-organized management of communication with functional modules coupled via backplane assembly based on received module description including control logic | |
CN104410530A (en) | Method of finding and utilizing MAC address to manage industrial switches | |
CN104270432B (en) | Based on drilling well industry Real-time Data Service system and data interactive method | |
CN113395180B (en) | Industrial real-time big data acquisition and release method and industrial real-time big data platform | |
CN102685726B (en) | Adaptive management entity, base station self-configuring method and base station self-configuring system | |
Ran et al. | Development of computer intelligent control system based on Modbus and WEB technology | |
CN110161896A (en) | Affiliated method for the control system of Power Supply Assembly and for being started, being controlled and being monitored for Power Supply Assembly | |
CN106330567A (en) | Server management control method and server management control system for server cluster | |
CN113904928A (en) | Telesignaling configuration rapid checking system and method for telemechanical device | |
CN113824801A (en) | Intelligent integration terminal unified access management component system | |
CN110493343B (en) | OPC-based method for communicating with multiple PLCs |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20140611 Termination date: 20160510 |