www.seipub.org/mef Marine Engineering Frontiers (MEF) Volume 1 Issue 2, May 2013 24 Efficient Database Management System For Wireless Sensor Network James Agajo 1 , Okhaifoh Joseph 2 , Onyebuchi Nosiri 3 ,Stephen Ufoaroh 4 1 Department of Electrical/Electronics Engineering, P.M.B 13, Auchi Polytechnic, Auchi Edo State, Nigeria 2 Department of Electrical/Electronics Engineering, Federal University of Petroleum Resources Effurun Delta State, Nigeria 3 Department of Electrical/Electronics Federal University of Technology Owerri Imo State, Nigeria 4 Department of Electronics and Computer Engineering Nnamdi Azikiwe University Awka Anambra State agajojul@yahoo.com Abstract An effective database management system has been put forward in this work to tackle the problem in remote monitoring using Wireless Sensor Network Object Oriented Analysis and Design method employed as classes was evolved to create objects in the employed program used. An algorithm was developed with a corresponding flowchart to realize the design, the work also came up with a dynamic graph plotter, as this offers an adaptive monitoring facility for data stored in the Database. Sensor Node query was implemented and result of transmitted data was filtered for a particular node. Keywords WS; Database; Query; Java; Oracle; C-Sharp Introduction Wireless Sensor Networks are composed of a set of (tiny) devices (hereafter called sensors), which are microsystems, each comprising a processor, a memory, a set of sensors, and a low-range, low-bandwidth radio transceiver. Sensors are powered by on board batteries thus their energy efficiency is critical in most applications. Applications of sensor networks include, amongst others, environment sampling, disaster areas monitoring, and health monitoring. This system allows interaction with a wireless sensor network as a traditional database management system. In a traditional database system queries are used to search for data contained in a persistent storage repository. In a wireless sensor network, the data base consists of the environmental data that can be measured and acquired by the transducers available on the sensor nodes. Queries instruct nodes on the management, filtering, and processing of the data acquired from the environment. The wireless sensor network and the software running on the nodes are the means that allow data to be acquired when needed from the environment, exactly in the way that a traditional database software allows data to be accessed on disks. In a wireless sensor network data is stored somewhere: environmental [4] data acquired by sensors of the nodes when needed, in accordance with the query that the network is being processing. A new data is available every time when a transducer is activated. [Ajit Warrier et.al] The high speeds of data transfer in wireless communication media have unlocked the doors for the development many applications like health care, military, security and disaster management. The wireless data transmit rates combined with web enabled computer system, is opening new fields on Internet services. Wireless sensor networks are made up of large number of sensor nodes. The sensor nodes which are densely deployed either inside a phenomenon or very close to it. The location of nodes need not be pre-determined or engineered. Recently developed nodes can be directly connected to the internet. The examined data needs to be stored for later analysis. Object-oriented databases for data storage have significant benefits to the applications that exercise complex object models, high concurrency requirements and large data sets. [BES (1998). Baltimore] The database approach is generally used for WSNs. It offers an easy-to-use interface and allows the user to query to the sensors to take out the data of interest. [5] have implemented an inquisitional query processing system. [Burns, R., Terzis, A., and Franklin, M] We make the case for a sensor network model where each node runs a database management system (DBMS), providing a rich query interface to the flash