1 / 22

ODBC interface for Remote Wireless Sensor Network

ODBC interface for Remote Wireless Sensor Network. Jun Ma Jun.Ma@csiro.au. What is Wireless Sensor Network. This wireless sensor is called a “ mote ”. It’s a small-scale computers with sensors , a microprocessor , RF communication and battery .

wren
Download Presentation

ODBC interface for Remote Wireless Sensor Network

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ODBC interface for Remote Wireless Sensor Network Jun Ma Jun.Ma@csiro.au

  2. What is Wireless Sensor Network • This wireless sensor is called a “mote”. It’s a small-scale computers with sensors, a microprocessor, RF communication and battery. • It is intended to be very small and very cheap so that it can be massively distributed.

  3. What is Wireless Sensor Network • A number of wireless sensors forms an wireless adhoc network which provides functionality like message routing. • WSN can be used in a wide range of applications, including environmental monitoring, surveillance, smart buildings, health, traffic monitoring, and military systems.

  4. What is Remote WSN • A wireless sensor network deployed at very remote locations. • Data is collected remotely through telephone network like GPRS or CDMA.

  5. A Database for WSNs • TinyDB is a database system written in java for extracting information from a WSN.

  6. Project Motivation • We can’t interface with WSN like a standard database. • WSN can be much easier to use if it could be used directly from the standard tools for programmatically interfacing with database.

  7. Objective • Improve usability of WSN by providing a standard ODBC interface between TinyDB and most normally available database tools. • Map the sensor network to a database paradigm. • Make the whole sensor network looks like an standard database table.

  8. Software platform • An ODBC driver for Windows platform. • Wireless sensor runs TinyOS which is an open-source operating system designed specially for wireless embedded sensor networks. • GPRS modem runs Nut/OS which is an open-source operating system designed for Atmel microcontroller. • TinyDB which is a database engine for WSN. • TinyDB proxy which is a java application which translates SQL query into something motes can understand. • Programming language: C, C++ and Java

  9. Driver Development • An ODBC driver is a DLL on windows platform. • The driver implements functions specified in the ODBC standard. • The driver must make sure the ODBC functions are called in correct sequence. • Sending query to TinyDB Proxy server • Retrieving data from the XMLBlaster server. • Decoding TinyDB binary messages. • Mapping errors to ODBC SQLSTATEs.

  10. Programming Considerations • Make the ODBC driver fully thread-safe, so that the driver can handle an ODBC call from any thread at any time . • The ODBC driver resides in the same memory space of the user application. • All the ODBC functions must be exported with its original name using a module-definition (.DEF) file instead of __declspec(dllexport). • A event logger is needed for debugging.

  11. Research issues • Supporting TinyDB specific SQL . • How effectively can a sensor network be mapped to database paradigm. • Balancing query latency vs. power consumption.

  12. Supporting TinyDB specific SQL . • If a query contains TinyDB-Speicific SQL, the driver sends it to TinyDB proxy for processing. • A SAMPLE PERIOD is appended to SQL queries if it doesn’t exist. • Replace “*” in the query with a list of all available attributes in the sensor network.

  13. Mapping sensor network to database paradigm

  14. Balancing query latency vs. power consumption. • Polling instead of continuous sampling saves power. • Changing the schedule scheme to balance power consumption vs. latency.

  15. Summary • With an standard ODBC interface, Wireless Sensor networks have greater usability, functionality, extensibility and ease of integration. • However some new restrictions like large latency and difficulties with event driven sampling are introduced.

  16. Any Questions?

  17. Function Sequence • Applications retrieve data from ODBC driver by calling functions in a certain sequence.

  18. Decorated Name DEF file LIBRARY ODBCWSN EXPORTS ;SQLAllocConnect @1 ;SQLAllocEnv @2 ;SQLAllocStmt @3 ;SQLBindCol @4 ;SQLCancel @5

  19. TinyDB packet

More Related