CN109308305A - Querying method, device and the computer equipment of monitoring data - Google Patents
Querying method, device and the computer equipment of monitoring data Download PDFInfo
- Publication number
- CN109308305A CN109308305A CN201811162462.8A CN201811162462A CN109308305A CN 109308305 A CN109308305 A CN 109308305A CN 201811162462 A CN201811162462 A CN 201811162462A CN 109308305 A CN109308305 A CN 109308305A
- Authority
- CN
- China
- Prior art keywords
- monitoring
- data
- monitoring data
- inquiry
- factors
- 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.)
- Granted
Links
Landscapes
- Debugging And Monitoring (AREA)
- Computer And Data Communications (AREA)
Abstract
The present invention relates to a kind of querying method of monitoring data, device, computer equipment and computer readable storage mediums, and wherein method includes: to receive the monitoring data inquiry request of user terminal；According to monitoring data inquiry request, monitoring device mark, the information of Monitoring factors and data obtaining time of monitoring data to be checked are obtained；Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；Using query statement, inquiry obtains monitoring device mark, Monitoring factors and the corresponding monitoring data of data obtaining time in the database.The monitoring data of inquiry are returned to user terminal.The above method, it is generated by the splicing of query statement, the query statement that any monitoring data type corresponds to Monitoring factors can be flexibly generated, and the inquiry for carrying out corresponding monitoring data obtains, it realizes the inquiry in the monitoring data of same interface difference monitoring data type, promotes the search efficiency to monitoring data.
Description
Technical field
The present invention relates to data processing fields, set more particularly to the querying method, device, computer of a kind of monitoring data
Standby and computer readable storage medium.
Background technique
In environmental protection industry (epi), online environment monitoring system is frequently necessary to be monitored the inquiry of data, the monitoring data of inquiry
Data type may include the data of exhaust gas, the data of waste water, the data of heavy metal pollution and data of air quality etc..
Existing online environment monitoring system is typically only capable to inquiry single kind when inquiring monitoring data
Monitoring data then need to exit the system currently logged in, step on again if it is desired to checking the monitoring data of another data type
Record, then the inquiry that new data type is monitored data is reselected, lead to the inefficiency of data query.
Summary of the invention
Based on this, it is necessary to be asked for the technology of the inefficiency of the data query of existing online environment monitoring system
Topic, provides querying method, device, computer equipment and the computer readable storage medium of a kind of monitoring data.
A kind of querying method of monitoring data, comprising the following steps:
Receive the monitoring data inquiry request of user terminal.
According to monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
According to the information of acquisition time；
Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
Using query statement, inquiry obtains monitoring device mark, Monitoring factors and data obtaining time pair in the database
The monitoring data answered；
The monitoring data of inquiry are returned to user terminal.
The querying method of above-mentioned monitoring data obtains to be checked according to the monitoring data inquiry request that user terminal is sent
Monitoring data monitoring device mark, Monitoring factors and data obtaining time information monitoring device mark, Monitoring factors
And data obtaining time, the splicing of these parameters is generated into the query statement comprising these parameters, using the query statement in data
Inquiry obtains corresponding monitoring data and is back to user terminal in library.It is generated, can neatly be given birth to by the splicing of query statement
The query statement of Monitoring factors is corresponded at any monitoring data type, and the inquiry for carrying out corresponding monitoring data obtains, Yong Hu
It when inquiring the monitoring data of different monitoring data types, is logged in again without logging off, realizes and monitored in same interface difference
The inquiry of the monitoring data of data type promotes the search efficiency to monitoring data.
In one embodiment, monitoring data inquiry request carries monitoring device mark, monitoring data type and data and obtains
Take the information of time；
According to monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
Information according to acquisition time includes: that monitoring device mark, monitoring data type and data are read from monitoring data inquiry request
The information of acquisition time；In the facility information table prestored, inquiry monitoring device identifies monitoring corresponding with monitoring data type
The information of the factor；Wherein, prestored in facility information table each monitoring device identify monitoring corresponding with monitoring data type because
The information of son.
It is corresponding with monitoring data type to prestore monitoring device mark in facility information table for the technical solution of above-described embodiment
The information of Monitoring factors can be read by facility information table in the monitoring data inquiry request for receiving user terminal
The information of corresponding Monitoring factors, the data so as to the different monitoring device mark of Rapid matching and monitoring data type are looked into
Inquiry condition promotes the search efficiency of monitoring data.
In one embodiment, splicing is generated comprising monitoring device mark, the information of Monitoring factors and data obtaining time
Query statement include: that corresponding querying condition is obtained according to monitoring device mark, Monitoring factors and data obtaining time；Its
In, querying condition includes the information of classification data table, the information of Monitoring factors and data obtaining time of monitoring data to be checked
Information, classification data table is used to store the monitoring data that monitoring device identifies corresponding monitoring device acquisition；According to querying condition,
Splicing generates the query sentence of database comprising querying condition.
The monitoring data of different monitoring devices are stored respectively in different classification data by the technical solution of above-described embodiment
In table, when inquiring corresponding monitoring data, the information that monitoring device identifies corresponding classification data table is joined as querying condition
Number splices with the information of Monitoring factors and the information of data obtaining time and generates query sentence of database, jointly so as to logical
Crossing the query statement, quickly inquiry obtains corresponding monitoring data from classification data table corresponding in database.
In one embodiment, using query statement, in the database inquiry obtain monitoring device mark, Monitoring factors and
The corresponding monitoring data of data obtaining time include: using query statement, and inquiry obtains corresponding classification data in the database
Table, and inquiry obtains the monitoring data for meeting Monitoring factors and data obtaining time in querying condition in classification data table.
The technical solution of above-described embodiment, by query statement, inquiry first obtains corresponding classification data table, then from point
Inquiry obtains corresponding monitoring data in class tables of data, inquires compared to all data are stored in a total tables of data,
The application is stored by the data classification of classification data table, and single classification data table inquiry data are more rapid when data query,
Improve the efficiency of data query.
In one embodiment, using query statement, in the database inquiry obtain monitoring device mark, Monitoring factors and
After the corresponding monitoring data of data obtaining time, comprising: analyze monitoring data, will wherein exceed given threshold range
Monitoring data be identified as exceeded data, and mark exceeded data；
Monitoring data to the user terminal for returning to inquiry includes: to return to monitoring data to user terminal, and monitoring data include
The information of the exceeded data of label；Wherein, the information of the exceeded data of label is used to indicate user terminal and identifies and show exceeded
Data.
The technical solution of above-described embodiment analyzes the monitoring data of inquiry, is back to use after marking exceeded data
Family terminal, user terminal in the monitoring data for receiving inquiry, can quick obtaining exceeded data therein, and corresponded to
Display, the information for the exceeded data for facilitating user to know in monitoring data.
A kind of inquiry unit of monitoring data, comprising:
Request receiving module, for receiving the monitoring data inquiry request of user terminal；
Parameter acquisition module, for obtaining the monitoring device of monitoring data to be checked according to monitoring data inquiry request
Mark, the information of Monitoring factors and data obtaining time；
Query statement splicing module is generated for splicing comprising monitoring device mark, Monitoring factors and data obtaining time
Information query statement；
Data inquiry module, for utilizing query statement, inquiry obtains monitoring device mark, Monitoring factors in the database
Monitoring data corresponding with data obtaining time；
Data return module, for returning to the monitoring data inquired to user terminal.
The inquiry unit of above-mentioned monitoring data obtains to be checked according to the monitoring data inquiry request that user terminal is sent
Monitoring data monitoring device mark, Monitoring factors and data obtaining time information monitoring device mark, Monitoring factors
And data obtaining time, the splicing of these parameters is generated into the query statement comprising these parameters, using the query statement in data
Inquiry obtains corresponding monitoring data and is back to user terminal in library.It is generated, can neatly be given birth to by the splicing of query statement
The query statement of Monitoring factors is corresponded at any monitoring data type, and the inquiry for carrying out corresponding monitoring data obtains, Yong Hu
It when inquiring the monitoring data of different monitoring data types, is logged in again without logging off, realizes and monitored in same interface difference
The inquiry of the monitoring data of data type promotes the search efficiency to monitoring data.
A kind of computer equipment can be run on a memory and on a processor including memory, processor and storage
Computer program, processor perform the steps of when executing computer program
Receive the monitoring data inquiry request of user terminal；
According to monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
According to the information of acquisition time；
Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
Using query statement, inquiry obtains monitoring device mark, Monitoring factors and data obtaining time pair in the database
The monitoring data answered；
The monitoring data of inquiry are returned to user terminal.
Above-mentioned computer equipment, when processor executes program, by realizing step as above, so as to according to user's end
The monitoring data inquiry request sent is held, monitoring device mark, Monitoring factors and the data for obtaining monitoring data to be checked obtain
The monitoring device of the information of time is taken to identify, Monitoring factors and data obtaining time, it includes these that the splicing of these parameters, which is generated,
The query statement of parameter is inquired the corresponding monitoring data of acquisition in the database using the query statement and is back to user terminal.
It is generated by the splicing of query statement, the query statement that any monitoring data type corresponds to Monitoring factors can be flexibly generated,
And the inquiry for carrying out corresponding monitoring data obtains, user is when inquiring the monitoring data of different monitoring data types, without exiting
System logs in again, realizes the inquiry in the monitoring data of same interface difference monitoring data type, is promoted to monitoring data
Search efficiency.
A kind of computer readable storage medium is stored thereon with computer program, when computer program is executed by processor
It performs the steps of
Receive the monitoring data inquiry request of user terminal；
According to monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
According to the information of acquisition time；
Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
Using query statement, inquiry obtains monitoring device mark, Monitoring factors and data obtaining time pair in the database
The monitoring data answered；
The monitoring data of inquiry are returned to user terminal.
Above-mentioned computer readable storage medium, the computer program of storage, by realizing step as above, so as to root
According to the monitoring data inquiry request that user terminal is sent, monitoring device mark, the Monitoring factors of monitoring data to be checked are obtained
With monitoring device mark, Monitoring factors and the data obtaining time of the information of data obtaining time, these parameters are spliced and are generated
Query statement comprising these parameters is inquired the corresponding monitoring data of acquisition in the database using the query statement and is back to use
Family terminal.It is generated by the splicing of query statement, any monitoring data type can be flexibly generated and correspond to looking into for Monitoring factors
Sentence is ask, and the inquiry for carrying out corresponding monitoring data obtains, user is when inquiring the monitoring data of different monitoring data types, no
It is logged in again with logging off, realizes the inquiry in the monitoring data of same interface difference monitoring data type, promoted to monitoring
The search efficiency of data.
Detailed description of the invention
Fig. 1 is the applied environment figure of the querying method of monitoring data in one embodiment；
Fig. 2 is the flow diagram of the querying method of monitoring data in one embodiment；
Fig. 3 is the structural block diagram of the inquiry unit of monitoring data in one embodiment；
Fig. 4 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the present invention, not
For limiting the present invention.
The querying method of monitoring data provided by the invention can be applied in application environment as shown in Figure 1.Wherein,
Multiple monitoring terminals 101 and user terminal 102 are connect by network with server 103 respectively.Each monitoring terminal 101 is adopted respectively
Monitor set data, and the monitoring data of acquisition are sent to server 103, server 103 to received monitoring data at
Reason, wherein each monitoring terminal 101 and user terminal 102 can be, but not limited to be various personal computers, laptop,
Smart phone, tablet computer, portable wearable device or special equipment etc., server 103 can use independent server
The either server cluster of multiple servers composition is realized.
In one embodiment, as shown in Fig. 2, providing a kind of querying method of monitoring data, it is applied in this way
It is illustrated for server in Fig. 1, comprising the following steps:
S210 receives the monitoring data inquiry request of user terminal；
In this step, server receives the monitoring data inquiry request of user terminal.
S220 obtains monitoring device mark, the Monitoring factors of monitoring data to be checked according to monitoring data inquiry request
With the information of data obtaining time；
Wherein, monitoring device mark refers to the identification code of each monitoring device of acquisition monitoring data, can be for example
Suite number, to mark and which platform monitoring device identification is.Monitoring factors are further segmented under monitoring data type
Monitored project, for example, monitoring data type may include exhaust gas data, waste water data, heavy metal for environmental monitoring
Contamination data, air quality data etc. type, and with exhaust gas data therein and waste water data instance, the monitoring of exhaust gas data
The factor includes sulfur dioxide, nitrogen oxides, particulate matter etc..The Monitoring factors of waste water data then include biochemical oxygen demand (BOD), pH value
With suspended matter etc..Data obtaining time refers to, value or time segment value at the time of monitoring device acquires the monitoring data.
S230, splicing generate the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
In this step, server by monitoring device mark, the monitoring device of Monitoring factors and data obtaining time mark,
Monitoring factors and data obtaining time, common splicing generate corresponding query statement.
S240, using query statement, when inquiry obtains monitoring device mark, Monitoring factors and data acquisition in the database
Between corresponding monitoring data；
In this step, server by utilizing query statement is inquired in the database of server, and acquisition meets monitoring device
Mark, the monitoring device of Monitoring factors and data obtaining time mark, Monitoring factors and data obtaining time condition monitoring number
According to.
S250 returns to the monitoring data of inquiry to user terminal.
In this step, server returns to the monitoring data of inquiry to user terminal.
The querying method of above-mentioned monitoring data obtains to be checked according to the monitoring data inquiry request that user terminal is sent
Monitoring data monitoring device mark, Monitoring factors and data obtaining time information monitoring device mark, Monitoring factors
And data obtaining time, the splicing of these parameters is generated into the query statement comprising these parameters, using the query statement in data
Inquiry obtains corresponding monitoring data and is back to user terminal in library.It is generated, can neatly be given birth to by the splicing of query statement
The query statement of Monitoring factors is corresponded at any monitoring data type, and the inquiry for carrying out corresponding monitoring data obtains, Yong Hu
It when inquiring the monitoring data of different monitoring data types, is logged in again without logging off, realizes and monitored in same interface difference
The inquiry of the monitoring data of data type promotes the search efficiency to monitoring data.
In one embodiment, monitoring data inquiry request carries monitoring device mark, monitoring data type and data and obtains
Take the information of time；
S220 obtains monitoring device mark, the Monitoring factors of monitoring data to be checked according to monitoring data inquiry request
Information with data obtaining time include: from monitoring data inquiry request read monitoring device mark, monitoring data type and
The information of data obtaining time；In the facility information table prestored, inquiry monitoring device mark is corresponding with monitoring data type
The information of Monitoring factors；Wherein, each monitoring device is prestored in facility information table identifies prison corresponding with monitoring data type
Survey the information of the factor.
It is corresponding with monitoring data type to prestore monitoring device mark in facility information table for the technical solution of above-described embodiment
The information of Monitoring factors can be read by facility information table in the monitoring data inquiry request for receiving user terminal
The information of corresponding Monitoring factors, the data so as to the different monitoring device mark of Rapid matching and monitoring data type are looked into
Inquiry condition promotes the search efficiency of monitoring data.
In one embodiment, S230 splicing is generated comprising monitoring device mark, Monitoring factors and data obtaining time
The query statement of information includes: to obtain corresponding inquiry item according to monitoring device mark, Monitoring factors and data obtaining time
Part；Wherein, querying condition includes the information of classification data table, the information of Monitoring factors and data acquisition of monitoring data to be checked
The information of time, classification data table are used to store the monitoring data that monitoring device identifies corresponding monitoring device acquisition；According to inquiry
Condition, splicing generate the query sentence of database comprising querying condition.
The monitoring data of different monitoring devices are stored respectively in different classification data by the technical solution of above-described embodiment
In table, when inquiring corresponding monitoring data, the information that monitoring device identifies corresponding classification data table is joined as querying condition
Number splices with the information of Monitoring factors and the information of data obtaining time and generates query sentence of database, jointly so as to logical
Crossing the query statement, quickly inquiry obtains corresponding monitoring data from classification data table corresponding in database.
Correspondingly, in one embodiment, S240 utilizes query statement, and inquiry obtains monitoring device mark in the database
Know, Monitoring factors and the corresponding monitoring data of data obtaining time include: to utilize query statement, in the database inquiry acquisition pair
The classification data table answered, and inquiry obtains the Monitoring factors and data obtaining time met in querying condition in classification data table
Monitoring data.
The technical solution of above-described embodiment, by query statement, inquiry first obtains corresponding classification data table, then from point
Inquiry obtains corresponding monitoring data in class tables of data, inquires compared to all data are stored in a total tables of data,
The application is stored by the data classification of classification data table, and single classification data table inquiry data are more rapid when data query,
Improve the efficiency of data query.
In one embodiment, S240 utilize query statement, in the database inquiry obtain monitoring device mark, monitor because
After son monitoring data corresponding with data obtaining time, comprising: analyze monitoring data, will wherein exceed given threshold
The monitoring data of range are identified as exceeded data, and mark exceeded data；
Monitoring data to the user terminal that S250 returns to inquiry includes: to return to monitoring data to user terminal, monitoring data
The information of exceeded data including label；Wherein, the information of the exceeded data of label is used to indicate user terminal and identifies and show
Exceeded data.
The technical solution of above-described embodiment analyzes the monitoring data of inquiry, is back to use after marking exceeded data
Family terminal, user terminal in the monitoring data for receiving inquiry, can quick obtaining exceeded data therein, and corresponded to
Display, the information for the exceeded data for facilitating user to know in monitoring data.
It should be understood that although each step in above-described embodiment is arranged successively according to number, these steps
It is not necessarily successively to be executed according to the sequence of number.Unless expressly stating otherwise herein, the execution of these steps is not
Stringent sequence limitation, these steps can execute in other order.Moreover, at least part in the step of above-described embodiment
Step may include that perhaps these sub-steps of multiple stages or stage are executed in synchronization to multiple sub-steps
It completes, but can execute at different times, the execution sequence in these sub-steps or stage, which is also not necessarily, successively to be carried out,
But it can be executed in turn or alternately at least part of the sub-step or stage of other steps or other steps.
In one embodiment, as shown in figure 3, providing a kind of inquiry unit 300 of monitoring data, comprising:
Request receiving module 310, for receiving the monitoring data inquiry request of user terminal；
Parameter acquisition module 320, for according to monitoring data inquiry request, the monitoring for obtaining monitoring data to be checked to be set
Standby mark, the information of Monitoring factors and data obtaining time；
Query statement splicing module 330, when generating for splicing comprising monitoring device mark, Monitoring factors and data acquisition
Between information query statement；
Data inquiry module 340, for utilizing query statement, inquiry obtains monitoring device mark, monitoring in the database
The factor and the corresponding monitoring data of data obtaining time；
Data return module 350, for returning to the monitoring data inquired to user terminal.
The inquiry unit of above-mentioned monitoring data obtains to be checked according to the monitoring data inquiry request that user terminal is sent
Monitoring data monitoring device mark, Monitoring factors and data obtaining time information monitoring device mark, Monitoring factors
And data obtaining time, the splicing of these parameters is generated into the query statement comprising these parameters, using the query statement in data
Inquiry obtains corresponding monitoring data and is back to user terminal in library.It is generated, can neatly be given birth to by the splicing of query statement
The query statement of Monitoring factors is corresponded at any monitoring data type, and the inquiry for carrying out corresponding monitoring data obtains, Yong Hu
It when inquiring the monitoring data of different monitoring data types, is logged in again without logging off, realizes and monitored in same interface difference
The inquiry of the monitoring data of data type promotes the search efficiency to monitoring data.
In one embodiment, monitoring data inquiry request carries monitoring device mark, monitoring data type and data and obtains
Take the information of time；
Parameter acquisition module 320 includes:
Information reading module, for from monitoring data inquiry request read monitoring device mark, monitoring data type and
The information of data obtaining time；
Monitoring factors enquiry module, in the facility information table prestored, inquiry monitoring device identifies and monitoring data
The information of the corresponding Monitoring factors of type；Wherein, each monitoring device mark and monitoring data class are prestored in facility information table
The information of the corresponding Monitoring factors of type.
In one embodiment, query statement splicing module 330 includes:
Querying condition obtains module, for obtaining and corresponding to according to monitoring device mark, Monitoring factors and data obtaining time
Querying condition；Wherein, querying condition includes classification data table, Monitoring factors and the data obtaining time of monitoring data to be checked
Information, classification data table is used to store the monitoring data that monitoring device identifies corresponding monitoring device acquisition；
Sentence splices generation module, for according to querying condition, splicing to generate the data base querying language comprising querying condition
Sentence.
In one embodiment, data inquiry module 340 is further used for using query statement, and inquiry obtains in the database
Corresponding classification data table is taken, and inquiry obtains the Monitoring factors and data acquisition met in querying condition in classification data table
The monitoring data of time.
In one embodiment, the inquiry unit 300 of monitoring data further include:
Exceeded data markers module will wherein exceed the monitoring of given threshold range for analyzing monitoring data
Data are identified as exceeded data, and mark exceeded data；
Data return module 350 is further used for returning monitoring data to user terminal, and monitoring data include the super of label
Mark the information of data；Wherein, the information of the exceeded data of label is used to indicate user terminal and identifies and show exceeded data.
The specific of inquiry unit about monitoring data limits the querying method that may refer to above for monitoring data
Restriction, details are not described herein.Modules in the inquiry unit of above-mentioned monitoring data can be fully or partially through software, hard
Part and combinations thereof is realized.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment,
It can also be stored in a software form in the memory in computer equipment, execute the above modules in order to which processor calls
Corresponding operation.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 4.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is for storing monitoring data.The network interface of the computer equipment is used to pass through network with external terminal
Connection communication.A kind of querying method of monitoring data is realized when the computer program is executed by processor.
It will be understood by those skilled in the art that structure shown in Fig. 4, only part relevant to the present invention program is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to the present invention program, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, processor perform the steps of when executing computer program
Receive the monitoring data inquiry request of user terminal；
According to monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
According to the information of acquisition time；
Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
Using query statement, inquiry obtains monitoring device mark, Monitoring factors and data obtaining time pair in the database
The monitoring data answered；
The monitoring data of inquiry are returned to user terminal.
Above-mentioned computer equipment, when processor executes program, by realizing step as above, so as to according to user's end
The monitoring data inquiry request sent is held, monitoring device mark, Monitoring factors and the data for obtaining monitoring data to be checked obtain
The monitoring device of the information of time is taken to identify, Monitoring factors and data obtaining time, it includes these that the splicing of these parameters, which is generated,
The query statement of parameter is inquired the corresponding monitoring data of acquisition in the database using the query statement and is back to user terminal.
It is generated by the splicing of query statement, the query statement that any monitoring data type corresponds to Monitoring factors can be flexibly generated,
And the inquiry for carrying out corresponding monitoring data obtains, user is when inquiring the monitoring data of different monitoring data types, without exiting
System logs in again, realizes the inquiry in the monitoring data of same interface difference monitoring data type, is promoted to monitoring data
Search efficiency.
A kind of computer equipment provided by the embodiment of the present invention, computer executable instructions are not limited to monitoring as above
The querying method of data operates, and the phase in the querying method of monitoring data provided by any embodiment of the invention can also be performed
Operation is closed, and has corresponding function and beneficial effect.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performs the steps of when being executed by processor
Receive the monitoring data inquiry request of user terminal；
According to monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
According to the information of acquisition time；
Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
Using query statement, inquiry obtains monitoring device mark, Monitoring factors and data obtaining time pair in the database
The monitoring data answered；
The monitoring data of inquiry are returned to user terminal.
Above-mentioned computer readable storage medium, the computer program of storage, by realizing step as above, so as to root
According to the monitoring data inquiry request that user terminal is sent, monitoring device mark, the Monitoring factors of monitoring data to be checked are obtained
With monitoring device mark, Monitoring factors and the data obtaining time of the information of data obtaining time, these parameters are spliced and are generated
Query statement comprising these parameters is inquired the corresponding monitoring data of acquisition in the database using the query statement and is back to use
Family terminal.It is generated by the splicing of query statement, any monitoring data type can be flexibly generated and correspond to looking into for Monitoring factors
Sentence is ask, and the inquiry for carrying out corresponding monitoring data obtains, user is when inquiring the monitoring data of different monitoring data types, no
It is logged in again with logging off, realizes the inquiry in the monitoring data of same interface difference monitoring data type, promoted to monitoring
The search efficiency of data.
Certainly, a kind of storage medium comprising computer executable instructions, computer provided by the embodiment of the present invention
Executable instruction is not limited to the querying method operation of monitoring data as above, and any embodiment of that present invention can also be performed and provided
Monitoring data querying method in relevant operation, and have corresponding function and beneficial effect.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
It can inquire in storage medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided by the present invention,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to protection of the invention
Range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of querying method of monitoring data characterized by comprising
Receive the monitoring data inquiry request of user terminal；
According to the monitoring data inquiry request, monitoring device mark, the Monitoring factors sum number of monitoring data to be checked are obtained
According to the information of acquisition time；
Splicing generates the query statement comprising monitoring device mark, the information of Monitoring factors and data obtaining time；
Using the query statement, when inquiry obtains the monitoring device mark, Monitoring factors and data acquisition in the database
Between corresponding monitoring data；
The monitoring data of inquiry are returned to user terminal.
2. the querying method of monitoring data according to claim 1, which is characterized in that the monitoring data inquiry request is taken
With monitoring device mark, the information of monitoring data type and data obtaining time；
It is described according to the monitoring data inquiry request, obtain monitoring device mark, the Monitoring factors of monitoring data to be checked
Information with data obtaining time includes:
The letter of monitoring device mark, monitoring data type and data obtaining time is read from the monitoring data inquiry request
Breath；
In the facility information table prestored, inquires the monitoring device and identify Monitoring factors corresponding with the monitoring data type
Information；Wherein, prestored in the facility information table each monitoring device identify monitoring corresponding with monitoring data type because
The information of son.
3. the querying method of monitoring data according to claim 1, which is characterized in that it includes the prison that the splicing, which generates,
Measurement equipment identifies, the query statement of the information of Monitoring factors and data obtaining time includes:
According to monitoring device mark, Monitoring factors and data obtaining time, corresponding querying condition is obtained；Wherein, described
Querying condition includes the information of the classification data table of monitoring data to be checked, Monitoring factors and data obtaining time, the classification
Tables of data is used to store the monitoring data that the monitoring device identifies corresponding monitoring device acquisition；
According to the querying condition, splicing generates the query sentence of database comprising the querying condition.
4. the querying method of monitoring data according to claim 3, which is characterized in that it is described to utilize the query statement,
The inquiry acquisition monitoring device mark, Monitoring factors and the corresponding monitoring data of data obtaining time include: in the database
Using the query statement, inquiry obtains corresponding classification data table in the database, and in the classification data table
Inquiry obtains the monitoring data for meeting Monitoring factors and data obtaining time in the querying condition.
5. the querying method of monitoring data according to claim 1, which is characterized in that the query statement,
After inquiry obtains the monitoring device mark, Monitoring factors and the corresponding monitoring data of data obtaining time in database, packet
It includes:
The monitoring data are analyzed, the monitoring data for wherein exceeding given threshold range are identified as exceeded data, and
Mark the exceeded data；
It is described return inquiry the monitoring data to user terminal include:
The monitoring data are returned to user terminal, the monitoring data include the information of the exceeded data of label；The label
The information of exceeded data be used to indicate the user terminal and identify and show the exceeded data.
6. a kind of inquiry unit of monitoring data characterized by comprising
Request receiving module, for receiving the monitoring data inquiry request of user terminal；
Parameter acquisition module, for obtaining the monitoring device of monitoring data to be checked according to the monitoring data inquiry request
Mark, the information of Monitoring factors and data obtaining time；
Query statement splicing module is generated for splicing comprising monitoring device mark, Monitoring factors and data obtaining time
Information query statement；
Data inquiry module, for utilizing the query statement, inquiry obtains the monitoring device mark, monitoring in the database
The factor and the corresponding monitoring data of data obtaining time；
Data return module, for returning to the monitoring data inquired to user terminal.
7. the inquiry unit of monitoring data according to claim 6, which is characterized in that the monitoring data inquiry request is taken
With monitoring device mark, the information of monitoring data type and data obtaining time；
The parameter acquisition module includes:
Information reading module, for from the monitoring data inquiry request read monitoring device mark, monitoring data type and
The information of data obtaining time；
Monitoring factors enquiry module, in the facility information table prestored, inquiring the monitoring device mark and the monitoring
The information of the corresponding Monitoring factors of data type；Wherein, each monitoring device mark and prison are prestored in the facility information table
The information of the corresponding Monitoring factors of measured data type.
8. the inquiry unit of monitoring data according to claim 6, which is characterized in that the query statement splicing module packet
It includes:
Querying condition obtains module, for obtaining and corresponding to according to monitoring device mark, Monitoring factors and data obtaining time
Querying condition；Wherein, the querying condition includes classification data table, Monitoring factors and the data acquisition of monitoring data to be checked
The information of time, the classification data table are used to store the monitoring data that the monitoring device identifies corresponding monitoring device acquisition；
Sentence splices generation module, for according to the querying condition, splicing to generate the database comprising the querying condition and looks into
Ask sentence.
9. a kind of computer equipment, including memory, processor and it is stored on the memory and can be in the processor
The computer program of upper operation, which is characterized in that the processor realized when executing the computer program as claim 1 to
The step of querying method of monitoring data described in 5 any one.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of querying method of the monitoring data as described in claim 1 to 5 any one is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811162462.8A CN109308305B (en) | 2018-09-30 | 2018-09-30 | Monitoring data query method and device and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811162462.8A CN109308305B (en) | 2018-09-30 | 2018-09-30 | Monitoring data query method and device and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109308305A true CN109308305A (en) | 2019-02-05 |
| CN109308305B CN109308305B (en) | 2021-06-08 |
Family
ID=65225521
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811162462.8A Active CN109308305B (en) | 2018-09-30 | 2018-09-30 | Monitoring data query method and device and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109308305B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110990235A (en) * | 2019-09-06 | 2020-04-10 | 深圳平安通信科技有限公司 | Performance data management method, device, equipment and medium of heterogeneous storage equipment |
| CN111368172A (en) * | 2020-02-28 | 2020-07-03 | 深圳市通用互联科技有限责任公司 | Sensor data processing method and device, computer equipment and storage medium |
| CN112765408A (en) * | 2020-12-31 | 2021-05-07 | 欧普照明股份有限公司 | Equipment information query method and query equipment for control system |
| CN112818004A (en) * | 2021-01-21 | 2021-05-18 | 杭州海康威视数字技术股份有限公司 | Data storage method, query method and electronic equipment |
| CN112817976A (en) * | 2021-01-26 | 2021-05-18 | 广州欢网科技有限责任公司 | ID generation method, system, computer and readable instruction storage medium |
| CN114490241A (en) * | 2021-12-25 | 2022-05-13 | 苏州浪潮智能科技有限公司 | Chip monitoring method, system, storage medium and equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064933A (en) * | 2012-12-24 | 2013-04-24 | 华为技术有限公司 | Data query method and system |
| US20140358894A1 (en) * | 2013-05-30 | 2014-12-04 | International Business Machines Corporation | Optimizing query statements in relational databases |
| CN105224636A (en) * | 2015-09-24 | 2016-01-06 | 沈阳东软医疗***有限公司 | A kind of data access method and device |
-
2018
- 2018-09-30 CN CN201811162462.8A patent/CN109308305B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064933A (en) * | 2012-12-24 | 2013-04-24 | 华为技术有限公司 | Data query method and system |
| US20140358894A1 (en) * | 2013-05-30 | 2014-12-04 | International Business Machines Corporation | Optimizing query statements in relational databases |
| CN105224636A (en) * | 2015-09-24 | 2016-01-06 | 沈阳东软医疗***有限公司 | A kind of data access method and device |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110990235A (en) * | 2019-09-06 | 2020-04-10 | 深圳平安通信科技有限公司 | Performance data management method, device, equipment and medium of heterogeneous storage equipment |
| CN111368172A (en) * | 2020-02-28 | 2020-07-03 | 深圳市通用互联科技有限责任公司 | Sensor data processing method and device, computer equipment and storage medium |
| CN112765408A (en) * | 2020-12-31 | 2021-05-07 | 欧普照明股份有限公司 | Equipment information query method and query equipment for control system |
| CN112818004A (en) * | 2021-01-21 | 2021-05-18 | 杭州海康威视数字技术股份有限公司 | Data storage method, query method and electronic equipment |
| CN112817976A (en) * | 2021-01-26 | 2021-05-18 | 广州欢网科技有限责任公司 | ID generation method, system, computer and readable instruction storage medium |
| CN112817976B (en) * | 2021-01-26 | 2024-04-05 | 广州欢网科技有限责任公司 | ID generation method, system, computer and readable instruction storage medium |
| CN114490241A (en) * | 2021-12-25 | 2022-05-13 | 苏州浪潮智能科技有限公司 | Chip monitoring method, system, storage medium and equipment |
| CN114490241B (en) * | 2021-12-25 | 2023-09-15 | 苏州浪潮智能科技有限公司 | Chip monitoring method, system, storage medium and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109308305B (en) | 2021-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109308305A (en) | Querying method, device and the computer equipment of monitoring data | |
| CN109446068B (en) | Interface test method, device, computer equipment and storage medium | |
| US10642913B2 (en) | Intent and bot based query guidance | |
| CN109800258B (en) | Data file deployment method, device, computer equipment and storage medium | |
| CN113282513B (en) | Interface test case generation method and device, computer equipment and storage medium | |
| CN111124872A (en) | Branch detection method and device based on difference code analysis and storage medium | |
| CN111026080A (en) | Hardware-in-loop test method and device for controller | |
| CN114428677A (en) | Task processing method, processing device, electronic equipment and storage medium | |
| CN111831574A (en) | Regression test planning method, device, computer system and medium | |
| CN111324375A (en) | Code management method and device, computer equipment and storage medium | |
| CN113221036B (en) | Method and device for processing electronic bill mail | |
| CN113572900A (en) | Outbound test method, device, computer equipment and computer readable storage medium | |
| CN113220597A (en) | Test method, test device, electronic apparatus, and storage medium | |
| CN105159834A (en) | Software dynamic testing operating data extracting method | |
| CN112445692B (en) | Case testing method and terminal | |
| CN114611850A (en) | Service analysis method and device and electronic equipment | |
| CN109145092A (en) | A kind of database update, intelligent answer management method, device and its equipment | |
| CN112416648A (en) | Data verification method and device | |
| CN107766228A (en) | It is a kind of based on multilingual automated testing method and device | |
| CN114968725A (en) | Task dependency relationship correction method and device, computer equipment and storage medium | |
| CN113934595A (en) | Data analysis method and system, storage medium and electronic terminal | |
| CN113672507A (en) | Software source code detection method and device, computer equipment and storage medium | |
| CN111078574A (en) | Method and device for generating influence analysis report | |
| CN113204379B (en) | Method, system, equipment and medium for dynamically loading test resources | |
| CN109785102A (en) | System of account information-pushing method, device, computer 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 |