Historical data online recalculation method, system, computer and storage medium

Abstract

The present invention provides a method, system, computer, and storage medium for recalculating historical data online. The method includes obtaining a baseline value of the historical data of a device, and determining whether the baseline value is equal to the normal data baseline value in the normal working state of the device; if the baseline value is not equal to the normal data baseline value in the normal working state of the device, obtaining the time period corresponding to the historical data, and inversely calculating the initial value of the historical data according to a corresponding first calculation formula; filling the initial value into an online platform, calculating the true data corresponding to the historical data according to the time period corresponding to the historical data, eliminating external untrue data, and retaining true device data.

Description

Technical Field

[0001] The present invention belongs to the technical field of facility safety monitoring, and particularly relates to a method, system, computer, and storage medium for online recalculation of historical data. Background Art

[0002] The bridge health monitoring system is a complex systematic project that integrates cutting-edge technologies in modern test analysis, computer, mathematical theory, communication, and other fields. The main goal of the health monitoring system is to measure certain information reflecting the environmental excitation and structural response state of the bridge, monitor the working performance of the bridge in real time, and evaluate the working state of the bridge to ensure the safe operation of the bridge. In recent years, with the improvement of the understanding of bridge safety and durability and the continuous emergence of new detection means, monitoring technologies, and information transmission means, the long-term structural monitoring technology has made great progress.

[0003] In bridge monitoring, the data monitored by existing bridge monitoring devices are often easily interfered by internal and external factors. For example, the data displayed after maintenance or after being disturbed or damaged by the outside world are non-genuine abnormal data and invalid data. Summary of the Invention

[0004] To solve the above technical problems, the present invention provides a method, system, computer, and storage medium for online recalculation of historical data, which are used to solve the technical problem that the data displayed by existing bridge monitoring devices after maintenance are non-genuine abnormal data and invalid data.

[0005] On the one hand, the invention provides the following technical solution. A method for online recalculation of historical data, the method includes: obtaining the baseline value of the historical data of the device, and determining whether the baseline value is equal to the normal data baseline value of the device in the normal working state;

[0006] If the baseline value is not equal to the normal data baseline value of the device in the normal working state, obtain the time period corresponding to the historical data, and inversely calculate the initial value of the historical data according to the corresponding first calculation formula;

[0007] Fill the initial value into the online platform, and calculate the real data corresponding to the historical data according to the time period corresponding to the historical data.

[0008] Compared with the prior art, the beneficial effects of the present application are as follows: changing the initial value of the original data of the device on the online platform, and then running this algorithm on the data of the historical time period that needs to be recalculated. The data obtained after running is the monitoring data that truly reflects the device calculated according to the original formula; eliminating external non-genuine data and retaining the real device data; being able to process historical data; being able to be processed through this algorithm online, improving the data processing efficiency.

[0009] Further, the baseline value of the historical data and the baseline value of the normal data are the connecting lines of the data values of the device on the trend chart.

[0010] Further, the step of obtaining the baseline value of the historical data of the device includes:

[0011] Determine whether the device is affected. If the device is affected, obtain the baseline value of the historical data of the device.

[0012] Further, the step of calculating the true data corresponding to the historical data according to the time period corresponding to the historical data includes:

[0013] Obtain a second calculation formula for calculating the historical data, and use the second calculation formula to recalculate the true data of the device for the corresponding time period of the historical data based on the initial value.

[0014] In a second aspect, the present invention provides the following technical solution. The historical data online recalculation system includes:

[0015] A judgment module, configured to obtain the baseline value of the historical data of the device, and judge whether the baseline value is equal to the baseline value of the normal data in the normal working state of the device;

[0016] A calculation module, configured to, if the baseline value is not equal to the baseline value of the normal data in the normal working state of the device, obtain the time period corresponding to the historical data, and inversely calculate the initial value of the historical data according to the corresponding first calculation formula;

