CN110619006A - Statistical data management method, device, platform and storage medium based on Internet of things - Google Patents
Statistical data management method, device, platform and storage medium based on Internet of things Download PDFInfo
- Publication number
- CN110619006A CN110619006A CN201910812239.1A CN201910812239A CN110619006A CN 110619006 A CN110619006 A CN 110619006A CN 201910812239 A CN201910812239 A CN 201910812239A CN 110619006 A CN110619006 A CN 110619006A
- Authority
- CN
- China
- Prior art keywords
- data
- statistical data
- user
- historical
- equipment state
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
Abstract
The invention discloses a statistical data management method, a device, a platform and a storage medium based on the Internet of things, wherein the method comprises the following steps: acquiring authority information of a login user; providing a corresponding statistical data query entry according to the authority information; receiving a query request of a user; acquiring historical statistical data; acquiring and processing equipment state data after a preset time point to obtain current statistical data; combining the historical statistical data and the current statistical data to generate final statistical data; and displaying the final statistical data to a user. The method provided by the invention optimizes the authority design and divides the statistical data through the setting of the authority, so that the condition of cross-authority access can not occur; the data volume is reduced, and the response speed of the platform is improved; only the data after the preset time point needs to be processed, so that the data processing amount is greatly reduced, the response speed is improved, and the user experience is optimized.
Description
Technical Field
The application relates to the technical field of the internet of things, in particular to a statistical data management method, a statistical data management device, a statistical data management platform and a storage medium based on the internet of things.
Background
The internet of things, namely the internet connected with objects, is an important component of a new generation of information technology, and the internet of things technology is widely applied to various industries, and various internet of things devices need to be accessed into an internet of things platform. It is important for the user to obtain data on the status of these devices.
On one hand, because the authority design of a user is mostly imperfect and unreasonable, and a large amount of data needs to be cleaned and aggregated when the user requests the data, the accurate correspondence between the authority and the corresponding data cannot be realized; on the other hand, since the data is temporarily processed based on the user request, the response speed is slow when the number of devices increases and the amount of data is large. In order to solve the above problems, at present, a means of limiting the application scale of the device or not performing authority differentiation on statistical data is generally adopted, but the internet of things platform is limited at the same time, and the user requirements cannot be met.
Disclosure of Invention
The invention aims to provide a data management method, a data management device, a data management platform and a data management storage medium based on the Internet of things, which can solve one or more of the existing problems.
In a first aspect, a method for statistical data management based on the internet of things is provided, the method comprising,
acquiring authority information of a login user;
providing a corresponding statistical data query entry for the user according to the authority information of the user;
receiving a request of a user for inquiring statistical data;
acquiring historical statistical data, wherein the historical statistical data is obtained by processing equipment state data before a preset time point;
acquiring and processing equipment state data after a preset time point to obtain current statistical data;
combining the historical statistical data and the current statistical data to generate final statistical data;
and displaying the final statistical data to a user.
In a second aspect, an internet of things-based statistical data management device is provided, which comprises the following modules,
the user authority acquisition module is used for acquiring authority information of a login user;
the data query entry module is used for providing a corresponding statistical data query entry for the user according to the authority information of the user;
the user inquiry request receiving module is used for receiving a request of a user for inquiring the statistical data;
the historical statistical data acquisition module is used for acquiring historical statistical data, and the historical statistical data is obtained by processing equipment state data before a preset time point;
the current statistical data generation module is used for acquiring and processing equipment state data after a preset time point to obtain current statistical data;
the final statistical data synthesis module is used for combining the historical statistical data and the current statistical data to generate final statistical data;
and the final statistical data display module is used for displaying the final statistical data to the user.
In a third aspect, an internet of things platform is provided, where the internet of things platform includes a processor and a memory, where the memory stores at least one instruction, at least one program, a code set, or an instruction set, and the at least one instruction, the at least one program, or the instruction set is loaded and executed by the processor to implement any of the above statistical data management methods based on the internet of things.
In a fourth aspect, a computer-readable storage medium is provided, where at least one instruction, at least one program, a set of codes, or a set of instructions is stored in the computer-readable storage medium, and the at least one instruction, the at least one program, the set of codes, or the set of instructions is loaded and executed by a processor to implement any of the above statistical data management methods based on the internet of things of the present invention.
According to the method provided by the invention, the authority design is optimized and the statistical data is divided through the setting of the authority by acquiring the authority information of the login user and providing the corresponding statistical data query entrance, so that the condition of cross-authority access is avoided; because only statistical data corresponding to the authority is provided for the user, the data volume is reduced, and the response speed of the platform is improved; after receiving the query request of the user, the acquired historical data is processed data, so that only the data after the preset time point needs to be processed, the data processing amount is greatly reduced, the response speed is improved, and the use experience of the user is optimized.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Fig. 1 is a flowchart of a statistical data management method based on the internet of things according to an embodiment of the present invention.
Fig. 2 is a block diagram of a statistical data management device based on the internet of things according to a second embodiment of the present invention.
Fig. 3 is a schematic structural diagram of an internet of things platform according to a third embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. 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 invention.
Example 1:
in the embodiment, the statistical data management method based on the internet of things is provided, and is applied to an internet of things platform, and the internet of things platform can be a computer, a server and other equipment. As shown in fig. 1, the method comprises the steps of:
s11: acquiring authority information of a login user;
specifically, the user can use an account to log in the internet of things platform, and the account corresponding to each user is provided with corresponding authority. In an alternative embodiment, the user's rights may be represented by user tags, each user having at least one tag under which multiple devices may be added. Therefore, the inquiry authority of the device data is determined according to the corresponding relation between the user, the label and the device. In combination with a specific application scenario, for example, if the user a has a user tag in a unit, but has no user tag in a unit, the user a can view the device status data in the unit a, but cannot view the device status data in the unit b.
S12: providing a corresponding statistical data query entry for the user according to the authority information of the user;
specifically, according to the user authority information, a corresponding statistical data query entry is provided, so that on one hand, the authority design is optimized, and the cross-authority access condition is avoided through the setting of the authority; on the other hand, after the user authority information is determined, only data in the authority need to be provided for the user, so that the data volume is greatly reduced, and the response speed is improved.
S13: receiving a request of a user for inquiring statistical data;
specifically, the user can issue a corresponding data query request within the authority range of the user.
S14: acquiring historical statistical data, wherein the historical statistical data is obtained by processing equipment state data before a preset time point;
for example, when the time point preset by the platform is 0 per day, the user a queries all device data states under the tag of the first unit at 21 th and 14 th of 9 th, and the historical statistical data is statistical data before 0 th of 21 th of 9 th.
In an alternative embodiment, the method of generating historical statistical data comprises the steps of,
detecting whether the equipment state data changes;
specifically, whether the device status data changes or not may be detected in a timing manner or triggered dynamically. In an optional embodiment, the detected device status data is device status data of all devices under any authority.
If the equipment state data changes, storing the equipment state data at the moment;
specifically, the device status data at this time may be stored in a time series database.
Periodically acquiring all stored equipment state data in a preset time period;
specifically, in combination with the actual application scenario, all the saved device state data within 24 hours of the previous day may be acquired at a 24-hour period, i.e., 0 hour of each day.
Processing the acquired equipment state data to generate historical statistical data;
specifically, according to the actual situation of the device, the obtained device state data is grouped and aggregated in combination with the user tag to which the device belongs and the date of the data, so as to generate historical statistical data.
The generated historical statistics are saved.
In an alternative embodiment, storing the generated historical statistics includes storing the generated historical statistics in the server and the browser, respectively. Therefore, when a user requests data, the data stored in the browser can be directly called without sending a request to the server, so that the transmission of the data is reduced, and the response speed is increased; meanwhile, the data stored in the server avoids data loss caused by the fact that a user clears the cache of the browser or improper operation.
S15: acquiring and processing equipment state data after a preset time point to obtain current statistical data;
for example, when the preset time point of the platform is 0 per day, the user a queries the states of all the device data under the tag of the first unit at 21 th of 9 months and 14 th of 9 months, and the device state data after the preset time point is data between 0 th of 9 months and 21 th of 9 months and 14 th of 9 months and 21 th of 14 days. Therefore, only the equipment state data in the time period is grouped and aggregated according to the needs, the data processing amount is greatly reduced, the response speed is improved, and the user experience is optimized.
S16: combining the historical statistical data and the current statistical data to generate final statistical data;
s17: and displaying the final statistical data to a user.
According to the method provided by the invention, the authority design is optimized and the statistical data is divided through the setting of the authority by acquiring the authority information of the login user and providing the corresponding statistical data query entrance, so that the condition of cross-authority access is avoided; because only statistical data corresponding to the authority is provided for the user, the data volume is reduced, and the response speed of the platform is improved; after receiving the query request of the user, the acquired historical data is processed data, so that only the data after the preset time point needs to be processed, the data processing amount is greatly reduced, the response speed is improved, and the use experience of the user is optimized.
Example 2:
as shown in fig. 2, there is provided an internet of things-based statistical data management apparatus 200, including:
a user right obtaining module 210, configured to obtain right information of a login user;
the data query entry module 220 is used for providing a corresponding statistical data query entry for the user according to the authority information of the user;
a user query request receiving module 230, configured to receive a request for querying statistical data from a user;
a historical statistical data obtaining module 240, configured to obtain historical statistical data, where the historical statistical data is obtained by processing device state data before a preset time point;
a current statistical data generating module 250, configured to obtain device state data after a preset time point and process the device state data to obtain current statistical data;
a final statistical data synthesis module 260 for combining the historical statistical data and the current statistical data to generate final statistical data;
and a final statistical data presentation module 270, configured to present the final statistical data to the user.
In an alternative embodiment, the statistical data management device 200 based on the internet of things further comprises a history data generation module for generating history data, the history data generation module comprises the following units,
the data detection unit is used for detecting whether the equipment state data changes;
the data storage unit is used for storing the current equipment state data when the equipment state data changes;
the data acquisition unit is used for periodically acquiring all the stored equipment state data in a preset time period;
the data processing unit is used for processing the acquired equipment state data to generate historical statistical data;
and the historical statistical data storage unit is used for storing the generated historical statistical data.
In an optional embodiment, the device state data detected in the data detection unit is device state data of all devices under any authority.
In an alternative embodiment, the historical statistical data storage unit is configured to store the generated historical statistical data in the server and the browser, respectively.
For the device embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.
Example 3:
fig. 3 is a schematic structural diagram of an internet of things platform provided in embodiment 3 of the present application, and as shown in fig. 3, the internet of things platform includes:
one or more processors 310 and a memory 320, one processor 310 being illustrated in fig. 3. The internet of things platform can also comprise: an input device 330 and an output device 340.
The memory 320 is a non-volatile computer-readable storage medium, and can be used to store non-volatile software programs, non-volatile computer-executable programs, and modules, such as program instructions/modules corresponding to the statistical data management method based on the internet of things in the embodiment of the present application.
The processor 310 executes various functional applications and data processing by running nonvolatile software programs, instructions and modules stored in the memory 320, so as to implement the statistical data management method based on the internet of things according to the above method embodiment.
The memory 320 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the internet-of-things-based statistical data management device, and the like. Further, the memory 320 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some embodiments, the memory 320 may optionally include memory located remotely from the processor 310, which may be connected to the internet of things based statistics management device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 330 may receive input numeric or character information and generate signal inputs related to user settings and function control. The output device 340 may include a display device such as a display screen.
The one or more modules are stored in the memory 320 and, when executed by the one or more processors 310, perform the statistical data management method of any of the method embodiments described above.
The product can execute the method provided by the embodiment of the application, and has the corresponding functional modules and beneficial effects of the execution method. For technical details that are not described in detail in this embodiment, reference may be made to the methods provided in the embodiments of the present application.
Example 4:
embodiment 4 of the present invention provides a computer-readable storage medium, in which one or more programs including execution instructions are stored, where the execution instructions can be read and executed by a device (including but not limited to a computer, a server, or a network device, etc.) to perform relevant steps in the above-described method embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technical content can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the scheme of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: u disk, ROM, RAM, removable hard disk, magnetic or optical disk, etc. for storing program codes.
The foregoing is only an alternative embodiment of the present invention, and it should be noted that modifications and embellishments could be made by those skilled in the art without departing from the principle of the present invention, and these should be considered as the protection scope of the present invention.
Claims (10)
1. The statistical data management method based on the Internet of things comprises the following steps,
acquiring authority information of a login user;
providing a corresponding statistical data query entry for the user according to the authority information of the user;
receiving a request of a user for inquiring statistical data;
acquiring historical statistical data, wherein the historical statistical data is obtained by processing equipment state data before a preset time point;
acquiring and processing equipment state data after a preset time point to obtain current statistical data;
combining the historical statistical data and the current statistical data to generate final statistical data;
and displaying the final statistical data to a user.
2. The method of claim 1, wherein the historical statistical data is generated by a method comprising the steps of,
detecting whether the equipment state data changes;
if the equipment state data changes, storing the equipment state data at the moment;
periodically acquiring all stored equipment state data in a preset time period;
processing the acquired equipment state data to generate historical statistical data;
the generated historical statistics are saved.
3. The method according to claim 2, wherein in the process of detecting whether the device status data changes, the detected device status data is the device status data of all devices under any authority.
4. The method of claim 2, wherein saving the generated historical statistics comprises storing the generated historical statistics in a server and a browser, respectively.
5. The statistical data management device based on the Internet of things is characterized by comprising the following modules,
the user authority acquisition module is used for acquiring authority information of a login user;
the data query entry module is used for providing a corresponding statistical data query entry for the user according to the authority information of the user;
the user inquiry request receiving module is used for receiving a request of a user for inquiring the statistical data;
the historical statistical data acquisition module is used for acquiring historical statistical data, and the historical statistical data is obtained by processing equipment state data before a preset time point;
the current statistical data generation module is used for acquiring and processing equipment state data after a preset time point to obtain current statistical data;
the final statistical data synthesis module is used for combining the historical statistical data and the current statistical data to generate final statistical data;
and the final statistical data display module is used for displaying the final statistical data to the user.
6. The method of claim 5, further comprising a historical data generation module for generating historical data, the historical data generation module comprising the following elements,
the data detection unit is used for detecting whether the equipment state data changes;
the data storage unit is used for storing the current equipment state data when the equipment state data changes;
the data acquisition unit is used for periodically acquiring all the stored equipment state data in a preset time period;
the data processing unit is used for processing the acquired equipment state data to generate historical statistical data;
and the historical statistical data storage unit is used for storing the generated historical statistical data.
7. The apparatus according to claim 6, wherein the device status data detected in the data detection unit is device status data of all devices under any authority.
8. The apparatus according to claim 6, wherein the historical statistical data storage unit is configured to store the generated historical statistical data in the server and the browser, respectively.
9. An internet of things platform, comprising a processor and a memory, wherein the memory stores at least one instruction, at least one program, a set of codes, or a set of instructions, and the at least one instruction, the at least one program, or the set of instructions is loaded and executed by the processor to implement the internet of things based statistical data management method according to any one of claims 1 to 4.
10. A computer-readable storage medium having stored therein at least one instruction, at least one program, a set of codes, or a set of instructions, which is loaded and executed by a processor to implement the method of internet of things based statistics management according to any of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910812239.1A CN110619006A (en) | 2019-08-30 | 2019-08-30 | Statistical data management method, device, platform and storage medium based on Internet of things |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910812239.1A CN110619006A (en) | 2019-08-30 | 2019-08-30 | Statistical data management method, device, platform and storage medium based on Internet of things |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110619006A true CN110619006A (en) | 2019-12-27 |
Family
ID=68922809
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910812239.1A Pending CN110619006A (en) | 2019-08-30 | 2019-08-30 | Statistical data management method, device, platform and storage medium based on Internet of things |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110619006A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112506926A (en) * | 2020-12-03 | 2021-03-16 | 广州华多网络科技有限公司 | Monitoring data storage and query method and corresponding device, equipment and medium |
| CN114138868A (en) * | 2021-12-03 | 2022-03-04 | 中科三清科技有限公司 | Method and device for drawing air quality statistical distribution map |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103957248A (en) * | 2014-04-21 | 2014-07-30 | 中国科学院软件研究所 | Public real-time data management cloud service platform based on Internet of Things |
| CN105243161A (en) * | 2015-10-29 | 2016-01-13 | 国网内蒙古东部电力有限公司经济技术研究院 | Information inquiry system and method |
| CN106446170A (en) * | 2016-09-27 | 2017-02-22 | 努比亚技术有限公司 | Data querying method and device |
| CN106682232A (en) * | 2017-01-13 | 2017-05-17 | 西安电子科技大学 | Statistical statement generating method of vehicle monitoring system |
| CN107402969A (en) * | 2017-06-28 | 2017-11-28 | 郑州云海信息技术有限公司 | A kind of storage performance statistical method and system |
| CN107895124A (en) * | 2017-11-13 | 2018-04-10 | 东信和平科技股份有限公司 | The production information management method and relevant apparatus of a kind of smart card |
-
2019
- 2019-08-30 CN CN201910812239.1A patent/CN110619006A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103957248A (en) * | 2014-04-21 | 2014-07-30 | 中国科学院软件研究所 | Public real-time data management cloud service platform based on Internet of Things |
| CN105243161A (en) * | 2015-10-29 | 2016-01-13 | 国网内蒙古东部电力有限公司经济技术研究院 | Information inquiry system and method |
| CN106446170A (en) * | 2016-09-27 | 2017-02-22 | 努比亚技术有限公司 | Data querying method and device |
| CN106682232A (en) * | 2017-01-13 | 2017-05-17 | 西安电子科技大学 | Statistical statement generating method of vehicle monitoring system |
| CN107402969A (en) * | 2017-06-28 | 2017-11-28 | 郑州云海信息技术有限公司 | A kind of storage performance statistical method and system |
| CN107895124A (en) * | 2017-11-13 | 2018-04-10 | 东信和平科技股份有限公司 | The production information management method and relevant apparatus of a kind of smart card |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112506926A (en) * | 2020-12-03 | 2021-03-16 | 广州华多网络科技有限公司 | Monitoring data storage and query method and corresponding device, equipment and medium |
| CN114138868A (en) * | 2021-12-03 | 2022-03-04 | 中科三清科技有限公司 | Method and device for drawing air quality statistical distribution map |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11733982B1 (en) | Dynamically changing input data streams processed by data stream language programs | |
| CN107391538B (en) | Click data acquisition, processing and display method, device, equipment and storage medium | |
| US11580136B2 (en) | Method and apparatus of user clustering, computer device and medium | |
| CN109313642B (en) | Bill information caching method, bill information query method and terminal equipment | |
| RU2622850C2 (en) | Method and server for processing product identifiers and machine-readable storage medium | |
| CN111639965B (en) | Integral updating method and device | |
| CN112860737B (en) | Data query method and device, electronic equipment and readable storage medium | |
| CN111814045A (en) | Data query method and device, electronic equipment and storage medium | |
| CN110619006A (en) | Statistical data management method, device, platform and storage medium based on Internet of things | |
| CN110597860A (en) | Data identification method and device, electronic equipment and medium | |
| CN111258819A (en) | Data acquisition method, device and system for MySQL database backup file | |
| CN108959514B (en) | Data processing method and device | |
| CN110851758B (en) | Webpage visitor quantity counting method and device | |
| CN113222408A (en) | Online inquiry service monitoring method, device, equipment and storage medium | |
| CN108897796B (en) | Method for calling Influxdb database by service system, storage medium and server | |
| CN115713395A (en) | Flink-based user wind control management method, device and equipment | |
| CN112699149B (en) | Target data acquisition method and device, storage medium and electronic device | |
| WO2019019596A1 (en) | Breakpoint list processing method, device, server and medium | |
| CN114531374A (en) | Network monitoring method, device, equipment and storage medium | |
| CN114048231A (en) | Data processing method, device and computer program product | |
| US10558647B1 (en) | High performance data aggregations | |
| CN113515541A (en) | Data query method, device and system of database | |
| CN111198900A (en) | Data caching method and device for industrial control network, terminal equipment and medium | |
| CN111131393B (en) | User activity data statistical method, electronic device and storage medium | |
| CN112215369A (en) | Method, device, equipment and storage medium for determining effectiveness of nuclear power plant maintenance |
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 |