Article

Making database systems usable

Authors:

H. V. Jagadish,

Adriane Chapman,

Magesh Jayapandian,

Cong YuAuthors Info & Claims

SIGMOD '07: Proceedings of the 2007 ACM SIGMOD international conference on Management of data

Pages 13 - 24

https://doi.org/10.1145/1247480.1247483

Published: 11 June 2007 Publication History

Abstract

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.

Supplementary Material

Low Resolution (p13-jagadish_56k.mp4)

Download
72.24 MB

High Resolution (p13-jagadish_768k.mp4)

Download
432.30 MB

References

[1]

R. Abraham. FoXQ - XQuery by forms. In IEEE Symposium on Human Centric Computing Languages and Environments, 2003.

Digital Library

[2]

S. Agrawal, S. Chaudhuri, and G. Das. DBXplorer: A System for Keyword-Based Search over Relational Databases. In ICDE, 2002.

Digital Library

[3]

S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005. In VLDB, 2004.

[4]

S. Amer-Yahia, L. V. S. Lakshmanan, and S. Pandit. FleXPath: Flexible Structure and Full-Text Querying for XML. In SIGMOD, 2004.

Digital Library

[5]

I. Androutsopoulos, G. Ritchie, and P. Thanisch. Natural Language Interfaces to Databases -- an introduction. Journal of Language Engineering, 1(1):29--81, 1995.

[6]

D. Beech. Can SQL3 Be Simplified? Database Programming and Design, 10(1):46--50, Jan 1997.

[7]

G. Bell and J. Gemmell. A Digital Life, 2007.

[8]

O. Benjelloun, A. D. Sarma, A. Halevy, and J. Widom. ULDBs: Databases with Uncertainty and Lineage. In VLDB, 2006.

Digital Library

[9]

F. Benzi, D. Maio, and S. Rizzi. Visionary: A Viewpoint-based Visual Language for Querying Relational Databases. Journal of Visual Languages and Computing, 10(2), 1999.

[10]

D. Bhagwat, L. Chiticariu, W. C. Tan, and G. Vijayvargiya. An Annotation Management System for Relational Databases. In VLDB, 2005.

Digital Library

[11]

G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan. Keyword Searching and Browsing in Databases using BANKS. In ICDE, 2002.

Digital Library

[12]

A. Blum. Microsoft English Query 7.5: Automatic Extraction of Semantics from Relational Databases and OLAP Cubes. In VLDB, 1999.

Digital Library

[13]

D. Braga, A. Campi, and S. Ceri. XQBE (XQuery By Example): A Visual Interface to the Standard XML Query Language. ACM Trans. Database Syst., 30(2), 2005.

Digital Library

[14]

S. Brin and L. Page. The Anatomy of a Large-Scale Hypertextual Web Search Engine. Computer Networks, 30(1-7):107--117, 1998.

Digital Library

[15]

A. Brown, L. Chung, W. Kakes, C. Ling, and D. Patterson. Experience With Evaluating Human-Assisted Recovery Processes. Dependable Systems and Networks, pages 405--410, 2004.

Digital Library

[16]

A. B. Brown, L. C. Chung, and D. A. Patterson. Including the Human Factor in Dependability Benchmarks. In DSN Workshop on Dependability Benchmarking, 2002.

[17]

P. Buneman, A. Chapman, and J. Cheney. Provenance Management in Curated Databases. In SIGMOD, 2006.

Digital Library

[18]

P. Buneman, S. Khanna, and W.-C. Tan. Why and Where: A Characterization of Data Provenance. In ICDT, 2001.

Digital Library

[19]

Business Objects, Inc. Crystal Xcelsius, http://xcelsius.com.

[20]

R. Butterworth, A. Blandford, and D. Duke. Using Formal Models to Explore Display-Based Usability Issues. Journa of Visual Languages and Computing, 10(5), 1999.

[21]

