期刊名称：International Journal of Computer Technology and Applications
电子版ISSN：2229-6093
出版年度：2012
卷号：3
期号：6
页码：2001-2005
出版社：Technopark Publications
摘要：Sensor networks are collection of sensor nodes which co-operatively send sensed data to base station. As sensor nodes are battery driven, an efficient utilization of power is essential in order to use networks for long duration hence it is needed to reduce data traffic inside sensor networks, reduce amount of data that need to send to base station. The aim of the project is to develop scalable aggregation methods to extract useful information from the data the sensors collect. Partitioning large set of data, for the result of horizontal aggregation, in to homogeneous dataset is important task in this system. Association rule apriority algorithm using SQL is best suited for implementing this operation. In this project we consider the PIVOT operator which is a built-in operator in a commercial DBMS. Since this operator can perform transposition it can help evaluating horizontal aggregations, our proposal though the list of distinct to values must be provided by the user, whereas ours does it automatically, output columns are automatically created.