[0017] A basis module, configured to fill the initial value into an online platform, and calculate the true data corresponding to the historical data according to the time period corresponding to the historical data.

[0018] 6. The robotic arm joint control system according to claim 5, wherein: the judgment module is specifically configured to:

[0019] Determine whether the device is affected. If the device is affected, obtain the baseline value of the historical data of the device.

[0020] 7. The robotic arm joint control system according to claim 5, wherein: the basis module is specifically configured to:

[0021] Obtain a second calculation formula for calculating the historical data, use the second calculation formula to recalculate the true data of the device for the corresponding time period of the historical data based on the initial value, and replace the historical data with the true data.

[0022] 8. The robotic arm joint control system according to claim 5, wherein: the judgment module is specifically configured to:

[0023] The baseline value of the historical data and the baseline value of the normal data are the connecting lines of the data values of the device on the trend chart.

[0024] In a third aspect, the present invention provides the following technical solution. A computer includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, the method for recalculating on the historical data line as described above is implemented.

[0025] In a fourth aspect, the present invention provides the following technical solution. A storage medium stores a computer program, and when the computer program is executed by a processor, the method for recalculating on the historical data line as described above is implemented. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other drawings can also be obtained based on these drawings.

[0027] Figure 1 It is a flowchart of the method for recalculating on the historical data line provided by the first embodiment of the present invention;

[0028] Figure 2 It is a schematic diagram of the re-timing in the original value state provided by the first embodiment of the present invention;

[0029] Figure 3 It is a historical data trend chart of the re-timing provided by the first embodiment of the present invention;

[0030] Figure 4 It is a schematic diagram of the reverse calculation initial value of the re-timing provided by the first embodiment of the present invention;

[0031] Figure 5 It is a schematic diagram of the calculation interface of the re-timing provided by the first embodiment of the present invention;

[0032] Figure 6 It is a data trend chart after the calculation of the re-timing is completed provided by the first embodiment of the present invention;

[0033] Figure 7 It is a structural block diagram of the system for recalculating on the historical data line provided by the second embodiment of the present invention;

[0034] Figure 8 It is a schematic diagram of the hardware structure of the computer provided by the third embodiment of the present invention.

[0035] The embodiments of the present invention will be further described below in conjunction with the accompanying drawings. Detailed implementation manners

[0036] The embodiments of the present invention will be described in detail below. Examples of the embodiments are shown in the accompanying drawings, where the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to explain the embodiments of the present invention, and should not be construed as limiting the present invention.

[0037] In the description of the embodiments of the present invention, it should be understood that the orientation or positional relationship indicated by the terms "length", "width", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc. is based on the orientation or positional relationship shown in the accompanying drawings, and is only for the convenience of describing the embodiments of the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be construed as limiting the present invention.

[0038] In addition, the terms "first" and "second" are only used for descriptive purposes and should not be construed as indicating or implying relative importance or implicitly indicating the quantity of the indicated technical features. Thus, the features defined with "first" and "second" may explicitly or implicitly include one or more of such features. In the description of the embodiments of the present invention, "plurality" means two or more unless otherwise specifically defined.

[0039] The present invention discloses a method for online recalculation of historical data, mainly to solve the problems of the existing portal system, such as the portal menu bar page being too rigid; the business system application programs that users can operate being too scattered; and the portal page generation and dynamic layout technology being backward. It improves the user's business processing efficiency and enables the user to have the ability to independently design and dynamically configure the page.

[0040] Embodiment 1

[0041] In the first embodiment of the present invention, as Figure 1 shown, a method for online recalculation of historical data includes the following steps S01 to S03:

[0042] S01, obtaining the baseline value of the historical data of the device, and determining whether the baseline value is equal to the normal data baseline value in the normal working state of the device;

[0043] Specifically, the baseline value of the historical data and the normal data baseline value are the connection lines of the data values of the device on the trend graph.

[0044] The step of obtaining the baseline value of the historical data of the device includes:

