Introduction

Schema

• Sensors: Sensor motes measure light, temperature, humidity, barometric pressure, and infrared readings, and produce a data stream with the following schema.
  
  

  Sensors(id          /* unique identifier of the sensor */,
          location    /* the location of the sensor */,
          light       /* the current light reading */,
          temperature /* the current temperature reading */,
          timestamp   /* time of measurement */);         
  

  
  
• Events: Sensors detect and report some special events like entry of a bird. The events are presented as a stream.
  
  

  Events(type      /* type of the event */ 
         location  /* location of the event */,
         timestamp /* time of event */);
  

  
  

Queries

• Queries in English
• Queries in CQL. The latest information on CQL is available here.

Queries in English

1. Data Collection Query: Report light readings from each sensor at the rate of one reading every 10 seconds.
   
   
2. Light Monitoring Query: Sample data from each sensor at the rate of one reading every second and monitor the average light over the last 30 seconds.
   
   
3. Event-Triggered Query: Whenever a sensor reports a bird-detection event, collect data from all sensors within 10 meters of the event at the rate of one reading every second for 10 seconds and report the average light and temperature.
   
   
4. Bird Counter Query: Keep a count of the number of times birds have entered a particular nest.
   
   
5. Delta Compression Query: Report the new light reading at a particular location every time it changes by 3.
   
   
6. Take Action Query: To keep birds and animals away from the sensors, apply a low electric pulse whenever an external body comes in contact with an active sensor on the field.