CN112732794A - Long-time-period data curve display method, device, equipment and medium - Google Patents
Long-time-period data curve display method, device, equipment and medium Download PDFInfo
- Publication number
- CN112732794A CN112732794A CN202110068519.3A CN202110068519A CN112732794A CN 112732794 A CN112732794 A CN 112732794A CN 202110068519 A CN202110068519 A CN 202110068519A CN 112732794 A CN112732794 A CN 112732794A
- Authority
- CN
- China
- Prior art keywords
- data
- curve
- maximum
- time period
- value
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 238000012952 Resampling Methods 0.000 claims abstract description 63
- 238000012544 monitoring process Methods 0.000 claims abstract description 20
- 238000004364 calculation method Methods 0.000 claims abstract description 16
- 239000003245 coal Substances 0.000 claims abstract description 15
- 238000012545 processing Methods 0.000 claims abstract description 14
- 230000006870 function Effects 0.000 claims description 9
- 238000004590 computer program Methods 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 6
- 238000002372 labelling Methods 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 2
- VNWKTOKETHGBQD-UHFFFAOYSA-N methane Chemical compound C VNWKTOKETHGBQD-UHFFFAOYSA-N 0.000 description 20
- RAHZWNYVWXNFOC-UHFFFAOYSA-N Sulphur dioxide Chemical compound O=S=O RAHZWNYVWXNFOC-UHFFFAOYSA-N 0.000 description 10
- QVGXLLKOCUKJST-UHFFFAOYSA-N atomic oxygen Chemical compound [O] QVGXLLKOCUKJST-UHFFFAOYSA-N 0.000 description 6
- 229910052760 oxygen Inorganic materials 0.000 description 6
- 239000001301 oxygen Substances 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 239000007789 gas Substances 0.000 description 5
- CURLTUGMZLYLDI-UHFFFAOYSA-N Carbon dioxide Chemical compound O=C=O CURLTUGMZLYLDI-UHFFFAOYSA-N 0.000 description 4
- 239000003086 colorant Substances 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- UGFAIRIUMAVXCW-UHFFFAOYSA-N Carbon monoxide Chemical compound [O+]#[C-] UGFAIRIUMAVXCW-UHFFFAOYSA-N 0.000 description 2
- RWSOTUBLDIXVET-UHFFFAOYSA-N Dihydrogen sulfide Chemical compound S RWSOTUBLDIXVET-UHFFFAOYSA-N 0.000 description 2
- 229910002092 carbon dioxide Inorganic materials 0.000 description 2
- 239000001569 carbon dioxide Substances 0.000 description 2
- 229910002091 carbon monoxide Inorganic materials 0.000 description 2
- 239000000428 dust Substances 0.000 description 2
- 230000007613 environmental effect Effects 0.000 description 2
- 238000004880 explosion Methods 0.000 description 2
- 229910000037 hydrogen sulfide Inorganic materials 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- MGWGWNFMUOTEHG-UHFFFAOYSA-N 4-(3,5-dimethylphenyl)-1,3-thiazol-2-amine Chemical compound CC1=CC(C)=CC(C=2N=C(N)SC=2)=C1 MGWGWNFMUOTEHG-UHFFFAOYSA-N 0.000 description 1
- 208000005392 Spasm Diseases 0.000 description 1
- NINIDFKCEFEMDL-UHFFFAOYSA-N Sulfur Chemical compound [S] NINIDFKCEFEMDL-UHFFFAOYSA-N 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000002485 combustion reaction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 208000002173 dizziness Diseases 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000007788 liquid Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- JCXJVPUVTGWSNB-UHFFFAOYSA-N nitrogen dioxide Inorganic materials O=[N]=O JCXJVPUVTGWSNB-UHFFFAOYSA-N 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 231100000572 poisoning Toxicity 0.000 description 1
- 230000000607 poisoning effect Effects 0.000 description 1
- 230000001681 protective effect Effects 0.000 description 1
- 231100001229 severe poisoning Toxicity 0.000 description 1
- 239000000779 smoke Substances 0.000 description 1
- 230000002269 spontaneous effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 229910052717 sulfur Inorganic materials 0.000 description 1
- 239000011593 sulfur Substances 0.000 description 1
- 239000002341 toxic gas Substances 0.000 description 1
- 238000009423 ventilation Methods 0.000 description 1
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/02—Agriculture; Fishing; Forestry; Mining
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Animal Husbandry (AREA)
- Economics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Agronomy & Crop Science (AREA)
- Mathematical Physics (AREA)
- Marine Sciences & Fisheries (AREA)
- Mining & Mineral Resources (AREA)
- Fuzzy Systems (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Testing And Monitoring For Control Systems (AREA)
Abstract
The invention discloses a data curve display method for a long time period. The method comprises the steps of firstly, acquiring original data from a coal mine safety monitoring system database according to a specified time period, and determining the quantity of the original data; calculating the maximum data quantity which can be displayed by the curve display interface according to the time period; then comparing the quantity of the original data with the maximum data quantity, and if the quantity of the original data is larger than the maximum data quantity, performing resampling period calculation processing; and finally, counting the maximum value, the minimum value and the average value of the data in each resampling period, wherein the curve display interface acquires the maximum value, the minimum value and the average value in all the resampling periods and respectively draws curves of the maximum value, the minimum value and the average value. By using the invention, the data of any time period and data amount can be rapidly drawn and displayed, and the data trend accuracy can be improved.
Description
Technical Field
The invention relates to the field of data statistics, in particular to a long-time period data curve display method.
Background
The coal mine safety monitoring system is a system which is mainly used for monitoring methane concentration, carbon monoxide concentration, carbon dioxide concentration, oxygen concentration, hydrogen sulfide concentration, mine dust concentration, wind speed, wind pressure, humidity, temperature, feed state, air door state, air duct state, local ventilator on-off, main fan on-off and the like, and realizing functions of methane over-limit acousto-optic alarm, power failure, methane wind power locking control and the like.
In the daily application process of the coal mine safety monitoring system, along with the optimization of the underground network environment and the continuous improvement of the performance of system equipment, the period of data acquisition and uploading of an underground sensor is continuously shortened, and a large amount of original data records can exist in a system database. When raw data in a database is subjected to curve drawing and displaying, sometimes a data curve with a long time span needs to be checked, but the problem that the existing curve drawing and displaying is slow in drawing or cannot completely display the curve is caused by huge raw data quantity.
The existing curve drawing and displaying method has the following defects:
1. the query time span is limited, the curve data of the long time span cannot be checked at one time, and the curve data can be checked for multiple times in a segmented mode.
2. The time range of curve interface display can be only reduced, and the curve data of long time span can be checked by dragging the curve interface left and right, so that the whole data can not be visually displayed at one time.
3. In order to improve the curve drawing efficiency, part of data is discarded during drawing, so that data information cannot be correctly and really reflected.
Disclosure of Invention
In view of the above-mentioned shortcomings of the prior art, the technical problem to be solved by the present invention is to provide a data curve showing method which can draw a data curve quickly and does not lose data characteristics for a long period of time.
In order to solve the technical problems, the invention firstly provides the following technical scheme: a data curve display method for a long time period comprises the following steps:
s101: acquiring original data from the coal mine safety monitoring system database according to a specified time period, and determining the quantity of the original data;
s102: calculating the maximum data quantity which can be displayed by the curve display interface according to the time period;
s103: comparing the quantity of the original data with the maximum data quantity, and if the quantity of the original data is less than or equal to the maximum data quantity, directly drawing a curve of the original data by the curve display interface; if the quantity of the original data is larger than the maximum data quantity, calculating the resampling period;
s104: and counting the maximum value, the minimum value and the average value of the data in each resampling period, acquiring the maximum value, the minimum value and the average value in all the resampling periods by the curve display interface, and respectively drawing curves of the maximum value, the minimum value and the average value.
By adopting the method, the data of any time period and data quantity can be quickly drawn and displayed, and meanwhile, the accuracy of data trend can be improved.
In an embodiment of the present invention, the method further includes step S105: and adjusting the curve display mode according to the functional module of the curve display interface.
By adopting the method, the staff can select the curve display mode according to the demands of the staff, and the display diversity is realized.
In an embodiment of the present invention, the step S102 includes: setting the value of the maximum data quantity within 1 day of the time period as 500 by default, increasing the value of the maximum data quantity by 100 every time the time period T is increased by 1 day, and setting the upper limit value of the maximum data quantity as 1000.
In an embodiment of the invention, the resampling period is a quotient obtained by dividing the time period by the maximum data amount.
By adopting the method, the curve can be completely displayed on the display interface, and the inconvenience that the curve needs to be viewed in a segmented manner is improved.
In an embodiment of the present invention, the step S104 includes: comparing every two original data in each resampling period in a traversing way, and respectively screening out the maximum value and the minimum value of each resampling period; and calculating the average value of all the original data in each resampling period by adopting a weighted average method.
By adopting the method, only one group of maximum value, minimum value and average value is output in each resampling period, namely, each resampling period T1 only contains three data, so that the number of data in the period is greatly reduced, the efficiency of program operation and curve drawing is improved, and the key characteristics of the data are kept.
In an embodiment of the present invention, the step S104 includes: and carrying out interference pseudo data labeling processing in the process of data statistics, and if the value of a certain original data in the resampling period is larger than m times of the average value of all the original data in the resampling period and the duration of the value of the original data is smaller than s seconds, judging that interference pseudo data exists in the resampling period.
By adopting the method, the representativeness of the data curve can be improved, so that the checking of workers is clearer.
In an embodiment of the present invention, the function modules of the curve display interface include a vertical coordinate adjustment module, a co-coordinate display module, a co-screen display module, a curve color selection module, and a curve type selection module.
By adopting the method, diversified selection of the display curve is realized.
In order to solve the above problem, the present invention further provides a data curve display device for a long time period, including:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring original data from a coal mine safety monitoring system database according to a specified time period and determining the quantity of the original data;
the calculation unit is connected with the acquisition unit and is used for calculating the maximum data quantity which can be displayed by the curve display interface according to the time period;
the comparison unit is respectively connected with the acquisition unit and the calculation unit and is used for comparing the quantity of the original data with the maximum data quantity, and if the quantity of the original data is less than or equal to the maximum data quantity, the curve display interface directly draws a curve of the original data; if the quantity of the original data is larger than the maximum data quantity, calculating the resampling period;
and the display unit is connected with the comparison unit and is used for counting the maximum value, the minimum value and the average value of the data in each resampling period, and the curve display interface acquires all the maximum values, the minimum values and the average values in each resampling period and respectively draws curves of the maximum values, the minimum values and the average values.
By adopting the technical scheme, large data volume can be converted into small data volume, and the curve display interface can draw a characteristic curve quickly and completely.
In order to solve the above problem, the present invention also provides an electronic device, including: a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of any of the methods as described above when executing the computer program.
To solve the above problem, the present invention further provides a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of any one of the methods described above.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method for displaying data curves for a long time period according to the present invention;
FIG. 2 is a schematic diagram of a curved display interface according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a data curve display device for a long time period according to the present invention;
fig. 4 is a schematic structural diagram of an electronic device provided in the present invention.
Reference numerals:
the device comprises an acquisition unit 10, a calculation unit 20, a comparison unit 30, a display unit 40 and a function module 401;
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention.
In the description of the present invention, it is to be understood that the terms "central," "longitudinal," "lateral," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," "axial," "radial," "circumferential," and the like are used in the orientations and positional relationships indicated in the drawings for convenience in describing the invention and to simplify the description, and are not intended to indicate or imply that the referenced devices or elements must have a particular orientation, be constructed and operated in a particular orientation, and are therefore not to be considered limiting of the invention. Furthermore, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present invention, "a plurality" means two or more unless otherwise specified.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
As shown in fig. 1, the present invention provides a method for displaying a data curve for a long time period, which can be applied to a coal mine safety monitoring system, and mainly includes the following steps:
s101: and acquiring original data from a coal mine safety monitoring system database according to a specified time period, and determining the quantity of the original data.
It should be noted that, in an embodiment, the specified time period T may be one year or several years, the time unit may be accurate to second, the time range that the worker needs to view may be screened and specified, and the raw data in the corresponding range may be screened according to the specified time period T, so as to obtain the number DataNum of the raw data. The coal mine safety monitoring system can be used for monitoring parameters such as methane concentration, dust concentration, oxygen, carbon monoxide, carbon dioxide, sulfur dioxide, nitrogen dioxide, hydrogen sulfide, temperature and humidity, smoke, air speed, air volume, air door opening and closing, equipment starting and stopping, gas drainage, liquid level and pressure in a mine, monitored data can be stored in a database, but the monitoring system carries out real-time monitoring, so that the quantity of original data can be huge. In one embodiment, the database used by the method is an InfluxDB time sequence database, the type of database supports the functions of quick writing, persistence, multidimensional aggregation query and the like of time sequence data, when a worker needs to check a certain parameter in a certain time period, the method can obtain corresponding original data from the database according to a selected time period,
s102: and calculating the maximum data quantity which can be displayed by the curve display interface according to the time period.
It should be noted that, in an embodiment, the maximum data amount is recorded as ResultNum, the value of ResultNum within 1 day of the time period T is default to be 500, the value of ResultNum is increased by 100 every time the time period T is increased by 1 day, and the upper limit value of ResultNum is set to be 1000, so that the calculation formula of ResultNum can be obtained, that is: ResultNum ═ 500+ (t.days-1) × 100, where t.days is the number of days of the time period T, and when t.days is greater than 6, ResultNum is the upper limit 1000. Since the monitoring system can be connected to a computer screen, which can be used to display a curve, generally, the pixels in the horizontal direction of the computer screen are about 1000, and setting the upper limit of the maximum data amount to 1000 can make the curve displayed completely.
S103: comparing the quantity of the original data with the maximum data quantity, and if the quantity of the original data is less than or equal to the maximum data quantity, directly drawing a curve of the original data by a curve display interface; and if the quantity of the original data is larger than the maximum data quantity, performing resampling period calculation processing.
It should be noted that, in an embodiment, when the amount of raw data of the selected time period T is small and does not exceed the maximum data amount that can be displayed by the curve display interface, the curve display interface may directly plot the curve of the raw data. When the selected time period T is long and the amount of the raw data is large, the curve display interface cannot directly draw a curve showing the raw data, and only can display a part of the curve, so that a complete curve trend cannot be viewed, and at this time, resampling period calculation processing needs to be performed. In one embodiment, the resampling period T1 is defined as the quotient of the time period divided by the maximum data amount, i.e., T1 ═ T/ResultNum. The raw data records searched in the time period T may have millions or more, if the raw data are directly output to the curve display interface for drawing, the raw data cannot be drawn and displayed on one screen, and the drawing efficiency is very low. According to the method, the time period T is divided into a plurality of limited resampling periods T1, and original data in each resampling period T1 are re-counted, so that the program operation efficiency can be improved, and key data features can be guaranteed not to be lost.
S104: and counting the maximum value, the minimum value and the average value of the data in each resampling period, acquiring the maximum value, the minimum value and the average value in all the resampling periods by the curve display interface, and respectively drawing curves of the maximum value, the minimum value and the average value.
It should be noted that, in an embodiment, no matter how many original data are in each resampling period T1, only one set of maximum value, minimum value, and average value is finally output in each resampling period T1, that is, each resampling period T1 only includes three data, so that the number of data in a period is greatly reduced, and the program operation efficiency is improved. The time period T is divided into a plurality of new time periods at equal intervals according to the resampling period T1, for example, 0-T1, T1-T2, T2-T3 and the like, all original data in each resampling period T1 are traversed, two-by-two comparison is carried out, and the maximum value and the minimum value of each resampling period T1 are respectively screened out. The weighted average method is adopted to calculate the average value of the original data in each resampling period T1, the method adopts the weighted average method to calculate the average value, the influence factors of the original data and time can be simultaneously considered, and the method is more in line with the practical application requirements of the coal mine safety monitoring system. For example, there are 5 raw data in a certain resampling period: (t1, v1), (t2, v2), (t3, v3), (t4, v4), (t5, v5), where t is time and v is the value of the original data point, the average value can be calculated by the formula (v1 × (t2-t1) + v2 × (t3-t2) + v3 × (t4-t3) + v4 × (t5-t4))/(t5-t 1). Further, the method can also perform interference pseudo data labeling processing, in the process of data statistics, an average value SampleAvg of all original data in each resampling period is obtained through calculation, if a value Vn of certain original data in the resampling period is greater than SampleAvg x m, and the duration time of the original data value Vn is less than s seconds, it is determined that interference pseudo data exists in the resampling period, wherein m is default to 3, and s is default to 10, but not limited thereto, adjustment can be performed according to different situations in the using process, and finally the interference pseudo data can be labeled in a shadow mode in the curve drawing process, so that the data curve is more representative.
It should be noted that, in an embodiment, the curve display interface may obtain the maximum value, the minimum value, and the average value in all resampling periods, and respectively draw curves of the maximum value, the minimum value, and the average value, and different types of curves may be displayed in different colors, so as to be convenient for a worker to view. In the method, the maximum value, the minimum value and the average value obtained through statistics are stored in the memory, and when a worker selects to check a certain curve or certain curves, the curve display interface is drawn uniformly, so that the curve needing to be checked can be presented quickly. In one embodiment, the method selects the maximum value, the minimum value and the average value as the data characteristic values, and can basically cover the characteristic trends of all parameters monitored by the safety monitoring system. For example, the monitoring trend of the methane concentration is checked, the explosion concentration of methane is 3% -16%, and in a mine, if the monitored methane concentration exceeds 1%, power-off processing is carried out to prevent explosion, so that when the methane concentration curve is displayed, the change of the methane concentration in a time period can be more clearly known by checking the characteristic curve of the maximum value of the methane concentration curve, and workers can conveniently know the environmental condition in the mine. For example, in a mine, oxygen is very important for workers to see the concentration of oxygen, and if the concentration of oxygen is too low, the life safety of workers is seriously affected, so that the minimum value curve is very important in displaying the oxygen concentration curve. For example, the monitored concentration of sulfur dioxide gas is checked, the sulfur dioxide gas is from oxidized spontaneous combustion of sulfur-containing coal and the like, and is a highly toxic gas, when the concentration of the sulfur dioxide gas reaches 0.0001%, pungent odor can be smelled, when the concentration reaches 0.001%, mild poisoning and dizziness can be caused, and when the concentration reaches 0.05% -0.1%, severe poisoning, spasm or death can be caused, so when a curve of the concentration of the sulfur dioxide gas is displayed, the change in a period can be checked simultaneously by combining the characteristic curves of the maximum value and the minimum value, workers can know the environmental condition under a mine in advance, and protective measures can be made in advance. For example, if a downhole wind speed data curve is checked, the average trend of the downhole wind speed data can be known by displaying the average value curve, and whether the overall downhole ventilation condition is good or not can be estimated. When different parameter curves are checked, different characteristic value curves can be selected or different characteristic value curves can be combined, so that workers can know the change of the parameters more intuitively. By adopting the method of calculating the resampling period, the data volume output to the curve display interface can be effectively reduced, no matter how long the time period T is inquired and how many data Num are original data, the data volume output to the curve display interface is greatly reduced after the processing according to the steps of the method, meanwhile, the drawing speed of the curve is not influenced by the time period T and the original data number data Num, the curve drawing efficiency is improved, and the effect of quick drawing is realized. The average trend of the data can be seen through the average value curve, the range trend of the data can be seen through the maximum value curve and the minimum value curve, the overall trend accuracy of the data can be accurately reflected through comprehensive display of the three curves, and different business analysis requirements of various underground sensor data are met to the greatest extent.
As shown in fig. 2, in an embodiment, taking temperature data of a central substation under a coal mine as an example, the specified time period T is one year, for example, from 0 minute 0 second at 1 month and 1 day 0 of 2020 to 0 minute 0 second at 1 month and 1 day 0 of 2021 year, the number of raw data is 3015345, the time period T already exceeds 6 days, that is, the maximum data quantity that can be displayed by the curve interface is 1000, the raw data quantity far exceeds the maximum data quantity that can be displayed by the curve display interface, at this time, the resampling period is calculated as T1 ═ T/1000 ═ 31536 seconds, the final data quantity output to the curve display interface after statistical processing according to the resampling period is 1000 groups, each group includes a maximum value, a minimum value, and an average value, and the curve drawing time consumption of the curve display interface only needs about 2 seconds. For example, in fig. 2, curve a represents a maximum value curve, curve B represents a minimum value curve, curve C represents an average value curve, and a curve display interface is displayed by the maximum value curve and the minimum value curve together, so that the trend of extreme value temperature data at two ends of the downhole temperature sensor can be seen.
As shown in fig. 1, the method for displaying a data curve of a long time period provided by the present invention further includes:
s105: and adjusting the curve display mode according to the functional module of the curve display interface.
It should be noted that, in an embodiment, the function modules of the curve display interface include a vertical coordinate adjustment module, a co-coordinate display module, a co-screen display module, a curve color selection module, and a curve type selection module. For example, the vertical coordinate adjusting module can automatically or manually adjust the display range of the vertical coordinate, so that the curve can be displayed more clearly on the curve display interface, and the change trend can be more intuitively known by the staff. For example, the co-coordinate display module and the co-screen display module can allow the staff to freely select whether a plurality of curves are displayed in one coordinate or in different coordinates of the same screen, so that the staff can compare the curves conveniently. For example, the curve color selection module can display different curves through different colors, so that the display is clearer and more intuitive and is easy to distinguish. For example, the curve type selection module may select the maximum value curve, the minimum value curve and the average value curve to be displayed individually or in combination.
Corresponding to the foregoing embodiment, the present invention further provides a data curve display device for a long time period.
As shown in fig. 3, a data curve demonstration apparatus for a long time period includes: the device comprises an acquisition unit 10, a calculation unit 20, a comparison unit 30 and a display unit 40, wherein the comparison unit 30 is respectively connected with the acquisition unit 10 and the calculation unit 20, and the display unit 40 is connected with the comparison unit 30. The obtaining unit 10 may be configured to obtain raw data from a database of the coal mine safety monitoring system according to a specified time period T, and determine the amount of the raw data. The calculation unit 20 may be configured to calculate the maximum amount of data that can be presented by the curve presentation interface according to the time period. The comparing unit 30 may be configured to compare the amount of the raw data with the maximum amount of the raw data, and if the amount of the raw data is less than or equal to the maximum amount of the raw data, the curve display interface directly draws a curve of the raw data; and if the quantity of the original data is larger than the maximum data quantity, performing resampling period calculation processing. The display unit 40 may be configured to count the maximum value, the minimum value, and the average value of the data in each resampling period, and the curve display interface obtains the maximum value, the minimum value, and the average value in all resampling periods and respectively draws curves of the maximum value, the minimum value, and the average value.
In an embodiment, the time period T specified by the obtaining unit 10 may be one year or several years, the time unit may be accurate to second, the raw data in the corresponding range may be screened out according to the time range that the worker needs to check, and the number DataNum of the raw data may be obtained according to the specified time period T.
In an embodiment, the calculation unit 20 may calculate the maximum data amount that can be displayed by the curve display interface according to the time period calculation by using a formula ResultNum ═ 500+ (t.days-1) × 100, where t.days is the number of days of the time period T, and when t.days is greater than 6, ResultNum is an upper limit value of 1000.
In one embodiment, the resampling period T1 in the comparing unit 30 is defined as a quotient obtained by dividing the time period by the maximum data amount, i.e. T1 ═ T/ResultNum. No matter the number of the original data in each resampling period T1, only one set of maximum value, minimum value and average value is finally output in each resampling period T1, that is, each resampling period T1 only contains three data, so that the number of data in the period is greatly reduced, and the program operation efficiency is improved.
In an embodiment, the display unit 40 may further include a function module 401, and the function module 401 includes a vertical coordinate adjustment module, a co-coordinate display module, a co-screen display module, a curve color selection module, and a curve type selection module. For example, the vertical coordinate adjusting module can automatically or manually adjust the display range of the vertical coordinate, so that the curve can be displayed more clearly on the curve display interface, and the change trend can be more intuitively known by the staff. For example, the co-coordinate display module and the co-screen display module can allow the staff to freely select whether a plurality of curves are displayed in one coordinate or in different coordinates of the same screen, so that the staff can compare the curves conveniently. For example, the curve color selection module can display different curves through different colors, so that the display is clearer and more intuitive and is easy to distinguish. For example, the curve type selection module may select the maximum value curve, the minimum value curve and the average value curve to be displayed individually or in combination.
As shown in fig. 4, the present invention further provides an electronic device 500, which includes a memory 501 and a processor 502, wherein the memory 501 is connected to the processor 502, and the processor 502 is configured to control the overall operation of the electronic device 500, so as to complete all or part of the steps in the data curve demonstration method for a long time period. The Memory 501 is used for storing various types of data to support operations in the electronic device 500, and the Memory 501 may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as a Static Random Access Memory (SRAM), an Electrically Erasable Programmable Read-Only Memory (EEPROM), an Erasable Programmable Read-Only Memory (EPROM), a Programmable Read-Only Memory (PROM-ROM), a Read-Only Memory (ROM), a magnetic Memory, a flash Memory, a magnetic disk or an optical disk.
In an embodiment, the electronic Device 500 may be implemented by one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors or other electronic components, and is configured to perform the data curve display method for a long period of time.
In another embodiment, a computer readable storage medium comprising program instructions which, when executed by a processor, implement the steps of the above-described method for data curve representation for long time periods is also provided. For example, the computer readable storage medium may be the memory 501 comprising program instructions executable by the processor 502 of the electronic device 500 to perform the long time period data curve presentation method described above.
For a description of a relevant part in the long-time period data curve display device, the electronic device, and the computer readable storage medium provided in the embodiments of the present invention, reference is made to detailed descriptions of a corresponding part in the long-time period data curve display method provided in the embodiments of the present invention, and details are not repeated here.
In summary, the present invention provides a method for displaying a data curve in a long time period, which includes first obtaining raw data according to a selected time period, calculating a maximum data amount, then performing resampling period calculation on the time period, dividing the time period into a limited number of resampling periods, counting a maximum value, a minimum value and an average value of the raw data in each resampling period, storing the maximum value, the minimum value and the average value in a memory, and finally, quickly drawing a curve through a curve display interface. According to the method, for data of any time period and any data volume, the data trend accuracy is guaranteed, meanwhile, the data curve is drawn and displayed rapidly through the small data volume, and the curve drawing efficiency is improved.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an illustrative embodiment," "an example," "a specific example," or "some examples" or the like mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
While embodiments of the invention have been shown and described, it will be understood by those of ordinary skill in the art that: various changes, modifications, substitutions and alterations can be made to the embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the claims and their equivalents.
Claims (10)
1. A long-time period data curve display method is applied to a coal mine safety monitoring system and is characterized by comprising the following steps:
s101: acquiring original data from the coal mine safety monitoring system database according to a specified time period, and determining the quantity of the original data;
s102: calculating the maximum data quantity which can be displayed by the curve display interface according to the time period;
s103: comparing the quantity of the original data with the maximum data quantity, and if the quantity of the original data is less than or equal to the maximum data quantity, directly drawing a curve of the original data by the curve display interface; if the quantity of the original data is larger than the maximum data quantity, calculating the resampling period;
s104: and counting the maximum value, the minimum value and the average value of the data in each resampling period, acquiring the maximum value, the minimum value and the average value in all the resampling periods by the curve display interface, and respectively drawing curves of the maximum value, the minimum value and the average value.
2. The method of claim 1, further comprising the steps of:
s105: and adjusting the curve display mode according to the functional module of the curve display interface.
3. The method for displaying data curve of long time period according to claim 1, wherein said step S102 comprises:
setting the value of the maximum data quantity within 1 day of the time period as 500 by default, increasing the value of the maximum data quantity by 100 every time the time period T is increased by 1 day, and setting the upper limit value of the maximum data quantity as 1000.
4. The method of claim 1, wherein the resampling period is a quotient of the time period divided by the maximum data amount.
5. The method for displaying data curve of long time period according to claim 1, wherein said step S104 comprises:
comparing every two original data in each resampling period in a traversing way, and respectively screening out the maximum value and the minimum value of each resampling period; and calculating the average value of all the original data in each resampling period by adopting a weighted average method.
6. The method for displaying data curve of long time period according to claim 5, wherein said step S104 comprises:
and carrying out interference pseudo data labeling processing in the process of data statistics, and if the value of a certain original data in the resampling period is larger than m times of the average value of all the original data in the resampling period and the duration of the value of the original data is smaller than s seconds, judging that interference pseudo data exists in the resampling period.
7. The method for displaying the data curve for the long time period according to claim 2, wherein the function modules of the curve display interface comprise a vertical coordinate adjusting module, an on-screen display module, a curve color selecting module and a curve type selecting module.
8. A long-time period data curve presentation apparatus used in the long-time period data curve presentation method according to any one of claims 1 to 7, comprising:
the system comprises an acquisition unit (10) and a processing unit, wherein the acquisition unit is used for acquiring original data from a coal mine safety monitoring system database according to a specified time period and determining the quantity of the original data;
the calculating unit (20), the calculating unit (20) is connected with the obtaining unit (10) and is used for calculating the maximum data quantity which can be displayed by the curve display interface according to the time period;
the comparison unit (30), the acquisition unit (10) and the calculation unit (20) are respectively connected to the comparison unit (30), and the comparison unit is used for comparing the amount of the original data with the maximum amount of the original data, and if the amount of the original data is less than or equal to the maximum amount of the original data, the curve display interface directly draws a curve of the original data; if the quantity of the original data is larger than the maximum data quantity, calculating the resampling period;
the display unit (40) is connected with the comparison unit (30) and used for counting the maximum value, the minimum value and the average value of the data in each resampling period, the curve display interface obtains all the maximum values, the minimum values and the average values in each resampling period, and curves of the maximum values, the minimum values and the average values are respectively drawn.
9. An electronic device, comprising: a memory (501), a processor (502) and a computer program stored on the memory (501) and executable on the processor (502), when executing the computer program, implementing the steps in the method of any one of claims 1 to 7.
10. 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 of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110068519.3A CN112732794A (en) | 2021-01-19 | 2021-01-19 | Long-time-period data curve display method, device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110068519.3A CN112732794A (en) | 2021-01-19 | 2021-01-19 | Long-time-period data curve display method, device, equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112732794A true CN112732794A (en) | 2021-04-30 |
Family
ID=75592284
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110068519.3A Pending CN112732794A (en) | 2021-01-19 | 2021-01-19 | Long-time-period data curve display method, device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112732794A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115649006A (en) * | 2022-10-27 | 2023-01-31 | 中国第一汽车股份有限公司 | Control system and method of power battery and vehicle |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050179868A1 (en) * | 2004-02-13 | 2005-08-18 | Angstrom Inc. | Three-dimensional display using variable focusing lens |
| US20070073489A1 (en) * | 2005-09-29 | 2007-03-29 | Roche Molecular Systems, Inc. | Systems and methods for determining real-time PCR cycle thresholds using cluster analysis |
| CN101630483A (en) * | 2006-07-27 | 2010-01-20 | 索尼株式会社 | Display device, driving method thereof, and electronic apparatus |
| CN101762732A (en) * | 2009-11-10 | 2010-06-30 | 北京普源精电科技有限公司 | Oscilloscope with automatic measurement function and measurement data storage method thereof |
| CN101982820A (en) * | 2010-11-22 | 2011-03-02 | 北京航空航天大学 | Curve display and inquiry method for large data quantity |
| CN106023280A (en) * | 2016-05-13 | 2016-10-12 | 中国航空工业集团公司西安飞机设计研究所 | Data trend curve diagram drawing method |
| CN110595525A (en) * | 2019-09-03 | 2019-12-20 | 精英数智科技股份有限公司 | Method, device, system and medium for monitoring abnormality of downhole sensor |
| CN111508456A (en) * | 2020-07-01 | 2020-08-07 | 北京美摄网络科技有限公司 | Audio data processing method and device, electronic equipment and storage medium |
-
2021
- 2021-01-19 CN CN202110068519.3A patent/CN112732794A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050179868A1 (en) * | 2004-02-13 | 2005-08-18 | Angstrom Inc. | Three-dimensional display using variable focusing lens |
| US20070073489A1 (en) * | 2005-09-29 | 2007-03-29 | Roche Molecular Systems, Inc. | Systems and methods for determining real-time PCR cycle thresholds using cluster analysis |
| CN101630483A (en) * | 2006-07-27 | 2010-01-20 | 索尼株式会社 | Display device, driving method thereof, and electronic apparatus |
| CN101762732A (en) * | 2009-11-10 | 2010-06-30 | 北京普源精电科技有限公司 | Oscilloscope with automatic measurement function and measurement data storage method thereof |
| CN101982820A (en) * | 2010-11-22 | 2011-03-02 | 北京航空航天大学 | Curve display and inquiry method for large data quantity |
| CN106023280A (en) * | 2016-05-13 | 2016-10-12 | 中国航空工业集团公司西安飞机设计研究所 | Data trend curve diagram drawing method |
| CN110595525A (en) * | 2019-09-03 | 2019-12-20 | 精英数智科技股份有限公司 | Method, device, system and medium for monitoring abnormality of downhole sensor |
| CN111508456A (en) * | 2020-07-01 | 2020-08-07 | 北京美摄网络科技有限公司 | Audio data processing method and device, electronic equipment and storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115649006A (en) * | 2022-10-27 | 2023-01-31 | 中国第一汽车股份有限公司 | Control system and method of power battery and vehicle |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11592428B2 (en) | Evaluation method for impact of emission control on air quality, device and storage medium thereof | |
| US20130069951A1 (en) | System and method for generating, processing and displaying data relating to consumption data with an application | |
| CN106292600A (en) | A kind of many remotely dump pit data acquisitions, record system | |
| CN102968438A (en) | Storage control method of history data in integrated supervisory control system | |
| WO2021042835A1 (en) | Control method and control system capable of precisely calculating service life of filtering screen, and purification apparatus | |
| CN117405177B (en) | Cable tunnel harmful gas leakage early warning method, system, equipment and medium | |
| CN112732794A (en) | Long-time-period data curve display method, device, equipment and medium | |
| CN115017214B (en) | Hydropower station auxiliary equipment operation state analysis early warning method, device and storage medium | |
| CN111879893A (en) | Pollutant monitoring device, monitoring method and management and control method | |
| US20240037831A1 (en) | Datacenter dashboard with temporal features | |
| CN105445579A (en) | Oil-chromatogram on-line monitoring data visualization system of multi-scale time sequence analysis and method thereof | |
| CN113761234A (en) | Method and device for routing inspection of equipment in hydraulic power plant, electronic equipment and storage medium | |
| CN117955245B (en) | Method and device for determining running state of power grid, storage medium and electronic equipment | |
| CN201697870U (en) | Automatic flue gas blackness monitoring and analyzing system | |
| CN116562712B (en) | System and method for predicting air quality | |
| CN112052566A (en) | Intelligent cable analog simulation method and system | |
| CN108052637B (en) | Real-time image-text monitoring method for power grid time scale measurement data access full life cycle | |
| CN113033166B (en) | Electronic report generation method and system based on PI system | |
| CN115993426A (en) | Calibration monitoring method, device, system, equipment and medium | |
| CN112871940B (en) | Paroxysmal non-fixed point source dust control effect monitoring system and method | |
| US20140365149A1 (en) | Visual Analytics of Spatial Time Series Data Using a Pixel Calendar Tree | |
| CN114117316A (en) | Dynamic wind zone drawing method and system based on multiple data sources | |
| CN113297169A (en) | Database instance processing method, system, device and storage medium | |
| CN110633395A (en) | Wisdom garden equipment is patrolled and examined and is reported for repairment visual system | |
| KR20190037973A (en) | Monitoring system of indoor air quality using mobile application |
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 |