CN106294829A - A method and device for constructing an Internet of Things database - Google Patents

Abstract

The invention is suitable for the field of construction of an Internet of things database, and provides a method and a device for constructing an Internet of things database, wherein the method for constructing the Internet of things database comprises the following steps: forming an unchangeable data storage node of the Internet of things by creating one or a combination of sensor node information, historical data and historical alarms; the method comprises the steps that a constant Internet of things data storage node is formed by creating one or a combination of real-time data and real-time alarms; the classified storage framework of the Internet of things database is constructed by configuring the unchangeable Internet of things data storage nodes and the invariable Internet of things data storage nodes. The invention solves the problems that the existing Internet of things database cannot construct a classified storage frame of the Internet of things database, and the data storage of the Internet of things is easy to generate redundancy. The method has the advantages that on one hand, the defect that the large data storage of the Internet of things is redundant is overcome, certain space is saved for data storage, and on the other hand, the intelligent degree of classification of the database of the Internet of things is improved.

Description

A method and device for constructing an Internet of Things database

technical field

The invention belongs to the field of building an Internet of Things database, and in particular relates to a method and a device for building an Internet of Things database.

Background technique

Through the establishment of the smart city Internet of Things, people's lives can be made more convenient and it is easier to obtain relevant information about their own cities. The most important part of establishing the smart city Internet of Things is the storage of Internet of Things data. The data of the Internet of Things is stored in urban sensors. collected data.

However, the current IoT data storage is prone to redundancy, which is not conducive to improving the storage efficiency of IoT data. The reason is that the current IoT databases generally only send and receive IoT data, and the scale of IoT data is relatively large, so it is particularly important to build an efficient IoT database.

Contents of the invention

The purpose of the embodiments of the present invention is to provide a method for building an Internet of Things database, which aims to solve the problem that the current Internet of Things database cannot construct a classified storage framework for an Internet of Things database, and the data storage of the Internet of Things is prone to redundancy, which is not conducive to improving the storage of Internet of Things data The question of efficiency.

The embodiment of the present invention is achieved in this way, a method for building an Internet of Things database, comprising:

By creating one or a combination of sensor node information, historical data, and historical alarms, an invariable IoT data storage node is formed;

By creating one of real-time data, real-time alarms or a combination thereof, a constantly changing IoT data storage node is formed;

By configuring the non-changing IoT data storage nodes and the constantly changing IoT data storage nodes, a classified storage framework for the IoT database is constructed.

Another object of the embodiments of the present invention is to provide a device for building an Internet of Things database, including:

A noise signal generating module, configured to use a microphone to collect noise and generate a noise signal;

The invariant IoT data storage node building block is used to form an invariable IoT data storage node by creating sensor node information, historical data, historical alarms or a combination thereof;

The constantly changing IoT data storage node building block is used to form a constantly changing IoT data storage node by creating one of real-time data, real-time alarms or a combination thereof;

The Internet of Things database classification storage framework building module is used to construct the Internet of Things database classification storage framework by configuring invariant Internet of Things data storage nodes and constant Internet of Things data storage nodes.

In the embodiment of the present invention, by configuring the non-changing IoT data storage nodes and the constantly changing IoT data storage nodes, the classified storage framework of the IoT database is constructed, which solves the problem that the current IoT database cannot construct the classified storage of the IoT database Framework, IoT data storage is prone to redundancy, which is not conducive to improving the storage efficiency of IoT data. The beneficial effect lies in two aspects. On the one hand, it solves the disadvantage of redundancy in the big data storage of the Internet of Things and saves a certain space for data storage; on the other hand, it improves the intelligence of the classification of the Internet of Things database.

Description of drawings

Fig. 1 is the implementation flow chart of the method for building the Internet of Things database provided by the embodiment of the present invention;

Fig. 2 is an embodiment of the present invention describing the implementation flow chart of storing Internet of Things data;

FIG. 3 is a first implementation flowchart of step S202 of storing Internet of Things data provided by an embodiment of the present invention;

FIG. 4 is a second implementation flowchart of step S202 of storing Internet of Things data provided by an embodiment of the present invention;

Fig. 5 is the implementation flowchart of the Internet of Things data update provided by the embodiment of the present invention;

