An optimization method for improving the effective capacity of a lift management system database

Abstract

The application discloses an optimization method for improving the effective capacity of a management system database, which adopts double judgment logic of communication characteristic data and service characteristic data to simultaneously provide communication state judgment and service state judgment, and instantly eliminates communication faults and service data that do not meet the requirements, so as to greatly reduce invalid data stored from a source system to the management system, thereby achieving the purposes of prolonging the available time of the same storage hardware or reducing the storage hardware storage under the same expected time limit, reducing the hardware cost on one hand and reducing the power consumption cost on the other hand, and improving the effective capacity of the management system database.

Description

TECHNICAL FIELD

[0001] The present application belongs to the field of database optimization method, and particularly relates to an optimization method for managing effective capacity of a system database. BACKGROUND

[0002] Web Service provides a common mechanism for the integration of business processes of the whole enterprise or even multiple organizations, and the applications implemented according to the Web Service specification can exchange data with each other regardless of the language, platform or internal protocol used by them. Web Service is a self-describing, self-contained network module that can perform specific business functions. Web Service is also easy to deploy because it is based on some common industry standards and existing technologies, such as the subset XML under the standard general markup language, HTTP, thereby reducing the cost of application interface.

[0003] However, when the application Web Service mechanism sends data from an industrial control system (such as a discrete control system DCS of a thermal power plant, a production real-time management system SIS, etc.) to a management system outside the configuration and safety zone, if the receiving system does not make a selection and takes all, the following problems will occur:

[0004] 1. The source system occasionally cannot generate data files in time and correctly due to data abnormalities or system problems;

[0005] 2. The source system or the network of the system has problems, such as network interruption and large communication delay, which result in that the system cannot upload files to the file server or download data files;

[0006] 3. This mode strictly limits the data type, for example, only coal consumption data is needed at present, and desulfurizing agent data needs to be added in the future, which results in that the SIS system and the system need to be changed in program, and the operation and maintenance cost is high;

[0007] 4. If the relevant data is changed after the source system generates the file, the data of both sides needs to be updated to keep consistent through a manual triggering mode;

[0008] 5. When the source system corresponding to the production equipment is in an abnormal working state (such as stoppage, standby, etc.), it still stores data, which not only occupies storage medium but also consumes power, resulting in cost increase. If the management system does not require all data, only data during normal operation or start-up process is needed, and the source system still sends all data, which will also cause greater waste of storage medium and consume a large amount of energy. SUMMARY

[0009] In order to overcome the above-mentioned deficiencies of the prior art, the purpose of the present application is to provide an optimization method for improving the effective capacity of a management system database, which can instantly eliminate communication failures and data that does not meet the requirements of service data, greatly reduce the invalid data stored from a source system to the management system, and thus achieve the purpose of prolonging the available time of the same storage hardware or reducing the storage hardware storage under the same expected time limit, thereby reducing hardware costs on the one hand and reducing power consumption costs on the other hand.

[0010] The technical solution of the present application is an optimization method for improving the effective capacity of a management system database, characterized in that communication feature data and service feature data are used to provide communication state judgment and service state judgment simultaneously, so as to maximize the avoidance of invalid data in the management system database and improve the effective capacity of the management system database.

[0011] Step one, send an http request to the data source side database, accept the returned data, and then use the communication feature data judgment logic to judge the communication state, judge whether the communication is normal, otherwise the data reading is ended;

[0012] Step two, report the data communication judgment normal data, use the service feature data judgment logic to judge the service state, and perform logical operation on the selected feature data generator operation GEN_run=0 and main steam flow TORBIN_f>[f0], when the generator operation and the main steam flow are greater than the basic value f0 at the same time, it is judged that the service state is normal, the data is normally stored, otherwise, it is judged that the service data is abnormal, and the data storage is abandoned;

[0013] Step three, after the database storage stops under certain conditions, the main system operation and the related data judgment system continue to run until the communication feature data and the service feature data two judgment logics show that the service system is normally running, then start to read and store the related data.

[0014] Further, the specific method for judging by the communication feature data judgment logic is as follows:

[0015] Through web service mode, communicate with the sis system, read the unit operation data of the sis system in real time, and eliminate the data type irrelevant to cost calculation, and store the effective data into the database; according to the ret_flag flag information returned by remote calling, judge whether the communication of both systems is normal, ret_flag=0 indicates that the communication is abnormal, skip the request, and do not parse the returned information; ret_flag=1 indicates that the communication is normal, data_flag=1 indicates that the data is normal, the returned data is stored and displayed according to the agreed mode; data_flag=0 indicates that the returned data is abnormal, the page prompts, and the user can manually correct the abnormal data.

[0016] Further, the specific method of judging by the business feature data judging logic is:

[0017] The database designed by the system is used for storing the operation data of the thermal power generating unit related to cost accounting, therefore, when selecting the business feature data for judging, the following three principles should be followed: first, the data serving as the judging data must be the core data related to the state of the generating unit; second, the different data sources must come from different DPU boards of the DCS system; third, the data must be selected from different data types, such as switch value data + analog value data, so as to avoid the low reliability of the parameters, the misjudgment caused by the switching of the data to the redundant part due to the fault of a single board, and the misjudgment caused by the systematic influence of the same type of data. Accordingly, the on-grid switch value data of the generating unit and the analog value data of the main steam flow of the boiler are selected as the criteria, and when the corresponding conditions are met, the read data is stored in the database.

