How does the application code read the sensors? For example, is there
a process for each sensor that hangs for a second and reads an IP
address? Are there multiple processes each of which polls a group of
sensors? Is there a device driver that reads the sensor data and
asynchronously e.g., via DMA, and puts the readings in a shared memory
What are the requirements for availability? Recoverability in the
Sounds like a nice little afternoon project with GT.M (http://fis-
On Mar 24, 6:27 am, Heiner Bunjes <h.bun...@googlemail.com> wrote:
> I need a database to log and retrieve sensor data.
> The scale is as follows:
> (01) Tenthousand sensors deliver 1 record per second each
> (02) They have to be stored for ~3 years
> (03) Each record has about 200 bytes
> (04) The system will start with just 700 sensors but will
> The main operations on the data are
> (05) Append the new records to the database
> (06) Return all records for sensor X with a timestamp
> (07) Return the records specified in (06) ordered by
> (08) Delete all records older than Y
> Further the following is true
> (09) The database system MUST be free and open source
> (10) The DB SHOULD be easy to administrate
> Which is the most appropriate database for this?
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.