Fig. 6 is a better sample diagram of the classified storage framework of the Internet of Things database provided by the embodiment of the present invention;

Fig. 7 is a structural block diagram of an apparatus for building an Internet of Things database provided by an embodiment of the present invention.

detailed description

In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

Embodiment one

Fig. 1 is the implementation flowchart of the Internet of Things database construction method provided by the embodiment of the present invention, detailed description is as follows:

In step S101, an invariable IoT data storage node is formed by creating one of sensor node information, historical data, and historical alarms or a combination thereof;

In step S102, by creating one of real-time data, real-time alarm or a combination thereof, a constantly changing IoT data storage node is formed;

In step S103, by configuring the non-changing IoT data storage nodes and the constantly changing IoT data storage nodes, a classified storage framework of the IoT database is constructed.

Steps S101 and S102 are executed first, and then step S103 is executed.

Step S101 and step S102 are performed in no particular order, and the order of execution is described as follows:

Simultaneously step S101 and step S102; or, execute step S101 first, then execute step S102;

Step S102 is executed first, and then step S101 is executed.

Among them, the method for building the Internet of Things database also includes:

classifying the Internet of Things data into non-changing Internet of Things data and constant-changing Internet of Things data;

The constructed IoT database classification storage framework is adopted to store infrequently changing IoT data and constantly changing IoT data.

Wherein, the Internet of Things data is divided into non-changing Internet of Things data and constant-changing Internet of Things data, specifically:

Reading sensor node information, historical monitoring data, historical abnormal data, real-time monitoring data and real-time abnormal data in the Internet of Things data;

Classify sensor node information, historical monitoring data, and historical anomaly data into invariant IoT data;

Classify real-time monitoring data and real-time abnormal data into constantly changing IoT data.

In the embodiment of the present invention, it is solved that the current Internet of Things database cannot construct a classified storage framework of the Internet of Things database, and the data storage of the Internet of Things is prone to redundancy, which is not conducive to improving the storage efficiency of the Internet of Things data. The beneficial effect lies in two aspects. On the one hand, it solves the disadvantage of redundancy in the big data storage of the Internet of Things and saves a certain space for data storage; on the other hand, it improves the intelligence of the classification of the Internet of Things database.

Embodiment two

Fig. 2 is an embodiment of the present invention describing the implementation flow chart of storing Internet of Things data, which is described in detail as follows:

In step S201, the Internet of Things data is acquired;

In step S202, the acquired Internet of Things data is stored by adopting the classified storage framework of the constructed Internet of Things database.

Embodiment three

Fig. 3 is a first implementation flowchart of the step S202 of storing Internet of Things data provided by an embodiment of the present invention, which is described in detail as follows:

In step S301, the constructed Internet of Things database classification storage framework is used to store infrequently changing Internet of Things data through inconstantly changing Internet of Things data storage nodes;

In step S302, the constantly changing Internet of Things data is stored through the constantly changing Internet of Things data storage node.

Embodiment four

FIG. 4 is a second implementation flow chart of the step S202 of storing Internet of Things data provided by an embodiment of the present invention, which is described in detail as follows:

In step S401, using the constructed Internet of Things database classification storage framework, the information of sensor nodes accessing the Internet of Things is stored in the sensor node information in the invariable Internet of Things data storage nodes;

In step S402, storing historical monitoring data in the Internet of Things data to historical data in an invariable Internet of Things data storage node;

In step S403, storing the historical abnormal data in the Internet of Things data to the historical alarm in the invariant Internet of Things data storage node;

In step S404, the real-time monitoring data in the Internet of Things data is stored to the real-time data in the constantly changing Internet of Things data storage node;

In step S405, the real-time abnormal data in the Internet of Things data is stored in real-time alarms in the ever-changing Internet of Things data storage nodes.

Step S401 is executed first, and then steps S402-S405 are executed.

Steps S402-S405 are executed in no particular order, and the execution order is described as follows:

Simultaneous steps S402-S405; or,

Perform any one of steps S402-S405 first, and then perform the remaining steps, for example:

Execute step S402 first, and then execute steps S403-S405; or,

Steps S403-S405 are executed first, and then step S402 is executed.

Embodiment five