[0045] Determine whether the device is affected. If the device is affected, obtain the baseline value of the historical data of the device.

[0046] In this embodiment, the normal data fluctuates up and down around a certain value, and there is a normal data baseline x; when the device is repaired, maintained, or affected by external disturbances or damages, the data will jump, and the data baseline will deviate from the normal value baseline. At this time, it is the baseline y, and this baseline y is the situation that does not truly reflect the device.

[0047] S02, if the baseline value is not equal to the normal data baseline value in the normal working state of the device, obtain the time period corresponding to the historical data, and inversely calculate the initial value of the historical data according to the corresponding first calculation formula;

[0048] It should be noted that the inverse calculation of the first calculation formula means re-calculating the historical data according to the original formula, not referring to a specific formula, and reasonable inverse calculation needs to be carried out according to the original formula for calculating the historical data. The innovation of the present invention is that it can re-calculate the historical data according to the original formula.

[0049] S03, fill the initial value into the online platform, and calculate the true data corresponding to the historical data according to the time period corresponding to the historical data

[0050] The step of calculating the true data corresponding to the historical data according to the time period corresponding to the historical data includes:

[0051] Obtain the second calculation formula for calculating the historical data, use the second calculation formula to re-calculate the true data of the device in the corresponding time period of the historical data based on the initial value, and replace the historical data with the true data.

[0052] In specific implementation, take the monitoring items of the expansion joint displacement device 4 of a certain bridge as an example:

[0053] Due to external factors interfering with the expansion joint of this bridge, the measured value drops suddenly below -100 mm. Select the jump time period for re-calculation, and the detailed process is as follows in detail Figure 2 To detailed Figure 6 As shown:

[0054] In summary, the differences and related advantages compared with the prior art are as follows: Change the initial value of the original data of the device on the online platform, and then run this algorithm on the historical time period data that needs to be re-calculated. The data obtained after running is the monitoring data that truly reflects the device calculated according to the original formula; eliminate external non-real data and retain real device data; be able to process historical data; can be processed through this algorithm online, improving data processing efficiency.

[0055] Example 2

[0056] As Figure 7 shown, in the second embodiment of the present invention, a historical data online recalculation system is provided, including: The historical data online recalculation system includes:

[0057] A judgment module 10, configured to obtain a baseline value of the historical data of the device, and judge whether the baseline value is equal to the normal data baseline value in the normal working state of the device;

[0058] A calculation module 20, configured to, if the baseline value is not equal to the normal data baseline value in the normal working state of the device, obtain the time period corresponding to the historical data, and inversely calculate the initial value of the historical data according to the corresponding first calculation formula;

[0059] A basis module 30, configured to fill the initial value into an online platform, and calculate the real data corresponding to the historical data according to the time period corresponding to the historical data.

[0060] Wherein, in the historical data online recalculation system, the judgment module 10 is specifically configured to:

[0061] Judge whether the device is affected. If the device is affected, obtain the baseline value of the historical data of the device.

[0062] Wherein, in the historical data online recalculation system, the basis module 30 is specifically configured to:

[0063] Obtain a second calculation formula for calculating the historical data, use the second calculation formula to recalculate the real data of the device in the time period corresponding to the historical data based on the initial value, and replace the historical data with the real data.

[0064] Wherein, in the historical data online recalculation system, the judgment module is specifically configured to:

[0065] The baseline value of the historical data and the normal data baseline value are the connection lines of the data values of the device on a trend chart.

[0066] The historical data online recalculation system provided by the embodiment of the present invention has the same implementation principle and the same technical effects as those of the foregoing method embodiment. For the sake of brief description, for the parts not mentioned in the system embodiment, reference may be made to the corresponding content in the foregoing method embodiment.

[0067] Example 3

[0068] As Figure 8As shown, in the third embodiment of the present invention, the present invention embodiment provides the following technical solution. A computer includes a memory 202, a processor 201, and a computer program stored on the memory 202 and executable on the processor 201. When the processor 201 executes the computer program, the above-described historical data online recalculation method is implemented.

