skip to main content
10.1145/1127777.1127842acmconferencesArticle/Chapter ViewAbstractPublication PagescpsweekConference Proceedingsconference-collections
Article

A spreadsheet approach to programming and managing sensor networks

Published: 19 April 2006 Publication History

Abstract

We present a spreadsheet approach to simplifying the process of managing, programming, and interacting with sensor networks and visualizing, archiving and retrieving sensor data. An Excel spreadsheet prototype has been built to demonstrate the idea. This environment provides Excel users, who are already familiar with spreadsheet applications, a convenient and powerful tool for programming and data analysis. We discuss the architecture of this prototype and our experience in implementing the tool. We show two different classes of sensor-net applications built using this platform. We also present performance data on the scalability of the tool with respect to data rate and number of data streams.

References

[1]
Elson, J., and Parker, A. Tinker: A tool for designing data-centric sensor networks. In Fifth Intl. Conf. on Information Processing in Sensor Networks (IPSN 2006), SPOTS track. Nashville, TN. (April 2006).
[2]
Horey, J., Bridges, P., Maccabe, A., and Mielke, A. Work in Progress: The design of a spreadsheet interface for sensor networks. In Proc. of Information Processing in Sensor Networks (IPSN'05), Los Angeles, CA (April 2005).
[3]
Hui, J. W., and Culler, D. The dynamic behavior of a data dissemination protocol for network programming at scale. In Proc. 2nd ACM Conference on Embedded Networked Sensor Systems (SenSys'04), Baltimore, MA (November 2004).
[4]
Jones, S. P., Burnett, M., and Blackwell, A. A user-centred approach to functions in excel. In Proc. of Intl. Conf. on Functional Programming (ICFP'03), Uppsala (Sept 2003), pp. 165--176.
[5]
Liu, J., Chu, M., Liu, J., Reich, J., and Zhao, F. State-centric programming for sensor-actuator network systems. IEEE Pervasive Computing 2, 4 (Oct-Dec 2003), 50--62.
[6]
Liu, J., and Zhao, F. Towards semantic services for sensor-rich information systems. In Proc. of the 2nd Intl. Workshop on Broadband Advanced Sensor Networks (Basenets'05), Boston, MA (October 2005).
[7]
Madden, S. R., Franklin, M. J., Hellerstein, J. M., and Hong, W. TAG: a Tiny AGgregation Service for Ad-Hoc Sensor Networks. In OSDI (December 2002).
[8]
Newton, R., and Welsh, M. Region streams: Functional macroprogramming for sensor networks. In Proceedings of the First International Workshop on Data Management for Sensor Networks (DMSN), Toronto, Canada (Augest 2004).
[9]
Ramakrishna Gummadi, Omprakash Gnawali, R. G. Macro-programming wireless sensor networks using Kairos. In Proc. of the Intl. Conference on Distributed Computing in Sensor Systems (DCOSS), Marina del Rey, CA (June 2005).
[10]
Tolle, G., and Culler, D. Design of an application-cooperative management system for wireless sensor networks. In Proc. 2nd European Workshop on Wireless Sensor Networks (EWSN), Istanbul, Turkey (January 2005).
[11]
Whitehouse, K., Zhao, F., and Liu, J. Semantic streams: a framework for the composable semantic interpretation of sensor data. In Proc. European Workshop on Wireless Sensor Networks (EWSN'06), Zurich, Switzerland (Feb. 2006).

Cited By

View all
  • (2016)Spreadsheets for stream processing with unbounded windows and partitionsProceedings of the 10th ACM International Conference on Distributed and Event-based Systems10.1145/2933267.2933607(49-60)Online publication date: 13-Jun-2016
  • (2015)A Spreadsheet Model for Handling Streaming DataProceedings of the 33rd Annual ACM Conference on Human Factors in Computing Systems10.1145/2702123.2702587(3399-3402)Online publication date: 18-Apr-2015
  • (2014)Stream Processing with a SpreadsheetProceedings of the 28th European Conference on ECOOP 2014 --- Object-Oriented Programming - Volume 858610.1007/978-3-662-44202-9_15(360-384)Online publication date: 1-Aug-2014
  • Show More Cited By

Index Terms

  1. A spreadsheet approach to programming and managing sensor networks

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    IPSN '06: Proceedings of the 5th international conference on Information processing in sensor networks
    April 2006
    514 pages
    ISBN:1595933344
    DOI:10.1145/1127777
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 19 April 2006

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. SQL server
    2. data streams
    3. excel
    4. networked sensors

    Qualifiers

    • Article

    Conference

    IPSN06
    Sponsor:

    Acceptance Rates

    Overall Acceptance Rate 143 of 593 submissions, 24%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)2
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 14 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2016)Spreadsheets for stream processing with unbounded windows and partitionsProceedings of the 10th ACM International Conference on Distributed and Event-based Systems10.1145/2933267.2933607(49-60)Online publication date: 13-Jun-2016
    • (2015)A Spreadsheet Model for Handling Streaming DataProceedings of the 33rd Annual ACM Conference on Human Factors in Computing Systems10.1145/2702123.2702587(3399-3402)Online publication date: 18-Apr-2015
    • (2014)Stream Processing with a SpreadsheetProceedings of the 28th European Conference on ECOOP 2014 --- Object-Oriented Programming - Volume 858610.1007/978-3-662-44202-9_15(360-384)Online publication date: 1-Aug-2014
    • (2013)Development of Efficient Role-Based Sensor Network Applications with Excel Spreadsheets2013 International Conference on Parallel and Distributed Systems10.1109/ICPADS.2013.58(365-371)Online publication date: Dec-2013
    • (2010)High-Level Application Development for Sensor Networks: Data-Driven ApproachTheoretical Aspects of Distributed Computing in Sensor Networks10.1007/978-3-642-14849-1_26(865-891)Online publication date: 8-Nov-2010
    • (2010)TablesProceedings of the 6th IEEE international conference on Distributed Computing in Sensor Systems10.1007/978-3-642-13651-1_1(1-14)Online publication date: 21-Jun-2010
    • (2008)An Integrated Framework for Wireless Sensor Web Service and Its Performance Analysis Based on Queue TheoryProceedings of the IFIP International Conference on Network and Parallel Computing10.1007/978-3-540-88140-7_25(276-285)Online publication date: 18-Oct-2008
    • (2006)Simple sensor syndiciationProceedings of the 4th international conference on Embedded networked sensor systems10.1145/1182807.1182863(377-378)Online publication date: 31-Oct-2006
    • (2006)AmbianceCompanion to the 21st ACM SIGPLAN symposium on Object-oriented programming systems, languages, and applications10.1145/1176617.1176662(663-664)Online publication date: 22-Oct-2006

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media