Advertisement

SpreadMash: A Spreadsheet-Based Interactive Browsing and Analysis Tool for Data Services

  • Woralak Kongdenfha
  • Boualem Benatallah
  • Régis Saint-Paul
  • Fabio Casati
Part of the Lecture Notes in Computer Science book series (LNCS, volume 5074)

Abstract

Spreadsheets are one of the most popular end-users programming environment. Although spreadsheets provide an interactive interface for data manipulation and analysis, they are mostly used today in data entry mode and not as interactive browsing tool for data stored in underlying data sources. In this paper, we present SpreadMash, a high-level language and tool for interactive data browsing and analysis for data services. The key innovation of SpreadMash is a repository of application building blocks called data widgets that characterize various data importation and presentation patterns in spreadsheets. Data widgets enable the separation of end-users tasks (composing data widgets) from the tasks of data architects (creating data abstractions and data widgets). Through a series of examples we illustrate how tasks that would be challenging in existing environments are facilitated by SpreadMash.

References

  1. 1.
    ASP.Net. http://asp.net/
  2. 2.
  3. 3.
    Exploiting The Power of Oracle Using Microsoft Excel, www.oracle.com/technology/products/bi/pdf/BI_Spreadsheet_Addin_WP.pdf
  4. 4.
  5. 5.
  6. 6.
  7. 7.
  8. 8.
    Abraham, R., Cooperstein, I., Kollmansberger, S., Erwig, M.: Automatic generation and maintenance of correct spreadsheets. In: Proc. ICSE 2005 (2005)Google Scholar
  9. 9.
    Adya, A., Blakeley, J., Melnik, S., Muralidhar, S.: Anatomy of the ADO.Net entity framework. In: SIGMOD 2007, pp. 877–888. ACM Press, China (2007)CrossRefGoogle Scholar
  10. 10.
    Carey, M.: Data delivery in a service-oriented world: the bea aqualogic data services platform. In: SIGMOD 2006, Chicago, IL, USA, pp. 695–705. ACM Press, New York (2006)CrossRefGoogle Scholar
  11. 11.
    Ceri, S., Fraternali, P., Bongio, A.: Web modeling language (webml): a modeling language for designing web sites. In: Proc. WWW 2000, pp. 137–157 (2000)Google Scholar
  12. 12.
    Engels, G., Erwig, M.: Classsheets: automatic generation of spreadsheet applications from object-oriented specifications. In: Proc. ASE 2005 (2005)Google Scholar
  13. 13.
    Jones, S., Blackwell, A., Burnett, M.: A user-centred approach to functions in excel. SIGPLAN J 38(9), 165–176 (2003)CrossRefGoogle Scholar
  14. 14.
    Pemberton, J., Robson, A.: Spreadsheets in business. IMDS J 100(8), 379–388 (2000)Google Scholar
  15. 15.
    Saint-Paul, R., Benatallah, B., Vayssiére, J.: Data services in your spreadsheet? In: Proc. EDBT 2008 (2008)Google Scholar
  16. 16.
    Scaffidi, C., Shaw, M., Myers, B.: Estimating the numbers of end users programmers. In: Proc. VLHCC 2005, pp. 207–214 (2005)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2008

Authors and Affiliations

  • Woralak Kongdenfha
    • 1
  • Boualem Benatallah
    • 1
  • Régis Saint-Paul
    • 1
  • Fabio Casati
    • 2
  1. 1.CSEUniversity of New South WalesSydneyAustralia
  2. 2.DITUniversity of TrentoPOVO (TN)Italy

Personalised recommendations