Fig. 5 is the implementation flowchart of the Internet of Things data update provided by the embodiment of the present invention, which is described in detail as follows:

In step S501, between the real-time data and the sensor node information, configure the Internet of Things real-time data update channel, and use the Internet of Things real-time data update channel to update the real-time data;

In step S502, configure an IoT real-time alarm update channel between the real-time alarm and sensor node information, and use the IoT real-time alarm update channel to update the real-time alarm;

In step S503, an Internet of Things historical alarm update channel is configured between the historical alarm and the sensor node information, and the historical alarm is updated by using the Internet of Things historical alarm update channel;

In step S504, an Internet of Things real-time alarm update channel is configured between the real-time alarm and sensor node information, and the real-time alarm is updated using the Internet of Things real-time alarm update channel.

Step S501 is executed first, and then steps S502-S504 are executed.

Steps S502-S504 are executed in no particular order, and the execution order is described as follows:

Simultaneous steps S502-S504; or,

Perform any one of steps S502-S504 first, and then perform the remaining steps, for example:

Execute step S502 first, and then execute steps S503-S504; or,

Steps S503-S504 are executed first, and then step S502 is executed.

Embodiment six

Fig. 6 is a preferred sample diagram of the classified storage framework of the Internet of Things database provided by the embodiment of the present invention, which is described in detail as follows:

The classified storage framework of the Internet of Things database includes five parts, namely: sensor node information, real-time data, historical data, real-time alarms and historical alarms.

Sensor node information: stores the information of sensor nodes connected to the Internet of Things, including but not limited to: sensor type, sensor alarm value or alarm upper and lower limits, geographical location of sensor, and gateway connected by sensor.

Real-time data: Store the data that the database sensor transmits to the client server in real time, that is, the data that the customer needs to monitor.

Historical data: Store historical data that customers need to monitor.

Real-time alarm: store whether the data monitored by the sensor is normal, and when the monitored data is abnormal, record the abnormal data and trigger an alarm.

Historical alarm: record every abnormal data.

Real-time data, historical data, real-time alarms and historical alarms must be associated with sensor node information. When updating real-time data, you must first find the corresponding node in the sensor node information, and then update the corresponding real-time data according to the association between sensor node information and real-time data. .

Inserting historical data is similar. When inserting historical data, the historical data corresponding to the node must be inserted according to the association between sensor node information and historical data.

The update of the real-time alarm is based on comparing the real-time data with the alarm value or upper and lower alarm limits in the associated sensor node information to determine whether to alarm, and if there is an alarm, update the real-time alarm data associated with the node.

The insertion of historical data is similar to the update of real-time data. It is based on the comparison of the real-time data with the alarm value or upper and lower alarm limits in the associated sensor node information to determine whether to alarm. If there is an alarm, insert the historical alarm data associated with the node.

Embodiment seven

Fig. 7 is a structural block diagram of an apparatus for building an Internet of Things database provided by an embodiment of the present invention, which can run in electronic equipment, including but not limited to mobile phones with processors, laptop computers or tablet computers. other portable devices. It should also be understood that in some embodiments, the device is not a portable communication device, but a desktop computer. For ease of description, only the parts related to this embodiment are shown.

With reference to Fig. 7, this Internet of Things database construction device comprises:

The non-changing IoT data storage node building module 71 is used to create one or a combination of sensor node information, historical data, and historical alarms to form a non-changing IoT data storage node;

The constantly changing IoT data storage node construction module 72 is used to form a constantly changing IoT data storage node by creating one of real-time data, real-time alarms or a combination thereof;

The Internet of Things database classified storage framework building module 73 is configured to construct an Internet of Things database classified storage framework by configuring non-changing Internet of Things data storage nodes and constant-changing Internet of Things data storage nodes.

As an implementation of this embodiment, in the IoT database construction device, the IoT database construction device also includes:

The Internet of Things data acquisition module is used to obtain the Internet of Things data;

The Internet of Things data storage module is used to store the obtained Internet of Things data by adopting the constructed Internet of Things database classification storage framework.

As an implementation of this embodiment, in the IoT database construction device, the IoT data storage module further includes:

The non-changing IoT data storage unit is used to store the non-changing IoT data through the non-changing IoT data storage nodes using the constructed IoT database classification storage framework;

