CN112783913B - Database updating method, device, equipment and storage medium - Google Patents
Database updating method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112783913B CN112783913B CN202110284929.1A CN202110284929A CN112783913B CN 112783913 B CN112783913 B CN 112783913B CN 202110284929 A CN202110284929 A CN 202110284929A CN 112783913 B CN112783913 B CN 112783913B
- Authority
- CN
- China
- Prior art keywords
- target data
- database
- engineering
- control logic
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 65
- 238000010586 diagram Methods 0.000 claims abstract description 198
- 238000013461 design Methods 0.000 claims description 24
- 238000004590 computer program Methods 0.000 claims description 23
- 230000006870 function Effects 0.000 description 16
- 230000008569 process Effects 0.000 description 8
- 230000007246 mechanism Effects 0.000 description 5
- 238000004364 calculation method Methods 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000004870 electrical engineering Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000003321 amplification Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000005034 decoration Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000003199 nucleic acid amplification method Methods 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000000275 quality assurance Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
Abstract
The application relates to a database updating method, a device, equipment and a storage medium, wherein the method comprises the following steps: the control logic diagram is generated based on the target data by acquiring the target data in the control logic diagram; after updating the target data in the control logic diagram, obtaining variable attributes of the target data from a database; and updating the target data in the database according to the variable attribute of the target data to obtain a target database. The technical scheme provided by the embodiment of the application can improve the efficiency and the flexibility of updating the database.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a storage medium for updating a database.
Background
The engineering improvement work of each specialty in the nuclear power plant can involve a control logic diagram, an engineer or an operator can grasp the principle of the system by looking at the control logic diagram, accurately judge the cause of the fault, and further take correct measures to ensure the safe operation of the unit, so that the design of the control logic diagram is particularly important.
At present, when designing a control logic diagram, professional drawing software of electrical design is generally used to design the control logic diagram, for example, professional electrical design software (EB) developed by the germany oltai company, and the graphic symbols in the drawing software are combined and connected to implement the design of the control logic diagram.
However, in the existing database updating method, after the control logic diagram is modified, all the data related to the control logic diagram are updated in the database corresponding to the control logic diagram. However, after the control logic diagram is modified, only a portion of the data in the database need be updated in practice. Therefore, the existing database updating method has low efficiency and poor flexibility.
Disclosure of Invention
Based on this, the embodiments of the present application provide a method, an apparatus, a device, and a storage medium for updating a database, which can improve the efficiency and flexibility of updating the database.
In a first aspect, a database updating method is provided, the method including:
acquiring target data in a control logic diagram, wherein the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station; after updating the target data in the control logic diagram, obtaining variable attributes of the target data from a database; and updating the target data in the database according to the variable attribute of the target data to obtain a target database.
In one embodiment, the target data includes common target data and engineering target data, the common target data is target data required for generating all the control logic diagrams, the engineering target data is target data required for generating different control logic diagrams respectively, and the different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein public target data are stored in the public database, and engineering target data are stored in the engineering database; the variable attributes comprise global variables and local variables;
updating the target data in the database according to the variable attribute of the target data to obtain a target database, comprising:
judging whether the target data is engineering target data or not; and if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database.
In one embodiment, determining whether the target data is engineering target data includes:
obtaining variable attributes of target data from a database; judging whether the variable attribute of the target data is a local variable or not; and if the variable attribute of the target data is a local variable, determining the target data as engineering target data.
In one embodiment, the method further comprises:
if the target data is not engineering target data, judging whether the target data is public target data or not; if the target data is public target data, a public database corresponding to the target data is obtained, and the target data in the public database is updated to obtain the target database.
In one embodiment, determining whether the target data is common target data includes:
obtaining variable attributes of target data from a database; judging whether the variable attribute of the target data is a global variable or not; and if the variable attribute of the target data is a global variable, determining that the target data is public target data.
In one embodiment, if the target data is a control logic diagram, the database is a control logic diagram database;
if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database, wherein the method comprises the following steps of:
and if the control logic diagram is engineering target data, acquiring an engineering database corresponding to the control logic diagram, and updating the target data in the engineering database to obtain the target database.
In one embodiment, if the target data includes meter data, the database is a meter database;
if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database, wherein the method comprises the following steps of:
and if the instrument data are engineering target data, acquiring an engineering database corresponding to the instrument data, and updating the instrument data in the engineering database to obtain the target database.
In a second aspect, there is provided a database updating apparatus, the apparatus comprising:
the first acquisition module is used for acquiring target data in a control logic diagram, and the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station;
the second acquisition module is used for acquiring variable attributes of the target data from the database after updating the target data in the control logic diagram;
and the updating module is used for updating the target data in the database according to the variable attribute of the target data to obtain a target database.
In a third aspect, there is provided a computer device comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, performs the method steps of any of the embodiments of the first aspect described above.
In a fourth aspect, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, carries out the method steps in any of the embodiments of the first aspect described above.
According to the database updating method, the device, the equipment and the storage medium, the target data in the control logic diagram is acquired, and the control logic diagram is generated based on the target data; after updating the target data in the control logic diagram, obtaining variable attributes of the target data from a database; and updating the target data in the database according to the variable attribute of the target data to obtain a target database. In the technical scheme provided by the embodiment of the application, the target data in the database can be updated according to the variable attribute of the target data for generating the control logic diagram, so that not only can all the data related in the control logic diagram be updated, but also the data corresponding to the control logic diagram of the system under a specific engineering project can be updated, and after the control logic diagram is modified, the linkage of the control logic diagram and the data is realized, and meanwhile, the updating efficiency and the updating flexibility of the database are also improved.
Drawings
FIG. 1 is a block diagram of a computer device provided in an embodiment of the present application;
FIG. 2 is a flowchart of a database updating method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a common database and an engineering database of meter data according to an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of a common database and an engineering database of meter data according to an embodiment of the present disclosure;
FIG. 5 is a schematic diagram of a common database and an engineering database of control logic diagram data according to an embodiment of the present disclosure;
FIG. 6 is a schematic diagram of a common database and an engineering database of control logic diagram data according to an embodiment of the present disclosure;
FIG. 7 is a schematic diagram of a common database and an engineering database of control logic diagram data according to an embodiment of the present disclosure;
FIG. 8 is a schematic diagram of a common database and an engineering database of control logic diagram data according to an embodiment of the present disclosure;
FIG. 9 is a schematic diagram of an instrument database management interface according to an embodiment of the present disclosure;
FIG. 10 is a schematic diagram of a control logic diagram database management interface according to an embodiment of the present disclosure;
FIG. 11 is a flowchart of a database update method according to an embodiment of the present application;
FIG. 12 is a flowchart of a database update method according to an embodiment of the present application;
FIG. 13 is a flowchart of a database update method according to an embodiment of the present application;
FIG. 14 is a flowchart of a database update method according to an embodiment of the present application;
fig. 15 is a block diagram of a database updating apparatus according to an embodiment of the present application.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present application more apparent, the embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
When designing a control logic diagram, general drawing software Visio or AutoCAD is generally adopted, where Visio is general drawing software in Office software series developed by microsoft corporation in the united states, and may be used to draw flowcharts and diagrams, and is a software that facilitates IT and business personnel to perform visualization processing, analysis and communication on complex information, systems and flows. It uses Office visual charts with professional appearance to facilitate knowledge of the system and process, to learn more about the complex information and to use this knowledge to make better business decisions. Microsoft Office Visio can help create charts with a professional appearance to understand, record and analyze information, data, systems and processes, and thus using existing data information, it is well suited to draw and generate many kinds of standard charts, including organizational charts, calendars, calendar and Gantt charts, etc. AutoCAD is automatic computer aided design software developed by Autodesk (European Tek) corporation in the United states, is used for two-dimensional drawing, detailed drawing, design documents, basic three-dimensional design and the like, and is now becoming a widely used drawing tool in the world, the AutoCAD has a good user interface, various operations can be performed through an interactive menu or command line mode, the AutoCAD is suitable for drawing in the fields of civil construction, decoration, industrial drawing, engineering drawing, electronic industry, clothing processing and the like, standard component libraries of the system, including bolts, nuts, screws, studs, keys, pins, washers, rings, springs, profiles, flanges and the like, and model data can be directly called. The AutoCAD software has the following characteristics: the method has a perfect graph drawing function; the method has a powerful graphic editing function; the conversion of various graphic formats can be carried out, and the data exchange capability is high; supporting a plurality of hardware devices; supporting multiple operation platforms; has universality and usability. However, both Office vision of microsoft corporation and AutoCAD of oltec corporation are universal drawing software tools on the market, and are not suitable for the instrument control design of nuclear power profession, especially the design of logic control diagram, and after the logic control diagram is selected and modified, the data attribute corresponding to the diagram cannot be synchronously updated, and the data information needs to be manually modified, so that the linkage of the diagram and the data cannot be realized.
The system can also adopt an electrical Engineering design platform (EB), wherein the EB is electrical design professional software developed by Germany European Thai company, the EB is an integrated electrical Engineering design platform taking an object as a guide and taking a central database as a core, the EB is a new generation of integrated electrical Engineering design platform taking the object as a guide and taking the central database as a core, various drawings and documents required by electrical design can be created, such as a component list, a purchase order, a cable album, a wiring list, a terminal diagram and the like, and the system also has a plurality of functions of optimizing Engineering management, such as version management, automatic detection, automatic translation, authority management and the like, and can also exchange data with other software systems. However, although the EB software is structured SQL Server database at the bottom layer, the data attribute of a certain control logic diagram graph can be changed, but because the image is universal in the software, the graph and data of the control logic diagram cannot be linked in a single Zhang Tuzhi or a specific engineering project drawing, and the graph and data of the control logic diagram in other drawings are not affected.
The database updating method provided by the application can be applied to computer equipment, wherein the computer equipment can be a server or a terminal, the server can be one server or a server cluster consisting of a plurality of servers, the embodiment of the application is not particularly limited to the method, and the terminal can be but not limited to various personal computers, notebook computers, smart phones, tablet computers and portable wearable equipment.
Taking the example of a computer device being a server, FIG. 1 illustrates a block diagram of a server, as shown in FIG. 1, which may include a processor and memory connected by a system bus. Wherein the processor of the server is configured to provide computing and control capabilities. The memory of the server includes nonvolatile storage medium and internal memory. The nonvolatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The computer program is executed by a processor to implement a database updating method.
It will be appreciated by those skilled in the art that the structure shown in fig. 1 is merely a block diagram of a portion of the structure associated with the present application and does not constitute a limitation of the server to which the present application is applied, and that alternatively the server may include more or less components than those shown, or may combine some components, or have a different arrangement of components.
The execution subject of the embodiments of the present application may be a computer device or a database updating device, and in the embodiments of the method described below, the execution subject is a computer device.
In one embodiment, as shown in fig. 2, which shows a flowchart of a database updating method provided in an embodiment of the present application, the method may include the following steps:
step 220, obtaining target data in a control logic diagram, wherein the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station.
In a nuclear power plant, a control logic diagram is used to describe a schematic diagram of the overall system control logic, and the logic relationships between the sensors, controllers and actuators are depicted in the form of graphical symbols. The target data in the control logic diagram is data for generating the control logic diagram, and the target data may be control logic diagram data, meter data and other target data required for generating the control logic diagram. The control logic diagram data may include function block data, dedicated function block data, template file data, typical scheme and template data, drawing specification data and variable-function block mapping rule data, wherein the function block data is function block data for generating different functions in the control logic diagram, the dedicated function block data is data for generating an instrument control dedicated function block, the template file data is data for generating an input/output list template file, a custom list template file and a function block list template file in the control logic diagram, the typical scheme and template data is data for generating a typical control logic diagram template file, the typical scheme and template data may include data of a frame, a title bar, a function block combination and the like of the control logic diagram, the drawing specification data is data for generating drawing specifications of the control logic diagram, and the drawing specification data may include data such as a line pattern, a text pattern, a function block pitch, an alignment setting and the like, and the variable-function block mapping rule data is data for storing correspondence between variables and function blocks.
The instrument data can comprise standard instrument data, calculation parameter data and template file data, wherein the standard instrument data is technical parameter data for generating a common instrument, the standard instrument data can comprise instrument type selection parameter configuration table data, standard attribute table data of an instrument and an executing mechanism, the instrument type selection parameter configuration table data is used for selecting types of the instrument, a certain margin is required for measuring ranges of the instrument when the instrument type selection is carried out, therefore, an instrument type selection amplification coefficient table can be designed as the instrument type selection parameter configuration table data, the coefficient can be adjusted only by an administrator, certain limiting conditions such as anti-seismic classification, identification requirements, quality assurance requirements, environmental conditions, precision requirements, irradiation partition and the like are considered when the instrument type selection is carried out, the limiting conditions can be set according to design requirements, and the instrument type selection can be carried out according to set rules after the setting is completed; the standard attribute table data of the instrument and the executing mechanism are used for setting the attribute of the instrument and the executing mechanism, and because some attributes of the instrument and the executing mechanism have fixed data ranges, such as function classification attributes can be FC1, FC2, FC3, NC, N/A and LATER, the attribute values are classified and stored in a database, when a user performs attribute editing on a certain instrument or executing mechanism record in the instrument control platform, the attribute values can be selected through a drop-down list instead of manually inputting the values for the fields with the fixed data ranges; the calculation parameter data are used for generating instrument model selection and parameter data adopted in the calculation process; the template file data is data for generating an instrument attribute table template file, a purchase data table template file, and a calculation book template file.
When the target data in the control logic diagram is acquired, the target data in the control logic diagram can be acquired from the database by calling the database corresponding to the control logic diagram after the control logic diagram is selected, for example, the database storing the control logic diagram data corresponding to the control logic diagram is called, the control logic diagram data of the control logic diagram can be acquired, the database storing the meter data corresponding to the control logic diagram is called, and the meter data of the control logic diagram can be acquired.
Step 240, after updating the target data in the control logic diagram, obtaining the variable attribute of the target data from the database.
In the process of drawing the control logic diagram, the control logic diagram may need to be modified and updated according to the change of actual requirements, a specific control logic diagram is provided for the system under different engineering projects in the nuclear power plant, the control logic diagram generally also comprises a plurality of drawings, and when the target data in the control logic diagram is updated, the target data of the control logic diagram of the system under all engineering projects can be updated, or the target data of the control logic diagram of the system under the specific engineering projects can be updated; the method can update the target data on all the drawings in the control logic diagram, or update the target data on the specific drawings in the control logic diagram, so that after the target data in the control logic diagram are updated, the variable attribute of the target data can be obtained from a database, the variable attribute of the target data is used for determining the updating range of the target data, the variable attribute of the target data can be preset according to actual experience, and then the target data is updated according to the variable attribute of the target data.
And 260, updating the target data in the database according to the variable attribute of the target data to obtain a target database.
The variable attributes of the target data may include global variables and local variables, and may further include other variable attributes of the target data, the target data corresponding to the global variables is applied to a control logic diagram of a system under all engineering projects, the target data corresponding to the local variables is applied to a control logic diagram of a system under a specific engineering project, the variable attributes of the target data may be divided according to correlations with the engineering projects, for example, variable attributes unrelated to the engineering projects may be divided into global variables, variable attributes related to the engineering projects may be divided into local variables, and different variable attributes of the target data may further carry preset corresponding attribute identifiers for distinguishing the target data. Updating the target data in the database according to the variable attribute of the target data to obtain a target database, for example, if the variable attribute of the target data is a global variable, updating the target data corresponding to the global variable in the database to obtain the target database, and updating the target data corresponding to the control logic diagram generated by applying the target data in the target database; if the variable attribute of the target data is a local variable, updating the target data corresponding to the local variable in the database to obtain a target database, and updating the target data corresponding to the control logic diagram of the system under the specific engineering project generated by applying the target data in the target database.
In this embodiment, the control logic diagram is generated based on the target data by acquiring the target data in the control logic diagram; after updating the target data in the control logic diagram, obtaining variable attributes of the target data from a database; and updating the target data in the database according to the variable attribute of the target data to obtain a target database. Because the target data in the database can be updated according to the variable attribute of the target data for generating the control logic diagram, not only can all the data related in the control logic diagram be updated, but also the data corresponding to the control logic diagram of the system under a specific engineering project can be updated, and after the control logic diagram is modified, the linkage of the control logic diagram and the data is realized, and meanwhile, the updating efficiency and the updating flexibility of the database are also improved.
In one embodiment, the target data includes common target data and engineering target data, the common target data is target data required for generating all the control logic diagrams, the engineering target data is target data required for generating different control logic diagrams respectively, and the different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein public target data are stored in the public database, and engineering target data are stored in the engineering database; variable attributes include global and local variables. The control logic diagram data and the meter data in the target data can both comprise public target data and engineering target data, the target data can be divided according to the correlation with the engineering project when the target data is divided, for example, the target data irrelevant to the engineering project is divided into the public target data, and the target data relevant to the engineering project is divided into the engineering target data. The public target data can be stored in a public database, the engineering target data can be stored in an engineering database, and as shown in fig. 3-8, the public database and the engineering database corresponding to different target data are respectively shown in schematic diagrams, wherein the public data maintenance stage in fig. 3-8 is a stage of establishing the public database, and the engineering design stage is a stage of establishing the engineering database. Fig. 3 is a schematic diagram of a common database and an engineering database corresponding to meter element data in meter data, fig. 4 is a schematic diagram of a common database and an engineering database corresponding to meter selection rule data in meter data, fig. 5 is a schematic diagram of a common database and an engineering database corresponding to function block data in control logic diagram data, fig. 6 is a schematic diagram of a common database and an engineering database corresponding to typical scheme data in control logic diagram data, fig. 7 is a schematic diagram of a common database and an engineering database corresponding to drawing specification data in control logic diagram data, and fig. 8 is a schematic diagram of a common database and an engineering database corresponding to matching rule data in control logic diagram data. Fig. 9 is a schematic diagram of a management interface of a control logic diagram database, in which a functional navigation area is provided on the left side and an editing area is provided on the right side, the functional navigation area is designed based on a service type, the editing area is designed based on specific service content, and the content of the editing area is changed along with the change of data items of the navigation area. Fig. 10 is a schematic diagram of a management interface of an instrument database, in which, similarly, a functional navigation area is provided on the left side and an editing area is provided on the right side, the functional navigation area is designed based on a service type, the editing area is designed based on specific service content, and the content of the editing area changes with the change of data items of the navigation area.
Referring to fig. 11, a flowchart of a database updating method provided in an embodiment of the present application, specifically relates to a process of updating a database according to engineering target data, where the method may include the following steps:
step 1120, judging whether the target data is engineering target data.
When determining whether the target data is engineering target data, the determination may be performed according to the variable attribute of the target data, or whether the target data is engineering target data may be determined according to the identifier of the target data. For example, when determining from the variable attribute of the target data, if the variable attribute of the target data is a global variable, it may be determined that the target data is not engineering target data, and if the variable attribute of the target data is a local variable, it may be determined that the target data is engineering target data.
Step 1140, if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database.
The engineering target data are target data needed by different control logic diagrams respectively, and the engineering target data are stored in an engineering database, so that after the engineering target data are judged to be engineering target data, the engineering database corresponding to the target data can be obtained, and the target data in the engineering database are updated, so that the target database is obtained.
The engineering target data may include that the control logic diagram is engineering target data and the meter data is engineering target data, optionally, if the target data is a control logic diagram, the database is a control logic diagram database; if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database, wherein the method comprises the following steps of: and if the control logic diagram is engineering target data, acquiring an engineering database corresponding to the control logic diagram, and updating the target data in the engineering database to obtain the target database.
Optionally, if the target data includes meter data, the database is a meter database; if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database, wherein the method comprises the following steps of: and if the instrument data are engineering target data, acquiring an engineering database corresponding to the instrument data, and updating the instrument data in the engineering database to obtain the target database.
In this embodiment, by determining whether the target data is engineering target data, if the target data is engineering target data, then acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database, because the engineering target data is target data required by respectively generating different control logic diagrams, updating the target data in the engineering database can realize updating the data corresponding to the control logic diagrams of the system under the specific engineering project, and after modifying the control logic diagrams of the system under the specific engineering project, realizing linkage between the control logic diagram diagrams and the data, thereby improving the flexibility of modifying the control logic diagrams. In addition, as the instrument database and the control logic diagram database are respectively created, the attribute input, deletion, modification and inquiry of legend symbols in the unified design drawing can be facilitated for instrument control professional designers under all nuclear power items, and the problem that the data in the control logic diagram is difficult to manage in a centralized manner is solved.
In one embodiment, as shown in fig. 12, a flowchart of a database updating method provided in an embodiment of the present application is shown, and specifically relates to a process of determining engineering target data, where the method may include the following steps:
step 1220, obtain the variable attribute of the target data from the database.
Step 1240, determine whether the variable attribute of the target data is a local variable.
Step 1260, if the variable attribute of the target data is a local variable, determining that the target data is engineering target data.
The variable attribute of the target data can be obtained from the database through the attribute identifier of the target data, after the variable attribute of the target data is obtained, the variable attribute needs to be judged, the variable attribute can be judged after the attribute identifier of the target data is compared with the preset attribute identifier, and if the variable attribute of the target data is a local variable, the target data is determined to be engineering target data.
In this embodiment, by acquiring the variable attribute of the target data from the database, it is determined whether the variable attribute of the target data is a local variable, and if the variable attribute of the target data is a local variable, it is determined that the target data is engineering target data. The type of the target data is determined according to the variable attribute of the target data, the judging mode is simple, and the speed of determining the type of the target data is improved, so that the efficiency of updating the target data is improved.
In one embodiment, as shown in fig. 13, a flowchart of a method for updating a database according to an embodiment of the present application is shown, and specifically relates to a process for updating a database according to common target data, where the method may include the following steps:
step 1320, if the target data is not engineering target data, determining whether the target data is public target data.
The target data includes engineering target data and public target data, if the target data is judged not to be engineering target data according to the variable attribute of the target data or the identification of the target data, whether the target data is public target data needs to be judged, at the moment, the judgment can be performed according to the variable attribute of the target data, and whether the target data is public target data can be judged according to the identification of the target data. For example, when determining according to the variable attribute of the target data, if the variable attribute of the target data is a global variable, it may be determined that the target data is common target data.
Step 1340, if the target data is public target data, acquiring a public database corresponding to the target data, and updating the target data in the public database to obtain the target database.
The common target data is target data required for generating all control logic diagrams, and the common target data is stored in a common database, so that after the target data is judged to be the common target data, the common database corresponding to the target data can be acquired, and the target data in the common database is updated to obtain the target database.
In this embodiment, by determining whether the target data is common target data, if the target data is common target data, then acquiring a common database corresponding to the target data, updating the target data in the common database to obtain the target database, and because the common target data is the target data required for generating all the control logic diagrams, updating the target data in the common database, it is possible to implement the linkage between the control logic diagram and the data after the modification of the control logic diagrams of the system under all the engineering projects, and improve the modification efficiency of the control logic diagrams.
In one embodiment, as shown in fig. 14, a flowchart of a database updating method provided in an embodiment of the present application is shown, and specifically relates to a process of determining public target data, where the method may include the following steps:
Step 1420, obtain variable attributes of the target data from the database.
Step 1440, determining whether the variable attribute of the target data is a global variable.
Step 1460, if the variable attribute of the target data is a global variable, determining that the target data is common target data.
The variable attribute of the target data can be obtained from the database through the attribute identifier of the target data, after the variable attribute of the target data is obtained, the variable attribute needs to be judged, the variable attribute can be judged after the attribute identifier of the target data is compared with the preset attribute identifier, and if the variable attribute of the target data is a global variable, the target data is determined to be public target data.
In this embodiment, by acquiring the variable attribute of the target data from the database, it is determined whether the variable attribute of the target data is a global variable, and if the variable attribute of the target data is a global variable, it is determined that the target data is common target data. The type of the target data is determined according to the variable attribute of the target data, the judging mode is simple, and the speed of determining the type of the target data is improved, so that the efficiency of updating the target data is improved.
It should be understood that, although the steps in the flowcharts of fig. 2-14 are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps of FIGS. 2-14 may include multiple steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the steps or stages of other steps or steps.
Referring to fig. 15, a block diagram of a database updating apparatus 1500 according to an embodiment of the present application is shown. As shown in fig. 15, the database updating apparatus 1500 may include: a first acquisition module 1502, a second acquisition module 1504, and an update module 1506, wherein:
a first obtaining module 1502, configured to obtain target data in a control logic diagram, where the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station.
The second obtaining module 1504 is configured to obtain, after updating the target data in the control logic diagram, the variable attribute of the target data from the database.
And the updating module 1506 is configured to update the target data in the database according to the variable attribute of the target data to obtain the target database.
In one embodiment, the target data includes common target data and engineering target data, the common target data is target data required by all control logic diagrams, the engineering target data is target data required by different control logic diagrams, and the different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein public target data are stored in the public database, and engineering target data are stored in the engineering database; the variable attributes comprise global variables and local variables; the update module 1506 includes a determining unit and a first obtaining unit, where the first determining unit is configured to determine whether the target data is engineering target data; the first acquisition unit is used for acquiring an engineering database corresponding to the target data if the target data is engineering target data, and updating the target data in the engineering database to obtain the target database.
In one embodiment, the first judging unit is specifically configured to obtain a variable attribute of the target data from the database; judging whether the variable attribute of the target data is a local variable or not; and if the variable attribute of the target data is a local variable, determining the target data as engineering target data.
In one embodiment, the updating module 1506 further includes a second determining unit and a second obtaining unit, where the second determining unit is configured to determine whether the target data is public target data if the target data is not engineering target data; the second obtaining unit is used for obtaining a public database corresponding to the target data if the target data is public target data, and updating the target data in the public database to obtain the target database.
In one embodiment, the second determining unit is specifically configured to obtain a variable attribute of the target data from the database; judging whether the variable attribute of the target data is a global variable or not; and if the variable attribute of the target data is a global variable, determining that the target data is public target data.
In one embodiment, if the target data is a control logic diagram, the database is a control logic diagram database; the first obtaining unit is further configured to obtain an engineering database corresponding to the control logic diagram if the control logic diagram is engineering target data, and update the target data in the engineering database to obtain the target database.
In one embodiment, if the target data includes meter data, the database is a meter database; the second obtaining unit is further configured to obtain an engineering database corresponding to the meter data if the meter data is engineering target data, and update the meter data in the engineering database to obtain the target database.
For specific limitations of the database updating means, reference is made to the above limitation of the database updating method, and no further description is given here. The respective modules in the database updating apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may invoke and perform the operations of the above modules.
In one embodiment of the present application, a computer device is provided, the computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor, when executing the computer program, performing the steps of:
acquiring target data in a control logic diagram, wherein the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station; after updating the target data in the control logic diagram, obtaining variable attributes of the target data from a database; and updating the target data in the database according to the variable attribute of the target data to obtain a target database.
In one embodiment of the present application, the target data includes common target data and engineering target data, the common target data is target data required for generating all control logic diagrams, the engineering target data is target data required for generating different control logic diagrams respectively, and the different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein public target data are stored in the public database, and engineering target data are stored in the engineering database; the variable attributes comprise global variables and local variables;
the processor when executing the computer program also implements the steps of:
judging whether the target data is engineering target data or not; and if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database.
In one embodiment of the present application, the processor when executing the computer program further performs the steps of:
obtaining variable attributes of target data from a database; judging whether the variable attribute of the target data is a local variable or not; and if the variable attribute of the target data is a local variable, determining the target data as engineering target data.
In one embodiment of the present application, the processor when executing the computer program further performs the steps of:
if the target data is not engineering target data, judging whether the target data is public target data or not; if the target data is public target data, a public database corresponding to the target data is obtained, and the target data in the public database is updated to obtain the target database.
In one embodiment of the present application, the processor when executing the computer program further performs the steps of:
obtaining variable attributes of target data from a database; judging whether the variable attribute of the target data is a global variable or not; and if the variable attribute of the target data is a global variable, determining that the target data is public target data.
In one embodiment of the present application, if the target data is a control logic diagram, the database is a control logic diagram database;
the processor when executing the computer program also implements the steps of:
and if the control logic diagram is engineering target data, acquiring an engineering database corresponding to the control logic diagram, and updating the target data in the engineering database to obtain the target database.
In one embodiment of the present application, if the target data includes meter data, the database is a meter database;
The processor when executing the computer program also implements the steps of:
and if the instrument data are engineering target data, acquiring an engineering database corresponding to the instrument data, and updating the instrument data in the engineering database to obtain the target database.
The computer device provided in the embodiments of the present application has similar implementation principles and technical effects to those of the above method embodiments, and will not be described herein.
In one embodiment of the present application, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring target data in a control logic diagram, wherein the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station; after updating the target data in the control logic diagram, obtaining variable attributes of the target data from a database; and updating the target data in the database according to the variable attribute of the target data to obtain a target database.
In one embodiment of the present application, the target data includes common target data and engineering target data, the common target data is target data required for generating all control logic diagrams, the engineering target data is target data required for generating different control logic diagrams respectively, and the different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein public target data are stored in the public database, and engineering target data are stored in the engineering database; the variable attributes comprise global variables and local variables;
The computer program when executed by the processor also performs the steps of:
judging whether the target data is engineering target data or not; and if the target data is engineering target data, acquiring an engineering database corresponding to the target data, and updating the target data in the engineering database to obtain the target database.
In one embodiment of the present application, the computer program when executed by the processor further performs the steps of:
obtaining variable attributes of target data from a database; judging whether the variable attribute of the target data is a local variable or not; and if the variable attribute of the target data is a local variable, determining the target data as engineering target data.
In one embodiment of the present application, the computer program when executed by the processor further performs the steps of:
if the target data is not engineering target data, judging whether the target data is public target data or not; if the target data is public target data, a public database corresponding to the target data is obtained, and the target data in the public database is updated to obtain the target database.
In one embodiment of the present application, the computer program when executed by the processor further performs the steps of:
obtaining variable attributes of target data from a database; judging whether the variable attribute of the target data is a global variable or not; and if the variable attribute of the target data is a global variable, determining that the target data is public target data.
In one embodiment of the present application, if the target data is a control logic diagram, the database is a control logic diagram database;
the computer program when executed by the processor also performs the steps of:
and if the control logic diagram is engineering target data, acquiring an engineering database corresponding to the control logic diagram, and updating the target data in the engineering database to obtain the target database.
In one embodiment of the present application, if the target data includes meter data, the database is a meter database;
the computer program when executed by the processor also performs the steps of:
and if the instrument data are engineering target data, acquiring an engineering database corresponding to the instrument data, and updating the instrument data in the engineering database to obtain the target database.
The computer readable storage medium provided in this embodiment has similar principles and technical effects to those of the above method embodiment, and will not be described herein.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples represent only a few embodiments of the present application, which are described in more detail and are not thereby to be construed as limiting the scope of the claims. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application is to be determined by the claims appended hereto.
Claims (9)
1. A method of updating a database, the method comprising:
acquiring target data in a control logic diagram, wherein the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station;
after updating the target data in the control logic diagram, acquiring variable attributes of the target data from a database;
Updating the target data in the database according to the variable attribute of the target data to obtain a target database;
the target data comprise public target data and engineering target data, the public target data are target data required by all control logic diagrams, the engineering target data are target data required by different control logic diagrams, and different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein the public database stores the public target data, and the engineering database stores the engineering target data; the variable attributes comprise global variables and local variables;
the updating the target data in the database according to the variable attribute of the target data to obtain a target database comprises the following steps:
judging whether the target data is engineering target data or not according to the variable attribute of the target data;
and if the target data are engineering target data, acquiring the engineering database corresponding to the target data, and updating the target data in the engineering database to obtain a target database.
2. The method of claim 1, wherein said determining whether the target data is engineering target data comprises:
obtaining variable attributes of the target data from the database;
judging whether the variable attribute of the target data is a local variable or not;
and if the variable attribute of the target data is a local variable, determining that the target data is engineering target data.
3. The method according to claim 1, wherein the method further comprises:
if the target data is not engineering target data, judging whether the target data is public target data or not;
and if the target data are public target data, acquiring the public database corresponding to the target data, and updating the target data in the public database to obtain a target database.
4. A method according to claim 3, wherein said determining whether said target data is common target data comprises:
obtaining variable attributes of the target data from the database;
judging whether the variable attribute of the target data is a global variable or not;
and if the variable attribute of the target data is a global variable, determining that the target data is public target data.
5. The method of claim 1, wherein if the target data is a control logic graph, the database is a control logic graph database;
if the target data is engineering target data, acquiring the engineering database corresponding to the target data, and updating the target data in the engineering database to obtain a target database, wherein the method comprises the following steps:
and if the control logic diagram is engineering target data, acquiring the engineering database corresponding to the control logic diagram, and updating the target data in the engineering database to obtain a target database.
6. The method of claim 1, wherein if the target data comprises meter data, the database is a meter database;
if the target data is engineering target data, acquiring the engineering database corresponding to the target data, and updating the target data in the engineering database to obtain a target database, wherein the method comprises the following steps:
and if the instrument data are engineering target data, acquiring the engineering database corresponding to the instrument data, and updating the instrument data in the engineering database to obtain a target database.
7. A database updating apparatus, the apparatus comprising:
the first acquisition module is used for acquiring target data in a control logic diagram, wherein the control logic diagram is generated based on the target data; the control logic diagram is applied to the instrument control design of the nuclear power station;
the second acquisition module is used for acquiring variable attributes of the target data from a database after updating the target data in the control logic diagram;
the updating module is used for updating the target data in the database according to the variable attribute of the target data to obtain a target database;
the target data comprise public target data and engineering target data, the public target data are target data required by all control logic diagrams, the engineering target data are target data required by different control logic diagrams, and different control logic diagrams correspond to different engineering target data; the database comprises a public database and an engineering database, wherein the public database stores the public target data, and the engineering database stores the engineering target data; the variable attributes comprise global variables and local variables;
The updating module comprises a judging unit and a first obtaining unit:
the judging unit is used for judging whether the target data is engineering target data according to the variable attribute of the target data;
the first obtaining unit is configured to obtain the engineering database corresponding to the target data if the target data is engineering target data, and update the target data in the engineering database to obtain a target database.
8. A computer device comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, implements the steps of the method of any of claims 1 to 6.
9. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110284929.1A CN112783913B (en) | 2021-03-17 | 2021-03-17 | Database updating method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110284929.1A CN112783913B (en) | 2021-03-17 | 2021-03-17 | Database updating method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112783913A CN112783913A (en) | 2021-05-11 |
| CN112783913B true CN112783913B (en) | 2024-02-06 |
Family
ID=75762761
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110284929.1A Active CN112783913B (en) | 2021-03-17 | 2021-03-17 | Database updating method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112783913B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103927402A (en) * | 2013-01-14 | 2014-07-16 | 上海核工程研究设计院 | Control logic diagram modular design management system implementation method |
| CN102522128B (en) * | 2011-11-09 | 2014-12-17 | 中广核工程有限公司 | Method and system for testing configuration logic design of DCS (Distributed Control System) of nuclear power station |
| CN103823666B (en) * | 2013-11-05 | 2017-02-01 | 国电南瑞科技股份有限公司 | Smart substation equipment visualized programming method |
| CN108829745A (en) * | 2018-05-24 | 2018-11-16 | 北京三快在线科技有限公司 | Management method, device and the electronic equipment of business datum |
| CN109408897A (en) * | 2018-09-26 | 2019-03-01 | 中广核工程有限公司 | The conversion method and system identified based on PDMS to AutoCAD drawing size marking |
| CN109991948A (en) * | 2014-11-11 | 2019-07-09 | 横河电机株式会社 | Process Control System and its configuration system and method |
| CN106649230B (en) * | 2016-09-30 | 2019-07-26 | 株洲中车时代电气股份有限公司 | A kind of figure automatic generation method of train network control system logic chart |
| CN110554675A (en) * | 2019-09-18 | 2019-12-10 | 台山核电合营有限公司 | Method and system for constructing, synchronizing, presenting and analyzing nuclear power DCS (distributed control System) offline database |
| CN110619016A (en) * | 2019-09-24 | 2019-12-27 | 苏州浪潮智能科技有限公司 | Data processing method and device for big data platform and storage medium |
| CN111373362A (en) * | 2018-06-30 | 2020-07-03 | 西部数据技术公司 | Multi-device storage system with distributed read/write processing |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11775505B2 (en) * | 2019-04-03 | 2023-10-03 | Unitedhealth Group Incorporated | Managing data objects for graph-based data structures |
-
2021
- 2021-03-17 CN CN202110284929.1A patent/CN112783913B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102522128B (en) * | 2011-11-09 | 2014-12-17 | 中广核工程有限公司 | Method and system for testing configuration logic design of DCS (Distributed Control System) of nuclear power station |
| CN103927402A (en) * | 2013-01-14 | 2014-07-16 | 上海核工程研究设计院 | Control logic diagram modular design management system implementation method |
| CN103823666B (en) * | 2013-11-05 | 2017-02-01 | 国电南瑞科技股份有限公司 | Smart substation equipment visualized programming method |
| CN109991948A (en) * | 2014-11-11 | 2019-07-09 | 横河电机株式会社 | Process Control System and its configuration system and method |
| CN110362056A (en) * | 2014-11-11 | 2019-10-22 | 横河电机株式会社 | Process Control System and its configuration system and method |
| CN106649230B (en) * | 2016-09-30 | 2019-07-26 | 株洲中车时代电气股份有限公司 | A kind of figure automatic generation method of train network control system logic chart |
| CN108829745A (en) * | 2018-05-24 | 2018-11-16 | 北京三快在线科技有限公司 | Management method, device and the electronic equipment of business datum |
| CN111373362A (en) * | 2018-06-30 | 2020-07-03 | 西部数据技术公司 | Multi-device storage system with distributed read/write processing |
| CN109408897A (en) * | 2018-09-26 | 2019-03-01 | 中广核工程有限公司 | The conversion method and system identified based on PDMS to AutoCAD drawing size marking |
| CN110554675A (en) * | 2019-09-18 | 2019-12-10 | 台山核电合营有限公司 | Method and system for constructing, synchronizing, presenting and analyzing nuclear power DCS (distributed control System) offline database |
| CN110619016A (en) * | 2019-09-24 | 2019-12-27 | 苏州浪潮智能科技有限公司 | Data processing method and device for big data platform and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 基于VISIO的功能图自动制图软件设计;董旭辰;崔瑶;;电脑知识与技术(14);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112783913A (en) | 2021-05-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Shi et al. | Manufacturability analysis for additive manufacturing using a novel feature recognition technique | |
| CN111309315B (en) | Automatic configuration method based on industrial Internet of things data and business modeling | |
| JP2015109011A (en) | Field device management apparatus, device information display method, computer program, and recording medium | |
| US10963894B2 (en) | Facilitating an error analysis of a product deficiency system and method | |
| CN110543303B (en) | Visual service platform | |
| CN111177825A (en) | Parameterized modeling method and device | |
| JP2018081693A (en) | Automated process control hardware engineering using schema-represented requirements | |
| US11531324B2 (en) | Method and system for cross discipline data validation checking in a multidisciplinary engineering system | |
| CN105159754A (en) | On-line simulation method and device based on intelligent business cloud platform | |
| KR100976829B1 (en) | The method and service system for reviewing design of shipbuilding and offshore plant | |
| JP6544407B2 (en) | INFORMATION PROCESSING APPARATUS, CONTROL METHOD THEREOF, AND PROGRAM | |
| Qiao et al. | Data driven design and simulation system based on XML | |
| CN112783913B (en) | Database updating method, device, equipment and storage medium | |
| US10902170B2 (en) | Method for computer assisted planning of a technical system | |
| Ricci et al. | PMI: a PLM approach for the management of geometrical and dimensional controls in modern industries | |
| CN109117431A (en) | System and method for the source data applied from source to be incorporated into the target data of target application | |
| JP2009193489A (en) | Work procedure manual creation system | |
| CN114092641A (en) | Method, device and equipment for generating wiring board drawing and readable storage medium | |
| JP4803447B2 (en) | CAD system and program implemented in this system | |
| US11327471B2 (en) | Building and tracking of an automation engineering environment | |
| JP6133763B2 (en) | Production information management device, production information management method and program | |
| JP4085789B2 (en) | Object-oriented machining simulation apparatus and object-oriented machining simulation program | |
| US20210240873A1 (en) | Cad systems using rule-driven product and manufacturing information | |
| CN114897393B (en) | Method, system, medium and equipment for realizing intelligent building site management by BIM | |
| KR100886657B1 (en) | System and Method for making Basic Document of Dimensional Accuracy Check Sheet for Block in Ship Production |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |