Universal method for storing and displaying various instrument control devices

Abstract

The invention relates to a universal method for storing and displaying various instrument control devices. The method comprises the steps that public basic information is extracted; extracting public attachment information; a database main table is designed, the database main table comprises a fixed field and a dynamic field, and the public basic information and the public attachment information serve as the fixed field; designing a dynamic field of the database main table, wherein the dynamic field is provided with a dynamic field identifier; designing a configuration table for the fixed fields and the dynamic fields; and performing joint analysis and display on the fixed field and the dynamic field. By designing the database, the fields for storing the data format content can be dynamically expanded to store various different instrument control equipment information and related document data, when different data formats are stored, the format storage can be realized only by performing simple configuration, and the data format can be analyzed by analyzing the storage format, so that the data format storage efficiency is improved. And data can be quickly screened and queried, and data statistics and the like can be displayed in multiple dimensions.

Description

Technical Field

[0001] This patent application belongs to the field of computer software database storage and automation technology, and more specifically, it relates to a general method for storing and displaying various types of instrumentation and control equipment. Background Art

[0002] In the field of automation, due to the wide variety of automation system instrumentation and control equipment (temperature, pressure, flow, control valves, etc.), each automation system instrumentation and control equipment has a large number of basic parameters and data. Due to the lack of a unified recording and management method, it is difficult to record the basic information of various types of instrumentation and control equipment and the corresponding data information through a set of systems, which makes daily management very cumbersome. Finding information and fault causes is not only inefficient but also very inconvenient.

[0003] The above basic parameters and data are currently mainly managed through file recording and database storage. The file recording method is to record through Excel tables, and record the full amount of basic attribute information of the parameters of the instrumentation and control equipment in the automation system, resulting in many redundant field columns, and some files and data corresponding to the instrumentation and control equipment cannot be well associated with the instrumentation and control equipment, resulting in the inability to query and multi-dimensional statistics of the file information stored in the instrumentation and control equipment. In the database storage method, all known possible instrumentation and control equipment attribute information will be designed into the database at the beginning of system design, and it cannot be adjusted dynamically. When unknown new equipment is entered, the existing design may not meet the required situation and requires system upgrades to support it. It cannot support various types of instrumentation and control equipment well. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a general method for storing and displaying various types of instrumentation and control equipment. By designing a database, the fields for storing data format content can be dynamically expanded to store various different instrumentation and control equipment information and related document materials. When storing different data formats, only simple configuration is required to realize format storage, and by parsing the storage format, data can be quickly screened and queried, and data statistics can be displayed in multiple dimensions.

[0005] In order to solve the above problems, the technical solution adopted by the present invention is: A general method for storing and displaying various types of instrumentation and control equipment includes the following steps: S1. Analyze and summarize the basic information of various existing instrumentation and control equipment, extract the common basic information of each instrumentation and control equipment, and represent it with fields.

[0006] S2. Add public attachment information to the instrumentation and control equipment, and extract the public attachment information that each instrumentation and control equipment has; S3. Design a database master table based on the public basic information and public attachment information. The database master table includes fixed fields and dynamic fields. The public basic information and public attachment information are used as fixed fields of the database master table. S4. Design a dynamic field of the database master table. The dynamic field is provided with a dynamic field identifier, which is an extensible identifier. S5. Design a configuration table for the fixed fields and dynamic fields of the database master table, and configure a record for each fixed field and dynamic field; S6. Perform joint analysis on the fixed fields and dynamic fields of the database master table, and display the configured data.

[0007] Furthermore, in S1, the public basic information includes, but is not limited to, one or more of equipment classification, equipment number, equipment name, manufacturer, range, and production date.

[0008] Further, in S2, the public attachment information includes but is not limited to one or more of equipment pictures, on-site pictures, operating instructions, processing instructions, and other attachments.

[0009] Furthermore, in S4, the dynamic field identifier is stored in the dynamic field of the database master table in json format.

[0010] Further, in S5, the configuration table database includes but is not limited to one or more of instrumentation and control equipment classification, whether a field is dynamic, field description, and field sorting.

[0011] Due to the adoption of the above technical solution, the beneficial effects achieved by the present invention are: The present invention can store various instrumentation and control equipment information and related documents by dynamically expanding the fields for storing data format contents through designing the database. When storing different data formats, only simple configuration is required to realize the storage of the formats, and by parsing the storage formats, data can be quickly screened and queried, and data statistics can be displayed in multiple dimensions. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] Figure 1 It is a business process diagram of the present invention.

[0013] Figure 2 This is an example diagram of data storage according to the present invention. DETAILED DESCRIPTION

[0014] The present invention is further described in detail below with reference to the embodiments.

[0015] A general method for storing and displaying various types of instrumentation and control equipment, such as Figure 1 , including the following steps: 1) It is necessary to analyze and summarize the basic information of various existing instrumentation and control equipment, extract the common basic information of each instrumentation and control equipment, and express it with fields. For example, the fields in the common basic information include: instrumentation and control equipment identification, instrumentation and control equipment classification, instrumentation and control equipment number / code, instrumentation and control equipment name, instrumentation and control equipment model, usage status, manufacturer, range, factory date, etc. As shown below:

[0016] 2) It is necessary to add public attachment information to the instrumentation and control equipment and extract the public attachment information that each instrumentation and control equipment has. The fields in the public attachment information include: equipment pictures, on-site pictures, operating instructions (books), processing instructions, other attachments, etc., as shown below:

