Making database systems usable

Database researchers have striven to improve the capability of a database in terms of both performance and functionality. We assert that the usability of a database is as important as its capability. In this paper, we study why database systems today are so difficult to use. We identify a set of five pain points and propose a research agenda to address these. In particular, we introduce a presentation data model and recommend direct data manipulation with a schema later approach. We also stress the importance of provenance and of consistency across presentation models.

[1]  Vagelis Hristidis,et al.  DISCOVER: Keyword Search in Relational Databases , 2002, VLDB.

[2]  Pat Hanrahan,et al.  VizQL: a language for query, analysis and visualization , 2006, SIGMOD Conference.

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

[4]  Weijing Yuan,et al.  End-User Searching Behavior in Information Retrieval: A Longitudinal Study , 1997, J. Am. Soc. Inf. Sci..

[5]  Sergey Brin,et al.  The Anatomy of a Large-Scale Hypertextual Web Search Engine , 1998, Comput. Networks.

[6]  DANIELE BRAGA,et al.  XQBE (XQuery By Example): A visual interface to the standard XML query language , 2005, TODS.

[7]  David A. Patterson,et al.  Including the Human Factor in Dependability Benchmarks , 2002 .

[8]  Steven M. Shugan.  The Cost Of Thinking , 1980 .

[9]  Martin Erwig.  A visual language for XML , 2000, Proceeding 2000 IEEE International Symposium on Visual Languages.

[10]  Yannis Papakonstantinou,et al.  Mixing querying and navigation in MIX , 2002, Proceedings 18th International Conference on Data Engineering.

[11]  David Carmel,et al.  Searching XML documents via XML fragments , 2003, SIGIR.

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

[13]  Yehoshua Sagiv,et al.  Flexible queries over semistructured data , 2001, PODS '01.

[14]  Ann Blandford,et al.  Using Formal Models to Explore Display-Based Usability Issues , 1999, J. Vis. Lang. Comput..

[15]  Surajit Chaudhuri,et al.  Database Tuning Advisor for Microsoft SQL Server 2005 , 2004, VLDB.

[16]  Cong Yu,et al.  Enabling Schema-Free XQuery with meaningful query focus , 2008, The VLDB Journal.

[17]  Alon Y. Halevy,et al.  A Platform for Personal Information Management and Integration , 2005, CIDR.

[18]  Amihai Motro,et al.  Query Generalization: A Method for Interpreting Null Answers , 1984, Expert Database Workshop.

[19]  Susan B. Davidson,et al.  Towards a Model of Provenance and User Views in Scientific Workflows , 2006, DILS.

[20]  Yannis E. Ioannidis,et al.  Conversational querying , 2006, Inf. Syst..

[21]  Ben Shneiderman,et al.  Determining Causes and Severity of End-User Frustration , 2004, Int. J. Hum. Comput. Interact..

