Interactive Visualization of Data-Oriented XML Documents

Chmelar, Petr; Hernych, Radim; Kubíček, Daniel

doi:10.1007/978-1-4020-8741-7_70

Cited by 2 publications

(3 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…VisualXML and XMLAD [30], like Elastic Hierarchies and EncCon, use node-link representations as part of their interface, but are geared towards XML visualization. The XMLAD system does indeed use tabular representations as part of the output layout, but does not support nested tables.…”

Section: Tree Visualizationmentioning

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

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

Section: Tree Visualizationmentioning

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

“…To evaluate the readability of our layouts, we conducted a betweensubjects online user study using Amazon Mechanical Turk 7 and StudyCaster, a Java-based tool we developed to allow test subjects to stream timestamped recordings of their computer screens to our server with a minimum of effort. In an initial public recruiting stage of the study, workers were offered $0.25 to launch the StudyCaster and solve a chart-making task that required the workers to have Microsoft Excel installed on their machines.…”

Section: Readabilitymentioning

confidence: 99%

“…VisualXML and XMLAD [7], like Elastic Hierarchies and EncCon, use node-link representations as part of their interface, but are geared towards XML visualization. The XMLAD system does indeed use tabular representations as part of the output layout, but does not support nested tables.…”

Section: Introductionmentioning

confidence: 99%

Automatic Layout of Structured Hierarchical Reports

Bakke

Karger

Miller

2013

IEEE Trans. Visual. Comput. Graphics

View full text Add to dashboard Cite

Fig. 1. Interactive adaptation of the layout of the data to be displayed, based on the available horizontal width of an on-screen window.Abstract-Domain-specific database applications tend to contain a sizable number of table-, form-, and report-style views that must each be designed and maintained by a software developer. A significant part of this job is the necessary tweaking of low-level presentation details such as label placements, text field dimensions, list or table styles, and so on. In this paper, we present a horizontally constrained layout management algorithm that automates the display of structured hierarchical data using the traditional visual idioms of hand-designed database UIs: tables, multi-column forms, and outline-style indented lists. We compare our system with pure outline and nested table layouts with respect to space efficiency and readability, the latter with an online user study on 27 subjects. Our layouts are 3.9 and 1.6 times more compact on average than outline layouts and horizontally unconstrained table layouts, respectively, and are as readable as table layouts even for large datasets.

show abstract

Interactive Visualization of Data-Oriented XML Documents

Cited by 2 publications

References 2 publications

Expressive Query Construction through Direct Manipulation of Nested Relational Results

Expressive Query Construction through Direct Manipulation of Nested Relational Results

Automatic Layout of Structured Hierarchical Reports

Contact Info

Product

Resources

About