D. Carmel, Y. S. Maarek, M. Mandelbrod, Y. Mass, and A. Soffer. Searching XML Documents via XML Fragments. In SIGIR, 2003.

Digital Library

[22]

I. Ceaparu, J. Lazar, K. Bessiere, J. Robinson, and B. Shneiderman. Determining Causes and Severity of End-User Frustration. International Journal of Human Computer Interaction, 17(3), 2004.

[23]

S. Chaudhuri and G. Weikum. Rethinking Database System Architecture: Towards a Self-Tuning, RISC-style Database System. In VLDB, 2000.

Digital Library

[24]

Z. Chen and T. Li. Addressing Diverse User Preferences in SQL-Query-Result Navigation. In SIGMOD, 2007.

Digital Library

[25]

K. Cheung and J. Hunter. Provenance Explorer - Customized Provenance Views Using Semantic Inferencing. In ISWC, 2006.

Digital Library

[26]

J. Choobineh, M. V. Mannino, and V. P. Tseng. A Form-Based Approach for Database Analysis and Design. CACM, 35(2), 1992.

Digital Library

[27]

S. Cohen, S. C. Boulakia, and S. Davidson. Towards a Model of Scientific Workflows and User Views. In DILS, 2006.

Digital Library

[28]

S. Cohen, Y. Kanza, Y. Kogan, Y. Sagiv, W. Nutt, and A. Serebrenik. EquiX--A Search and Query Language for XML. JASIST, 53(6), 2002.

Digital Library

[29]

S. Cohen, J. Mamou, Y. Kanza, and Y. Sagiv. XSEarch: A Semantic Search Engine for XML. In VLDB, 2003.

Digital Library

[30]

Y. Cui and J. Widom. Lineage Tracing for General Data Warehouse Transformations. In VLDB, 2001.

Digital Library

[31]

DabbleDB. http://www.dabbledb.com/.

[32]

C. J. Date. Database Usability. In SIGMOD, New York, NY, USA, 1983. ACM Press.

[33]

X. Dong and A. Halevy. A Platform for Personal Information Management and Integration. In CIDR, 2005.

[34]

A. Doubleday, M. Ryan, M. Springett, and A. Sutcliffe. A Comparison of Usability Techniques for Evaluating Design. In DIS, 1997.

Digital Library

[35]

A. Elkiss, Y. Li, and H. V. Jagadish. Ranked Relatedness Queries for XML Databases. Technical report, University of Michigan, 2007.

[36]

D. W. Embley. NFQL: The Natural Forms Query Language. ACM Trans. Database Syst., 1989.

Digital Library

[37]

M. Erwig. A Visual Language for XML. In IEEE Symposium on Visual Languages, 2000.

Digital Library

[38]

J. Frew and R. Bose. Earth System Science Workbench: A Data Management Infrastructure for Earth Science Products. In SSDBM, 2001.

Digital Library

[39]

A. Furtado and M. Casanova. Updating relational views. In Query Processing in Database Systems, 1985.

[40]

R. Goldman, N. Shivakumar, S. Venkatasubramanian, and H. Garcia-Molina. Proximity Search in Databases. In VLDB, 1998.

Digital Library

[41]

L. Guo, F. Shao, C. Botev, and J. Shanmugasundaram. XRANK: Ranked Keyword Search over XML Documents. In SIGMOD, 2003.

Digital Library

[42]

A. Y. Halevy, M. J. Franklin, and D. Maier. Principles of Dataspace Systems. In PODS, 2006.

Digital Library

[43]

P. Hanrahan. VizQL: A Language for Query, Analysis and Visualization. SIGMOD, pages 721--721, 2006.

Digital Library

[44]

E. Hatcher and O. Gospodnetic. Lucene in Action. Manning Publications, 2004.

Digital Library

[45]

T. Haveliwala. Topic-Sensitive PageRank: A Context-Sensitive Ranking Algorithm for Web Search. IEEE Transactions on Knowledge and Data Engineering, 15(4):784--796, 2003.

