A Spreadsheet Algebra for a Direct Data Manipulation Query Interface

— A spreadsheet-like “direct manipulation” interface is more intuitive for many non-technical database users compared to traditional alternatives, such as visual query builders. The construction of such a direct manipulation interface may appear straightforward, but there are some significant challenges. First, individual direct manipulation operations cannot be too complex, so expressive power has to be achieved through composing (long) sequences of small operations. Second, all intermediate results are visible to the user, so grouping and ordering are material after every small step. Third, users often find the need to modify previously specified queries. Since manipulations are specified one step at a time, there is no actual query expression to modify. Suitable means must be provided to address this need. Fourth, the order in which manipulations are performed by the user should not affect the results obtained, to avoid user confusion. We address the aforementioned challen...

• Type: Conference
• Year: 2009
• Where: ICDE
• Authors: Bin Liu, H. V. Jagadish
• Keywords: Database, Direct Manipulation, Direct Manipulation Interface, ICDE 2009, Visual Query Builder