Towards Sensor Database Systems

Towards Sensor Database Systems

| Philippe Bonnet, Johannes Gehrke, Praveen Seshadri
The paper "Towards Sensor Database Systems" by Philippe Bonnet, Johannes Gehrke, and Praveen Seshadri introduces a new concept of sensor database systems, which are designed to handle long-running queries over a combination of stored data and sensor data. Traditional centralized systems for collecting sensor data lack flexibility and scalability due to their predefined data extraction methods and the transfer of large volumes of raw data. The authors propose a distributed approach where queries dictate which data is extracted from sensors, making the system more flexible and efficient. The paper defines a model for sensor databases, where stored data is represented as relations and sensor data as time series. Each long-running query defines a persistent view maintained during a given time interval. The authors also describe the design and implementation of the COUGAR sensor database system, which extends the Cornell PREDATOR object-relational database system. COUGAR uses Abstract Data Types (ADTs) to model sensors and signal-processing functions, and SQL with modifications to formulate sensor queries. Key contributions of the paper include: 1. Defining a data model and long-running query semantics for sensor databases. 2. Describing the design and implementation of the COUGAR system, which includes a mechanism for executing sensor ADT functions. 3. Discussing the limitations of the initial version of COUGAR and the conclusions drawn from the experience. The authors highlight the importance of addressing challenges such as sensor and communication failures, representing sensor data as measurements with uncertainty, and maintaining metadata in a decentralized manner. They also discuss related work and future research directions, emphasizing the potential of sensor database systems for flexible and scalable access to large sensor networks.The paper "Towards Sensor Database Systems" by Philippe Bonnet, Johannes Gehrke, and Praveen Seshadri introduces a new concept of sensor database systems, which are designed to handle long-running queries over a combination of stored data and sensor data. Traditional centralized systems for collecting sensor data lack flexibility and scalability due to their predefined data extraction methods and the transfer of large volumes of raw data. The authors propose a distributed approach where queries dictate which data is extracted from sensors, making the system more flexible and efficient. The paper defines a model for sensor databases, where stored data is represented as relations and sensor data as time series. Each long-running query defines a persistent view maintained during a given time interval. The authors also describe the design and implementation of the COUGAR sensor database system, which extends the Cornell PREDATOR object-relational database system. COUGAR uses Abstract Data Types (ADTs) to model sensors and signal-processing functions, and SQL with modifications to formulate sensor queries. Key contributions of the paper include: 1. Defining a data model and long-running query semantics for sensor databases. 2. Describing the design and implementation of the COUGAR system, which includes a mechanism for executing sensor ADT functions. 3. Discussing the limitations of the initial version of COUGAR and the conclusions drawn from the experience. The authors highlight the importance of addressing challenges such as sensor and communication failures, representing sensor data as measurements with uncertainty, and maintaining metadata in a decentralized manner. They also discuss related work and future research directions, emphasizing the potential of sensor database systems for flexible and scalable access to large sensor networks.
Reach us at info@study.space