The constantly changing Internet of Things data storage unit is used to store the constantly changing Internet of Things data through the constantly changing Internet of Things data storage nodes.

As an implementation of this embodiment, in the IoT database construction device, the IoT data storage module includes:

The sensor node information storage unit is used to adopt the constructed Internet of Things database classification storage framework to store the information of sensor nodes connected to the Internet of Things to the sensor node information in the invariable Internet of Things data storage nodes;

The historical monitoring data storage unit is used to store the historical monitoring data in the Internet of Things data to the historical data in the invariable Internet of Things data storage nodes;

The historical abnormal data storage unit is used to store the historical abnormal data in the Internet of Things data to the historical alarms in the invariable Internet of Things data storage nodes;

The real-time monitoring data storage unit is used to store the real-time monitoring data in the Internet of Things data to the real-time data in the constantly changing Internet of Things data storage nodes;

The real-time abnormal data storage unit is used to store the real-time abnormal data in the IoT data to the real-time alarms in the ever-changing IoT data storage nodes.

As an implementation of this embodiment, in the IoT database construction device, the IoT database construction device further includes:

The real-time data update module is used to configure the Internet of Things real-time data update channel between the real-time data and the sensor node information, and utilizes the real-time data update channel of the Internet of Things to update the real-time data;

The real-time alarm update module is used to configure the real-time alarm update channel of the Internet of Things between the real-time alarm and the sensor node information, and update the real-time alarm by using the real-time alarm update channel of the Internet of Things;

The historical alarm update module is used to configure the historical alarm update channel of the Internet of Things between the historical alarm and the sensor node information, and update the historical alarm by using the historical alarm update channel of the Internet of Things;

The real-time alarm update module is configured to configure a real-time alarm update channel of the Internet of Things between the real-time alarm and sensor node information, and update the real-time alarm by using the real-time alarm update channel of the Internet of Things.

The apparatus provided by the embodiment of the present invention may be applied in the foregoing corresponding method embodiments. For details, refer to the description of the foregoing embodiments, and details are not repeated here.

Through the above description of the implementation manners, those skilled in the art can clearly understand that the present invention can be implemented by means of software plus necessary general-purpose hardware. The program can be stored in a readable storage medium, such as random access memory, flash memory, read-only memory, programmable read-only memory, electrically erasable programmable memory, registers, etc. The storage medium is located in the memory, and the processor reads the information in the memory, and executes the methods described in the various embodiments of the present invention in combination with its hardware.

The above is only a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Anyone skilled in the art can easily think of changes or substitutions within the technical scope disclosed in the present invention. All should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims (10)

1. an Internet of Things database construction method, it is characterised in that including:

By creating one or a combination set of sensor node information, historical data, history alarm, constitute the Internet of Things netting index seldom become According to memory node；

By creating one or a combination set of real time data, Real-time Alarm, constitute the Internet of Things data memory node often become；

By configuring the Internet of Things data memory node seldom become and the Internet of Things data memory node often become, construction networking number According to storehouse classification storing framework.

2. Internet of Things database construction method as claimed in claim 1, it is characterised in that described Internet of Things database sharing side Method also includes:

Obtain Internet of Things data；

The Internet of Things data base built is used to classify storing framework, the Internet of Things data that storage gets.

3. Internet of Things database construction method as claimed in claim 2, it is characterised in that the Internet of Things netting index that described employing builds According to storehouse classification storing framework, store the Internet of Things data got, particularly as follows:

Using the Internet of Things data base built to classify storing framework, by the Internet of Things data memory node seldom become, storage is not The Internet of Things data often become；

By the Internet of Things data memory node often become, the Internet of Things data that storage often becomes.

4. Internet of Things database construction method as claimed in claim 2 or claim 3, it is characterised in that the Internet of Things that described employing builds Grid database classification storing framework, the Internet of Things data that storage gets, particularly as follows:

Using the Internet of Things data base built to classify storing framework, the information that sensor node accesses Internet of Things stores to seldom Sensor node information in the Internet of Things data memory node become；

Historical Monitoring data in described Internet of Things data are stored the history to the Internet of Things data memory node seldom become Data；

History abnormal data in described Internet of Things data is stored the history to the Internet of Things data memory node seldom become Alarm；

