CN116627959B - Method for clearing operation history data of movable ring equipment of machine room - Google Patents
Method for clearing operation history data of movable ring equipment of machine room Download PDFInfo
- Publication number
- CN116627959B CN116627959B CN202310920050.0A CN202310920050A CN116627959B CN 116627959 B CN116627959 B CN 116627959B CN 202310920050 A CN202310920050 A CN 202310920050A CN 116627959 B CN116627959 B CN 116627959B
- Authority
- CN
- China
- Prior art keywords
- data
- equipment
- database
- memory
- validity
- 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 39
- 238000004458 analytical method Methods 0.000 claims abstract description 27
- 238000003860 storage Methods 0.000 claims abstract description 19
- 238000012545 processing Methods 0.000 claims abstract description 11
- 238000009877 rendering Methods 0.000 claims abstract description 7
- 238000004364 calculation method Methods 0.000 claims abstract description 6
- 238000006243 chemical reaction Methods 0.000 claims abstract description 3
- 238000004140 cleaning Methods 0.000 claims description 17
- 230000002159 abnormal effect Effects 0.000 claims description 14
- 238000007405 data analysis Methods 0.000 claims description 10
- 230000006870 function Effects 0.000 claims description 9
- 238000012544 monitoring process Methods 0.000 claims description 9
- 238000010586 diagram Methods 0.000 claims description 7
- 238000004891 communication Methods 0.000 claims description 6
- 238000012217 deletion Methods 0.000 claims description 6
- 230000037430 deletion Effects 0.000 claims description 6
- 238000007667 floating Methods 0.000 claims description 6
- 230000003139 buffering effect Effects 0.000 claims description 5
- 238000013500 data storage Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 claims description 5
- 230000003993 interaction Effects 0.000 claims description 3
- 238000005259 measurement Methods 0.000 claims description 3
- 238000002360 preparation method Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 5
- 230000015556 catabolic process Effects 0.000 description 4
- 206010033799 Paralysis Diseases 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 238000010926 purge Methods 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 239000010915 discarded equipment Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 239000002699 waste material Substances 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a method for clearing operation history data of movable ring equipment of a machine room, which relates to the field of computer data processing, wherein the method comprises the following steps: when the dynamic ring system is deployed, data acquisition is carried out on equipment to be accessed in advance; step two, data validity analysis: after analyzing the data, classifying the data into valid data and invalid data; step three, deleting data: deleting the effective data and the ineffective data according to rules respectively; in the data validity analysis, key parameters of data are detected at a certain frequency, and then through conversion and rendering, the effective data and the ineffective data are judged by comparing historical data after calculation by adopting a corresponding tool. The technical problem that the memory ratio of the database is overlarge is effectively solved, the database is further prevented from storing data endlessly, the memory ratio of the database is limited, the operation load of the moving ring host is reduced, and the storage capacity of the moving ring host is increased.
Description
Technical Field
The application relates to the field of computer data processing, in particular to a method for clearing operation history data of movable ring equipment of a machine room.
Background
The machine room movable ring monitoring system is also called a dynamic environment monitoring system, is called a movable ring for short, has indispensable importance to the machine room, is convenient for enterprise management, saves manpower and material resources, provides greater profit for enterprises, and ensures standardized management of the machine room. In order to ensure the orderly operation of the machine room, a company is usually provided with a machine room movable ring monitoring system to monitor equipment such as hardware such as a server in the machine room, so that potential safety hazards are eliminated, loss is avoided, and the whole unit is ensured to normally operate for 24 hours, so that the orderly operation of the machine room is ensured.
With the continuous improvement of the information management level of enterprises, many enterprises also establish large and small computer rooms so as to ensure the normal operation of the enterprises. Because the monitoring projects will be different from machine room to machine room, users prefer to use flexible, stable, low-cost and simple-to-operate monitoring systems.
However, in the implementation process of the technical scheme, at least the following technical problems are found:
1. the data of the current machine room dynamic ring system is stored, the data of the database is not processed in detail, the data of the database is increased continuously, useless data is not processed correspondingly, the load of a host is increased, and when the duty ratio exceeds a pole, memory leakage can occur, the host is paralyzed, and the system is crashed;
2. the machine room moving ring system is provided with a small part for cleaning data, cleaning is carried out according to a time sequence, and the load reduction of a host is realized, but for some important data, the data is not judged, the deleted data can be deleted as long as the data is out of date, the restoration operation can not be carried out, once the deleted data is permanently lost, the management of the equipment by an administrator and the tracing of the historical data of the equipment are not easy, and therefore, the method for cleaning the operation historical data of the machine room moving ring equipment is provided.
Disclosure of Invention
(one) solving the technical problems
Aiming at the defects of the prior art, the application provides a method for clearing the operation history data of the movable ring equipment of the machine room, which is used for realizing the optimization of a database, solving the problem of endless increase of a memory and considering the importance of the data, so that the method cannot be limited to screening the data to be deleted according to time, is critical to clearing invalid data and can be used for keeping valid data, not only is the realization of the system function greatly assisted, but also the support of data analysis can be provided for the system, the interference of the invalid data is eliminated, the result is more accurate, and the technical problem in the background technology is solved.
(II) technical scheme
In order to achieve the above purpose, the application is realized by the following technical scheme:
the method for clearing the operation history data of the movable ring equipment of the machine room comprises the following steps of:
step one, data acquisition: when the dynamic ring system is deployed, data acquisition is carried out on equipment to be accessed in advance;
step two, data validity analysis: detecting key parameters of data with a certain frequency, then comparing historical data after conversion and rendering, adopting corresponding tools to calculate, and then comparing to judge effective data and ineffective data, and obtaining the theoretical practical feasibility of the point through testing data effectiveness analysis on a UPS battery, wherein other devices are similar to the UPS battery, operation data can be acquired by the same method, and the fact verification is also feasible through carrying out similar effectiveness analysis on the data of the devices;
step three, deleting data: deleting the effective data and the ineffective data according to rules respectively;
step four, establishing a database: the database comprises a main table and an auxiliary table, wherein the main table is used for storing front-end equipment data, and the auxiliary table is used for storing system automatic deleting data.
Preferably, the method further comprises the step five of caching the database: when deleting data, the deleted data can be stored into the auxiliary table through the background, and an administrator can set time buffering, and if the time is not set, the time buffering is unified into a specific threshold value so as to enable the administrator to recover the data.
Preferably, after checking the corresponding data, the administrator receives the instruction from the rear end, and the deleted data can be restored to the original position, and in the time set by the administrator, if the cache data of the secondary table is greater than the memory threshold set by the secondary table, the short message informs the administrator to manually delete the corresponding data, and if the administrator chooses not to perform the corresponding operation, the earliest data is cleared preferentially.
Preferably, the data validity analysis: taking a UPS battery as an example, the data validity analysis comprises the following specific steps:
s1, for a UPS battery, a dynamic ring system mainly monitors the voltage and the internal resistance of the battery, after the deployment of front-end equipment is finished, data can be displayed on a dynamic ring host, and data acquisition is carried out at a frequency of 2 minutes for a period of 3 days;
s2, the collected data are transmitted to a serial server through a 485 communication protocol, the dynamic ring host computer obtains the data through a network protocol, the data are converted into a plaintext through an electric total protocol of a battery manufacturer, a websocket service is started, and the front end and the rear end are connected in a long way through the websocket to establish a data communication channel;
s3, the data are transferred to the front end through the rear end for display, and the front end refracts the data rendering to the corresponding line graph through the echartists component;
s4, analyzing the data trend of the UPS battery, searching the maximum value and the minimum value in the current line diagram, deleting the maximum value and the minimum value, taking the median of all data as an effective data measurement standard, taking the median size as a node, generating a straight line in the diagram, taking 0.1 as a cell, increasing or reducing one cell according to the straight line, counting the number of the data in the up-down floating unit, taking the average value of the number of all data, removing the data lower than the average value, acquiring the data of the stored cell, and setting the data as the up-down floating value;
s5, analyzing the threshold value and the size according to the data of other batteries of the same model at the same time manually, taking the threshold value with high repetition rate as the range fluctuation of the data in a normal state, and formulating the up-and-down fluctuation amplitude and the numerical value of the voltage and the internal resistance of the battery in the normal operation state so as to prepare for the subsequent data processing, wherein the threshold value is set according to the actual host memory;
s6, obtaining a data fluctuation range in a normal operation state through calculation and analysis, so as to correspondingly analyze operation data of the equipment, wherein when the operation data exceeds a threshold value, the operation data is considered to be abnormal data, the operation data is effective data, and when the operation data does not exceed the threshold value, the operation data is invalid data.
The method for clearing the operation history data of the movable ring equipment of the machine room is characterized by comprising the following steps of: the data deleting flow is as follows:
s1, the rear end logs in a database through ip, port numbers, user names and passwords, and stores all equipment data into a main table by utilizing a database access data instruction row;
s2, before the storage, the rear end carries out validity marking according to the data validity analysis, true is valid data, and false is invalid data;
s3, when the administrator sets the cleaning time, after the cleaning time reaches the set time, the system automatically deletes all data with the data validity of false, and the back end carries out data interaction monitoring through id number binding, and other positions stored by the data are queried, so that other rules related to the data are cleaned;
and S4, simultaneously, after the deletion operation is finished, the rear end applies for checking the memory of the database file to the computer, if the memory is lower than the set memory threshold, the processing is not performed, and if the memory is higher than the set memory threshold, the valid data is screened, the earliest data is deleted preferentially, and the memory is released.
Preferably, in the data validity analysis: according to the data analysis, the running state of the equipment is obtained, in the actual running process, the equipment with longer service life or faults cannot provide normal functions, normal running is difficult to perform, the effectiveness of the discarded equipment is distinguished by combining historical data, so that the equipment is judged to be abnormal or normal, the priority of data storage is higher than that of the data under normal conditions when the equipment is abnormal, the data is classified according to the preparation of early work, the data under the normal running state of the equipment is invalid data, and the data under the abnormal conditions is valid data.
Preferably, in the data validity analysis: and analyzing the data in a certain time period according to the data validity, if the occurrence frequency of the validity data exceeds 70%, determining that the equipment is faulty, and when the database data cleaning work is carried out, preferentially carrying out the processing of invalid data.
Preferably, the establishing a database: the database respectively sets the threshold value of the memory of the main table and the secondary table, so that the condition that the system operation time is too long and the storage occupation of effective data is too large is avoided, and under the early work, the system can already distinguish the validity and invalidity of the data, so that when the main table is created, the key name is set, and the data effective state is added except for time, equipment name, equipment data name and data size.
After checking the corresponding data, the administrator receives an instruction from the rear end, the deleted data can be restored to the original position, and in the time set by the administrator, if the cache data of the auxiliary table is larger than the memory threshold set by the auxiliary table, the short message informs the administrator to manually delete the corresponding data, and if the administrator chooses not to perform the corresponding operation, the earliest data is cleared preferentially.
The method solves the problem that the memory ratio of the database is overlarge, avoids the endless storage of the database, limits the memory ratio of the database, reduces the operation load of the moving ring host, increases the storage capacity of the moving ring host, improves the stability of the system, and avoids the system breakdown caused by memory leakage.
(III) beneficial effects
1. The machine room equipment data is classified, so that the machine room equipment data can be simply divided into effective data and invalid data, the storage of the effective data is ensured as much as possible, the storage of the invalid data is reduced or even avoided, the effective data can be used for various big data analysis in a system, corresponding support is provided for equipment alarm, and the equipment early warning function is realized, so that an administrator is reminded of timely overhauling, the technical problem that the memory ratio of a database is overlarge is effectively solved, the endless storage of the database is avoided, the memory ratio of the database is limited, the operation burden of a movable ring host is reduced, the storage capacity of the movable ring host is increased, the stability of the system is improved, and the system breakdown caused by memory leakage is avoided.
2. The automatic deleting part of the effective data is reserved and traceable after the data analysis is adopted, and an administrator confirmation mode is adopted for important effective data deletion, so that the loss caused by deleting the data simply according to time without backup is effectively solved, the effective data is further reserved, the realization of the system function is greatly facilitated, the support of the data analysis can be provided for the system, the interference of the ineffective data is eliminated, and the result is more accurate.
Drawings
The foregoing description is only an overview of the present application, and is intended to provide a better understanding of the present application, as it is embodied in the following description, with reference to the preferred embodiments of the present application and the accompanying drawings.
FIG. 1 is a diagram of a normal operation of a UPS battery;
FIG. 2 is a flow chart of data validity analysis;
FIG. 3 is a database purge flow chart.
Fig. 1 is a graph with time on the abscissa and partial values of voltage and internal resistance in the normal operation state on the ordinate.
Detailed Description
According to the method for clearing the operation history data of the equipment of the machine room, most of machine room moving ring monitoring does not process the operation data of the equipment stored in the database at present, so that the memory of the database is increased continuously along with the time, the conditions of memory leakage and system breakdown are caused, the classification of the equipment data of the machine room can be simply divided into effective data and ineffective data, the storage of the effective data is ensured as much as possible, the storage of the ineffective data is reduced or even avoided, the effective data can be used for various big data analyses in a system, corresponding support is provided for equipment alarm, the conditions of overlarge memory ratio of the database in a moving ring host are reduced by the technology, the memory allocation of the host is optimized, and the stability and fluency of software are improved.
Example 1
The technical scheme of the embodiment of the application is to solve the problems that the data storage of the current machine room movable ring system adopts a single establishment database main table, key names are set, corresponding values are stored and used for displaying front-end pages, the data cleaning of a rear-end database is not processed in detail, the data of the database is continuously increased, useless data are not processed correspondingly, the load of a host is increased, when the duty ratio exceeds a pole, memory leakage occurs, the host is paralyzed and the system is crashed, and the overall thought is as follows:
aiming at the problems in the prior art, the method for clearing the operation history data of the movable ring equipment of the machine room is mainly used for optimizing the processing data of the movable ring host after the front-end equipment transmits the operation data to the movable ring host, and comprises the following specific steps:
step one, data acquisition: for the purposes, when the dynamic ring system is deployed, data acquisition is performed on equipment to be accessed in advance;
step two, data validity analysis: detecting key parameters of the data with a certain frequency, converting and rendering, comparing historical data after calculation by adopting a corresponding tool to judge effective data and ineffective data,
referring to fig. 1 and 2, the data validity analysis of the UPS battery is shown as follows:
s1, for a UPS battery, a dynamic ring system mainly monitors the voltage and the internal resistance of the battery, after the deployment of front-end equipment is finished, data can be displayed on a dynamic ring host, and data acquisition is carried out at a frequency of 2 minutes for a period of 3 days;
s2, the collected data are transmitted to a serial server through a 485 communication protocol, the dynamic ring host computer obtains the data through a network protocol, the data are converted into a plaintext through an electric total protocol of a battery manufacturer, a websocket service is started, and the front end and the rear end are connected in a long way through the websocket to establish a data communication channel;
s3, the data are transferred to the front end through the rear end for display, and the front end refracts the data rendering to the corresponding line graph through the echarties component, as shown in FIG. 1;
s4, analyzing the data trend of the UPS battery, searching the maximum value and the minimum value in the current line diagram, deleting the maximum value and the minimum value, taking the median of all data as an effective data measurement standard, taking the median size as a node, generating a straight line in the diagram, taking 0.1 as a cell, increasing or reducing one cell according to the straight line, counting the number of the data in the up-down floating unit, taking the average value of the number of all data, removing the data lower than the average value, acquiring the data of the stored cell, and setting the data as the up-down floating value;
s5, analyzing the threshold value and the size according to the data of other batteries with the same model at the same time manually, taking the threshold value with large repetition rate as the range fluctuation of the data in the normal state, formulating the up-and-down fluctuation amplitude and the numerical value of the voltage and the internal resistance of the battery in the normal operation state, thereby preparing for the subsequent data processing,
s6, obtaining a data fluctuation range in a normal operation state through calculation and analysis, so as to correspondingly analyze operation data of equipment, wherein a threshold value is set according to an actual host memory, a main table is not more than 30% of the host memory, an auxiliary table is more than 80% of the main table, when the data exceeds the threshold value, the main table is regarded as abnormal data, and the data is validity data from the perspective of a user, so that the user can be reminded of paying attention to the operation condition of the equipment, and therefore the equipment needs to be replaced, when the data not exceeding the threshold value is the data in the normal operation state, the influence on actual operation is not great, and the data storage has no excessive significance, so that the main table is invalid data for the user, and the primary aim of invalid overhaul by the user is achieved, wherein the primary aim of valid and invalid analysis of the data is avoided from the perspective of the user;
the validity of the data takes a UPS battery as an example, and the theoretical practical feasibility of the point is obtained through the test of data validity analysis on the UPS battery, and because other devices are similar to the UPS battery, the operation data can be acquired by the same method, and the similar validity analysis is carried out on the data of the devices, so that the fact verification is also feasible.
According to the data analysis, the running state of the equipment is obtained, in the actual running process, the equipment with longer service life or faults cannot provide normal functions, normal running is difficult to perform, the waste equipment data collection eliminated by the projects is combined with historical data to distinguish the effectiveness of the equipment, so that the equipment is judged to be abnormal or normal, when the equipment is abnormal, the priority of data storage is higher than that of the data under normal condition, the data is classified according to the preparation of earlier work, the data under the normal running state of the equipment is invalid data, and the data under abnormal condition is valid data,
analyzing data in a certain time period according to the validity of the data, if the frequency of occurrence of the validity data exceeds 70%, determining that the device is faulty, analyzing the influence of the data on the device after the completion of the work, wherein the method can be used for judging whether the current state of the device is faulty or not, analyzing the abnormal data and judging the change trend of the data before and after the abnormal data, so that an administrator is informed of carrying out device replacement before the device is faulty, and the situation that work is stagnated due to the damage of the device is avoided, and therefore, for the realization of the two purposes, the effective data is saved for a long time and is not deleted, and therefore, when the data of a database is cleaned, the invalid data is processed preferentially;
step three, deleting data: deleting the valid data and the invalid data according to rules,
as shown in fig. 3, the database purge flow is as follows:
s1, the rear end logs in a database through ip, port numbers, user names and passwords, and stores all equipment data into a main table by utilizing a database access data instruction row;
s2, before the storage, the rear end carries out validity marking according to the data validity analysis, true is valid data, and false is invalid data;
s3, when the administrator sets the cleaning time, after the cleaning time reaches the set time, the system automatically deletes all data with the data validity of false, and the back end carries out data interaction monitoring through id number binding, and other positions stored by the data are queried, so that other rules related to the data are cleaned;
and S4, simultaneously, after the deletion operation is finished, the rear end applies for checking the memory of the database file to the computer, if the memory is lower than the set memory threshold, the processing is not performed, and if the memory is higher than the set memory threshold, the valid data is screened, the earliest data is deleted preferentially, and the memory is released.
Step four, establishing a database: the database comprises a main table and an auxiliary table, the main table is used for storing front-end equipment data, the auxiliary table is used for storing system automatic deleting data, and the memory of the main table and the memory of the auxiliary table are set with threshold values, so that the condition that the system operation time is too long and the storage occupation of effective data is too large is avoided.
Under the earlier work, the system can already distinguish the validity and invalidity of the data, so when creating the main table, the key name is set first, and the data valid state is added except for time, equipment name, equipment data name and data size.
The method solves the problem that the memory ratio of the database is overlarge, avoids the endless storage of the database, limits the memory ratio of the database, reduces the operation load of the moving ring host, increases the storage capacity of the moving ring host, improves the stability of the system, and avoids the system breakdown caused by memory leakage.
The machine room moving ring system has small parts for data cleaning, the cleaning time is simply set, the data in the earliest time period is deleted, the effect of timing cleaning is achieved, the purpose of reducing load of a host is realized, some important data are not judged, only the data are out of date, the data are deleted, the service life loss of machine room equipment is predicted, and the data are deleted and are judged not only in time;
the machine room equipment data can be classified into effective data and invalid data simply, the storage of the effective data is guaranteed as much as possible, the storage of the invalid data is reduced or even avoided, the effective data can be used for various large data analysis in the system, corresponding support is provided for equipment alarm, and the equipment early warning function is realized, so that an administrator is reminded of timely maintenance, more loss of equipment is avoided, and the characteristics of preventing accidents are achieved.
Finally, it should be noted that: the current data can be cleaned by screening the data in the first step, invalid data is selected, namely, the data which normally operates is not stored and only used for displaying, and the database only stores valid data, but the method is extremely unfavorable for the operation state of the subsequent user who wants to pass through the line graph analysis equipment for a certain period of time and has no data support, so that the method is placed in the second step to clean the data most reasonably.
Example 2
Based on embodiment 1, in the embodiment of the application, in order to ensure that deleted data cannot be restored, once deleted, the data is permanently lost, management of an administrator on equipment and tracing of historical data of the equipment are not easy, the form is stable, and the overall thought is as follows:
and step five, caching the database: when deleting data, the deleted data can be stored into the auxiliary table through the background, and an administrator can set time buffering, if the time is not set to be uniform for 10 days, the administrator can restore the data.
After checking the corresponding data, the administrator receives an instruction from the rear end, the deleted data can be restored to the original position, and in the time set by the administrator, if the cache data of the auxiliary table is larger than the memory threshold set by the auxiliary table, the short message informs the administrator to manually delete the corresponding data, and if the administrator chooses not to perform the corresponding operation, the earliest data is cleared preferentially.
For the self-deleted data of the system, a traceable and restored backup function is provided, so that the database is prevented from permanently deleting the data under the condition that an administrator forgets or misoperates.
Finally, it should be noted that: the data cleaning is not only used for realizing the optimization of the database and solving the problem of the endless increase of the memory, but also used for considering the importance of the data, so that the data to be deleted cannot be screened according to time, the cleaning of invalid data is critical, the effective data is reserved, the realization of the system function is greatly facilitated, the support of data analysis can be provided for the system, the interference of the invalid data is eliminated, and the result is more accurate.
It is apparent that the above examples are only illustrative of the present application and are not limiting of the embodiments. Other variations or modifications of the above teachings will be apparent to those of ordinary skill in the art. It is not necessary here nor is it exhaustive of all embodiments. And obvious variations or modifications thereof are contemplated as falling within the scope of the present application.
Claims (7)
1. The method for clearing the operation history data of the movable ring equipment of the machine room is characterized by comprising the following steps of:
step one, data acquisition: when the dynamic ring system is deployed, data acquisition is carried out on equipment to be accessed in advance;
step two, data validity analysis: after analyzing the data, classifying the data into valid data and invalid data;
step three, deleting data: deleting the effective data and the ineffective data according to rules respectively;
in the data validity analysis, key parameters of data are detected with a certain frequency, then through conversion and rendering, effective data and ineffective data are judged by comparing historical data after corresponding tool calculation, then in the data deletion rule, ineffective data are automatically deleted, and the effective data are deleted according to the time sequence according to the internal memory condition of a computer, wherein the data validity analysis comprises the following specific steps:
s1, for a UPS battery, a dynamic ring system mainly monitors the voltage and the internal resistance of the battery, after the deployment of front-end equipment is finished, data can be displayed on a dynamic ring host, and data acquisition is carried out at a frequency of 2 minutes for a period of 3 days;
s2, the collected data are transmitted to a serial server through a 485 communication protocol, the dynamic ring host computer obtains the data through a network protocol, the data are converted into a plaintext through an electric total protocol of a battery manufacturer, a websocket service is started, and the front end and the rear end are connected in a long way through the websocket to establish a data communication channel;
s3, the data are transferred to the front end through the rear end for display, and the front end refracts the data rendering to the corresponding line graph through the echartists component;
s4, analyzing the data trend of the UPS battery, searching the maximum value and the minimum value in the current line diagram, deleting the maximum value and the minimum value, taking the median of all data as an effective data measurement standard, taking the median size as a node, generating a straight line in the diagram, taking 0.1 as a cell, increasing or reducing one cell according to the straight line, counting the number of the data in the up-down floating unit, taking the average value of the number of all data, removing the data lower than the average value, acquiring the data of the stored cell, and setting the data as the up-down floating value;
s5, analyzing the threshold value and the size according to the data of other batteries of the same model at the same time manually, taking the threshold value with high repetition rate as the range fluctuation of the data in a normal state, and formulating the up-and-down fluctuation amplitude and the numerical value of the voltage and the internal resistance of the battery in the normal operation state so as to prepare for the subsequent data processing, wherein the threshold value is set according to the actual host memory;
s6, obtaining a data fluctuation range in a normal operation state through calculation and analysis, so as to correspondingly analyze operation data of the equipment, wherein when the operation data exceeds a threshold value, the operation data is considered to be abnormal data, the operation data is effective data, and when the operation data does not exceed the threshold value, the operation data is invalid data.
2. The method for clearing the operation history data of the movable ring equipment of the machine room as claimed in claim 1, wherein the method comprises the following steps: the method also comprises the step four of establishing a database: the data before deletion is classified through a database so as to be convenient to preserve, the database comprises a main table and an auxiliary table, the main table is used for storing front-end equipment data, and the auxiliary table is used for storing system automatic deleting data;
step five, caching a database: when deleting data, the deleted data can be stored into the auxiliary table through the background, and an administrator can set time buffering, and if the time is not set, the time buffering is unified into a specific threshold value so as to enable the administrator to recover the data.
3. The method for clearing the operation history data of the machine room moving ring device according to claim 2, wherein the method comprises the following steps: after checking the corresponding data, the administrator receives an instruction from the rear end, the deleted data can be restored to the original position, and in the time set by the administrator, if the cache data of the auxiliary table is larger than the memory threshold set by the auxiliary table, the short message informs the administrator to manually delete the corresponding data, and if the administrator chooses not to perform the corresponding operation, the earliest data is cleared preferentially.
4. The method for clearing the operation history data of the machine room moving ring device according to claim 2, wherein the method comprises the following steps: the data deleting flow is as follows:
s1, the rear end logs in a database through ip, port numbers, user names and passwords, and stores all equipment data into a main table by utilizing a database access data instruction row;
s2, before the storage, the rear end carries out validity marking according to the data validity analysis, true is valid data, and false is invalid data;
s3, when the administrator sets the cleaning time, after the cleaning time reaches the set time, the system automatically deletes all data with the data validity of false, and the back end carries out data interaction monitoring through id number binding, and other positions stored by the data are queried, so that other rules related to the data are cleaned;
and S4, simultaneously, after the deletion operation is finished, the rear end applies for checking the memory of the database file to the computer, if the memory is lower than the set memory threshold, the processing is not performed, and if the memory is higher than the set memory threshold, the valid data is screened, the earliest data is deleted preferentially, and the memory is released.
5. The method for clearing the operation history data of the machine room moving ring device according to claim 2, wherein the method comprises the following steps: in the data validity analysis: and analyzing the data in a certain time period according to the data validity, if the occurrence frequency of the validity data exceeds 70%, determining that the equipment is faulty, and when the database data cleaning work is carried out, preferentially carrying out the processing of invalid data.
6. The method for clearing the operation history data of the machine room moving ring device according to claim 5, wherein the method comprises the following steps: in the data validity analysis: according to the data analysis, the running state of the equipment is obtained, in the actual running process, the equipment with longer service life or faults cannot provide normal functions, the old equipment data acquisition is combined with the historical data to distinguish the validity of the equipment, so that the equipment is judged to be abnormal or normal, when the equipment is abnormal, the priority of data storage is higher than that of the data under the normal condition, the data is classified according to the preparation of early work, the data under the normal running state of the equipment is invalid data, and the data under the abnormal condition is valid data.
7. The method for clearing the operation history data of the machine room moving ring device according to claim 6, wherein the method comprises the following steps: the establishment database: the database respectively sets the threshold value of the memory of the main table and the secondary table, so that the condition that the system operation time is too long and the storage occupation of effective data is too large is avoided, and under the early work, the system can already distinguish the validity and invalidity of the data, so that when the main table is created, the key name is set, and the data effective state is added except for time, equipment name, equipment data name and data size.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310920050.0A CN116627959B (en) | 2023-07-26 | 2023-07-26 | Method for clearing operation history data of movable ring equipment of machine room |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310920050.0A CN116627959B (en) | 2023-07-26 | 2023-07-26 | Method for clearing operation history data of movable ring equipment of machine room |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116627959A CN116627959A (en) | 2023-08-22 |
| CN116627959B true CN116627959B (en) | 2023-10-13 |
Family
ID=87613913
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310920050.0A Active CN116627959B (en) | 2023-07-26 | 2023-07-26 | Method for clearing operation history data of movable ring equipment of machine room |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116627959B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108416069A (en) * | 2018-05-10 | 2018-08-17 | 湖南利能新能源有限公司 | A kind of data acquisition device and method |
| CN112433993A (en) * | 2020-11-16 | 2021-03-02 | 连邦网络科技服务南通有限公司 | Network data processing and analyzing system based on computer |
| CN114116685A (en) * | 2020-08-25 | 2022-03-01 | 福建天泉教育科技有限公司 | Method and terminal for cleaning historical data in unstructured database |
| CN114154035A (en) * | 2021-11-05 | 2022-03-08 | 北京银盾泰安网络科技有限公司 | Data processing system for dynamic loop monitoring |
| CN114489673A (en) * | 2022-01-28 | 2022-05-13 | 中国工商银行股份有限公司 | Method and device for deleting invalid codes in application program |
| CN114741455A (en) * | 2022-04-02 | 2022-07-12 | 合肥康尔信电力系统有限公司 | Noise reduction method for medium-voltage uninterruptible power supply |
| CN114996525A (en) * | 2022-06-08 | 2022-09-02 | 蒋家红 | Big data analysis method and system |
| CN115062061A (en) * | 2022-06-27 | 2022-09-16 | 艾象科技(深圳)股份有限公司 | Commodity ERP management system and ERP management method |
| CN115185938A (en) * | 2022-07-28 | 2022-10-14 | 宋赳锋 | Photoelectric detection data analysis method, device and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11886424B2 (en) * | 2021-09-22 | 2024-01-30 | Sap Se | System versioned table with transactional system time |
-
2023
- 2023-07-26 CN CN202310920050.0A patent/CN116627959B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108416069A (en) * | 2018-05-10 | 2018-08-17 | 湖南利能新能源有限公司 | A kind of data acquisition device and method |
| CN114116685A (en) * | 2020-08-25 | 2022-03-01 | 福建天泉教育科技有限公司 | Method and terminal for cleaning historical data in unstructured database |
| CN112433993A (en) * | 2020-11-16 | 2021-03-02 | 连邦网络科技服务南通有限公司 | Network data processing and analyzing system based on computer |
| CN114154035A (en) * | 2021-11-05 | 2022-03-08 | 北京银盾泰安网络科技有限公司 | Data processing system for dynamic loop monitoring |
| CN114489673A (en) * | 2022-01-28 | 2022-05-13 | 中国工商银行股份有限公司 | Method and device for deleting invalid codes in application program |
| CN114741455A (en) * | 2022-04-02 | 2022-07-12 | 合肥康尔信电力系统有限公司 | Noise reduction method for medium-voltage uninterruptible power supply |
| CN114996525A (en) * | 2022-06-08 | 2022-09-02 | 蒋家红 | Big data analysis method and system |
| CN115062061A (en) * | 2022-06-27 | 2022-09-16 | 艾象科技(深圳)股份有限公司 | Commodity ERP management system and ERP management method |
| CN115185938A (en) * | 2022-07-28 | 2022-10-14 | 宋赳锋 | Photoelectric detection data analysis method, device and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| ADS-B历史飞行轨迹数据清洗方法;王兵;;交通运输工程学报(第04期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116627959A (en) | 2023-08-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109660380A (en) | Monitoring method, platform, system and the readable storage medium storing program for executing of operation condition of server | |
| CN107947998B (en) | Real-time monitoring system based on application system | |
| GB2418799A (en) | Managing network slowdown by identifying a hop along a path which exceeds a hop limit within the path. | |
| CN114124655B (en) | Network monitoring method, system, device, computer equipment and storage medium | |
| CN113573352B (en) | Method for realizing real-time reporting of CPE fault alarm of 5G equipment based on SLA | |
| CN104503894A (en) | distributed server state real-time monitoring system and method | |
| CN108345527A (en) | A kind of interface enters the analysis monitoring method and system of ginseng | |
| CN110929896A (en) | Security analysis method and device for system equipment | |
| CN107180267B (en) | Familial defect diagnosis method of secondary operation and maintenance management system | |
| CN113448805A (en) | Monitoring method, device and equipment based on CPU dynamic threshold and storage medium | |
| CN114513400B (en) | Log aggregation system and method for improving usability of log aggregation system | |
| CN116627959B (en) | Method for clearing operation history data of movable ring equipment of machine room | |
| CN107968727A (en) | A kind of detection method, device and the medium of CIFS services | |
| CN107342880B (en) | Abnormal information acquisition method and system | |
| CN111124859A (en) | Log processing method, device, equipment and storage medium | |
| CN111221890A (en) | Automatic monitoring and early warning method and device for general indexes | |
| CN101997730A (en) | Method and system for warning service triggering | |
| CN113037549A (en) | Operation and maintenance environment warning method | |
| CN113626236B (en) | Fault diagnosis method, device, equipment and medium for distributed file system | |
| CN115801618A (en) | Method, device, platform, equipment and medium for testing stability of microservice application | |
| CN115174350A (en) | Operation and maintenance warning method, device, equipment and medium | |
| CN113886378A (en) | Big data management system | |
| CN109471775B (en) | Method, device and equipment for detecting shutdown failure and readable storage medium | |
| CN113610830A (en) | Detection system and method for lightning arrester | |
| CN112288403A (en) | Method and system for accurately pushing power failure information to user, electronic equipment and storage medium |
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 |