[0069] Specifically, the above-mentioned processor 201 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured as one or more integrated circuits implementing the embodiments of the present application.

[0070] Among them, the memory 202 may include a mass storage for data or instructions. By way of example and not limitation, the memory 202 may include a hard disk drive (HDD), a floppy disk drive, a solid state drive (SSD), a flash memory, an optical disc, a magneto-optical disc, a magnetic tape, or a universal serial bus (USB) drive, or a combination of two or more of these. In suitable cases, the memory 202 may include removable or non-removable (or fixed) media. In suitable cases, the memory 202 may be internal or external to the data processing device. In a particular embodiment, the memory 202 is a non-volatile memory. In a particular embodiment, the memory 202 includes a read-only memory (ROM) and a random access memory (RAM). In suitable cases, the ROM may be a mask-programmed ROM, a programmable ROM (PROM), an erasable PROM (EPROM), an electrically erasable PROM (EEPROM), an electrically alterable ROM (EAROM), or a flash memory, or a combination of two or more of these. In suitable cases, the RAM may be a static random access memory (SRAM) or a dynamic random access memory (DRAM), where the DRAM may be a fast page mode dynamic random access memory (FPMDRAM), an extended data output dynamic random access memory (EDODRAM), a synchronous dynamic random access memory (SDRAM), etc.

[0071] The memory 202 can be used to store or cache various data files required for processing and / or communication, as well as possible computer program instructions executed by the processor 201.

[0072] The processor 201 reads and executes the computer program instructions stored in the memory 202 to implement the above-mentioned historical data line recalculation method.

[0073] In some of the embodiments, the computer may further include a communication interface 203 and a bus 200. Among them, as Figure 8 shown, the processor 201, the memory 202, and the communication interface 203 are connected through the bus 200 and complete communication with each other.

[0074] The communication interface 203 is used to implement communication between the various modules, devices, units, and / or devices in the embodiments of the present application. The communication interface 203 can also implement data communication with other components, such as external devices, image / data acquisition devices, databases, external storage, and image / data processing workstations, etc.

[0075] The bus 200 includes hardware, software, or both, and couples the components of a computer to each other. The bus 200 includes, but is not limited to, at least one of the following: Data Bus, Address Bus, Control Bus, Expansion Bus, Local Bus. By way of example and not limitation, the bus 200 may include an Accelerated Graphics Port (AGP) or other graphics bus, an Extended Industry Standard Architecture (EISA) bus, a Front Side Bus (FSB), a Hyper Transport (HT) interconnect, an Industry Standard Architecture (ISA) bus, an InfiniBand interconnect, a Low Pin Count (LPC) bus, a memory bus, a Micro Channel Architecture (MCA) bus, a Peripheral Component Interconnect (PCI) bus, a PCI-Express (PCI-X) bus, a Serial Advanced Technology Attachment (SATA) bus, a Video Electronics Standards Association Local Bus (VLB) bus, or other suitable buses or a combination of two or more of these. Where appropriate, the bus 200 may include one or more buses. Although the embodiments of the present application describe and illustrate specific buses, the present application contemplates any suitable bus or interconnect.

[0076] Embodiment Five

[0077] In the fifth embodiment of the present invention, in combination with the above historical data line recalculation method, the embodiments of the present invention provide the following technical solution: a storage medium having a computer program stored thereon, where the computer program, when executed by a processor, implements the above historical data line recalculation method.

[0078] Those skilled in the art will understand that the data representation or the logic and / or steps described in other ways in the flowchart, for example, can be regarded as a sequenced data table of executable instructions for implementing logical functions, and can be specifically implemented in any computer-readable medium for use by an instruction execution system, apparatus, or device (such as a computer-based system, a system including a processor, or other systems that can fetch and execute instructions from the instruction execution system, apparatus, or device), or used in combination with these instruction execution systems, apparatuses, or devices. For the purposes of this specification, a "computer-readable medium" can be any device that can contain, store, communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.

