DataSheets: A Spreadsheet-Based Data-Flow Language

  • Angel Lagares Lemos
  • Moshe Chai Barukh
  • Boualem Benatallah
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8274)


We are surrounded by data, a vast amount of data that has brought about an increasing need for combining and analyzing it in order to extract information and generate knowledge. A need not exclusive of big software companies with expert programmers; from scientists to bloggers, many end-user programmers currently demand data management tools to generate information according to their discretion. However, data is usually distributed among multiple sources, hence, it requires to be integrated, and unfortunately, this process is still available just for professional developers. In this paper we propose DataSheets, a novel approach to make the data-flow specification accessible and its representation comprehensible to end-user programmers. This approach consists of a spreadsheet-based data-flow language that has been tested and evaluated in a service-centric composition framework.


Data-Flow End-User Programming Spreadsheets 


  1. 1.
    Cisco Visual Networking Index: Forecast and methodology, 2009-2014. White paper, CISCO, vol. 2 (June 2010)Google Scholar
  2. 2.
    Ko, A.J., Myers, B.A., Aung, H.H.: Six learning barriers in end-user programming systems. In: IEEE Symposium on Visual Languages and Human Centric Computing, pp. 199–206 (2004)Google Scholar
  3. 3.
    Asavametha, A., Ayyavu, P., Scaffidi, C.: No application is an island: Using topes to transform strings during data transfer. In: International Conference on Information Science and Applications (ICISA), pp. 1–10. IEEE (2011)Google Scholar
  4. 4.
    Rahm, E., Bernstein, P.: A survey of approaches to automatic schema matching. The VLDB Journal 10(4), 334–350 (2001)CrossRefzbMATHGoogle Scholar
  5. 5.
    Wong, J., Hong, J.I.: Making mashups with marmite: towards end-user programming for the web. In: Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, pp. 1435–1444. ACM (2007)Google Scholar
  6. 6.
    Nunez, F., Blake, E.: Vissh: A data visualisation spreadsheet. In: Joint Eurographics-IEEE TCVG Symposium on Visualization (VisSym), pp. 209–218. The Eurographics Association (2000)Google Scholar
  7. 7.
    Jones, S., Blackwell, A., Burnett, M.: A user-centered approach to functions in excel. In: Proceedings of the 8th ACM SIGPLAN International Conference on Functional Programming, pp. 165–176. ACM Press (2003)Google Scholar
  8. 8.
    Panko, R.: Spreadsheet errors: What we know. What we think we can do. Arxiv preprint arXiv:0802.3457 (2008)Google Scholar
  9. 9.
    Weber, I., Paik, H., Benatallah, B., Gong, Z., Zheng, L., Vorwerk, C.: Formsys: form-processing web services. In: Proceedings of the 19th International Conference on World Wide Web, pp. 1313–1316. ACM (2010)Google Scholar
  10. 10.
    Tarjan, R.: Depth-first search and linear graph algorithms. In: 12th Annual Symposium on Switching and Automata Theory, pp. 114–121. IEEE (1971)Google Scholar
  11. 11.
    Casati, F.: How end-user development will save composition technologies from their continuing failures. In: Piccinno, A. (ed.) IS-EUD 2011. LNCS, vol. 6654, pp. 4–6. Springer, Heidelberg (2011)Google Scholar
  12. 12.
    Mehandjiev, N., Namoune, A., Wajid, U., et al.: End user service composition: Perceptions and requirements. In: Proceedings of the 8th IEEE European Conference on Web Services, pp. 139–146. IEEE Computer Society (2010)Google Scholar
  13. 13.
    Namoun, A., Nestler, T., De Angeli, A.: Service composition for non-programmers: Prospects, problems, and design recommendations. In: 8th European Conference on Web Services (ECOWS), pp. 123–130. IEEE (2010)Google Scholar
  14. 14.
    Ko, A.J., Abraham, R., Beckwith, L., Blackwell, A., Burnett, M., et al.: The state of the art in end-user software engineering. ACM Computing Surveys (CSUR) 43(3), 21 (2011)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Angel Lagares Lemos
    • 1
  • Moshe Chai Barukh
    • 1
  • Boualem Benatallah
    • 1
  1. 1.SOC GroupUniversity of New South WalesAustralia

Personalised recommendations