Mashroom: end-user mashup programming using nested tables

ABSTRACT

This paper presents an end-user-oriented programming environment called Mashroom. Major contributions herein include an end-user programming model with an expressive data structure as well as a set of formally-defined mashup operators. The data structure takes advantage of nested table, and maintains the intuitiveness while allowing users to express complex data objects. The mashup operators are visualized with contextual menu and formula bar and can be directly applied on the data. Experiments and case studies reveal that end users have little difficulty in effectively and efficiently using Mashroom to build mashup applications.

REFERENCES

• 1: David E. Simmen , Mehmet Altinel , Volker Markl , Sriram Padmanabhan , Ashutosh Singh, Damia: data mashups for intranet applications, Proceedings of the 2008 ACM SIGMOD international conference on Management of data, June 09-12, 2008, Vancouver, Canada [doi>10.1145/1376616.1376734]
• 2: Yahoo Pipes, Inc. http://pipes.yahoo.com/, 2008.
• 3: Microsoft Popfly, http://www.popfly.com/, 2008
• 4: Rob Ennals , David Gay, User-friendly functional programming for web mashups, Proceedings of the 12th ACM SIGPLAN international conference on Functional programming, October 01-03, 2007, Freiburg, Germany
• 5: Robert J. Ennals , Minos N. Garofalakis, MashMaker: mashups for the masses, Proceedings of the 2007 ACM SIGMOD international conference on Management of data, June 11-14, 2007, Beijing, China [doi>10.1145/1247480.1247626]
• 6: Jeffrey Wong , Jason I. Hong, Making mashups with marmite: towards end-user programming for the web, Proceedings of the SIGCHI conference on Human factors in computing systems, April 28-May 03, 2007, San Jose, California, USA [doi>10.1145/1240624.1240842]
• 7: Akifumi Makinouchi, A consideration on normal form of not-necessarily-normalized relation in the relational data model, Proceedings of the third international conference on Very large data bases, p.447-453, October 06-08, 1977, Tokyo, Japan
• 8: Alberto H. F. Laender , Altigran S. da Silva , Paolo B. Golgher , Berthier Ribeiro-Neto , Irna M. R. Evangelista-Filha , Karine V. Magalhães, The Debye Environment for Web Data Management, IEEE Internet Computing, v.6 n.4, p.60-69, July 2002 [doi>10.1109/MIC.2002.1020327]
• 9: D. W. Embley , D. M. Campbell , Y. S. Jiang , S. W. Liddle , D. W. Lonsdale , Y.—K. Ng , R. D. Smith, Conceptual-model-based data extraction from multiple-record Web pages, Data & Knowledge Engineering, v.31 n.3, p.227-251, Nov. 1999 [doi>10.1016/S0169-023X(99)00027-0]
• 10: Filha, I.M.R.E., Laender, A.H.F., and Silva, A.S.D. Querying Semistructured Data By Example: The QSByE Interface. In Proceedings of Workshop on Information Integration on the Web. 2001, pp. 156--163.
• 11: Qin Z., Yao B. B., Liu Y., and McCool M. D., A Graphical XQuery Language Using Nested Windows, In Proc. of 5th Int. Conf. WISE, Brisbane, Australia, 2004, pp. 681--687
• 12: B. A. Nardi,; J. R. Miller, The Spreadsheet Interface: A Basis for End User Programming, HP Labs Technical Reports, http://www.hpl.hp.com/techreports/90/HPL-90-08.pdf, 1990
• 13: Brad A. Myers , Andrew J. Ko , Margaret M. Burnett, Invited research overview: end-user programming, CHI '06 extended abstracts on Human factors in computing systems, April 22-27, 2006, Montréal, Québec, Canada [doi>10.1145/1125451.1125472]
• 14: Allen Cypher , Daniel C. Halbert , David Kurlander , Henry Lieberman , David Maulsby , Brad A. Myers , Alan Turransky, Watch what I do: programming by demonstration, MIT Press, Cambridge, MA, 1993
• 15: Lieberman, H. (Ed.) 2001. Your Wish is My Command: Programming by Example. San Francisco: Morgan Kaufmann.
• 16: Latha S. Colby, A recursive algebra and query optimization for nested relations, ACM SIGMOD Record, v.18 n.2, p.273-283, June 1989
• 17: AJAX--SIMILE, http://simile.mit.edu/ajax/, 2007
• 18: Dapper: The Data Mapper. http://dapper.net. 2008
• 19: Shaohua Yang, Guiling Wang, Yanbo Han. Grubber: Allowing End-Users to Develop XML-based Wrappers for Web Data Sources. The Joint International Conferences on Asia-Pacific Web Conference (APWeb) and Web-Age Information Management (WAIM), Suzhou, China. 2009, pp. 645--650.
• 20: Jeffrey Wong , Jason Hong, What do we "mashup" when we make mashups?, Proceedings of the 4th international workshop on End-user software engineering, p.35-39, May 12-12, 2008, Leipzig, Germany [doi>10.1145/1370847.1370855]
• 21: 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]
• 22: Jun Fujima , Aran Lunzer , Kasper Hornbæk , Yuzuru Tanaka, Clip, connect, clone: combining application elements to build custom interfaces for information access, Proceedings of the 17th annual ACM symposium on User interface software and technology, October 24-27, 2004, Santa Fe, NM, USA [doi>10.1145/1029632.1029664]
• 23: Ubiquity. http://labs.mozilla.com/projects/ubiquity/. 2008
• 24: Björn Hartmann , Leslie Wu , Kevin Collins , Scott R. Klemmer, Programming by a sample: rapidly creating web applications with d.mix, Proceedings of the 20th annual ACM symposium on User interface software and technology, October 07-10, 2007, Newport, Rhode Island, USA [doi>10.1145/1294211.1294254]

INDEX TERMS

Primary Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
        D.2.13 Reusable Software

Additional Classification:
  H. Information Systems
  H.5 INFORMATION INTERFACES AND PRESENTATION (I.7)
      H.5.m Miscellaneous

General Terms:
Design, Human Factors, Languages

Keywords:
end-user programming, mashup, nested table, spreadsheet