[0079] More specific examples (nonexhaustive list) of the readable medium include the following: an electrical connection part (electronic device) having one or more wirings, a portable computer disk cartridge (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium can even be paper or other suitable media on which the program can be printed, because the program can be obtained electronically, for example, by optically scanning the paper or other media, followed by editing, interpretation, or other appropriate processing as necessary, and then stored in a computer memory.

[0080] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware, or a combination thereof. In the above embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, any one or a combination of the following techniques well known in the art can be used: discrete logic circuits having logic gate circuits for implementing logical functions on data signals, application-specific integrated circuits having appropriate combinational logic gate circuits, programmable gate arrays (PGAs), field-programmable gate arrays (FPGAs), etc.

[0081] The technical features of the above-described embodiments can be combined arbitrarily. For the sake of brevity of description, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, it should be considered to be within the scope described in this specification.

[0082] The above-described embodiments merely represent several implementation manners of the present application. The description thereof is relatively specific and detailed, but it should not be construed as a limitation on the scope of the invention patent. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all fall within the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the appended claims.

Claims

1. A method for online recalculation of historical data, characterized in that, The method includes: Obtaining a baseline value of historical data of the device, and determining whether the baseline value is equal to the normal data baseline value in the normal operating state of the device; If the baseline value is not equal to the normal data baseline value in the normal operating state of the device, obtaining the time period corresponding to the historical data, and inversely calculating the initial value of the historical data according to the corresponding first calculation formula; Filling the initial value into an online platform, and calculating the real data corresponding to the historical data according to the time period corresponding to the historical data.

2. The historical data online recalculation method according to claim 1, wherein The baseline value of the historical data and the normal data baseline value are the connection lines of the data values of the device on a trend chart.

3. The historical data online recalculation method according to claim 1, wherein In the step of obtaining the baseline value of the historical data of the device, it includes: Determining whether the device is affected. If the device is affected, obtaining the baseline value of the historical data of the device.

4. The online recalculation method for historical data according to claim 1, wherein In the step of calculating the real data corresponding to the historical data according to the time period corresponding to the historical data, it includes: Obtaining a second calculation formula for calculating the historical data, and using the second calculation formula to recalculate the real data of the device in the time period corresponding to the historical data based on the initial value.

5. A historical data online recalculation system, characterized in that, The historical data online recalculation system includes: A judgment module, configured to obtain a baseline value of historical data of the device, and determine whether the baseline value is equal to the normal data baseline value in the normal operating state of the device; A calculation module, configured to, if the baseline value is not equal to the normal data baseline value in the normal operating state of the device, obtain the time period corresponding to the historical data, and inversely calculate the initial value of the historical data according to the corresponding first calculation formula; A basis module, configured to fill the initial value into an online platform, and calculate the real data corresponding to the historical data according to the time period corresponding to the historical data.

6. The robotic arm joint control system according to claim 5, wherein: The judgment module is specifically configured to: Determine whether the device is affected. If the device is affected, obtain the baseline value of the historical data of the device.

7. The robotic arm joint control system according to claim 5, wherein: The basis module is specifically configured to: Obtain a second calculation formula for calculating the historical data, use the second calculation formula to recalculate the real data of the device in the time period corresponding to the historical data based on the initial value, and replace the historical data with the real data.

8. The robotic arm joint control system according to claim 5, characterized in that: The judgment module is specifically configured to: The baseline value of the historical data and the normal data baseline value are the connection lines of the data values of the device on a trend chart.

9. A computer, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the historical data online recalculation method according to any one of claims 1 to 4.

10. A storage medium, characterized in that, A computer program is stored on the storage medium, and when the computer program is executed by the processor, it implements the historical data online recalculation method according to any one of claims 1 to 4.

Images