Rapid development of spreadsheet-based web mashups

ABSTRACT

The rapid growth of social networking sites and web communities have motivated web sites to expose their APIs to external developers who create mashups by assembling existing functionalities. Current APIs, however, aim toward developers with programming expertise; they are not directly usable by wider class of users who do not have programming background, but would nevertheless like to build their own mashups. To address this need, we propose a spreadsheet-based Web mashups development framework, which enables users to develop mashups in the popular spreadsheet environment. First, we provide a mechanism that makes structured data first class values of spreadsheet cells. Second, we propose a new component model that can be used to develop fairly sophisticated mashups, involving joining data sources and keeping spreadsheet data up to date. Third, to simplify mashup development, we provide a collection of spreadsheet-based mashup patterns that captures common Web data access and spreadsheet presentation functionalities. Users can reuse and customize these patterns to build spreadsheet-based Web mashups instead of developing them from scratch. Fourth, we enable users to manipulate structured data presented on spreadsheet in a drag-and-drop fashion. Finally, we have developed and tested a proof-of-concept prototype to demonstrate the utility of the proposed framework.

REFERENCES

• 1: Designing Reports with the Microsoft Excel Add-in for SQL Server analysis services. Microsoft Corp., 2004.
• 2: ASP.Net. http://asp.net/.
• 3: Intel mash maker. http://mashmaker.intel.com.
• 4: Jabber Framework. http://www.jabber.org.
• 5: Microsoft popfly. http://www.popfly.ms.
• 6: StrikeIron Web Services for Excel. http://www.strikeiron.com/tools/toolssoaexpress.aspx.
• 7: Yahoo! pipe. http://pipes.yahoo.com/pipes.
• 8: Martin Erwig , Robin Abraham , Irene Cooperstein , Steve Kollmansberger, Automatic generation and maintenance of correct spreadsheets, Proceedings of the 27th international conference on Software engineering, May 15-21, 2005, St. Louis, MO, USA [doi>10.1145/1062455.1062494]
• 9: Robin Abraham , Martin Erwig, Inferring templates from spreadsheets, Proceedings of the 28th international conference on Software engineering, May 20-28, 2006, Shanghai, China [doi>10.1145/1134285.1134312]
• 10: Michael Carey, Data delivery in a service-oriented world: the BEA aquaLogic data services platform, Proceedings of the 2006 ACM SIGMOD international conference on Management of data, June 27-29, 2006, Chicago, IL, USA [doi>10.1145/1142473.1142551]
• 11: P. Castro and A. Nori. Astoria: A programming model for data on the web. Proc. ICDE'08, pages 1556--1559.
• 12: Stefano Ceri , Piero Fraternali , Aldo Bongio, Web Modeling Language (WebML): a modeling language for designing Web sites, Proceedings of the 9th international World Wide Web conference on Computer networks : the international journal of computer and telecommunications netowrking, p.137-157, June 2000, Amsterdam, The Netherlands
• 13: J. R. Durant. Web queries and dynamic chart data in Excel. Technical report, TR. Microsoft Corp., 2003.
• 14: Martin Erwig , Robin Abraham , Steve Kollmansberger , Irene Cooperstein, Gencel: a program generator for correct spreadsheets, Journal of Functional Programming, v.16 n.3, p.293-325, May 2006 [doi>10.1017/S0956796805005794]
• 15: Marc Gyssens , Laks V. S. Lakshmanan , Iyer N. Subramanian, Tables as a paradigm for querying and restructuring (extended abstract), Proceedings of the fifteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems, p.93-103, June 04-06, 1996, Montreal, Quebec, Canada [doi>10.1145/237661.237688]
• 16: Anant Jhingran, Enterprise information mashups: integrating information, simply, Proceedings of the 32nd international conference on Very large data bases, September 12-15, 2006, Seoul, Korea
• 17: Simon Peyton Jones , Alan Blackwell , Margaret Burnett, A user-centred approach to functions in Excel, ACM SIGPLAN Notices, v.38 n.9, p.165-176, September 2003
• 18: Woralak Kongdenfha , Boualem Benatallah , Régis Saint-Paul , Fabio Casati, SpreadMash: A Spreadsheet-Based Interactive Browsing and Analysis Tool for Data Services, Proceedings of the 20th international conference on Advanced Information Systems Engineering, June 16-20, 2008 [doi>10.1007/978-3-540-69534-9_27]
• 19: K. Laker. Exploiting the power of oracle using microsoft excel. Technical report, Oracle Corp., 2004.
• 20: Laks V. S. Lakshmanan , Subbu N. Subramanian , Nita Goyal , Ravi Krishnamurthy, On Query Spreadsheets, Proceedings of the Fourteenth International Conference on Data Engineering, p.134-141, February 23-27, 1998
• 21: E. Lippert and E. Carter. .Net programming for office: C# with Excel, Word, Outlook, Infopath. Addison Wesley, 2005.
• 22: D. Merrill. Mashups: The new breed of web app. Technical report, IBM Corp., 2006.
• 23: J. Pemberton and A. Robson. Spreadsheets in business. IMDS J., 100(8):379--388, 2000.
• 24: F. Rice. Creating XML mappings in excel 2003. In TR. Microsoft Corp., 2005.
• 25: Régis Saint-Paul , Boualem Benatallah , Julien Vayssière, Data services in your spreadsheet!, Proceedings of the 11th international conference on Extending database technology: Advances in database technology, March 25-29, 2008, Nantes, France [doi>10.1145/1353343.1353427]
• 26: Christopher Scaffidi , Mary Shaw , Brad Myers, Estimating the Numbers of End Users and End User Programmers, Proceedings of the 2005 IEEE Symposium on Visual Languages and Human-Centric Computing, p.207-214, September 20-24, 2005 [doi>10.1109/VLHCC.2005.34]

INDEX TERMS

Primary Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
      D.2.2 Design Tools and Techniques
          Subjects: Modules and interfaces

Additional Classification:
  H. Information Systems
  H.5 INFORMATION INTERFACES AND PRESENTATION (I.7)
      H.5.2 User Interfaces (D.2.2, H.1.2, I.3.6)
          Subjects: Graphical user interfaces (GUI); Prototyping; Interaction styles (e.g., commands, menus, forms, direct manipulation)

General Terms:
Design

Keywords:
component model, spreadsheet-based mashup patterns, spreadsheets, web data mashups