WYSIWYG development of data driven web applications

An emerging trend in Social Networking sites and Web portals is the opening up of their APIs to external application developers. For example, the Facebook Platform, Google Gadgets and Yahoo! Widgets allow developers to design their own applications, which can then can be integrated with the platform and shared with other users. However, current APIs are targeted towards developers with programming expertise and database knowledge; they are not accessible to a large class of users who do not have a programming/database background, but would nevertheless like to create new applications. To address this need, we have developed the AppForge system, which provides a WYSIWYG application development platform. Users can graphically specify the components of webpages inside a Web browser, and the corresponding database schema and application logic will be automatically generated on the fly by the system. The WYSIWYG interface gives instantaneous feedback on what users have created and allows them to run, test and continuously refine their applications. AppForge has been used to create prototype versions of a variety of applications such as an event planning system, a recruiting system, an item trading system and an online course management system. We have also conducted a small and preliminary user study to identify and fix some of the usability aspects of AppForge.

[1]  Stefano Rizzi,et al.  VISIONARY: a Viewpoint-based Visual Language for Querying Relational Databases , 1999, J. Vis. Lang. Comput..

[2]  Qing Li,et al.  Unified Modeling Language , 2009 .

[3]  Moshé M. Zloof Query-by-example: the invocation and definition of tables and forms , 1975, VLDB '75.

[4]  Adriane Chapman,et al.  Making database systems usable , 2007, SIGMOD '07.

[5]  David W. Embley,et al.  NFQL: the natural forms query language , 1989, ACM Trans. Database Syst..

[6]  Carole A. Goble,et al.  Kaleidoquery: a visual query language for object databases , 1998, AVI '98.

[7]  Peter P. Chen Entity-Relationship Approach to Information Modeling and Analysis, Proceedings of the Second International Conference on the Entity-Relationship Approach (ER'81), Washington, DC, USA, October 12-14, 1981 , 1981 .

[8]  Joobin Choobineh,et al.  A form-based approach for database analysis and design , 1992, CACM.

[9]  Fan Yang,et al.  Hilda: A High-Level Language for Data-DrivenWeb Applications , 2006, 22nd International Conference on Data Engineering (ICDE'06).

[10]  H. V. Jagadish,et al.  Assisted querying using instant-response interfaces , 2007, SIGMOD '07.

[11]  Jessie B. Kennedy,et al.  DRIVE - An Environment for the Organised Construction of User-Interfaces to Databases , 1996, IDS.

[12]  Serge Abiteboul,et al.  Non First Normal Form Relations: An Algebra Allowing Data Restructuring , 1986, J. Comput. Syst. Sci..

[13]  Stefano Ceri,et al.  Web Modeling Language (WebML): a modeling language for designing Web sites , 2000, Comput. Networks.

[14]  Jürgen Wolff von Gudenberg,et al.  UML- Unified Modeling Language , 1998, Informatik-Spektrum.