The data model in TinyDB simply extends the traditional relational data
model. It defines the sensed data as a single, infinitely long logical table. The
table has two kinds of attributes. One is perceptive data attributes, such as
pressure, temperature, etc. The other kind of attributes describes the features
of the sensed data, the features and status of sensors such as sensorID, the data
type of the sensed data (light, voice, pressure, temperature, humidity) and the
measurement units of sensed data. This table conceptually contains one row
for each reading generated by any sensor, and hence the table can be thought
of streaming infinitely over time. Table 1 is an example of the relational table
for TinyDB. The operation set in an unlimited relational table is the extension
from a traditional relational algebraic to an unlimited relational table.
Table 1. An example of a relational table for TinyDB.
Sensor Query Time Humidity Light Tempe Horizontal Vertical Horizontal Vertical Voice Tone Original Original
ID Cycle -rature Acceleration Acceleration magnetometer magnetometer voice Tone
1 1 03.5.1 562 598 235 421 855 74 154 425 0.2 524 0.6
2 1 03.5.1 457 237 524 635 589 52 321 652 0.5 256 0.4
3 1 03.5.1 586 256 458 365 652 29 456 256 0.3 652 0.6
1 2 03.5.2 562 235 462 652 425 35 458 152 0.5 456 0.2
2 2 03.5.2 459 263 652 354 562 45 485 263 148 368 0.2
3 2 03.5.2 587 266 454 365 652 29 456 256 0.3 652 0.
Pages:
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473