[0018] The present application has the following features

[0019] (1) The two core optimization algorithms of the present method provide communication state judgment and business state judgment at the same time, thereby avoiding the inclusion of invalid data in the database of the management system to the maximum extent and improving the effective capacity of the database of the management system.

[0020] (2) The present application cancels the storage of data in the invalid time period based on the communication feature data and the business feature data, thereby improving the effectiveness of the data in the database, and according to the state change of the business object, the storage time of the data can be greatly improved under the condition of a certain storage system capacity.

[0021] (3) The present application cancels the illegal storage of related system data by using the regular judgment method of the communication feature data.

[0022] (4) The present application cancels the storage of data groups in the time period that does not meet the storage requirements in the business system targeted by the database by using the regular judgment method of the business feature data.

[0023] (5) The database used by the present system is a standard database, which has good compatibility and universality.

[0024] (6) The data stored by the present application corresponds to the time relationship, and the data can be extracted and calculated according to a certain rule while preserving the corresponding relationship of the data. BRIEF DESCRIPTION OF DRAWINGS

[0025] Figure 1 is the logic diagram for judging the effectiveness of the data stored in the present application. DETAILED DESCRIPTION

[0026] In order to make the purposes, technical solutions and advantages of the present application clearer, the technical solutions of the present application will be described in detail below. Obviously, the described embodiments are only some of the embodiments of the present application, but not all the embodiments. Based on the embodiments of the present application, all other embodiments obtained by those skilled in the art without creative effort belong to the protection scope of the present application.

[0027] The present application will be described in further detail below with reference to the drawings.

[0028] When the program reads in data, the program is started regularly to judge the validity of the read-in data and selectively store, so as to reduce the probability of invalid data storage and improve the effectiveness of storage unit utilization.

[0029] The specific implementation is as follows Figure 1 As shown in the logic, an http request is sent to the data source side database, the returned data is accepted, and then the communication characteristic data criterion is used to judge whether the communication is normal, otherwise the data reading is ended.

[0030] The data report is sent to the data communication judgment normal, the business characteristic data is judged, the selected characteristic data (generator operation GEN_run=0 and main steam flow TORBIN_f>[f0]) is logically operated, and when the "generator operation" and "main steam flow greater than the basic value f0" are established at the same time, it is judged that the business state is normal, the data is normally stored, otherwise, it is judged that the business data is abnormal, and the data storage is abandoned.

[0031] After the database storage stops under certain conditions, the main system operation and the related data judgment system continue to run until both judgment logics (i.e. the communication characteristic data and the business characteristic data) show that the business system is normally running, and then the related data is read in and stored.

[0032] The above is only a specific embodiment of the present application, but the protection scope of the present application is not limited thereto, and any changes or replacements easily thought of by those skilled in the art within the technical range disclosed by the present application should be covered in the protection scope of the present application.

Claims

1. An optimization method for enhancing the effective capacity of a lift management system database, characterized by, The communication characteristic data and the service characteristic data are used to provide the communication state judgment and the service state judgment, so that invalid data in the management system database is avoided, and the effective capacity of the management system database is improved. Step one, sending http request to the data source side database, accepting the returned data, and then using the communication characteristic data judgment logic to judge the communication state, judging whether the communication is normal, otherwise the data reading is ended; Step two, the data communication judgment normal data report, using the service characteristic data judgment logic to judge the service state, the selected characteristic data generator operation GEN_run=0 and main steam flow TORBIN_f>[f0] are operated, when the generator operation and the main steam flow are greater than the basic value f0, the service state is normal, the data is normally stored, otherwise, the service data is abnormal, the data storage is abandoned; Step three, after the database storage stops under certain conditions, the main system runs with the related data judgment system, until the communication characteristic data and the service characteristic data two judgment logics show that the service system runs normally, the related data is read and stored; The specific method of using the communication characteristic data judgment logic to judge the communication state is: Through the web service mode, the sis system is communicated, the unit operation data of the sis system is read in real time, and the data type unrelated to the cost calculation is removed, and the effective data is stored in the database; according to the ret_flag flag information returned by remote calling, whether the communication between the two systems is normal is judged, ret_flag=0 indicates that the communication is abnormal, the request is skipped, and the returned information is not parsed; ret_flag=1 indicates that the communication is normal, data_flag=1 indicates that the data is normal, the returned data is stored and displayed according to the agreed mode; data_flag=0 indicates that the returned data is abnormal, the page prompts, and the user manually corrects the abnormal data; The specific method of using the service characteristic data judgment logic to judge the service state is: The database designed by the system is used to store the operation data related to the cost accounting of the thermal power generator unit, therefore, when the service characteristic data is judged, the following three principles should be followed: first, the data used for judgment must be the core data related to the state of the generator unit; second, different data sources must come from different DPU boards of the DCS system; third, different data types must be selected, according to which the generator grid connection switch quantity data and the boiler main steam flow analog quantity data are selected as the criterion, and when the corresponding conditions are met, the read data starts to be stored in the database.

Images