WYSIWYG development of data driven web applications

Yang, Fan; Gupta, Nitin; Botev, Chavdar; Churchill, Elizabeth F.; Levchenko, G. G.; Shanmugasundaram, Jayavel

doi:10.14778/1453856.1453879

Cited by 21 publications

(20 citation statements)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The effect is a schema navigation capability analogous to that of QBB [84], AppForge [108], and App2You [66].…”

Section: An Example Session In the Sieuferd Query Builder Interfacementioning

confidence: 99%

“…For example, in GestureDB [78], the user has no way to modify a filter on a column that was subsequently totaled in an aggregation, since the column that was originally associated with the filter is no longer on the screen to be manipulated. Similar problems exist in R 2 [50], AppForge [108], CRIUS [86], and Gneiss [25]. SheetMusiq [71] provides a partial solution by using an algebra where certain operators can commute out of a complex expression for subsequent modification; however, the technique breaks down for expressions enclosed in binary operators such as joins, set union, or set difference.…”

Section: Visual Query Systemsmentioning

confidence: 99%

See 1 more Smart Citation

Expressive Query Construction through Direct Manipulation of Nested Relational Results

Bakke

Karger

2016

Proceedings of the 2016 International Conference on Management of Data

View full text Add to dashboard Cite

Despite extensive research on visual query systems, the standard way to interact with relational databases remains to be through SQL queries and tailored form interfaces. This makes the power of relational databases largely inaccessible to non-programmers. This thesis proposes a solution, in two parts.The first contribution of this thesis is a solution to the visual query language problem, that is, the problem of letting end users construct arbitrary database queries through a graphical user interface. We propose the first visual query language to simultaneously satisfy three requirements: (1) query specification through direct manipulation of results, (2) the ability to view and modify any part of the current query without departing from the direct manipulation interface, and (3) SQL-like expressiveness. By directly manipulating nested relational results, and using spreadsheet idioms such as formulas and filters, the user can express arbitrary SQL-92 queries while always remaining able to track and modify the state of the complete query.The second contribution of this thesis is an algorithm for automatically formatting nested relational data using the traditional visual idioms of hand-designed database UIs: tables, multi-column forms, and outline-style indented lists. The algorithm plugs directly into the output stage of our visual query language, and produces the concrete graphics that the user sees and manipulates on the screen during query construction. The algorithm eliminates the need for an application developer to specify low-level presentation details such as label placements, text field dimensions, table column widths, and list styles.Our prototype visual query system gives the user an experience of responsive, incremental query building while pushing all actual query processing to the database layer. We evaluate the query building aspects of our system with formative and controlled user studies on a total of 28 spreadsheet users. The controlled study shows our system outperforming Microsoft Access by 18 points on the System Usability Scale [17]; this corresponds to a 46 percentage point difference on a percentile scale of other studies in the Business Software category. We also evaluate the different layouts that can be produced by our automatic layout algorithm, including via an online user study on 27 subjects.

show abstract

“…The effect is a schema navigation capability analogous to that of QBB [84], AppForge [108], and App2You [66].…”

Section: An Example Session In the Sieuferd Query Builder Interfacementioning

confidence: 99%

Section: Visual Query Systemsmentioning

confidence: 99%

Expressive Query Construction through Direct Manipulation of Nested Relational Results

Bakke

Karger

2016

Proceedings of the 2016 International Conference on Management of Data

View full text Add to dashboard Cite

show abstract

“…Visual application builders like app2you [16] and AppForge [23] allow authors to specify the design of pages by placing drag-and-drop elements into a WYSIWIG-like environment. However, this approach limits authors to only the building blocks provided by the tools and cannot be used to transform arbitrary HTML.…”

Section: End User Web Developmentmentioning

confidence: 99%

Mavo

Verou

Zhang

Karger

2016

Proceedings of the 29th Annual Symposium on User Interface Software and Technology

View full text Add to dashboard Cite

My tasks: [count(done)] done, [count(task)] total

Do stuff

ABSTRACTMany people can author static web pages with HTML and CSS but find it hard or impossible to program persistent, interactive web applications. We show that for a broad class of CRUD (Create, Read, Update, Delete) applications, this gap can be bridged. Mavo extends the declarative syntax of HTML to describe Web applications that manage, store and transform data. Using Mavo, authors with basic HTML knowledge define complex data schemas implicitly as they design their HTML layout. They need only add a few attributes and expressions to their HTML elements to transform their static design into a persistent, data-driven web application whose data can be edited by direct manipulation of the content in the browser. We evaluated Mavo with 20 users who marked up static designs-some provided by us, some their own creation-to transform them into fully functional web applications. Even users with no programming experience were able to quickly craft Mavo applications.

show abstract

“…Recent DIY web services for form creation can hide the underlying data storage details from the users. However, each form is stored individually without semantic integration [1,28].…”

Section: Related Workmentioning

confidence: 99%

“…For building form-based applications, Do-It-Yourself (DIY) [18] and What You See Is What You Get (WYSIWYG) [28] are popular paradigms in the Cloud or in supporting non-technical users. Applications in these paradigms automatically translate forms into underlying databases and shield users from the technical details for database creation and code generation.…”

Section: Introductionmentioning

confidence: 99%

Automatically Mapping and Integrating Multiple Data Entry Forms into a Database

An¹,

Khare²,

Song³

et al. 2011

Conceptual Modeling – ER 2011

View full text Add to dashboard Cite

Abstract. Forms are a standard way of gathering data into a database. Many applications need to support multiple users with evolving data gathering requirements. It is desirable to automatically link dynamic forms to the back-end database. We have developed the FormMapper system, a fully automatic solution that accepts user-created data entry forms, and maps and integrates them into an existing database in the same domain. The solution comprises of two components: tree extraction and form integration. The tree extraction component leverages a probabilistic process, Hidden Markov Model (HMM), for automatically extracting a semantic tree structure of a form. In the form integration component, we develop a merging procedure that maps and integrates a tree into an existing database and extends the database with desired properties. We conducted experiments evaluating the performance of the system on several large databases designed from a number of complex forms. Our experimental results show that the FormMapper system is promising: It generated databases that are highly similar (87% overlapped) to those generated by the human experts, given the same set of forms.

show abstract

WYSIWYG development of data driven web applications

Cited by 21 publications

References 11 publications

Expressive Query Construction through Direct Manipulation of Nested Relational Results

Expressive Query Construction through Direct Manipulation of Nested Relational Results

Mavo

Automatically Mapping and Integrating Multiple Data Entry Forms into a Database

Contact Info

Product

Resources

About