[22]  Chris Nelson,et al.  XML and objects-the future of the e-forms on the Web , 1999, Proceedings. IEEE 8th International Workshops on Enabling Technologies: Infrastructure for Collaborative Enterprises (WET ICE'99).

[23]  Wang Chiew Tan,et al.  An annotation management system for relational databases , 2004, The VLDB Journal.

[24]  Bin Liu,et al.  Michigan Molecular Interactions (MiMI): putting the jigsaw puzzle together , 2006, Nucleic Acids Res..

[25]  Jaideep Srivastava,et al.  Automatic personalization based on Web usage mining , 2000, CACM.

[26]  H. V. Jagadish,et al.  NaLIX: A generic natural language search environment for XML data , 2007, TODS.

[27]  Sepandar D. Kamvar,et al.  An Analytical Comparison of Approaches to Personalizing PageRank , 2003 .

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

[29]  J. Dyer,et al.  A Generalized Utility Model of Disappointment and Regret Effects on Post-Choice Valuation , 1997 .

[30]  Jennifer Widom,et al.  Lineage tracing for general data warehouse transformations , 2003, The VLDB Journal.

[31]  Georgia Koutrika,et al.  Personalization of queries in database systems , 2004, Proceedings. 20th International Conference on Data Engineering.

[32]  David Maier,et al.  Principles of dataspace systems , 2006, PODS '06.

[33]  David A. Patterson,et al.  Experience with evaluating human-assisted recovery processes , 2004, International Conference on Dependable Systems and Networks, 2004.

[34]  H. V. Jagadish,et al.  Constructing a Generic Natural Language Interface for an XML Database , 2006, EDBT.

[35]  Mark V. Springett,et al.  A comparison of usability techniques for evaluating design , 1997, DIS '97.

[36]  James Frew,et al.  Earth System Science Workbench: a data management infrastructure for earth science products , 2001, Proceedings Thirteenth International Conference on Scientific and Statistical Database Management. SSDBM 2001.

[37]  Otis Gospodnetic,et al.  Lucene in Action , 2004 .

[38]  Antonio L. Furtado,et al.  Updating Relational Views , 1985, Query Processing in Database Systems.

[39]  Robin Abraham.  FoXQ - XQuery by forms , 2003, IEEE Symposium on Human Centric Computing Languages and Environments, 2003. Proceedings. 2003.

[40]  Peter J. Haas,et al.  Making DB2Products Self-Managing: Strategies and Experiences , 2006, IEEE Data Eng. Bull..

[41]  P. Shannon,et al.  Cytoscape: a software environment for integrated models of biomolecular interaction networks. , 2003, Genome research.

[42]  Andrew Dillon,et al.  Query by templates: a generalized approach for visual query formulation for text dominated databases , 1997, Proceedings of ADL '97 Forum on Research and Technology. Advances in Digital Libraries.

[43]  Peter Thanisch,et al.  Natural language interfaces to databases – an introduction , 1995, Natural Language Engineering.

[44]  Werner Nutt,et al.  EquiX - A search and query language for XML , 2000, J. Assoc. Inf. Sci. Technol..

[45]  H. V. Jagadish,et al.  Effective Phrase Prediction , 2007, VLDB.

[46]  Gerhard Weikum,et al.  Rethinking Database System Architecture: Towards a Self-Tuning RISC-Style Database System , 2000, VLDB.

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

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

[49]  James Cheney,et al.  Provenance management in curated databases , 2006, SIGMOD Conference.

[50]  Cong Yu,et al.  Schema-Free XQuery , 2004, VLDB.

[51]  Paul P. Maglio,et al.  System administrators are users, too: designing workspaces for managing internet-scale systems , 2003, CHI Extended Abstracts.

[52]  Jennifer Widom,et al.  ULDBs: databases with uncertainty and lineage , 2006, VLDB.

[53]  Jennifer Widom,et al.  Trio: A System for Integrated Management of Data, Accuracy, and Lineage , 2004, CIDR.

[54]  Volker Markl,et al.  LEO: An autonomic query optimizer for DB2 , 2003, IBM Syst. J..

[55]  J. F. Kelley,et al.  An iterative design methodology for user-friendly natural language office information applications , 1984, TOIS.

[56]  Oren Etzioni,et al.  Adaptive Web sites , 2000, CACM.

[57]  Jayant Madhavan,et al.  Web-Scale Data Integration: You can afford to Pay as You Go , 2007, CIDR.

[58]  Ben Shneiderman,et al.  Improving the human factors aspect of database interactions , 1978, TODS.

[59]  Cong Yu,et al.  Schema summarization , 2006, VLDB.

[60]  Jane Hunter,et al.  Provenance Explorer - Customized Provenance Views Using Semantic Inferencing , 2006, SEMWEB.

[61]  Lin Guo.  XRANK : Ranked Keyword Search over XML Documents , 2003 .

[62]  Adam Blum,et al.  Microsoft English Query 7.5: Automatic Extraction of Semantics from Relational Databases and OLAP Cubes , 1999, VLDB.

[63]  Tieng K. Yap,et al.  Integrating information retrieval techniques with traditional DB methods in a Web-based database browser , 1998, SAC '98.

[64]  Simon Miles,et al.  PrIMe: a software engineering methodology for developing provenance-aware applications , 2006, SEM '06.

[65]  Anastasia Ailamaki,et al.  Challenges inbuilding a DBMS Resource Advisor , 2006, IEEE Data Eng. Bull..

[66]  C. J. Date.  Database usability , 1983, SIGMOD '83.

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

[68]  Yogesh L. Simmhan,et al.  A survey of data provenance in e-science , 2005, SGMD.

[69]  V. Vianu,et al.  Edinburgh Why and Where: A Characterization of Data Provenance , 2017 .

[70]  Oren Etzioni,et al.  Towards a theory of natural language interfaces to databases , 2003, IUI '03.

[71]  H. V. Jagadish,et al.  NaLIX: an interactive natural language interface for querying XML , 2005, SIGMOD '05.

[72]  Mark V. Springett,et al.  Model mismatch analysis: Towards a deeper explanation of users' usability problems , 2000, Behav. Inf. Technol..

[73]  Yannis Papakonstantinou,et al.  QURSED: querying and reporting semistructured data , 2002, SIGMOD '02.

[74]  Kaizar Amin,et al.  Metadata in the Collaboratory for Multi-Scale Chemical Science , 2003, Dublin Core Conference.

[75]  Yehoshua Sagiv,et al.  XSEarch: A Semantic Search Engine for XML , 2003, VLDB.

[76]  Tao Li,et al.  Addressing diverse user preferences in SQL-query-result navigation , 2007, SIGMOD '07.

[77]  Roy Goldman,et al.  Proximity Search in Databases , 1998, VLDB.

[78]  G. Bell,et al.  A digital life , 2007 .

[79]  Cong Yu,et al.  TIMBER: A native XML database , 2002, The VLDB Journal.

[80]  Michael Stonebraker,et al.  Supporting fine-grained data lineage in a database visualization environment , 1997, Proceedings 13th International Conference on Data Engineering.

[81]  Andreas Pfeiffer.  Why features don't matter anymore: the new laws of digital technology , 2006, UBIQ.

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

[83]  Ivan Mervielde,et al.  The Need for Closure and the Spontaneous Use of Complex and Simple Cognitive Structures , 2003, The Journal of social psychology.

[84]  H. V. Jagadish,et al.  DaNaLIX: a domain-adaptive natural language interface for querying XML , 2007, SIGMOD '07.

[85]  Saurabh Sinha,et al.  Accessing a Medical Database using WWW-Based User Interfaces , 1998 .

[86]  Anthony I. Wasserman,et al.  User Software Engineering and the design of interactive systems , 1981, ICSE '81.

[87]  Cong Yu,et al.  Querying Complex Structured Databases , 2007, VLDB.

[88]  Laks V. S. Lakshmanan,et al.  FleXPath: flexible structure and full-text querying for XML , 2004, SIGMOD '04.

[89]  Jennifer Widom,et al.  Scaling personalized web search , 2003, WWW '03.

[90]  Taher H. Haveliwala.  Topic-Sensitive PageRank: A Context-Sensitive Ranking Algorithm for Web Search , 2003, IEEE Trans. Knowl. Data Eng..

[91]  Sriram Raghavan,et al.  Avatar Information Extraction System , 2006, IEEE Data Eng. Bull..

[92]  S. Sudarshan,et al.  Keyword searching and browsing in databases using BANKS , 2002, Proceedings 18th International Conference on Data Engineering.

[93]  Surajit Chaudhuri,et al.  DBXplorer: a system for keyword-based search over relational databases , 2002, Proceedings 18th International Conference on Data Engineering.

[94]  H. V. Jagadish,et al.  Term Disambiguation in Natural Language Query for XML , 2006, FQAS.