[0017] 3) Design the database main table based on the public basic information and public attachment information, and design the public information fields of the database main table. The database main table includes fixed fields and dynamic fields. The common information (public basic information and public attachment information) of the extracted instrumentation and control equipment is designed as the fixed fields of the database main table.

[0018] 4) For the dynamic field database design in the database master table, only one field is set as the dynamic field identifier, such as Figure 2 In the upper right corner, fixed is marked with 0, and dynamic is marked with 1. In the design of the dynamic field of the database main table, it is stored in the dynamic field in json (key value) format. This method can expand the dynamic field identification.

[0019] Example: The storage field format is a json key-value format, {"range": "Range 15", "technology": ["Technology"], "alarmValue": "Alarm Value 15", "batchStatus": "1", "programLabel": "Label 15", "manufacturerName": "Yokogawa"} Description of the key-value naming method of key-value pairs: If there is a camel case key name, it should be decomposed into two or more words by underscores, and connected by underscores. If there is no camel case, all are lowercase and the name remains unchanged. For example: the key rang corresponds to the field [English name] value of rang in the configuration table in 5. The key alarmValue corresponds to the field [English name] alarm_value in the configuration table in step 5.

[0020] 5) Design the configuration table for the fixed fields and dynamic fields of the database main table, and design the database table for the dynamic fields of the database. There is one record for each field, and one record is configured for each fixed field and dynamic field. Configure according to the fields and descriptions.

[0021] The core fields in the configuration table include: instrumentation and control equipment classification (classification design is carried out in a recursive manner), configuration identification (unique), dynamic field identification (very important, used to distinguish dynamic fields, expressed as "yes or no", used to distinguish which configuration field is a fixed field and which is a dynamic extension field), field description (including Chinese description, English name, English name and data field name correspond or have mapping rules, camel case correspondence rules can be used), field sorting (page display position control), control type (text box, list, check box, etc.), input control type (single or multiple selection), query control type (single or multiple selection), default display value (usually initial value), status (valid or invalid), etc. When designing, you can give the configuration table more attribute fields to facilitate better display or presentation later. The examples are as follows:

[0022] 6) Perform joint parsing query on the fixed fields and dynamic extended content fields of the database main table, combine the fixed field query and the dynamic extended content query, escape the query content through the configuration table, and display the results.

[0023] The data storage example of the present invention is as follows Figure 2 As shown, in the order from left to right and from top to bottom, the basic information of the instrumentation and control equipment is summarized first. Taking category 10001 and number A001 as an example, the basic information (public basic information + public attachment information) is displayed, covering equipment model, first use time, equipment photo, instruction manual, range, alarm value, process and other contents.

[0024] The database master table is designed based on the public basic information + public attachment information, covering equipment classification, equipment number, equipment name, equipment model, first use time, extended data, etc. Next, the data configuration table is designed. In the dynamic flag, 0 means fixed and 1 means dynamic. In the data format, 1 means single and 2 means multiple. In the data, 1 means normal storage and 2 means dynamic storage. In the status, 0 means valid and 1 means invalid.

[0025] After the data configuration table is designed successfully, the data configuration table data is displayed, and the equipment code, equipment name, equipment model, first use time, range, alarm value, process, equipment picture, instruction manual and other contents are all marked with corresponding 0 or 1. Finally, the main data table data storage is formed, such as Figure 2 The bottom of the display. Figure 2 It can be seen that when storing different data formats, the present invention only needs to perform simple configuration to realize format storage, and can perform multi-dimensional display by quickly screening and querying data, data statistics, etc. through parsing the storage format.

Claims

1. A general method for storing and displaying various types of instrumentation and control equipment, characterized in that The steps include: S1. Analyze and summarize the basic information of various existing instrumentation and control equipment, and extract the common basic information of each instrumentation and control equipment; S2. Add public attachment information to the instrumentation and control equipment, and extract the public attachment information that each instrumentation and control equipment has; S3. Design a database master table based on the public basic information and public attachment information. The database master table includes fixed fields and dynamic fields. The public basic information and public attachment information are used as fixed fields of the database master table. S4. Design a dynamic field of the database master table. The dynamic field is provided with a dynamic field identifier, which is an extensible identifier. S5. Design a configuration table for the fixed fields and dynamic fields of the database master table, and configure a record for each fixed field and dynamic field; S6. Perform joint analysis on fixed fields and dynamic fields, and display the configured data.

2. A general method for storing and displaying various types of instrumentation and control equipment according to claim 1, characterized in that: In S1, the public basic information includes, but is not limited to, one or more of equipment classification, equipment number, equipment name, manufacturer, range, and production date.

3. A general method for storing and displaying various types of instrumentation and control equipment according to claim 2, characterized in that: In S2, the public attachment information includes, but is not limited to, one or more of equipment pictures, on-site pictures, operating instructions, processing instructions, and other attachments.

4. A general method for storing and displaying various types of instrumentation and control equipment according to claim 2, characterized in that: In S4, dynamic field identifiers are stored in the dynamic fields of the database master table in JSON format.

5. A general method for storing and displaying various types of instrumentation and control equipment according to claim 1, characterized in that: In S5, the configuration table database includes but is not limited to one or more of instrumentation and control equipment classification, whether a field is dynamic, field description, and field sorting.

6. A general method for storing and displaying various types of instrumentation and control equipment according to claim 5, characterized in that: The classification of instrumentation and control equipment is carried out recursively.

Images