Design of Tables in SQLite Database
In the system the main purpose of the use of the database
is storing and managing the sensors’ data information. It
also includes information on laboratory abnormalities and
information of the laboratory administrators. The storage of
the data is achieved by the tables in the database.
This system involves temperature sensor 18B20, broadspectrum
gas sensor MQ-2, sound sensor MIC, PIR Sensor
and humidity sensor HS1101, a total of five kinds. Because
the measured data of each sensor is single, it is enough to
store the data of all sensors in one table. This will also
facilitate the extraction of sensors’ data. At the same time,
when stores the data it also needs to add the time to each
entry. The following is a discussion of the size of the table.
Because the system inserts a message to the table per minute,
it can record almost the past two days’ information of the sensors if the table is fixed 2500 lines. This has already met
the requirement that record and query the historical
information. Of course, the size of the table can be adjusted
according to the need. The structural design of the sensor
data table is shown in Table 1. The meaning of every
attribute in the table and the introduction of the
corresponding storage