Rapid development of spreadsheet-based web mashups

Woralak Kongdenfha, Boualem Benatallah, Julien Vayssière, Régis Saint-Paul, Fabio Casati

Research output: Chapter in Book/Report/Conference proceedingConference contribution

42 Citations (Scopus)

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. Copyright is held by the International World Wide Web Conference Committee (IW3C2).

Original languageEnglish
Title of host publicationWWW'09 - Proceedings of the 18th International World Wide Web Conference
Pages851-860
Number of pages10
DOIs
Publication statusPublished - 2009
Externally publishedYes
Event18th International World Wide Web Conference, WWW 2009 - Madrid, Spain
Duration: 20 Apr 200924 Apr 2009

Conference

Conference18th International World Wide Web Conference, WWW 2009
CountrySpain
CityMadrid
Period20.4.0924.4.09

Fingerprint

Spreadsheets
Application programming interfaces (API)
World Wide Web
Joining
Drag
Websites

Keywords

  • Component model
  • Spreadsheet-based mashup patterns
  • Spreadsheets
  • Web data mashups

ASJC Scopus subject areas

  • Computer Networks and Communications

Cite this

Kongdenfha, W., Benatallah, B., Vayssière, J., Saint-Paul, R., & Casati, F. (2009). Rapid development of spreadsheet-based web mashups. In WWW'09 - Proceedings of the 18th International World Wide Web Conference (pp. 851-860) https://doi.org/10.1145/1526709.1526824

Rapid development of spreadsheet-based web mashups. / Kongdenfha, Woralak; Benatallah, Boualem; Vayssière, Julien; Saint-Paul, Régis; Casati, Fabio.

WWW'09 - Proceedings of the 18th International World Wide Web Conference. 2009. p. 851-860.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Kongdenfha, W, Benatallah, B, Vayssière, J, Saint-Paul, R & Casati, F 2009, Rapid development of spreadsheet-based web mashups. in WWW'09 - Proceedings of the 18th International World Wide Web Conference. pp. 851-860, 18th International World Wide Web Conference, WWW 2009, Madrid, Spain, 20.4.09. https://doi.org/10.1145/1526709.1526824
Kongdenfha W, Benatallah B, Vayssière J, Saint-Paul R, Casati F. Rapid development of spreadsheet-based web mashups. In WWW'09 - Proceedings of the 18th International World Wide Web Conference. 2009. p. 851-860 https://doi.org/10.1145/1526709.1526824
Kongdenfha, Woralak ; Benatallah, Boualem ; Vayssière, Julien ; Saint-Paul, Régis ; Casati, Fabio. / Rapid development of spreadsheet-based web mashups. WWW'09 - Proceedings of the 18th International World Wide Web Conference. 2009. pp. 851-860
@inproceedings{03213ff605444a10b53fbb6e3ceb8321,
title = "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. Copyright is held by the International World Wide Web Conference Committee (IW3C2).",
keywords = "Component model, Spreadsheet-based mashup patterns, Spreadsheets, Web data mashups",
author = "Woralak Kongdenfha and Boualem Benatallah and Julien Vayssi{\`e}re and R{\'e}gis Saint-Paul and Fabio Casati",
year = "2009",
doi = "10.1145/1526709.1526824",
language = "English",
isbn = "9781605584874",
pages = "851--860",
booktitle = "WWW'09 - Proceedings of the 18th International World Wide Web Conference",

}

TY - GEN

T1 - Rapid development of spreadsheet-based web mashups

AU - Kongdenfha, Woralak

AU - Benatallah, Boualem

AU - Vayssière, Julien

AU - Saint-Paul, Régis

AU - Casati, Fabio

PY - 2009

Y1 - 2009

N2 - 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. Copyright is held by the International World Wide Web Conference Committee (IW3C2).

AB - 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. Copyright is held by the International World Wide Web Conference Committee (IW3C2).

KW - Component model

KW - Spreadsheet-based mashup patterns

KW - Spreadsheets

KW - Web data mashups

UR - http://www.scopus.com/inward/record.url?scp=84865641884&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84865641884&partnerID=8YFLogxK

U2 - 10.1145/1526709.1526824

DO - 10.1145/1526709.1526824

M3 - Conference contribution

AN - SCOPUS:84865641884

SN - 9781605584874

SP - 851

EP - 860

BT - WWW'09 - Proceedings of the 18th International World Wide Web Conference

ER -