Digital Library

[46]

T. Haveliwala, S. Kamvar, and G. Jeh. An Analytical Comparison of Approaches to Personalizing PageRank, Preprint, June 2003.

[47]

V. Hristidis and Y. Papakonstantinou. DISCOVER: Keyword Search in Relational Databases. In VLDB, 2002.

Digital Library

[48]

J. J. Inman, J. S. Dyer, and J. Jia. A Generalized Utility Model of Disappointement and Regret Effects on Post-Choice Valuation. Marketing Science, 16(2):97--111, 1997.

Digital Library

[49]

Y. E. Ioannidis and S. Viglas. Conversational Querying. Inf. Syst, 31(1):33--56, 2006.

Digital Library

[50]

H. V. Jagadish, S. Al-Khalifa, A. Chapman, L. V. Lakshmanan, A. Nierman, S. Paparizos, J. M. Patel, D. Srivastava, N. Wiwatwattana, Y. Wu, and C. Yu. TIMBER: A Native XML Database. VLDB Journal, 11(4):274--291, 2002.

Digital Library

[51]

M. Jayapandian, A. Chapman, V. G. Tarcea, C. Yu, A. Elkiss, A. Ianni, B. Liu, A. Nandi, C. Santos, P. Andrews, B. Athey, D. States, and H. Jagadish. Michigan Molecular Interactions (MiMI): Putting the Jigsaw Puzzle Together. Nucleic Acids Research, pages D566--D571, Jan 2007.

[52]

T. S. Jayram, R. Krishnamurthy, S. Raghavan, S. Vaithyanathan, and H. Zhu. Avatar Information Extraction System. IEEE Data Eng. Bull., 29(1):40--48, 2006.

[53]

G. Jeh and J. Widom. Scaling Personalized Web Search. WWW, pages 271--279, 2003.

Digital Library

[54]

Y. Kanza and Y. Sagiv. Flexible Queries Over Semistructured Data. In PODS, 2001.

Digital Library

[55]

J. F. Kelley. An Iterative Design Methodology for User-Friendly Natural Language Office Information Applications. ACM Trans. Database Syst., 2(1), 1984.

Digital Library

[56]

G. Koutrika and Y. Ioannidis. Personalization of Queries in Database Systems. In ICDE, 2004.

Digital Library

[57]

Y. Li, I. Chaudhuri, H. Yang, S. Singh, and H. V. Jagadish. DaNaLIX: a Domain-adaptive Natural Language Interface for Querying XML. In SIGMOD, 2007.

Digital Library

[58]

Y. Li, H. Yang, and H. V. Jagadish. NaLIX: an Interactive Natural Language Interface for Querying XML. In SIGMOD, 2005.

Digital Library

[59]

Y. Li, H. Yang, and H. V. Jagadish. Constructing a Generic Natural Language Interface for an XML Database. In EDBT, 2006.

Digital Library

[60]

Y. Li, H. Yang, and H. V. Jagadish. Term Disambiguation in Natural Language Query for XML. In FQAS, 2006.

Digital Library

[61]

Y. Li, H. Yang, and H. V. Jagadish. NaLIX: A Generic Natural Language Search Environment for XML Data. acmtds, accepted.

[62]

Y. Li, C. Yu, and H. V. Jagadish. Schema-Free XQuery. In VLDB, 2004.

Digital Library

[63]

Y. Li, C. Yu, and H. V. Jagadish. Enabling Schema-Free XQuery with Meaningful Query Focus. VLDB Journal, in press.

Digital Library

[64]

S. Lightstone, G. M. Lohman, P. J. Haas, et al. MakingDB2 Products Self-Managing: Strategies and Experiences. IEEE Data Eng. Bull, 29(3):16--23, 2006.

[65]

J. Madhavan, S. Jeffery, S. Cohen, X. Dong, D. Ko, C. Yu, and A. Halevy. Web-scale Data Integration: You Can Only Afford to Pay As You Go. In CIDR, 2007.

