CN112364074B - Time sequence data visualization method, equipment and medium - Google Patents

Time sequence data visualization method, equipment and medium Download PDF

Info

Publication number
CN112364074B
CN112364074B CN202011191995.6A CN202011191995A CN112364074B CN 112364074 B CN112364074 B CN 112364074B CN 202011191995 A CN202011191995 A CN 202011191995A CN 112364074 B CN112364074 B CN 112364074B
Authority
CN
China
Prior art keywords
time sequence
data
equipment
visualization
sequence analysis
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
Application number
CN202011191995.6A
Other languages
Chinese (zh)
Other versions
CN112364074A (en
Inventor
邱云钊
徐同明
王少刚
于兆洋
李伯钊
刘子永
高怀金
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur General Software Co Ltd
Original Assignee
Inspur General Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur General Software Co Ltd filed Critical Inspur General Software Co Ltd
Priority to CN202011191995.6A priority Critical patent/CN112364074B/en
Publication of CN112364074A publication Critical patent/CN112364074A/en
Application granted granted Critical
Publication of CN112364074B publication Critical patent/CN112364074B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2474Sequence data queries, e.g. querying versioned data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The application discloses a time sequence data visualization method, equipment and a medium, which comprise the following steps: the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template; analyzing the equipment time sequence analysis template, determining a time sequence data display component, and converting the time sequence data display component into a corresponding data template structure; acquiring corresponding equipment parameter information in a time sequence database, binding the equipment parameter information to the data template structure, and generating data in a preset format; sending the data in the preset format to time sequence analysis software for generating a visual time sequence analysis interface; and acquiring related time sequence data according to the visual time sequence analysis interface for displaying.

Description

Time sequence data visualization method, equipment and medium
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, and a medium for visualizing time series data.
Background
The time-series data refers to time-series data. The time-series data is a data series in which the uniform index is recorded in time series. The purpose of time series visualization is to analyze and predict time series data by finding out the statistical characteristics and development regularity of the time series in a sample. With the promotion and popularization of industrial internet and intelligent manufacturing, the visual display and analysis of equipment time sequence data becomes an important link for the informatization development of more and more enterprises.
In the prior art, the time sequence data visualization operation is complicated, and the display flexibility and configurability are poor.
Based on this, a scheme capable of more effectively utilizing the traffic resources of the system is required.
Disclosure of Invention
In view of this, embodiments of the present application provide a time series data visualization method, device, and medium, which are used to solve the following technical problems in the prior art: there is a need to be able to more efficiently utilize the traffic resources of the system.
The embodiment of the application adopts the following technical scheme:
the embodiment of the application provides a time series data visualization method, which comprises the following steps:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
An embodiment of the present specification further provides a time series data visualization apparatus, where the apparatus includes:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein, the first and the second end of the pipe are connected with each other,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
Embodiments of the present specification further provide a time series data visualization medium, in which computer-executable instructions are stored, where the computer-executable instructions are configured to:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
The embodiment of the application adopts at least one technical scheme which can achieve the following beneficial effects: the device data are matched with templates in a time sequence analysis template library to determine a corresponding device time sequence analysis template, data in a preset format are generated according to the device time sequence analysis template, and then time sequence data visualization is completed through time sequence analysis software.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a schematic flow chart of a time series data visualization method provided by an embodiment of the specification;
FIG. 2 is a schematic flow chart diagram illustrating another method for visualizing time series data according to an exemplary embodiment of the present disclosure;
FIG. 3 is a diagram of a device parameter timing analysis without a fill rule provided by an embodiment of the specification;
FIG. 4 is a configuration provided for an embodiment of the specification a device timing analysis graph of linear fill rules;
fig. 5 is a schematic diagram of a time series data visualization apparatus provided in an embodiment of the specification.
Detailed Description
At present, a time sequence data visualization analysis tool is complex to operate, repeated and time-consuming, and the flexibility and configurability of the display of time sequence big data (namely, data with characteristics changing along with time sequences) are poor under the background of intelligent manufacturing and industrial internet big data. The flexible configuration visualization method for the equipment time sequence data is a future development trend, and an effective solution is provided for flexible configuration and display of the equipment time sequence data.
With the promotion and popularization of industrial internet and intelligent manufacturing, the visual display and analysis of equipment time sequence data becomes an important link for the informatization development of more and more enterprises. However, for the conventional manufacturing industry, on one hand, a workshop has many devices with the same specification, and on the other hand, when data collection is performed on the same type of devices, collected parameters are mostly the same. By adopting the existing time sequence data visualization method, flexible configuration of equipment time sequence data and one-key generation of a visualization interface cannot be realized. For mass equipment and parameters under the industrial internet environment, visual display of time sequence data is carried out according to changeable analysis requirements, and repeated workload is undoubtedly huge. A method which can be flexibly configured and can automatically generate visual display of equipment time sequence data in a one-click mode is urgently needed.
To make the objects, technical solutions and advantages of the present application more clear, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
Fig. 1 is a schematic flow chart of a time series data visualization method provided in an embodiment of the specification, which may specifically include:
step S101, the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by the visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template.
In step S101 of this embodiment, the request information of the device time sequence data visualization configuration may be which templates in a preset time sequence analysis template library the device data needs to be bound to. And matching the equipment time sequence data visualization service module with templates in a preset time sequence analysis template library according to the request information to determine a corresponding equipment time sequence analysis template.
Step S102, the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component, and converts the time sequence data display component into a corresponding data template structure.
Step S103, the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure, and generates data in a preset format.
In step S103 of this embodiment, the time-series database is one or more of infiluxdb, openTSD, graph, and Prometheus.
And step S104, the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface.
And step S105, the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
In step S105 of the embodiment of the present specification, time series data is displayed by a visualization device. The visualization device can comprise software such as a google browser and the like capable of displaying a webpage, and a visual time sequence analysis interface is displayed by utilizing a webpage label.
The equipment time sequence data visualization service module can be developed based on a standard interface provided by time sequence analysis software and a standard structure of a template in a time sequence analysis template library, wherein the time sequence analysis software can be a visualization tool grafana.
The device time sequence data visualization service module has the main functions of acquiring corresponding device parameters from a time sequence database, binding corresponding device parameter information to a preset time sequence analysis template, and automatically generating data in a preset format supported by the grafana through template analysis and device data binding functions of the time sequence data visualization service module, wherein the data in the preset format can be json data, and the json data can be data such as icons, charts, graphs, devices and parameters in the same visualization time sequence analysis interface in an abstract packaging manner;
the equipment time sequence data visualization service module can send json data to the grafana through a standard API (application program interface) of the grafana;
the grafana can generate a visual time sequence analysis interface by utilizing json data sent by the equipment time sequence data visual service module, and acquire related time sequence data from the time sequence database in real time for displaying.
When it needs to be explained, the preset time sequence analysis template library may be specifically used for:
abstracting the content in the visual time sequence analysis interface into a template which accords with a preset specification for management, and providing an interface for the equipment time sequence data visual service module to call.
In addition, the device parameter information in the embodiments of the present description may be acquired by a data acquisition module, where the data acquisition module acquires and uploads the device parameter information by using OPC UA data acquisition service, or acquires and uploads the device parameter information by using Modbus data acquisition service.
Corresponding to the embodiment of fig. 1, fig. 2 is a schematic flow chart of another time series data visualization method provided in the embodiment of the present specification, which may specifically include:
step S201, the device time sequence data visualization service module receives request information for device time sequence data visualization configuration sent by the visualization apparatus, and matches the request information with templates in a preset time sequence analysis template library to determine a corresponding device time sequence analysis template.
In step S201 of the embodiment of the present specification, the request information of the device time sequence data visualization configuration may be which templates in a preset time sequence analysis template library the device needs to be bound to. And matching the equipment time sequence data visualization service module with templates in a preset time sequence analysis template library according to the request information to determine a corresponding equipment time sequence analysis template.
Step S202, the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure.
In step S202 of the embodiment of the present specification, the time series data presentation component may include a plurality of different types, and accordingly, a plurality of data template structures may exist.
Step S203, the equipment time sequence data visualization service module stores the acquired equipment parameter data according to the time sequence through the data processing and storing module, and stores the equipment parameter data into the time sequence database according to a preset data storage structure.
Before the device parameter data is stored into the time sequence database according to the preset data storage structure, the following steps are also required to be executed: and cleaning and processing the equipment parameter data through a data processing and storing module.
When the data processing and storing module needs to explain, the data processing and storing module can clean and process the equipment parameter data according to the data quality stamp provided by the data acquisition module so as to discard the data with poor quality.
Step S204, the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure, and generates data in a preset format.
In step S204 in this embodiment of the present description, if there are multiple pieces of device parameter information, the multiple pieces of device parameter information need to be respectively bound to corresponding data template structures, and the multiple data template structures are spliced to generate data in a preset format, where the data in the preset format may be json data.
Step S205, the device time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface.
Step S206, the equipment time sequence data visualization service module obtains relevant time sequence data according to the visualization time sequence analysis interface for displaying.
In step S206 in the embodiment of the present specification, time series data is displayed by a visualization device. The visualization device can comprise software such as a google browser and the like capable of displaying a webpage, and a visual time sequence analysis interface is displayed by utilizing a webpage label.
Further, when implementing time series data visualization in the embodiments of the present description, the related apparatus may include an apparatus time series data visualization service module, a data acquisition module, a data processing and storing module, a time series database, time series analysis software, a time series analysis template library, and a visualization apparatus, and refer to a schematic diagram of the time series data visualization apparatus shown in fig. 5, specifically:
the data acquisition module can be used for acquiring time sequence data of each parameter of the equipment in real time and sending the acquired data to the data processing and storing module, the data acquisition module can acquire and upload equipment parameter values by using OPC UA data acquisition service and can also acquire and upload equipment parameter values by using Modbus data acquisition service, but the service used by the data acquisition module is not limited to the method;
the data processing and storing module is mainly used for storing the acquired equipment parameter data according to a time sequence and storing the equipment parameter data into a time sequence database according to a specified data storage structure.
The data processing and storing module has data cleaning and processing functions, performs data cleaning and processing according to a data quality stamp provided by the data acquisition service, discards quality difference data, and stores the processed equipment parameter data to a time sequence database;
the time sequence analysis template library has the functions of abstracting the content in the equipment time sequence data display interface into the equipment time sequence analysis template which accords with the time sequence analysis software specification for management, and providing an interface for the equipment time sequence data visualization module to call.
The equipment time sequence data visualization service module can be developed based on a standard interface provided by time sequence analysis software and a standard structure of an equipment time sequence analysis template;
the equipment time sequence data visualization module mainly has the functions of acquiring equipment related parameters from a time sequence database, binding the equipment related parameters to an equipment time sequence analysis template, and automatically generating a data template structure supported by time sequence analysis software in a one-click manner through the template analysis and equipment data binding functions of the time sequence data visualization module;
the equipment time sequence data visualization service module can send the data template structure to time sequence analysis software through a time sequence analysis software standard API interface so as to generate data in a preset format, wherein the data can be json data;
the time sequence analysis software can utilize json data sent by the equipment time sequence data visualization module to generate a visualized time sequence analysis interface, and relevant data can be obtained from the time sequence database in real time for displaying, and the time sequence data can be displayed through the visualization device.
The visualization device comprises software which can display webpages, such as a Google browser, and displays the equipment time sequence analysis interface by utilizing a webpage label.
In the embodiment of the present disclosure, when a template in a time sequence analysis template library is preset, parameters that need to be displayed by a device may be flexibly configured, and a filling rule and a linear smoothing rule of device time sequence data may be configured, where the filling rule includes non-filling, linear filling, and filling with a data value at a previous sampling time, but the embodiment of the present disclosure is not limited to the above filling rules. The flexible configuration can be realized by modifying the templates in the preset time sequence analysis template library, and can also be realized by editing the generated visual time sequence analysis interface.
Further, fig. 3 is a diagram of a device parameter timing analysis without padding rule, and fig. 4 is a diagram of a device timing analysis with linear padding rule. After appropriate automatic filling and linear smoothing processing, the utilization rate of data can be greatly improved, and a visual display effect of the equipment time sequence data is realized.
When the time sequence analysis method is required to be described, the embodiment of the description supports that the device data is bound to a template in a time sequence analysis template library for displaying the time sequence data, and a visual time sequence analysis interface corresponding to the device is generated through time sequence analysis software, wherein the template in the time sequence analysis template library may be a template of json data.
Meanwhile, the difficulty of the user in analyzing the time sequence of the equipment data can be reduced, the visual time sequence analysis interface of the equipment can be automatically generated in one key mode only by binding the equipment data with the templates in the time sequence analysis template library, and the user can rapidly display and analyze the time sequence data of the equipment without knowing the principle.
Correspondingly, the embodiment of the specification can reduce the workload of performing time sequence analysis on the data of the same type of equipment by a user and improve the expandability, the time sequence data display of the equipment of the same type generally uses the same configuration and display rules, the time sequence data to be displayed can be abstracted into the template in the time sequence analysis template library, batch operation can be performed on the equipment of the same type through the template, compared with a time sequence display tool in the prior art, each parameter of each equipment does not need to be configured one by one, the workload of performing time sequence analysis on the equipment parameters by the user is greatly reduced, and the expandability is improved.
In addition, the embodiment of the description can intercept a large amount of time sequence data according to the setting of the template in the time sequence analysis template library, so that the extraction and analysis of the key time node data of the equipment are facilitated. And the elimination of abnormal data and the configurability of automatic filling and linear smoothing of discrete time sequence data are supported, the visual display effect of the time sequence data of the equipment is realized, and the service resources of the system can be more effectively utilized.
It should be noted that, compared with a traditional hard-coded device time sequence data visualization display method or a method that each device parameter needs to be edited and configured respectively, the flexible device time sequence data visualization method adopted in the embodiments of the present specification does not rely on hard coding to solve visualization of time sequence data, omits repeated configuration of a large number of parameters, and configures a basic visualization effect interface as a template for time sequence data analysis display in a data configurable manner. The device can automatically generate the visual display panel in one key mode after passing through the binding template.
An embodiment of the present specification further provides a time series data visualization apparatus, where the apparatus includes:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
Embodiments of the present specification further provide a time series data visualization medium, in which computer-executable instructions are stored, where the computer-executable instructions are configured to:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library, and determines a corresponding equipment time sequence analysis template;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
In the 90 s of the 20 th century, improvements in a technology could clearly distinguish between improvements in hardware (e.g., improvements in circuit structures such as diodes, transistors, switches, etc.) and improvements in software (improvements in process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain the corresponding hardware circuit structure by programming an improved method flow into the hardware circuit. Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical modules. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Furthermore, nowadays, instead of manually manufacturing an Integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development, but the original code before compiling is also written in a specific Programming Language, which is called Hardware Description Language (HDL), and the HDL is not only one kind but many kinds, such as abll (Advanced boot Expression Language), AHDL (alternate hard Description Language), traffic, CUPL (computer universal Programming Language), HDCal (Java hard Description Language), lava, lola, HDL, PALASM, software, rhydl (Hardware Description Language), and vhul-Language (vhyg-Language), which is currently used in the field. It will also be apparent to those skilled in the art that hardware circuitry that implements the logical method flows can be readily obtained by merely slightly programming the method flows into an integrated circuit using the hardware description languages described above.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer-readable medium storing computer-readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, and an embedded microcontroller, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, atmel AT91SAM, microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic for the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may thus be considered a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. One typical implementation device is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smartphone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Disks (DVD) or other optical storage, magnetic cassettes, magnetic tape storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information and/or data which can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a … …" does not exclude the presence of another identical element in a process, method, article, or apparatus that comprises the element.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims (10)

1. A method for visualizing time series data, the method comprising:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library and determines corresponding equipment time sequence analysis templates, and configures filling rules and linear smoothing processing rules of the equipment time sequence data when the templates in the time sequence analysis template library are preset, wherein the filling rules comprise linear filling and filling by using data values at the last sampling moment;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
2. The time series data visualization method according to claim 1, wherein the preset time series analysis template library is specifically configured to:
abstracting the content in the visual time sequence analysis interface into a template which accords with a preset specification for management, and providing an interface for the equipment time sequence data visual service module to call.
3. The method for visualizing the time series data of claim 1, wherein the equipment parameter information is collected by a data collection module, wherein the data collection module uses OPC UA data collection service to collect and upload the equipment parameter information, or uses Modbus data collection service to collect and upload the equipment parameter information.
4. The method for visualizing time series data of claim 1, wherein before the device time series data visualization service module obtains corresponding device parameter information in a time series database, the method further comprises:
and storing the acquired equipment parameter data according to a time sequence through a data processing and storing module, and storing the equipment parameter data into a time sequence database according to a preset data storage structure.
5. The method for visualizing time series data of claim 4, wherein before storing the device parameter data into the time series database according to the preset data storage structure, the method further comprises:
and cleaning and processing the equipment parameter data through a data processing and storing module.
6. The time series data visualization method according to claim 1, wherein the time series database is one or more of infiuxdb, openTSD, graph, and Prometheus.
7. The method for visualizing time series data according to claim 1, wherein said time series analysis software is a visualization tool grafana.
8. The method for visualizing time series data of claim 1, wherein the data in the preset format is json data.
9. A time series data visualization apparatus, characterized in that the apparatus comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library and determines corresponding equipment time sequence analysis templates, and configures filling rules and linear smoothing processing rules of the equipment time sequence data when the templates in the time sequence analysis template library are preset, wherein the filling rules comprise linear filling and filling by using data values at the last sampling moment;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
10. A time series data visualization medium storing computer executable instructions, the computer executable instructions configured to:
the equipment time sequence data visualization service module receives request information of equipment time sequence data visualization configuration sent by a visualization device, matches the request information with templates in a preset time sequence analysis template library and determines corresponding equipment time sequence analysis templates, and configures filling rules and linear smoothing processing rules of the equipment time sequence data when the templates in the time sequence analysis template library are preset, wherein the filling rules comprise linear filling and filling by using data values at the last sampling moment;
the equipment time sequence data visualization service module analyzes the equipment time sequence analysis template, determines a time sequence data display component and converts the time sequence data display component into a corresponding data template structure;
the equipment time sequence data visualization service module acquires corresponding equipment parameter information in a time sequence database, binds the equipment parameter information to the data template structure and generates data in a preset format;
the equipment time sequence data visualization service module sends the data in the preset format to time sequence analysis software for generating a visualization time sequence analysis interface;
and the equipment time sequence data visualization service module acquires relevant time sequence data according to the visualization time sequence analysis interface and displays the relevant time sequence data.
CN202011191995.6A 2020-10-30 2020-10-30 Time sequence data visualization method, equipment and medium Active CN112364074B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011191995.6A CN112364074B (en) 2020-10-30 2020-10-30 Time sequence data visualization method, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011191995.6A CN112364074B (en) 2020-10-30 2020-10-30 Time sequence data visualization method, equipment and medium

Publications (2)

Publication Number Publication Date
CN112364074A CN112364074A (en) 2021-02-12
CN112364074B true CN112364074B (en) 2023-04-07

Family

ID=74513942

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011191995.6A Active CN112364074B (en) 2020-10-30 2020-10-30 Time sequence data visualization method, equipment and medium

Country Status (1)

Country Link
CN (1) CN112364074B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113127580A (en) * 2021-05-08 2021-07-16 中国南方电网有限责任公司超高压输电公司检修试验中心 Power grid data visualization method, device, equipment and medium
CN113342299B (en) * 2021-06-25 2023-02-21 上海致景信息科技有限公司 Factory LED data distribution screen projection method and system
CN117194528A (en) * 2023-03-24 2023-12-08 山东浪潮爱购云链信息科技有限公司 Visualized data processing method, device and medium based on mall

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107592334A (en) * 2017-07-17 2018-01-16 阿里巴巴集团控股有限公司 A kind of information popularization method, apparatus and equipment
CN108170655A (en) * 2017-12-26 2018-06-15 平安科技(深圳)有限公司 Production method, device, terminal device and the storage medium of Visual Report Forms
CN108334342A (en) * 2017-07-26 2018-07-27 阿里巴巴集团控股有限公司 A kind of information displaying method, device and equipment
CN110086853A (en) * 2019-03-28 2019-08-02 浙江明度智控科技有限公司 A kind of industry Internet of Things information visualization methods, server and storage medium
CN110413356A (en) * 2018-09-18 2019-11-05 广东优世联合控股集团股份有限公司 Visual display method and device for user data, electronic equipment and storage medium
CN110856038A (en) * 2019-11-25 2020-02-28 新华智云科技有限公司 Video generation method and system, and storage medium
CN111324582A (en) * 2020-02-18 2020-06-23 支付宝(杭州)信息技术有限公司 Method and device for visually backtracking and processing business processing behaviors

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107592334A (en) * 2017-07-17 2018-01-16 阿里巴巴集团控股有限公司 A kind of information popularization method, apparatus and equipment
CN108334342A (en) * 2017-07-26 2018-07-27 阿里巴巴集团控股有限公司 A kind of information displaying method, device and equipment
CN108170655A (en) * 2017-12-26 2018-06-15 平安科技(深圳)有限公司 Production method, device, terminal device and the storage medium of Visual Report Forms
CN110413356A (en) * 2018-09-18 2019-11-05 广东优世联合控股集团股份有限公司 Visual display method and device for user data, electronic equipment and storage medium
CN110086853A (en) * 2019-03-28 2019-08-02 浙江明度智控科技有限公司 A kind of industry Internet of Things information visualization methods, server and storage medium
CN110856038A (en) * 2019-11-25 2020-02-28 新华智云科技有限公司 Video generation method and system, and storage medium
CN111324582A (en) * 2020-02-18 2020-06-23 支付宝(杭州)信息技术有限公司 Method and device for visually backtracking and processing business processing behaviors

Also Published As

Publication number Publication date
CN112364074A (en) 2021-02-12

Similar Documents

Publication Publication Date Title
CN112364074B (en) Time sequence data visualization method, equipment and medium
US11386128B2 (en) Automatic feature learning from a relational database for predictive modelling
US9760551B2 (en) Generating regular expression
US11144506B2 (en) Compression of log data using field types
CN109033109B (en) Data processing method and system
CN109947643B (en) A/B test-based experimental scheme configuration method, device and equipment
CN110635962B (en) Abnormity analysis method and device for distributed system
CN110674408A (en) Service platform, and real-time generation method and device of training sample
US11392607B2 (en) Automatic feature engineering during online scoring phase
CN109241026A (en) The method, apparatus and system of data management
CN110764849A (en) Rendering method and device for user interface, client device and electronic device
CN112528614A (en) Table editing method and device and electronic equipment
CN112231531A (en) Data display method, equipment and medium based on openstb
CN116048977B (en) Test method and device based on data reduction
CN116341642A (en) Data processing method and device, storage medium and electronic equipment
CN110704742B (en) Feature extraction method and device
CN115687310A (en) Data cleaning method and device
CN107645541B (en) Data storage method and device and server
CN110019068B (en) Log text processing method and device
CN117455015B (en) Model optimization method and device, storage medium and electronic equipment
CN111143464A (en) Data acquisition method and device and electronic equipment
CN110502551A (en) Data read-write method, system and infrastructure component
CN116881724B (en) Sample labeling method, device and equipment
CN113821437B (en) Page test method, device, equipment and medium
CN111241147B (en) Data acquisition method and device, 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