The use of spreadsheets in organizations: determinants and consequences
Information and Management
Polaris: A System for Query, Analysis, and Visualization of Multidimensional Relational Databases
IEEE Transactions on Visualization and Computer Graphics
The Lowell database research self-assessment
Communications of the ACM - Adaptive complex enterprises
Predicalc: A logical spreadsheet management system
The Knowledge Engineering Review
WYSIWYG development of data driven web applications
Proceedings of the VLDB Endowment
The interactive join: recognizing gestures for database queries
CHI '13 Extended Abstracts on Human Factors in Computing Systems
Hi-index | 0.01 |
A key feature of relational database applications is managing \emph{plural} relationships---one-to-many and many-to-many---between entities. However, since it is often infeasible to adopt or develop a new database application for any given schema at hand, information workers instead turn to spreadsheets, which lend themselves poorly to schemas requiring multiple related entity sets. In this paper, we propose to reduce the cost-usability gap between spreadsheets and tailor-made relational database applications by extending the spreadsheet paradigm to let the user establish relationships between rows in related worksheets as well as view and navigate the hierarchical cell structure that arises as a result. We present Related Worksheets, a spreadsheet-like prototype application, and evaluate it with a screencast-based user study on 36 Mechanical Turk workers. First-time users of our software were able to solve lookup-type query tasks with the same or higher accuracy as subjects using Microsoft Excel, in one case 40% faster on average.