Providing persistence for sensor data streams by remote WAL

  • Authors:
  • Hideyuki Kawashima;Michita Imai;Yuichiro Anzai

  • Affiliations:
  • Information and Computer Science, Keio University, Kohoku-ku, Yokohama, JAPAN;Information and Computer Science, Keio University, Kohoku-ku, Yokohama, JAPAN;Information and Computer Science, Keio University, Kohoku-ku, Yokohama, JAPAN

  • Venue:
  • DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

Rapidly changing environments such as robots, sensor networks, or medical services are emerging. To deal with them, DBMS should persist sensor data streams instantaneously. To achieve the purpose, data persisting process must be accelerated. Though write ahead logging (WAL) acceleration is essential for the purpose, only a few researches are conducted. To accelerate data persisting process, this paper proposes remote WAL with asynchronous checkpointing technique. Furthermore this paper designs and implements it. To evaluate the technique, this paper conducts experiments on an object relational DBMS called KRAFT. The result of experiments shows that remote WAL overwhelms performance disk based WAL. As for throughput evaluation, best policy shows about 12 times better performance compared with disk based WAL. As for logging time, the policy shows lower than 1000 micro seconds which is the period of motor data acquisition on conventional robots.