[66]

V. Markl, G. M. Lohman, and V. Raman. LEO: An Autonomic Query Optimizer for DB2. IBM Systems Journal, 42(1):98--106, 2003.

Digital Library

[67]

I. Mervielde. The Need for Closure and the Spontaneous Use of Complex and Simple Cognitive Structures. The Journal of Social Psychology, 2003.

[68]

K. Mitchell and J. Kennedy. DRIVE: An Environment for the Organized Construction of User-Interfaces to Databases. In Interfaces to Databases (IDS-3), 1996.

Digital Library

[69]

B. Mobasher, R. Cooley, and J. Srivastava. Automatic Personalization Based on Web Usage Mining. CACM, 43(8):142--151, 2000.

Digital Library

[70]

A. Motro. Query generalization: A method for interpreting null answers. In Workshop on Expert Database Systems, 1986.

[71]

P. Mukhopadhyay and Y. Papakonstantinou. Mixing Querying and Navigation in MIX. In ICDE, 2002.

[72]

S. Munroe, S. Miles, L. Moreau, and J. Vázquez-Salceda. PrIMe: A Software Engineering Methodology for Developing Provenance-Aware Applications. In SEM, 2006.

Digital Library

[73]

N. Murray, N. Paton, and C. Goble. Kaleidoquery: A Visual Query Language for Object Databases. In Advanced Visual Interfaces, 1998.

Digital Library

[74]

A. Nandi and H. V. Jagadish. Assisted Querying using Instant-Response Interfaces. In SIGMOD, 2007.

Digital Library

[75]

A. Nandi and H. V. Jagadish. Effective Phrase Prediction. Technical report, University of Michigan, 2007.

[76]

OpenRecord. http://www.openrecord.org/.

[77]

D. Oppenheimer. The Importance of Understanding Distributed System Configuration. System Administrators are Users, Too: Designing Workspaces for Managing Internet-scale Systems, CHI 2003 Workshop, 2003.

[78]

C. Pancerella, J. Hewson, W. Koegler, et al. Metadata in the Collaboratory for Multi-Scale Chemical Science. In Dublin Core Conference, 2003.

Digital Library

[79]

Y. Papakonstantinou, M. Petropoulos, and V. Vassalos. QURSED: Querying and Reporting Semistructured Data. In SIGMOD, 2002.

Digital Library

[80]

M. Perkowitz and O. Etzioni. Adaptive Web Sites. CACM, 43(8):152--158, 2000.

Digital Library

[81]

A. Pfeiffer. Why Features Don't Matter Anymore: The New Laws of Digital Technology. Ubiquity, 7(7), Feburary 2006.

Digital Library

[82]

Pilot Software. http://www.pilotsoftware.com/.

[83]

A.-M. Popescu, O. Etzioni, and H. A. Kautz. Towards a Theory of Natural Language Interfaces to Databases. In IUI, 2003.

Digital Library

[84]

R. E. Sabin and T. K. Yap. Integrating Information Retrieval Techniques with Traditional DB Methods in a Web-Based Database Browser. In SAC, 1998.

Digital Library

[85]

A. Sengupta and A. Dillon. Query by Templates: A Generalized Approach for Visual Query Formulation for Text Dominated Databases. In ADL, 1997.

Digital Library

[86]

P. Shannon et al. Cytoscape: A Software Environment for Integrated Models of Biomolecular Interaction Networks. Genome Res, 13(11):2498--504, 2003.

[87]

B. Sheneiderman. Improving the Human Factors Aspect of Database Interactions. ACM Trans. Database Syst., 3(4),1978.

Digital Library

[88]

S. M. Shugan. The Cost of Thinking. Journal of Consumer Research, 7(2):99--111, 1980.

[89]

Y. Simmhan, B. Plale, and D. Gannon. A Survey of Data Provenance in E-Science. SIGMOD Record, 34(3):31--36, 2005.

Digital Library

[90]

S. Sinha, K. Bowers, and S. A. Mamrak. Accessing a Medical Database using WWW-Based User Interfaces. Technical report, Ohio State University, 1998.

[91]

C. Soules, S. Shah, G. R. Ganger, and B. D. Noble. It's Time to Bite the User Study Bullet. Technical report, University of Michigan, 2007.

[92]

A. Sutcliffe, M. Ryan, A. Doubleday, and M. Springett. Model Mismatch Analysis: Towards a Deeper Explanation of Users' Usability Problems. Behavior & Information Technology, 19(1), 2000.

[93]

A. Tornqvist, C. Nelson, and M. Johnsson. XML and Objects - The Future for E-Forms on the Web. In WETICE. IEEE Computer Society, 1999.

Digital Library

[94]

A. I. Wasserman. User Software Engineering and the Design of Interactive Systems. In ICSE, Piscataway, NJ, USA, 1981. IEEE Press.

Digital Library

[95]

J. Widom. Trio: A System for Integrated Management of Data, Accuracy, and Lineage. In CIDR, 2005.

[96]

A. Woodruff and M. Stonebraker. Supporting Fine-grained Data Lineage in a Database Visualization Environment. In ICDE, 1997.

Digital Library

[97]

C. Yu and H. V. Jagadish. Schema Summarization. In VLDB, 2006.

Digital Library

[98]

C. Yu and H. V. Jagadish. Querying Complex Structured Databases. Technical report, University of Michigan, 2007.

[99]

W. Yuan. End-User Searching Behavior in Information Retrieval: A Longitudinal Study. JASIST, 48(3), 1997.

Digital Library

[100]

M. M. Zloof. Query-by-Example: the Invocation and Definition of Tables and Forms. In VLDB, 1975.

Digital Library

Cited By

Tian YKummerfeld JLi TZhang T(2024)SQLucid: Grounding Natural Language Database Queries with Interactive ExplanationsProceedings of the 37th Annual ACM Symposium on User Interface Software and Technology10.1145/3654777.3676368(1-20)Online publication date: 13-Oct-2024
https://dl.acm.org/doi/10.1145/3654777.3676368
Sun PYu HWei Y(2024)Top-k Query Algorithm on Massive Data2024 IEEE 7th Advanced Information Technology, Electronic and Automation Control Conference (IAEAC)10.1109/IAEAC59436.2024.10503603(1923-1929)Online publication date: 15-Mar-2024
https://doi.org/10.1109/IAEAC59436.2024.10503603
Soni KSachdeva S(2024)MTable: Visual Query Interface for Browsing and Navigation in NoSQL Data StoresJournal of Computer Languages10.1016/j.cola.2024.101312(101312)Online publication date: Dec-2024
https://doi.org/10.1016/j.cola.2024.101312
Show More Cited By

Index Terms

Making database systems usable
1. Human-centered computing
2. Information systems
  1. Data management systems

Recommendations

An object-oriented prototype for a geophysical database
SSST '95: Proceedings of the 27th Southeastern Symposium on System Theory (SSST'95)

Database management systems (DBMSs) are being used in a wide variety of domains to handle many types of data. Scientific data pose a special challenge to DBMSs due to their volume and complex nature. The object-oriented model has many additional ...
Database Research: Are We at a Crossroad? Reflection on NoSQL
NBIS '12: Proceedings of the 2012 15th International Conference on Network-Based Information Systems

The demand to process large sets of data has increased in the last few years from both the scientific and business community. To serve this demand, a number of new databases have been introduced that are not based on relational models. This group of ...
Database Systems: A Practical Approach to Design, Implementation and Management

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '07: Proceedings of the 2007 ACM SIGMOD international conference on Management of data

June 2007

1210 pages

ISBN:9781595936868

DOI:10.1145/1247480

General Chairs:
Lizhu Zhou
Tsinghua University, China
,
Tok Wang Ling
National University of Singapore, Singapore
,
Program Chair:
Beng Chin Ooi
National University of Singapore, Singapore

Copyright © 2007 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 11 June 2007

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

SIGMOD/PODS07

Sponsor:

SIGMOD/PODS07: International Conference on Management of Data

June 11 - 14, 2007

Beijing, China

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

211
Total Citations
View Citations
276
Total Downloads

Downloads (Last 12 months)44
Downloads (Last 6 weeks)6

Reflects downloads up to 08 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Tian YKummerfeld JLi TZhang T(2024)SQLucid: Grounding Natural Language Database Queries with Interactive ExplanationsProceedings of the 37th Annual ACM Symposium on User Interface Software and Technology10.1145/3654777.3676368(1-20)Online publication date: 13-Oct-2024
https://dl.acm.org/doi/10.1145/3654777.3676368
Sun PYu HWei Y(2024)Top-k Query Algorithm on Massive Data2024 IEEE 7th Advanced Information Technology, Electronic and Automation Control Conference (IAEAC)10.1109/IAEAC59436.2024.10503603(1923-1929)Online publication date: 15-Mar-2024
https://doi.org/10.1109/IAEAC59436.2024.10503603
Soni KSachdeva S(2024)MTable: Visual Query Interface for Browsing and Navigation in NoSQL Data StoresJournal of Computer Languages10.1016/j.cola.2024.101312(101312)Online publication date: Dec-2024
https://doi.org/10.1016/j.cola.2024.101312
An YGreenberg JUribe-Romo FGómez-Gualdrón DLanglois KFurst JKalinowski AZhao XHu X(2024)Knowledge Graph Question Answering for Materials Science (KGQA4MAT)Metadata and Semantic Research10.1007/978-3-031-65990-4_2(18-29)Online publication date: 31-Jul-2024
https://doi.org/10.1007/978-3-031-65990-4_2
Chen ZManolios PRiedewald M(2023)Why Not Yet: Fixing a Top-k Ranking that is Not Fair to IndividualsProceedings of the VLDB Endowment10.14778/3598581.359860616:9(2377-2390)Online publication date: 10-Jul-2023
https://dl.acm.org/doi/10.14778/3598581.3598606
Kennedy OGlavic BBrachmann M(2023)Overlay SpreadsheetsProceedings of the Workshop on Human-In-the-Loop Data Analytics10.1145/3597465.3605220(1-7)Online publication date: 21-Jul-2023
https://doi.org/10.1145/3597465.3605220
de Carvalho TMartins Dde Lima Neto F(2023)Human-in-the-Loop Evolution of Database Views for Data Exploration2023 IEEE Latin American Conference on Computational Intelligence (LA-CCI)10.1109/LA-CCI58595.2023.10409423(1-6)Online publication date: 29-Oct-2023
https://doi.org/10.1109/LA-CCI58595.2023.10409423
De Carvalho TMartins DDe Lima Neto FVossen G(2022)Recommending View Bundles in Data Marketplaces2022 IEEE International Conference on Systems, Man, and Cybernetics (SMC)10.1109/SMC53654.2022.9945110(3403-3408)Online publication date: 9-Oct-2022
https://doi.org/10.1109/SMC53654.2022.9945110
Parkin LChardin BJean SHadjali ABaron M(2022)A cooperative treatment of the plethoric answers problem in RDFKnowledge and Information Systems10.1007/s10115-022-01710-864:9(2481-2514)Online publication date: 13-Aug-2022
https://doi.org/10.1007/s10115-022-01710-8
Parkin LChardin BJean SHadjali A(2022)Explaining Unexpected Answers of SPARQL QueriesWeb Information Systems Engineering – WISE 202210.1007/978-3-031-20891-1_11(136-151)Online publication date: 7-Nov-2022
https://doi.org/10.1007/978-3-031-20891-1_11
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten