CN104200397A - Method for verifying consistence of designed input file and variable information database of DCS (Distributed Control System) of nuclear power station - Google Patents
Method for verifying consistence of designed input file and variable information database of DCS (Distributed Control System) of nuclear power station Download PDFInfo
- Publication number
- CN104200397A CN104200397A CN201410428254.3A CN201410428254A CN104200397A CN 104200397 A CN104200397 A CN 104200397A CN 201410428254 A CN201410428254 A CN 201410428254A CN 104200397 A CN104200397 A CN 104200397A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- point
- roll
- input
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for verifying consistence of a designed input file and a variable information database of a DCS (Distributed Control System) of nuclear power station. The method comprises the steps of: searching in the variable information database according to point information of the designed input file, and storing the searching result in a data search comparing chart, then comparing the designed point information with the point information of the database in the data search comparing chart. In the scheme provided by the invention, the data search is carried out according to the data type, and multiple data can be inquired per each time. Meanwhile, the data search range is decreased progressively in the database according to the SHEET page, and the search of the data is separated from the comparing working region; that is to say, firstly the search of all the data is carried out, the searched data and the designed input data are distributed in the same EXCEL SHEET table, and then the consistence comparison work of the data is carried out uniformly. Therefore, the data searching and comparing time can be saved efficiently.
Description
Technical field
The invention belongs to the technical field based on nuclear power station DCS system, particularly the method for the mass data fast query of a kind of nuclear power station DCS variable information database and input design file comparison.
Background technology
In nuclear power station distributed monitoring control system field, variable information database is an important ingredient wherein, it is an EXCEL file that comprises multiple SHEET pages in form, in variable information database, each variable data is defined as to one " variable point ", the information of variable point is made up of some features of this point, these features are called as " point ", point item has multiple, wherein, being marked as the some item (being all directly called below roll-call) of roll-call, is that this " variable point " distinguishes the unique identification of other " variable point "; Point in variable information database is to classify according to the some item information of this point, classifies according to " vertex type "." the variable point " of identical point type has identical information, and these " variable points " with identical point item are stored in same SHEET page in variable information database, and this SHEET page is just with this kind of vertex type name.
At nuclear power station DCS system design stage, need to first design the information of these variable points, comprise and call the roll and put some information such as description, the dot information designing is stored in input design file with document form, and the dot information in input design file is to distribute by function, carrys out design point information according to flogic system, and in the engineering construction stage, conventionally according to the functional requirement of each field control station, input design file is carried out to function fractionation and Project Configuration, after Project Configuration completes, again the dot information of each field control station is integrated, (DCS system is in the Project Configuration stage to form variable information database, except the dot information in input design file carries out configuration, also design a large amount of intermediate variables, these intermediate variables are also the important component parts of variable information database), variable information database after the system testing stage need to complete Project Configuration and the dot information in input design file carry out consistency checking (in the time carrying out consistency checking, only verify that whether the dot information in input design file is consistent with variable information database, a large amount of intermediate variables is not carried out to consistency checking), when dot informations all in input design file is in variable information database completely in correspondence, the variable point in all input design files has corresponding variable point in variable information database, and the institute of these a corresponding variable points a little value is also identical, this project configuration is exactly correct, otherwise wrong, need to revise according to input design file the Project Configuration of DCS system.
Because the dot information in nuclear power station DCS system variable information database is to be distributed in different EXCEL SHEET pages according to vertex type, and dot information in input design file is to carry out raisonnely according to function, therefore needs a kind of method two parts of fileinfos can be searched fast and compared.
In variable information database, information whether consistent with input design file work in checkpoint is always one of difficulties of nuclear power station DCS system testing.Trace it to its cause and be that the data volume of input design file and variable information database is all huger, and the two is not equity in data volume, for example variable information database is usually made up of more than 100 SHEET pages, approximately have more than 50,000 variable point, each variable point on average approximately has 30 kinds of some item information; And variable point in input design file approximately has 10000 left and right, each variable point approximately has 10 kinds of some item information, and therefore to need data volume be variable dot information in the input design file of 10000 (point) × 10 (point) carries out consistency desired result in data volume is the variable information database of 50000 (point) × 30 (point).
The conventional test methodologies adopting is at present: the mode that uses computer programming, each point for variable point in input design file is searched and is compared in variable information database, but because data volume is huge, even if adopting computer program to carry out datamation searches and compares, consuming time also relatively long, as the upper routine data volume in the situation that, use Zhaoyang of Legend's notebook computer (be configured to:
core (TM) 2 CPU, P7450@2.13GHz, 1.60GHz, the internal memory of 1.86GB.Adopt Microsoft Windows XP Professional version 2 002 Service Pack 2 operating systems) conventionally need just can complete for 1～2 day searching and comparison work of total data.
Analysis conventional is tested the data search that adopts and the computer program process flow diagram (as shown in Figure 6) of comparison method, we find that its data search and comparison method are defective, especially in the situation that data query amount is larger, be easy to cause data search inefficiency, long phenomenon consuming time.Its data search and comparison method defect mainly contain following three aspects:
One: carry out in data search process in application classic method, the reduction speed of data volume to be found is slow, because just search data at every turn.
Its two: application classic method carry out in data search process, the seek scope of data is not reduced.Start till inquire about last data from inquiring about first data, seek scope is all of whole database, and seek scope is without any change.
Its three: application classic method carry out in data search process, that data search and consistance comparison work are put together and carried out, first to carry out searching of " point " for each data point, then the be correlated with comparison of coherence of " point ", carry out again afterwards searching and comparing of next data, so move in circles.Like this searching and comparing all and independently carry out a little, have the dot information of how many needs comparisons, just need to repeat how many times.
Summary of the invention
Low to the search efficiency of dot information in input design file for solving in prior art nuclear power station DCS variable information database, long problem consuming time, the present invention is directed to the feature of carrying out dot information consistency check test in nuclear power station DCS variable information database, proposed a kind of utilize computing machine automatically to carry out data query and the optimization method compared can fast query data, greatly improve searching and comparison speed of data, shorten the test duration, improve testing efficiency, realize the efficient and accurate of whole test process.Concrete scheme is as follows:
The invention provides a kind of nuclear power station DCS system input file and variable information data base consistency(-tance) method of calibration, wherein, input design file is the file that described DCS system design stage uses, for the concrete physical parameter of storing the nuclear power station field apparatus that need to realize in DCS system, the relevant information of described physical parameter is defined as design point information in described input design file, described variable information database be DCS System Implementation complete after, file the concrete physical parameter that described nuclear power station DCS system collects from field apparatus is integrated, described variable information database, be defined as database dot information from the physical parameter information of described DCS system combination, it is characterized in that, described consistency desired result method is exactly: in variable information database, search corresponding database dot information according to the described design point information of described input design file, and the described database dot information finding and described design point information are stored in same deck watch, then, in described deck watch, design point information and database dot information are compared, and mark comparison result,
Here, described field apparatus comprises: reactor pressure vessel, steam generator, reactor coolant pump, voltage stabilizer, sensor, amplifier, indicator, registering instrument, limit switch, pilot lamp, relay equipment, steam turbine, generator, feed pump, separator, main-transformer;
Described physical parameter comprises: steam generator thermal power, main feedwater enthalpy, blowdown enthalpy, feedwater flow, blowdown flow, enthalpy of wet steam, neutron flux, temperature, pressure, flow, voltage, electric current, equipment leave state, equipment off status.
Described input design file is: I/O variable information table.
At described nuclear power station DCS system design stage, described physical parameter comprises multiple features, and the feature of described physical parameter is defined as the input point item of described input point information in described input design file; After System Implementation completes, described DCS system to described variable information database, and is defined as database point by the feature integration of the described physical parameter collecting from field apparatus; The input point information of storing in described deck watch is made up of all input point items of described input point information, the described database dot information of storing in described deck watch is made up of the database point of described database dot information, the described design point information of carrying out in described deck watch and the comparison of database dot information, described exactly input point information a little information compare with a corresponding database point information of described database dot information, and distinguish the comparison result of the corresponding input point item of mark information and date storehouse point item information;
Described design point item at least comprises input roll-call: it is the unique identification of the described physical parameter of difference and other physical parameter that described input is called the roll;
Described database point item at least comprises database roll-call: it is the unique identification that described DCS system is distinguished the physical parameter collecting from field apparatus other physical parameter that described database is called the roll, in the design phase, the parameter of physical quantity is after DCS System Implementation is complete, and the database roll-call that input corresponding to described physical parameter called the roll corresponding with the respective physical parameter collecting from field apparatus from DCS system is consistent;
In described variable information database, searching with the corresponding database dot information of described design point information is exactly to search the value database dot information identical with described design roll-call value that database is called the roll; Described input is called the roll and is comprised: the concrete physical quantity title of the numbering+described field apparatus representative of this place flogic system title+this institute's corresponding device.
Described database dot information also comprises vertex type, and vertex type is the type of the physical parameter that collects from field apparatus of described DCS system, and the database dot information that described vertex type is identical has identical database point;
Described vertex type comprises: 2 limit value analog input signals (AVI), 4 limit value analog input signals (AVI4), 8 limit value analog input signals (AVI8), analog quantity output signals (AVO), switching value input signal (DVI), switching value output signal (DVO) etc.;
Preferably, described 2 limit value analog input signals (AVI) at least comprise: call the roll, put description, lower bound warning, high limit warning etc. and put item;
Described 4 limit value analog input signals (AVI4) at least comprise: the points such as roll-call, point are described, the first lower bound is reported to the police, the second lower bound is reported to the police, the first high limit is reported to the police, the second high limit warning;
Described 8 limit value analog input signals (AVI8) at least comprise: the point such as call the roll, point is described, the first lower bound is reported to the police, the second lower bound is reported to the police, the 3rd lower bound is reported to the police, the 4th lower bound is reported to the police, the first high limit is reported to the police, the second high limit is reported to the police, third high limit is reported to the police, the 4th high limit is reported to the police.
In nuclear power station DCS system, design document is verified after engineering construction to be necessary, especially for the checking of I/O variable information table.Consider for the high security to nuclear power plant system; need timing whether normally to detect the equipment such as instrument, the plate operation of all passages of nuclear power station in the DCS system operation phase; especially in the time that the input signal (in DCS system, the input/output signal of equipment being also defined as to physical quantity) that some equipment detected is outside safety value scope; also need to start Reactor trip, to reduce to greatest extent nuclear power station operation risk.As can be seen here, the input/output signal of the equipment such as instrument, plate of nuclear power station DCS system can affect the coordinated operation of multiple equipment, therefore need the physical quantity of the equipment such as instrument, plate in nuclear power station DCS system to define multiple features, when from DCS system acquisition to the equipment such as instrument, plate physical quantity all features with design in full accord, the communication between guarantee relevant device is accurate.And all features of the physical quantity of the equipment such as instrument, plate of DCS system are defined as an item, so very necessary for comparing of the corresponding database point of respective point information in the input point item in input design file and variable information database.
Preferably, described input design file, described variable information database and described deck watch are EXCEL file, described design point information is stored in the same SHEET page of described input design file, described database dot information is stored in by described vertex type in the different SHEET pages of described variable information database, the database dot information of storing in same SHEET page in described variable information database has identical vertex type, the function INDEX () and the MATCH () that utilize EXCEL to carry, input design file is all stored in same a line of described deck watch with input point information and database dot information corresponding in variable information database, and then utilize the EXACT () function of EXCEL to compare to design point information and corresponding database dot information, mark comparison result,
Preferably, described deck watch is described input design file;
Preferably, described deck watch is database deck watch, described database deck watch generates in the time that execution is searched in variable information database according to the design point information of input design file, described database deck watch's generation method is: all design point information in described input design file are called the roll according to described design, the described design input point item information order that need to contrast copies in described database deck watch, and after ranking, inserts described design point as the row that extract corresponding described database roll-call information in described variable information database, insert afterwards the row as a corresponding database point information in extracting variable information database at described design point item,
Preferably, as the column heading that extracts corresponding described database roll-call information in described variable information database be: " PN_DB "; Insert afterwards as the column heading of a corresponding database point information in extracting variable information database at described design point item and be: " design point item value "+" _ DB ".
Because described input design file, described variable information database and described deck watch are EXCEL file, the step therefore lookup result being stored in data search deck watch is:
1) first, and all data areas of described deck watch are made as to region to be found, first SHEET page of choice variable information data library file is as current operation page simultaneously;
2) in deck watch, apply INDEX () and MATCH () function, taking the current SHEET page of described variable information database as seek scope, in described deck watch, do not find described database associated databases roll-call region to carry out writing and filling of " the inquiry formula of calling the roll ";
3) by described step 2) in carried out the row at the place, data area that described " the inquiry formula of calling the roll " fill, sort according to the row at described database roll-call place;
4) to described step 3) in carried out in database point the region of sequence, application INDEX () and MATCH () function continue to search and fill other relevant database points item information;
5) using the next SHEET page of described variable information database as current operation page, and perform step 2), until all inputs roll-calls that variable information database executes in searching of last SHEET page or data search deck watch have all been searched complete in variable information database;
Preferably, in step 2) in, the concrete grammar of searching that database is called the roll is: ranks, do not find in the cell of roll-call data at data search deck watch's database point, and input or filling " the inquiry formula of calling the roll ", described " the inquiry formula of calling the roll " is:
"=INDEX (array, match (lookup_value, lookup_array, [match_type])) ", wherein,
Array: be the scope of the row at " roll-call " place in the current SHEET page of variable information database,
Match (): be EXCEL function, return and specify the position of numerical value in appointed area,
Lookup_value: be design roll-call information to be found in data search deck watch,
Lookup_array: be the scope of the row at " roll-call " place in the current SHEET page of variable information database,
Match_type: be 0 (exact matching);
Preferably, do not find the cell of roll-call data to comprise: mentioned null cell and the cell with " #N/A " mark;
Preferably, in execution step 2) carry out before the searching of database roll-call, first in the current SHEET page head of described variable information database row, search: whether have the database point identical with a described design point item information, just perform step 2 if existed) the searching of database roll-call; Otherwise execution step 5);
Preferably, in step 2) in, if use the database point that INDEX () function is searched to be called 0, do not find the database identical with design point name to call the roll, perform step 5);
Preferably, in step 4) in, the concrete grammar of searching other relevant database points information is, with data search deck watch's the corresponding database point Xiang Liezhong of other design point items, input or fill following function formula:
"=INDEX (array, match (lookup_value, lookup_array, [match_type])) ", wherein,
Array: in the current SHEET page of variable information database with the scope of the corresponding database point of a design point item column,
Match (): be EXCEL function, return and specify the position of numerical value in appointed area,
Lookup_value: for designing roll-call information in data search deck watch,
Lookup_array: be the scope of the row at " roll-call " place in the current SHEET page of variable information database,
Match_type: be 0, i.e. exact matching;
Preferably, described design point item is multiple, in the described step 4 of execution) time, for a described database point application of formula "=INDEX (array; match (lookup_value; lookup_array, [match_type])) " for each described design point item correspondence is searched and is filled, the row scope at the current SHEET page of the database mid point item place that array and lookup_array are respectively corresponding with current design point item here and the row scope at roll-call place.
Described step of carrying out comparison of data consistency is:
1) first in data search deck watch, corresponding design point item and the rear insertion point item contrast of database point is listed as;
2) in the some item contrast row that insert, input function "=EXACT (text1, text2) ", wherein,
EXACT: whether identical for detection of two character strings, if two parameters are identical, return to TRUE value; Otherwise return to FALSE value,
Text1 and text2 represent respectively needs text-string relatively, and what text1 quoted here is the text-string of design point item correspondence, and what text2 quoted is a corresponding database point corresponding text-string.
Can also use " conditional formats " function of EXCEL here, and according to the rreturn value of function EXACT, be a some contrast row Fill Color automatically;
Preferably, the cell that is " false " by rreturn value is filled to redness.
Technological means disclosed by the invention has the advantage of following three aspects compared with classic method:
One: carry out in data search process in application classic method, the reduction speed of data volume to be found is slow, owing to just searching data at every turn, data volume to be found is linear and successively decreases one by one.In the scheme proposing in the present invention, searching according to data type of data carried out, and can realize the multiple data of each inquiry.
Its two: application classic method carry out in data search process, the seek scope of data is not reduced.Start till inquire about last data from inquiring about first data, seek scope is all of whole database, and seek scope is without any change.In the scheme proposing in the present invention, because searching according to data type of data carried out, the feature that syncaryon power station DCS variable information database forms is known, such data search mode is also to carry out according to the SHEET page in database, thereby data search scope is successively decreased according to SHEET page in database.
Its three: application classic method carry out in data search process, that data search and consistance comparison work are put together and carried out, first to carry out searching of " point " for each data point, then the be correlated with comparison of coherence of " point ", carry out again afterwards searching and comparing of next data, so move in circles.Like this searching and comparing all and independently carry out a little, have the dot information of how many needs comparisons, just need to repeat how many times.In the scheme proposing in the present invention, that searching with comparison work of data distinguished, first carry out searching of all data, the data that find are distributed in same EXCEL SHEET table with design input data, and then comparison of data consistency work is carried out in unification.
Therefore, adopt conventional test methodologies carry out data search and compare the common needs test duration of 1～2 day, and the scheme that adopts the present invention to propose, conventionally only need to be less than the test duration of 10 minutes.
Brief description of the drawings
Below in conjunction with accompanying drawing, a kind of nuclear power station DCS system input file of the present invention and variable information data base consistency(-tance) method of calibration are specifically described.
The computer programs process process flow diagram of Fig. 1 data search of the present invention and comparison method;
Fig. 2 nuclear power station DCS variable information database (part);
Fig. 3 I/O variable information table (part);
Fig. 4 nuclear power station data search deck watch (starting stage, part);
Fig. 5 nuclear power station data search deck watch (completing stage, part);
The computer programs process process flow diagram of the data search that Fig. 6 prior art adopts and comparison method.
Embodiment
For nuclear power station DCS system in solution prior art is at test phase, when input design file and database variable information are carried out to consistency desired result, the search efficiency existing is low, long problem consuming time, the invention provides a kind of computing machine that utilizes and automatically carry out data query and the optimization method of comparing, realize the efficient and accurate of whole test process.Input design file of the present invention is: I/O variable information table, and the concrete scheme of realization is as follows:
As shown in Figure 4, the present invention is directed to nuclear power station DCS variable information database is the feature that EXCEL file and input design file can change into EXCEL file, adopt EXCEL VBA language to carry out Programming, input design file is processed and formed data search deck watch, design input data and the data that need to search comparison are shown in the SHEET page of same EXCEL table, facilitate the intuitive of comparing; Meanwhile, utilizing the function of EXCEL function to realize datamation searches and compares.The present invention data search and comparison separates and carries out, treat that total data searches completely, application EXCEL function is realized the unified comparison of total data.For searching of data, the present invention has abandoned the mode that individual data is searched, in conjunction with the function of function and the feature of nuclear power station DCS variable information database of EXCEL, a kind of new data search method is proposed: carry out data search according to vertex type, realized the fast finding of mass data; As shown in Figure 1, the step of specific implementation of the present invention is:
1. open database and input design file, input design file is the I/O variable information table after conversion processing;
I/O variable information table is input design file, be variable information database configuration according to one of, be also simultaneously the foundation that checks DCS system variable information.
2. statistics need to be searched comparison " point " information, generates deck watch
Need " point " information checking according to input design file statistics, and need generated data to search deck watch in conjunction with test, as shown in Figure 3.The name of the some item in data search deck watch should be identical with the name of respective point item in variable information database.In figure: station number, the description of DS-point, UT-dimension, MD-Lower Range, the MU-range upper limit, Default-default value under PN-roll-call, SN-are design input data except SN; Corresponding " row " with " _ DB " name, as corresponding " point " information of extracting same point in database, are realized design input " point " value and the database configuration value of same I/O variable point and are arranged in same a line adjacent columns.Wherein SN point Xiang Weifei design input data, program is only carried out data search, does not carry out consistance comparison.
3. select first SHEET page of database as current operation page
Select a SHEET page as data search scope, be also to have selected a kind of data type as data search scope simultaneously.
4. in database current operation page head row, inquire about " point " information of comparison to be found
5. judge whether database current operation page exists " point " information of comparison to be found
If there is " point " information that need to search comparison, carry out the operation of step 6; Otherwise carry out the operation of step 12.
The variable dot information of searching due to needs is not distributed in each SHEET page of database, so, for the judgement that whether has the variable dot information that need to search in database current operation page, contribute to reduce data search scope, improve data search speed.
6. in deck watch, apply EXCEL function, taking database current operation page as seek scope, carry out searching of " roll-call ",
In the cell of data search deck watch " PN_DB " row, the data of not calling the roll, to call the roll and search by inputting and fill EXCEL formula, the formula of searching and filling is:
＝INDEX(array,match(lookup_value,lookup_array,[match_type]))
Array: database is specified the scope of " roll-call " column in SHEET page
Lookup_value: " roll-call " to be found in nuclear power station data search deck watch
Lookup_array: database is specified the scope of " roll-call " column in sheet page
Match_type: be 0 (exact matching)
The cell of the data of not calling the roll comprises: mentioned null cell and the cell with " #N/A " mark
7. couple deck watch's data area to be found, sorts according to " roll-call "
The effect of sequence is: make the data area that finds roll-call only carry out the inquiry of corresponding other " points ", no longer participate in searching of other SHEET page datas of database, reduce data search destination number.
Data area whole to be found (not comprising after sorted the data area of finding " roll-call ") to deck watch, sorts according to " roll-call " row, makes not find the data field of " roll-call " to be arranged in the below of whole data field.In the time using the INDEX function of EXCEL, do not find matched data to return to " #N/A " mark, can distinguish whether find data by this mark.
8. judge whether to find identical " roll-call " data
If do not find identical " roll-call ", carry out the operation of step 12; Otherwise carry out the operation of step 9.
Find identical " roll-call ", searching of other " point " information is thereafter just meaningful, so " roll-call " identical searching is the precondition of other " point " information searchings.
In deck watch to finding the data area of " roll-call ", application EXCEL function continues to search other " point " information of these points
Through the sorting operation of previous step, in data search deck watch, be searched the data ordering of " roll-call " above whole data field, searching just of ensuing other " points " finds the data area of " roll-call " to carry out for these.
At corresponding other " points " “ ﹡ _ DB of data search deck watch " row, fill function by EXCEL formula, input following formula:
＝INDEX(array,match(lookup_value,lookup_array,[match_type]))
Array: database is specified the scope of " point " column to be found in SHEET page
Lookup_value: " roll-call " to be found in nuclear power station data search deck watch
Lookup_array: database is specified the scope of " roll-call " column in SHEET page
Match_type: be 0 (exact matching)
10. judge in deck watch, whether data have all searched complete
If it is complete that the data that the needs in data search deck watch are searched have all been searched, carry out the operation of step 14; Otherwise, carry out the operation of step 11.
In 11. deck watch, do not find the data area of " roll-call " as data region to be found
12. judge whether the current SHEET page of database is last SHEET page
If the current database SHEET page last SHEET page that is database, carry out step 14; Otherwise carry out the operation of step 13.
13. select the next SHEET page of database as current operation page, carry out steps 4;
Searching of 14. end data
15. pairs of market demand EXCEL functions that found carry out consistance comparison
In this program, realize the comparison of data consistency in adjacent cells lattice with the EXACT function of EXCEL
16. finish whole programs.
Here, data " point " are in nuclear power station DCS field, and the concrete physical quantity of the on-the-spot nuclear power generating equipment of some representatives, as I/O variable; Such a " variable point " corresponding real physical; Have plenty of the variable artificially specifying for realizing transmission, the logical calculated etc. of data in Project Configuration, as intermediate variable, do not represent concrete physical quantity.The information of variable point is made up of some features of this point, and these features are called as an item, and some item has multiple, wherein, is marked as the some item (being all directly called below roll-call) of roll-call, is the unique identification of this other variable point of variable point difference; Vertex type in variable information database is divided according to an item information, " the variable point " of identical point type has identical, these have identical point item " variable point " and are stored in the same SHEET page of variable information database, and this SHEET page is just with this vertex type name.Here, " the variable point " that a kind of vertex type is corresponding has multiple, for example, shown in accompanying drawing 2: " the variable point " that type is AVO, its point comprises: call the roll (unique identification that variable point is distinguished), affiliated station number (control station belonging to when logical process), point is described (concrete meaning of variable point representative), the dimension (unit of this variable point) of point, the Lower Range of point and the range upper limit (span of this variable point) of point, in the time that this value is sky, need to be that this point is composed default value, be that default value is (in real work, if just in time broken down in the time gathering the value of this variable point, now just there is the situation less than the value of this variable point of adopting, at this moment the default value that system is composed for this variable point is exactly default value).
The present invention only for the variable point of a real physical " corresponding " consistance in input design file and variable information database carry out verification, and " not representing the intermediate variable of concrete physical quantity ".Do not carry out consistency desired result.
Be below the concrete physical parameter information from the nuclear power station field apparatus of DCS system acquisition:
Example 1, is shown in shown in accompanying drawing 4, sequence number 2 for the dot information of the feedwater flow of LP well heater
(PN): PY3ABP001MD calls the roll
Point is described (DS): LP HEATERS FEEDWATER FLOW, Chinese implication is " feedwater flow of low-pressure heater "
Unit (UT): t/h is flux unit " ton/hour "
Lower Range (MD): 0 is that minimum flow is 0 ton/hour
The range upper limit (MU): 5000 is that maximum flow is 5000 tons/hour
Default value (Default): the last valid value by " effective value in a upper cycle " as default value
Signal type (TP): 4～20mA is that this flow signal can be converted to 4～20mA current signal by DCS and processes.
Example 2, for the dot information of the admission pressure of device A BP301RE, is shown in shown in accompanying drawing 4, sequence number 4
(PN): PY3ABP001MP calls the roll
Point is described (DS): ABP301RE B.STM ILET PRES. Chinese implication is " pressure that is numbered the heat interchanger water vapor inflow point of ABP301 "
Unit (UT): MPa is pressure unit " MPa "
Lower Range (MD): 0 is that minimum pressure is 0 MPa
The range upper limit (MU): 0.25 is that maximum pressure is 0.25 MPa
Default value (Default): the last valid value by " effective value in a upper cycle " as default value
Signal type (TP): 4～20mA is that this flow signal can be converted to 4～20mA current signal by DCS and processes.
Example 3, for the dot information of the internal temperature of device A BP101RE, is shown in shown in accompanying drawing 4 data point of sequence number 5
(PN): PY3ABP001MT calls the roll
Point is described (DS): ABP101RE F.W ILET TEMP. Chinese implication is " temperature that is numbered the heat interchanger feed-water inlet place of ABP101 "
Unit (UT): DEG C be temperature unit " degree Celsius "
Lower Range (MD): 0 is that minimum temperature is 0 degree Celsius
The range upper limit (MU): 50 is that maximum temperature is 50 degrees Celsius
Default value (Default): the last valid value by " effective value in a upper cycle " as default value
Signal type (TP): PT100 is thermal resistance signal.
Below be only preferred embodiment of the present invention, not the present invention is done to any pro forma restriction, although the present invention discloses as above with preferred embodiment, but not in order to limit the present invention, any technician who is familiar with this patent is not departing within the scope of technical solution of the present invention, when can utilizing the technology contents of above-mentioned prompting to make a little change or being modified to the equivalent embodiment of equivalent variations, in every case be the content that does not depart from technical solution of the present invention, any simple modification of above embodiment being done according to technical spirit of the present invention, equivalent variations and modification, all still belong in the present invention program's scope.
Claims (8)
1. a nuclear power station DCS system input file and variable information data base consistency(-tance) method of calibration, described input design file is the file that described DCS system design stage uses, for the concrete physical parameter of storing the nuclear power station field apparatus that need to realize in DCS system, the relevant information of described physical parameter is defined as design point information in described input design file, described variable information database is after DCS system configuration completes, file the concrete physical parameter collecting from field apparatus is integrated, described variable information database, be defined as database dot information from the physical parameter information of described DCS system combination, it is characterized in that, described consistency desired result method is exactly: in variable information database, search corresponding database dot information according to the described design point information of described input design file, and the described database dot information finding and described design point information are stored in same deck watch, then, in described deck watch, design point information and database dot information are compared, and mark comparison result,
Preferably, described field apparatus comprises: reactor pressure vessel, steam generator, reactor coolant pump, voltage stabilizer, sensor, amplifier, indicator, registering instrument, limit switch, pilot lamp, relay equipment, steam turbine, generator, feed pump, separator, main-transformer;
Described physical parameter comprises: steam generator thermal power, main feedwater enthalpy, blowdown enthalpy, feedwater flow, blowdown flow, enthalpy of wet steam, neutron flux, temperature, pressure, flow, voltage, electric current, equipment leave state, equipment off status.
2. a kind of nuclear power station DCS system input file according to claim 1 and variable information data base consistency(-tance) method of calibration, it is characterized in that, at described nuclear power station DCS system design stage, described physical parameter comprises multiple features, and the feature of described physical parameter is defined as the input point item of described input point information in described input design file; After system configuration completes, the feature integration of the described physical parameter collecting from field apparatus, to described variable information database, and is defined as to database point; The input point information of storing in described deck watch is made up of all input point items of described input point information, the described database dot information of storing in described deck watch is made up of the database point of described database dot information, the described design point information of carrying out in described deck watch and the comparison of database dot information, described exactly input point information a little information compare with a corresponding database point information of described database dot information, and distinguish the comparison result of the corresponding input point item of mark information and date storehouse point item information;
Described design point item at least comprises input roll-call: it is the unique identification of the described physical parameter of difference and other physical parameter that described input is called the roll;
Described database point item at least comprises database roll-call: it is the unique identification that described DCS system is distinguished the physical parameter collecting from field apparatus other physical parameter that described database is called the roll, in the design phase, the parameter of physical quantity completes after configuration in DCS system, and the database roll-call that input corresponding to described physical parameter called the roll corresponding with the respective physical parameter collecting from field apparatus from DCS system is consistent;
In described variable information database, searching with the corresponding database dot information of described design point information is exactly to search the value database dot information identical with described design roll-call value that database is called the roll; Described input is called the roll and is comprised: the concrete physical quantity title of the numbering+described field apparatus representative of the flogic system title at described input point place+described input point institute corresponding device.
3. a kind of nuclear power station DCS system input file according to claim 2 and variable information data base consistency(-tance) method of calibration, it is characterized in that, described database dot information also comprises vertex type, described vertex type is the type of the physical parameter that collects from field apparatus, and the database dot information that described vertex type is identical has identical database point;
Described vertex type comprises: 2 limit value analog input signal AVI, 4 limit value analog input signal AVI4,8 limit value analog input signal AVI8, analog quantity output signals AVO, switching value input signal DVI, switching value output signal DVO;
Preferably, described 2 limit value analog input signal AVI at least comprise: call the roll, put description, lower bound warning, high limit warning;
Described 4 limit value analog input signal AVI4 at least comprise: roll-call, point are described, the first lower bound is reported to the police, the second lower bound is reported to the police, the first high limit is reported to the police, the second high limit warning;
Described 8 limit value analog input signal AVI8 at least comprise: call the roll, point is described, the first lower bound is reported to the police, the second lower bound is reported to the police, the 3rd lower bound is reported to the police, the 4th lower bound is reported to the police, the first high limit is reported to the police, the second high limit is reported to the police, third high limit is reported to the police, the 4th high limit is reported to the police.
4. according to any one nuclear power station DCS system input file described in claim 1-3 and variable information data base consistency(-tance) method of calibration, it is characterized in that, described input design file, described variable information database and described deck watch are EXCEL file, described design point information is stored in the same SHEET page of described input design file, described database dot information is stored in by described vertex type in the different SHEET pages of described variable information database, the database dot information of storing in same SHEET page in described variable information database has identical vertex type, the function INDEX () and the MATCH () that utilize EXCEL to carry, input design file is all stored in same a line of described deck watch with input point information and database dot information corresponding in variable information database, and then utilize the EXACT () function of EXCEL to compare to design point information and corresponding database dot information, mark comparison result,
Preferably, described deck watch is described input design file;
Preferably, described deck watch is database deck watch, described database deck watch generates in the time that execution is searched in variable information database according to the design point information of input design file, described database deck watch's generation method is: all design point information in described input design file are called the roll according to described design, the described design input point item information order that need to contrast copies in described database deck watch, and after ranking, inserts described design point as the row that extract corresponding described database roll-call information in described variable information database, insert afterwards the row as a corresponding database point information in extracting variable information database at described design point item,
Preferably, as the column heading that extracts corresponding described database roll-call information in described variable information database be: " PN_DB "; Insert afterwards as the column heading of a corresponding database point information in extracting variable information database at described design point item and be: " design point item value "+" _ DB ".
5. according to any one nuclear power station DCS system input file described in claim 1-4 and variable information data base consistency(-tance) method of calibration, it is characterized in that, the described step that lookup result is stored in data search deck watch is:
1) first, and all data areas of described deck watch are made as to region to be found, first SHEET page of choice variable information data library file is as current operation page simultaneously;
2) in deck watch, apply INDEX () and MATCH () function, taking the current SHEET page of described variable information database as seek scope, in described deck watch, do not find described database associated databases roll-call region to carry out writing and filling of " the inquiry formula of calling the roll ";
3) by described step 2) in carried out the row at the place, data area that described " the inquiry formula of calling the roll " fill, sort according to the row at described database roll-call place;
4) to described step 3) in carried out in database point the region of sequence, application INDEX () and MATCH () function continue to search and fill other relevant database points item information;
5) using the next SHEET page of described variable information database as current operation page, and perform step 2), until all inputs roll-calls that variable information database executes in searching of last SHEET page or data search deck watch have all been searched complete in variable information database;
Preferably, in step 2) in, the concrete grammar of searching that database is called the roll is: ranks, do not find in the cell of roll-call data at data search deck watch's database point, and input or filling " the inquiry formula of calling the roll ", described " the inquiry formula of calling the roll " is:
"=INDEX (array, match (lookup_value, lookup_array, [match_type])) ", wherein,
Array: be the scope of the row at " roll-call " place in the current SHEET page of variable information database,
Match (): be EXCEL function, return and specify the position of numerical value in appointed area,
Lookup_value: be design roll-call information to be found in data search deck watch,
Lookup_array: be the scope of the row at " roll-call " place in the current SHEET page of variable information database,
Match_type: be 0 (exact matching);
Preferably, do not find the cell of roll-call data to comprise: mentioned null cell and the cell with " #N/A " mark;
Preferably, in execution step 2) carry out before the searching of database roll-call, first in the current SHEET page head of described variable information database row, search: whether have the database point identical with a described design point item information, just perform step 2 if existed) the searching of database roll-call; Otherwise execution step 5);
Preferably, in step 2) in, if use the database point that INDEX () function is searched to be called 0, do not find the database identical with design point name to call the roll, perform step 5);
Preferably, in step 4) in, the concrete grammar of searching other relevant database points information is, with data search deck watch's the corresponding database point Xiang Liezhong of other design point items, input or fill following function formula:
"=INDEX (array, match (lookup_value, lookup_array, [match_type])) ", wherein,
Array: in the current SHEET page of variable information database with the scope of the corresponding database point of a design point item column,
Match (): be EXCEL function, return and specify the position of numerical value in appointed area,
Lookup_value: for designing roll-call information in data search deck watch,
Lookup_array: be the scope of the row at " roll-call " place in the current SHEET page of variable information database,
Match_type: be 0, i.e. exact matching;
Preferably, described design point item is multiple, in the described step 4 of execution) time, for a described database point application of formula "=INDEX (array; match (lookup_value; lookup_array, [match_type])) " for each described design point item correspondence is searched and is filled, the row scope at the current SHEET page of the database mid point item place that array and lookup_array are respectively corresponding with current design point item here and the row scope at roll-call place.
6. according to any one nuclear power station DCS system input file described in claim 1-5 and variable information data base consistency(-tance) method of calibration, it is characterized in that, described in carry out comparison of data consistency step be:
1) first in data search deck watch, corresponding design point item and the rear insertion point item contrast of database point is listed as;
2) in the some item contrast row that insert, input function "=EXACT (text1, text2) ", wherein,
EXACT: whether identical for detection of two character strings, if two parameters are identical, return to TRUE value; Otherwise return to FALSE value,
Text1 and text2 represent respectively needs text-string relatively, and what text1 quoted here is the text-string of design point item correspondence, and what text2 quoted is a corresponding database point corresponding text-string.
7. a kind of nuclear power station DCS system input file according to claim 6 and variable information data base consistency(-tance) method of calibration, it is characterized in that, use " conditional formats " function of EXCEL, and according to the rreturn value of function EXACT, be a some contrast row Fill Color automatically;
Preferably, the cell that is " false " by rreturn value is filled to redness.
8. according to any one nuclear power station DCS system input file described in claim 1-7 and variable information data base consistency(-tance) method of calibration, it is characterized in that, described input design file is: I/O variable information table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410428254.3A CN104200397B (en) | 2014-08-27 | 2014-08-27 | A kind of nuclear power station DCS system input design file and variable information data base consistency(-tance) method of calibration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410428254.3A CN104200397B (en) | 2014-08-27 | 2014-08-27 | A kind of nuclear power station DCS system input design file and variable information data base consistency(-tance) method of calibration |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104200397A true CN104200397A (en) | 2014-12-10 |
| CN104200397B CN104200397B (en) | 2018-04-03 |
Family
ID=52085683
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410428254.3A Active CN104200397B (en) | 2014-08-27 | 2014-08-27 | A kind of nuclear power station DCS system input design file and variable information data base consistency(-tance) method of calibration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104200397B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104965865A (en) * | 2015-06-08 | 2015-10-07 | 北京广利核系统工程有限公司 | Quick inspection method of nuclear power plant DCS electronic alarm card |
| CN105335165A (en) * | 2015-12-04 | 2016-02-17 | 济南大学 | Automatic separating method of circulating volt-ampere data |
| CN105808749A (en) * | 2016-03-14 | 2016-07-27 | 北京广利核系统工程有限公司 | History storage method for nuclear power station |
| CN108958312A (en) * | 2018-09-06 | 2018-12-07 | 广东芬尼克兹节能设备有限公司 | A kind of temperature output control method, device, terminal device and readable storage medium storing program for executing |
| CN109639520A (en) * | 2018-11-28 | 2019-04-16 | 北京广利核系统工程有限公司 | A kind of Computer Aided Measurement of reactor protection system network communication |
| CN109947797A (en) * | 2017-07-31 | 2019-06-28 | 华为技术有限公司 | A kind of data detecting device and method |
| CN113627892A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN114326642A (en) * | 2022-01-05 | 2022-04-12 | 北京广利核系统工程有限公司 | Interface matching method, device, equipment and medium for nuclear power DCS (distributed control System) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20110047411A (en) * | 2009-10-30 | 2011-05-09 | 한국전력공사 | Apparatus and Method for ??? Logic inspection in Nuclear Power Plant |
| CN102591808A (en) * | 2011-12-19 | 2012-07-18 | 上海西门子工业自动化有限公司 | System and method for DCS (distributed control system) hardware configuration based on Excel |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103034549A (en) * | 2012-12-05 | 2013-04-10 | 中广核工程有限公司 | Data consistency verifying method and system based on pattern model design |
| CN103838871A (en) * | 2014-03-21 | 2014-06-04 | 北京广利核系统工程有限公司 | Method for checking nuclear power plant safety level DCS S-VDU process file |
-
2014
- 2014-08-27 CN CN201410428254.3A patent/CN104200397B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20110047411A (en) * | 2009-10-30 | 2011-05-09 | 한국전력공사 | Apparatus and Method for ??? Logic inspection in Nuclear Power Plant |
| CN102591808A (en) * | 2011-12-19 | 2012-07-18 | 上海西门子工业自动化有限公司 | System and method for DCS (distributed control system) hardware configuration based on Excel |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103034549A (en) * | 2012-12-05 | 2013-04-10 | 中广核工程有限公司 | Data consistency verifying method and system based on pattern model design |
| CN103838871A (en) * | 2014-03-21 | 2014-06-04 | 北京广利核系统工程有限公司 | Method for checking nuclear power plant safety level DCS S-VDU process file |
Non-Patent Citations (2)
| Title |
|---|
| 平嘉临，徐晓臻: "台山EPR核电厂DCS逻辑设计验证方法研究", 《核科学与工程》 * |
| 霍建波等: "CPR1000核电站数字化仪控系统常规岛I/O通道自动测试工具的应用", 《自动化博览》 * |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104965865A (en) * | 2015-06-08 | 2015-10-07 | 北京广利核系统工程有限公司 | Quick inspection method of nuclear power plant DCS electronic alarm card |
| CN105335165A (en) * | 2015-12-04 | 2016-02-17 | 济南大学 | Automatic separating method of circulating volt-ampere data |
| CN105808749A (en) * | 2016-03-14 | 2016-07-27 | 北京广利核系统工程有限公司 | History storage method for nuclear power station |
| CN109947797A (en) * | 2017-07-31 | 2019-06-28 | 华为技术有限公司 | A kind of data detecting device and method |
| CN109947797B (en) * | 2017-07-31 | 2022-04-05 | 华为技术有限公司 | Data inspection device and method |
| CN108958312A (en) * | 2018-09-06 | 2018-12-07 | 广东芬尼克兹节能设备有限公司 | A kind of temperature output control method, device, terminal device and readable storage medium storing program for executing |
| CN109639520A (en) * | 2018-11-28 | 2019-04-16 | 北京广利核系统工程有限公司 | A kind of Computer Aided Measurement of reactor protection system network communication |
| CN109639520B (en) * | 2018-11-28 | 2020-12-04 | 北京广利核系统工程有限公司 | Computer-aided test method for network communication of reactor protection system |
| CN113627892A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN113627892B (en) * | 2021-08-16 | 2023-09-01 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN114326642A (en) * | 2022-01-05 | 2022-04-12 | 北京广利核系统工程有限公司 | Interface matching method, device, equipment and medium for nuclear power DCS (distributed control System) |
| CN114326642B (en) * | 2022-01-05 | 2024-02-20 | 北京广利核系统工程有限公司 | Interface matching method, device, equipment and medium for nuclear power DCS system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104200397B (en) | 2018-04-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104200397A (en) | Method for verifying consistence of designed input file and variable information database of DCS (Distributed Control System) of nuclear power station | |
| CN104048842B (en) | A kind of thermal loss of steam turbine rate on-line monitoring method based on soft-measuring technique | |
| Giustolisi et al. | An Excel-based solution to bring water distribution network analysis closer to users | |
| CN109522600A (en) | Complex equipment remaining life prediction technique based on combined depth neural network | |
| CN103473056B (en) | A kind of remote measurement configuration file automatic generation method | |
| CN106355375B (en) | A kind of automatic materiel affirmation method | |
| CN101477555B (en) | Fast retrieval and generation display method for task tree based on SQL database | |
| CN108763064A (en) | A kind of code tester generation method and device based on black box function and machine learning | |
| Wang | Thermo-economic evaluation, optimization and synthesis of large-scale coal-fired power plants | |
| CN108363678A (en) | One kind being used for the fast automatic processing system of fuel cell pile test data | |
| CN103176905B (en) | A kind of Defect Correlation method and device | |
| CN106294139B (en) | A kind of Detection and Extraction method of repeated fragment in software code | |
| CN108228232B (en) | Automatic repairing method for circulation problem in program | |
| CN105302547A (en) | Fault injection method for Verilog HDL design | |
| Srivastava et al. | Wood of Oleaceae from the latest Cretaceous of India–the earliest olive branch? | |
| CN116466237B (en) | Charging safety monitoring and early warning method and system for lithium battery | |
| CN106991050A (en) | A kind of static test null pointer dereference defect false positive recognition methods | |
| CN109117564B (en) | System and method for converting PDS three-dimensional model into RELAP5 model | |
| CN108536585B (en) | Data change influence domain analysis method | |
| CN112849429B (en) | Tracing method for civil aircraft system measurement parameters | |
| CN103870590B (en) | Webpage identification method and device with error-reported characteristic | |
| CN114897193A (en) | Airplane structure maintenance decision method and decision system based on man-in-the-loop | |
| CN100375196C (en) | Method for reading semiconductor die information in a parallel test and burn-in system | |
| CN101807260B (en) | Method for detecting pedestrian under changing scenes | |
| CN105787205B (en) | Failure mode effect relationship based on FMEA illustrates method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |