CN113609129A - Heat energy monitoring comprehensive retrieval method based on big data - Google Patents
Heat energy monitoring comprehensive retrieval method based on big data Download PDFInfo
- Publication number
- CN113609129A CN113609129A CN202110861702.9A CN202110861702A CN113609129A CN 113609129 A CN113609129 A CN 113609129A CN 202110861702 A CN202110861702 A CN 202110861702A CN 113609129 A CN113609129 A CN 113609129A
- Authority
- CN
- China
- Prior art keywords
- field
- service data
- value
- index table
- dynamic index
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
Abstract
The invention belongs to the technical field of heat energy monitoring, and provides a heat energy monitoring comprehensive retrieval method based on big data, which comprises the following steps: establishing a service data field: establishing a service data field and a service data type corresponding to the service data field in a database; selecting a retrieval key field: selecting a field to be monitored from the business data field in real time as a retrieval key field; establishing an index table: retrieving the business data records in the database on the basis of the retrieval key field, and taking the business data records containing the retrieval key field as index records to form a dynamic index table; data monitoring: periodically searching a service data updating field in the dynamic index table, and displaying the service data updating field and the associated information of the service data updating field; and (6) data alarming. The heat energy monitoring comprehensive retrieval method based on big data improves retrieval speed and has the effects of real-time monitoring and alarming.
Description
Technical Field
The invention relates to the technical field of heat energy monitoring, in particular to a heat energy monitoring comprehensive retrieval method based on big data.
Background
With the rapid development of the heating industry, the number of users needing heating is increased rapidly, a heating company needs to manage a large number of heating users and mass heating data related to the heating users, and a traditional database cannot perform rapid data query and alarm display while managing a large number of heating data, so that poor management is caused. Therefore, there is a need for an improved method of retrieving conventional databases.
Disclosure of Invention
Aiming at the defects in the prior art, the heat energy monitoring comprehensive retrieval method based on big data improves the retrieval speed and has the effects of real-time monitoring and alarming.
In order to solve the technical problems, the invention provides the following technical scheme:
a heat energy monitoring comprehensive retrieval method based on big data comprises the following steps:
establishing a service data field: establishing a service data field and a service data type corresponding to the service data field in a database;
selecting a retrieval key field: selecting a field to be monitored from the business data field in real time as a retrieval key field;
establishing an index table: retrieving the business data records in the database on the basis of the retrieval key field, and taking the business data records containing the retrieval key field as index records to form a dynamic index table;
data monitoring: periodically searching a service data updating field in the dynamic index table, and displaying the service data updating field and the associated information of the service data updating field;
data alarming: and (4) the value of the service data updating field in the dynamic index table reaches a set alarm threshold value, and alarming is carried out.
Further, the dynamic index table stores the states or values of the service data fields at the current time and the previous time.
Further, the process of periodically retrieving the service data update field in the dynamic index table and displaying the service data update field and the associated information of the service data update field includes:
starting a timer;
judging whether the state or the value of the service data field of the dynamic index table at the current moment and the previous moment is updated, if so, displaying the state or the value of the service data field and the associated information of the service data field; if not, quitting the current round of monitoring;
and finishing the monitoring in the current round.
Further, the process of determining whether the service data fields of the dynamic index table at the current time and the previous time have status or value updates includes:
full-text retrieval is carried out on the dynamic index table at the current moment through a search engine, and if a matched service data field is retrieved, the state or the numerical value of the service data field at the current moment is obtained; if the matched service data field is not retrieved, submitting an error log record of the index table, and recording the error log;
comparing the state or the value of the service data field at the current moment with the state or the value of the service data field at the previous moment, and if the comparison result is consistent, the service data field is not updated; and if the comparison result is not consistent, the service data field is a service data updating field.
Further, the process of alarming when the value of the service data update field in the dynamic index table reaches a set alarm threshold value includes: and comparing the value of the acquired service data updating field with a set threshold, if the value does not reach the alarm threshold, continuing monitoring, and if the value reaches the alarm threshold, alarming.
According to the technical scheme, the invention has the beneficial effects that: the method has the advantages that the fields to be monitored and the retrieval key fields associated with the fields to be monitored are preprocessed to form the dynamic index table, the retrieval and query of the business data fields are carried out in the dynamic index table, the direct retrieval of the massive business data fields in the database is avoided, the retrieval speed is improved, the states or the numerical values of the updated business data fields are displayed after the business data fields are retrieved, and when the numerical values of the business data updating fields reach the set alarm threshold value, the alarm is carried out, and the effects of real-time monitoring and alarm are achieved.
Drawings
In order to more clearly illustrate the detailed description of the invention or the technical solutions in the prior art, the drawings that are needed in the detailed description of the invention or the prior art will be briefly described below. Throughout the drawings, like elements or portions are generally identified by like reference numerals. In the drawings, elements or portions are not necessarily drawn to scale.
FIG. 1 is a flow chart of the method of the present invention;
FIG. 2 is a flowchart illustrating a process of periodically retrieving a service data update field in a dynamic index table and displaying the service data update field and associated information of the service data update field according to the present invention;
fig. 3 is a flowchart of a process of determining whether a status or a value of a service data field of a dynamic index table at a current time and a previous time is updated according to the present invention.
Detailed Description
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and therefore are only examples, and the protection scope of the present invention is not limited thereby.
Referring to fig. 1, the method for comprehensively retrieving thermal energy monitoring based on big data according to the present embodiment includes:
establishing a service data field: and establishing a service data field and a service data type corresponding to the service data field in the database, wherein the service data field comprises a user place, a user equipment name, a real-time temperature, a real-time voltage, a real-time current, a current water flow, a smoke concentration and the like, and the service data type comprises a numerical type, a character type and the like.
Selecting a retrieval key field: and selecting a field to be monitored from the business data field in real time as a retrieval key field, wherein the field to be monitored comprises real-time temperature, real-time voltage, real-time current, current water flow, smoke concentration and the like.
Establishing an index table: the method comprises the steps of retrieving business data records in a database on the basis of a retrieval key field, taking the business data records containing the retrieval key field as index records to form a dynamic index table, for example, when a field to be monitored is real-time temperature, the retrieval key field is real-time temperature, recording the business data records related to the real-time temperature in the database as the index records to form the dynamic index table related to the real-time temperature, and retrieving and inquiring the business data fields in the dynamic index table, so that the retrieval of massive business data fields in the database is avoided directly, and the retrieval speed is improved.
Data monitoring: the service data update field in the dynamic index table is periodically retrieved, and the service data update field and the associated information of the service data update field are displayed, for example, the real-time temperature of a certain device at a certain user location is updated, and the real-time temperature field is displayed, and the information of a certain device at a certain user location, which is the associated information of the "real-time temperature", needs to be displayed, so that the effect of real-time monitoring is achieved, and a worker can conveniently find a fault point.
Data alarming: and if the 'real-time temperature' of certain equipment at a certain user site is higher than the set alarm threshold value, alarming, and having a real-time alarm function.
In this embodiment, the dynamic index table stores the states or values of the service data fields at the current time and the previous time, and the states or values of the service data fields at the previous time may also be stored in a temporary cache of the database.
Referring to fig. 2, the process of periodically retrieving the service data update field in the dynamic index table and displaying the service data update field and the associated information of the service data update field includes:
the timer is started, the setting of the timer can be set according to actual needs, and the default condition is 1 minute.
Judging whether the state or the value of the service data field of the dynamic index table at the current moment and the previous moment is updated, if so, displaying the state or the value of the service data field and the associated information of the service data field; if not, quitting the monitoring in the current round, and displaying the updated state or value of the service data field, displaying the associated information of the service data field together, so that the staff can conveniently and visually obtain the fault point information.
And finishing the monitoring in the current round.
Referring to fig. 3, the process of determining whether the service data field of the dynamic index table at the current time and the previous time has status or value update includes:
full-text retrieval is carried out on the dynamic index table at the current moment through a search engine, and if a matched service data field is retrieved, the state or the numerical value of the service data field at the current moment is obtained; and if the matched service data field is not retrieved, submitting the error log record of the index table and recording the error log.
Comparing the state or the value of the service data field at the current moment with the state or the value of the service data field at the previous moment, and if the comparison result is consistent, the service data field is not updated; if the comparison result is not consistent, the service data field is a service data updating field, the change of the state or the value of the service data field is quickly obtained by comparing the state or the value of the service data field at the current moment with the state or the value of the service data field at the previous moment, the cache pressure of a database is reduced, and the data processing speed is higher.
In this embodiment, the process of alarming when the value of the service data update field in the dynamic index table reaches the set alarm threshold includes: and comparing the value of the acquired service data updating field with a set threshold, if the value does not reach the alarm threshold, continuing monitoring, and if the value reaches the alarm threshold, alarming.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present invention, and they should be construed as being included in the following claims and description.
Claims (5)
1. A heat energy monitoring comprehensive retrieval method based on big data is characterized by comprising the following steps:
establishing a service data field: establishing a service data field and a service data type corresponding to the service data field in a database;
selecting a retrieval key field: selecting a field to be monitored from the business data field in real time as a retrieval key field;
establishing an index table: retrieving the business data records in the database on the basis of the retrieval key field, and taking the business data records containing the retrieval key field as index records to form a dynamic index table;
data monitoring: periodically searching a service data updating field in the dynamic index table, and displaying the service data updating field and the associated information of the service data updating field;
data alarming: and (4) the value of the service data updating field in the dynamic index table reaches a set alarm threshold value, and alarming is carried out.
2. The thermal energy monitoring comprehensive retrieval method based on big data as claimed in claim 1, wherein the dynamic index table stores the state or value of the service data field at the current time and the previous time.
3. The thermal energy monitoring comprehensive retrieval method based on big data as claimed in claim 2, wherein the process of periodically retrieving the service data update field in the dynamic index table and displaying the service data update field and the associated information of the service data update field comprises:
starting a timer;
judging whether the state or the value of the service data field of the dynamic index table at the current moment and the previous moment is updated, if so, displaying the state or the value of the service data field and the associated information of the service data field; if not, quitting the current round of monitoring;
and finishing the monitoring in the current round.
4. The method according to claim 3, wherein the step of determining whether the service data fields of the dynamic index table at the current time and the previous time have status or value updates comprises:
full-text retrieval is carried out on the dynamic index table at the current moment through a search engine, and if a matched service data field is retrieved, the state or the numerical value of the service data field at the current moment is obtained; if the matched service data field is not retrieved, submitting an error log record of the index table, and recording the error log;
comparing the state or the value of the service data field at the current moment with the state or the value of the service data field at the previous moment, and if the comparison result is consistent, the service data field is not updated; and if the comparison result is not consistent, the service data field is a service data updating field.
5. The thermal energy monitoring comprehensive retrieval method based on big data as claimed in claim 4, wherein the value of the service data update field in the dynamic index table reaches a set alarm threshold, and the process of alarming comprises: and comparing the value of the acquired service data updating field with a set threshold, if the value does not reach the alarm threshold, continuing monitoring, and if the value reaches the alarm threshold, alarming.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110861702.9A CN113609129A (en) | 2021-07-29 | 2021-07-29 | Heat energy monitoring comprehensive retrieval method based on big data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110861702.9A CN113609129A (en) | 2021-07-29 | 2021-07-29 | Heat energy monitoring comprehensive retrieval method based on big data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113609129A true CN113609129A (en) | 2021-11-05 |
Family
ID=78305939
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110861702.9A Pending CN113609129A (en) | 2021-07-29 | 2021-07-29 | Heat energy monitoring comprehensive retrieval method based on big data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113609129A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105468492A (en) * | 2015-11-17 | 2016-04-06 | 中国建设银行股份有限公司 | SE(search engine)-based data monitoring method and system |
| CN106156304A (en) * | 2016-07-01 | 2016-11-23 | 中国南方电网有限责任公司 | A kind of data retrieval for power system and sort method |
| CN109299102A (en) * | 2018-10-23 | 2019-02-01 | 中国电子科技集团公司第二十八研究所 | A kind of HBase secondary index system and method based on Elastcisearch |
| CN111200517A (en) * | 2019-12-24 | 2020-05-26 | 苏州达家迎信息技术有限公司 | Service data early warning control method, device, equipment and storage medium |
| CN112445854A (en) * | 2020-11-25 | 2021-03-05 | 平安普惠企业管理有限公司 | Multi-source business data real-time processing method and device, terminal and storage medium |
-
2021
- 2021-07-29 CN CN202110861702.9A patent/CN113609129A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105468492A (en) * | 2015-11-17 | 2016-04-06 | 中国建设银行股份有限公司 | SE(search engine)-based data monitoring method and system |
| CN106156304A (en) * | 2016-07-01 | 2016-11-23 | 中国南方电网有限责任公司 | A kind of data retrieval for power system and sort method |
| CN109299102A (en) * | 2018-10-23 | 2019-02-01 | 中国电子科技集团公司第二十八研究所 | A kind of HBase secondary index system and method based on Elastcisearch |
| CN111200517A (en) * | 2019-12-24 | 2020-05-26 | 苏州达家迎信息技术有限公司 | Service data early warning control method, device, equipment and storage medium |
| CN112445854A (en) * | 2020-11-25 | 2021-03-05 | 平安普惠企业管理有限公司 | Multi-source business data real-time processing method and device, terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2530565C (en) | Server architecture and methods for persistently storing and serving event data | |
| US8635202B2 (en) | Automatic update of searches | |
| US7694212B2 (en) | Systems and methods for providing a graphical display of search activity | |
| CN113553420B (en) | Power grid fault processing rule recommendation method and system based on knowledge graph | |
| WO2022141803A1 (en) | Method for automatically discovering hot keywords and hot news | |
| CN109656958B (en) | Data query method and system | |
| CN112668772B (en) | State development trend prediction method, device, equipment and storage medium | |
| CN104182435A (en) | System and method for searching information based on data missing mark | |
| CN111221890B (en) | Automatic monitoring and early warning method and device for universal index class | |
| CN110173830B (en) | Air conditioner operation data monitoring method and related equipment | |
| US6356896B1 (en) | Data visualization of queries over joins | |
| CN113609129A (en) | Heat energy monitoring comprehensive retrieval method based on big data | |
| CN116303628B (en) | Alarm data query method, system and equipment based on elastic search | |
| CN107609203B (en) | Data analysis system and method for quantitative evaluation of search engine optimization effect | |
| CN115470192A (en) | Method for collecting and managing metadata of database | |
| CN116701890A (en) | Data quality evaluation system | |
| CN111522710B (en) | Data compression method, device and medium based on big data | |
| CN106528590B (en) | Query method and device | |
| CN112199396B (en) | Industrial Internet identification query method and system facing MES | |
| CN112434063A (en) | Monitoring data processing method based on time sequence database | |
| CN113420021A (en) | Data storage method, device, equipment and medium | |
| CN112101798A (en) | Power equipment service life management method based on big data technology | |
| CN117370313A (en) | Monitoring system data storage method, device and storage medium | |
| JP2006277179A (en) | Database tuning device, method, and program | |
| CN110633430A (en) | Event discovery method, device, equipment and computer readable 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 |