Real-time number Real-time Monitoring Data in described Internet of Things data stored to the Internet of Things data memory node often become According to；

The real-time announcement real-time abnormal data in described Internet of Things data stored to the Internet of Things data memory node often become Alert.

5. Internet of Things database construction method as claimed in claim 1, it is characterised in that described Internet of Things database sharing side Method, also includes:

Between real time data and sensor node information, configure Internet of Things real time data more new tunnel, utilize described Internet of Things Real time data more new tunnel, updates real time data；

Between Real-time Alarm and sensor node information, configure Internet of Things Real-time Alarm more new tunnel, utilize described Internet of Things Real-time Alarm more new tunnel, updates Real-time Alarm；

Between history alarm and sensor node information, configure Internet of Things history alarm more new tunnel, utilize described Internet of Things History alarm more new tunnel, updates history alarm；

Between Real-time Alarm and sensor node information, configure Internet of Things Real-time Alarm more new tunnel, utilize described Internet of Things Real-time Alarm more new tunnel, updates Real-time Alarm.

6. an Internet of Things database sharing device, it is characterised in that including:

The Internet of Things data memory node seldom become builds module, for by creating sensor node information, historical data, going through One or a combination set of history alarm, constitutes the Internet of Things data memory node seldom become；

The Internet of Things data memory node often become builds module, for by creating one of real time data, Real-time Alarm or its group Close, constitute the Internet of Things data memory node often become；

Internet of Things data base storing framework of classifying builds module, for by configure the Internet of Things data memory node that seldom becomes and The Internet of Things data memory node often become, construction networking data storehouse classification storing framework.

7. Internet of Things database sharing device as claimed in claim 6, it is characterised in that described Internet of Things database sharing fills Put and also include:

Internet of Things data acquisition module, is used for obtaining Internet of Things data；

Internet of Things data memory module, for using the Internet of Things data base of structure to classify storing framework, the thing that storage gets Networking data.

8. Internet of Things database sharing device as claimed in claim 7, it is characterised in that described Internet of Things data storage mould Block, also includes:

The Internet of Things data storage cell seldom become, for using the Internet of Things data base of structure to classify storing framework, by not The Internet of Things data memory node often become, the Internet of Things data that storage seldom becomes；

The Internet of Things data storage cell often become, for the Internet of Things data memory node by often becoming, the Internet of Things that storage often becomes Network data.

9. Internet of Things database sharing device as claimed in claim 7 or 8, it is characterised in that described Internet of Things data store Module, including:

Sensor node information memory cell, for using the Internet of Things data base of structure to classify storing framework, saves sensor Point accesses the information of Internet of Things and stores the sensor node information to the Internet of Things data memory node seldom become；

Historical Monitoring data storage cell, for storing the Historical Monitoring data in described Internet of Things data to the thing seldom become Historical data in networking data memory node；

History abnormal data memory element, for storing the history abnormal data in described Internet of Things data to the thing seldom become History alarm in networking data memory node；

Real-time Monitoring Data memory element, for storing the Real-time Monitoring Data in described Internet of Things data to the Internet of Things often become Real time data in network data memory node；

Abnormal data memory element in real time, for storing the real-time abnormal data in described Internet of Things data to the Internet of Things often become Real-time Alarm in network data memory node.

10. Internet of Things database sharing device as claimed in claim 6, it is characterised in that described Internet of Things database sharing Device, also includes:

Real time data more new module, between real time data and sensor node information, configuration Internet of Things real time data is more New tunnel, utilizes described Internet of Things real time data more new tunnel, updates real time data；

Real-time Alarm more new module, between Real-time Alarm and sensor node information, configuration Internet of Things Real-time Alarm is more New tunnel, utilizes described Internet of Things Real-time Alarm more new tunnel, updates Real-time Alarm；

History alarm more new module, between history alarm and sensor node information, configuration Internet of Things history alarm is more New tunnel, utilizes described Internet of Things history alarm more new tunnel, updates history alarm；

Real-time Alarm more new module, between Real-time Alarm and sensor node information, configuration Internet of Things Real-time Alarm is more New tunnel, utilizes described Internet of Things Real-time Alarm more new tunnel, updates Real-time Alarm.