data storage and query method and an Internet of Things system

A data storage and data table technology, applied in the field of the Internet of Things, can solve the problems of inconvenient equipment dynamic construction system, affecting system work efficiency, and uneven distribution of various tables, so as to improve development efficiency, reduce traversal range, and increase read and write speed Effect

Active Publication Date: 2019-05-24
青岛聚好联科技有限公司
View PDF9 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Therefore, there are the following disadvantages in the Internet of Things system for data sub-table storage shown in the prior art: 1. In the Internet of Things system, there are constantly new information sensing devices connected, the number of information sensing devices changes dynamically, and the fixed distribution The table will cause uneven distribution of each table; 2. Pre-entering the group number is equivalent to solidifying the identity of the device. It is not convenient to use these devices to dynamically build a system, which will affect the efficiency of the system.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • data storage and query method and an Internet of Things system
  • data storage and query method and an Internet of Things system
  • data storage and query method and an Internet of Things system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0064] see Figure 5 , the system shown in embodiment 1 also includes:

[0065] The information processing unit is used to receive the instruction uploaded by the intelligent terminal transmitted by the central processor, and determine the type of the instruction, and the instruction includes the target device ID;

[0066] In the Internet of Things system, the user queries the monitoring data of the information sensing device or controls the information sensing device through the smart terminal; the technical solution shown in the embodiment of the application judges the type of the instruction by adding an information processing unit, and transmits the instruction to the Corresponding read and write units, to perform corresponding control or query operations.

[0067] For example, the user queries the user's electricity consumption monitored by the electric meter through the smart terminal; another example, the user controls the opening and closing of the smart air condition...

Embodiment 3

[0081] In recent years, smart home technology has developed rapidly, and various smart home devices such as smart air conditioners, smart doors and windows, and smart speakers are becoming more and more diversified. Millions of information sensing devices are connected to the Internet of Things system. The continuous addition of data, as well as the accumulation of monitoring data uploaded by information sensing devices, the fixed data table cannot satisfy the accumulation and writing of data at all. In order to solve the above problems, a fourth read-write unit is added to the system shown in the embodiment of the present application.

[0082] see Figure 6 or Figure 7 , the system shown in embodiment 1 or embodiment 2 also includes a fourth reading and writing unit, wherein:

[0083] The first table processing subunit is further configured to construct a second data table set when the records in the data table are greater than the storage threshold, construct a second data...

Embodiment 4

[0091] In recent years, with the rapid development of smart home technology, various smart home devices such as smart air conditioners, smart doors and windows, and smart speakers are becoming increasingly diversified. Millions of information sensing devices are connected to the Internet of Things system. At the same time, new users continue to Adding, and the accumulation of monitoring data uploaded by information sensor devices, when the data recorded in the data table of the Internet of Things system reaches millions or tens of millions, the data query and reading operations are particularly slow, exceeding the Internet of Things business acceptance. range of capabilities.

[0092] In order to solve the above problems, the embodiment of this application shows a data processing method for automatic table division, please refer to Figure 8 , the method includes:

[0093] S101 Receive device information and monitoring data uploaded by an information sensing device, wherein t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The embodiment of the invention discloses a data storage and query method and an Internet of Things system. According to the technical scheme provided by the embodiment of the invention, the operationis simple; According to the technical scheme, data in the Internet of Things are stored in different data tables, the traversing range of a system in the query or control operation process is narrowed, the read-write speed of a database is increased, and meanwhile the equipment information and the monitoring data are written into the data tables according to the relation between the equipment IDand the data tables; Due to the fact that the device ID is unique, each device can be mapped into different tables through a certain rule. And even if new equipment is continuously accessed subsequently, the equipment can be randomly and averagely distributed in each data table. Moreover, according to the technical scheme provided by the embodiment of the invention, the number of the equipment does not need to be recorded in the information sensing equipment in advance, so that the development efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of the Internet of Things, in particular to a data storage and query method and an Internet of Things system. Background technique [0002] With the development of Internet of Things technology, there are more and more application service systems based on Internet of Things. Typical IoT-based application service systems such as figure 1 As shown, this system includes an IoT cloud platform server 1, an information sensing device 2, and an intelligent terminal 3. The information sensing device 2 and the intelligent terminal 3 are connected through the Internet of Things cloud platform server 1 according to the agreed protocol to perform information exchange and communication. [0003] In real life, the meter inquiry service system is like figure 1 or figure 2 system shown. In this specific application system, the information sensing device 2 is an electric meter, and each electric meter corresponds to a ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/27G06F16/25
Inventor 李冬冬
Owner 青岛聚好联科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap