DBScholar

Back to papers

Making Database Systems Usable

Summary: Pinpoints five usability pain points in today's databases and outlines a usability research agenda. Proposes a presentation data model with a schema-later approach, emphasizing direct data manipulation, provenance, and cross-model consistency. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3897
Venue
SIGMOD
Year
2007
Pagerank
0.00021574636
Overall Rank
314 | 97.85%
DOI
10.1145/1247480.1247483

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{jagadish_sigmod07,
        title = {{Making Database Systems Usable}},
        author = {Jagadish, H. V. and Chapman, Adriane and Elkiss, Aaron and Jayapandian, Magesh and Li, Yunyao and Nandi, Arnab and Yu, Cong},
        series = {{SIGMOD} '07},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1247480.1247483},
        url = {https://dl.acm.org/doi/10.1145/1247480.1247483},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 47 of 47 citing papers.

Rank Citing Paper Year Venue Pagerank
517 Query by Output 2009 SIGMOD 0.00017169735
530 An Analytical Study of Large SPARQL Query Logs 2018 VLDB 0.0001709169
846 SnipSuggest: Context-Aware Autocompletion for SQL 2011 VLDB 0.00013658824
856 How to ConQueR Why-Not Questions 2010 SIGMOD 0.00013573466
919 Provenance and Scientific Workflows: Challenges and Opportunities 2008 SIGMOD 0.00013214041
1,070 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.0001232307
1,098 Google Fusion Tables: Web-Centered Data Management and Collaboration 2010 SIGMOD 0.00012179025
1,262 Discovering Queries based on Example Tuples 2014 SIGMOD 0.00011427456
1,532 Summarizing Relational Databases 2009 VLDB 0.00010472227
1,701 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.9707165e-05
1,751 Sample-Driven Schema Mapping 2012 SIGMOD 9.838446e-05
2,087 Guided Interaction: Rethinking the Query-Result Paradigm 2011 VLDB 9.1914119e-05
2,631 FastQRE: Fast Query Reverse Engineering 2018 SIGMOD 8.3231158e-05
2,800 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 8.1124117e-05
2,895 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.9829449e-05
2,946 Gestural Query Specification 2014 VLDB 7.93259e-05
3,056 VIIQ: Auto-Suggestion Enabled Visual Interface for Interactive Graph Query Formulation 2015 VLDB 7.8075329e-05
3,239 Keyword Search on Structured and Semi-Structured Data 2009 SIGMOD 7.6078324e-05
3,982 WYSIWYG Development of Data Driven Web Applications 2008 VLDB 6.9745342e-05
4,046 Expressive Query Construction through Direct Manipulation of Nested Relational Results 2016 SIGMOD 6.9392871e-05
4,140 Interactive Mapping Specification with Exemplar Tuples 2017 SIGMOD 6.8765495e-05
4,206 NoDB in Action: Adaptive Query Processing on Raw Data 2012 VLDB 6.8334568e-05
4,350 SocialScope: Enabling Information Discovery on Social Content Sites 2009 CIDR 6.7499856e-05
4,721 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.5444379e-05
4,904 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.4503063e-05
5,039 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.3909067e-05
5,084 Querying Without Keyboards 2013 CIDR 6.3692734e-05
5,132 Facilitating SQL Query Composition and Analysis 2020 SIGMOD 6.3534526e-05
5,278 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.2856584e-05
5,887 Call to Order: A Hierarchical Browsing Approach to Eliciting Users' Preference 2010 SIGMOD 6.0500409e-05
5,919 PI2: End-to-end Interactive Visualization Interface Generation from Queries 2022 SIGMOD 6.0426677e-05
5,976 Interactive Browsing and Navigation in Relational Databases 2016 VLDB 6.0219844e-05
6,059 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.9915079e-05
6,627 Schema-free SQL 2014 SIGMOD 5.8198662e-05
6,693 GestureQuery: A Multitouch Database Query Interface 2013 VLDB 5.7992988e-05
7,312 Closing the functional and Performance Gap between SQL and NoSQL 2016 SIGMOD 5.6480976e-05
7,635 Qunits: queried units for database search 2009 CIDR 5.5769911e-05
7,989 Where To: Crowd-Aided Path Selection 2014 VLDB 5.5111036e-05
8,174 Databases will Visualize Queries too 2011 VLDB 5.4738201e-05
8,511 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.4119882e-05
8,884 GBLENDER: Towards Blending Visual Query Formulation and Query Processing in Graph Databases 2010 SIGMOD 5.3514928e-05
8,972 CRIUS: User-Friendly Database Design 2011 VLDB 5.3414676e-05
9,832 The Data Interaction Game 2018 SIGMOD 5.2124469e-05
11,886 Enabling Data Science for the Majority 2019 VLDB 5.093636e-05
12,217 The Case for Personal Data-Driven Decision Making 2014 VLDB 5.093636e-05
12,382 DBWiki: A Structured Wiki for Curated Data and Collaborative Data Management 2011 SIGMOD 5.093636e-05
12,428 Pay-As-You-Go - An Adaptive Approach to Provide Full Context-Aware Text Search over Document Content 2010 SIGMOD 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 28 of 28 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
37 DISCOVER: Keyword Search in Relational Databases 2002 VLDB 0.00048017193
77 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00037048607
78 ULDBs: Databases with Uncertainty and Lineage 2006 VLDB 0.00036571789
125 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030932014
301 Proximity Search in Databases 1998 VLDB 0.00022032878
399 XSEarch: A Semantic Search Engine for XML 2003 VLDB 0.00019177959
496 Schema-Free XQuery 2004 VLDB 0.0001750537
501 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001738508
531 An Annotation Management System for Relational Databases 2004 VLDB 0.00017083233
585 Lineage Tracing for General Data Warehouse Transformations 2001 VLDB 0.00016139897
600 Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System 2000 VLDB 0.00015871387
969 Web-scale Data Integration: You can only afford to Pay As You Go 2007 CIDR 0.00012892148
1,162 Principles of Dataspace Systems 2006 PODS 0.00011866011
1,305 Assisted Querying using Instant-Response Interfaces 2007 SIGMOD 0.00011235196
1,702 Schema Summarization 2006 VLDB 9.9697258e-05
1,725 Addressing Diverse User Preferences in SQL-Query-Result Navigation 2007 SIGMOD 9.9197083e-05
2,134 Provenance Management in Curated Databases 2006 SIGMOD 9.1154913e-05
2,138 Flexible Queries over Semistructured Data 2001 PODS 9.109132e-05
2,176 Effective Phrase Prediction 2007 VLDB 9.0172465e-05
2,236 A Platform for Personal Information Management and Integration 2005 CIDR 8.8902064e-05
2,412 NaLIX: an Interactive Natural Language Interface for Querying XML 2005 SIGMOD 8.6124752e-05
2,489 VizQL: A Language for Query, Analysis and Visualization 2006 SIGMOD 8.5090714e-05
2,616 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.339188e-05
3,492 QURSED: Querying and Reporting Semistructured Data 2002 SIGMOD 7.3652707e-05
4,131 Querying Complex Structured Databases 2007 VLDB 6.8834743e-05
5,160 Microsoft English Query 7.5: Automatic Extraction of Semantics from Relational Databases and OLAP Cubes 1999 VLDB 6.3399587e-05
5,840 DaNaLIX: a Domain-adaptive Natural Language Interface for Querying XML 2007 SIGMOD 6.0693725e-05
7,485 Database Usability 1983 SIGMOD 5.6073178e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 11,499 Towards Auto-Generated Data Systems 2023 VLDB
2 8,300 Dynamic Derivation of Personalized Views 1988 VLDB
3 6,063 A Graph-Oriented Object Model for Database End-User Interfaces 1990 SIGMOD
4 14,326 User Interfaces; Who Cares? 1994 VLDB
5 13,229 Conceptual-To-Internal Mappings in Commercial Database Systems 1984 PODS
6 14,564 User Performance Considerations in DBMS Selection 1977 SIGMOD
7 9,328 Forms Approach to Requirements Specification for Database Design 1983 SIGMOD
8 12,359 The Schema-Independent Database UI: A Proposed Holy Grail and Some Suggestions 2011 CIDR
9 13,564 Poor Usability in Data Processing 2015 CIDR
10 7,485 Database Usability 1983 SIGMOD