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
h3fc7313eebe980cc
Venue
SIGMOD
Year
2007
Pagerank
0.00021093212
Overall Rank
321 | 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
520 Query by Output 2009 SIGMOD 0.00016910379
536 An Analytical Study of Large SPARQL Query Logs 2018 VLDB 0.00016738841
790 How to ConQueR Why-Not Questions 2010 SIGMOD 0.00013929166
864 SnipSuggest: Context-Aware Autocompletion for SQL 2011 VLDB 0.00013358173
949 Provenance and Scientific Workflows: Challenges and Opportunities 2008 SIGMOD 0.00012897365
1,072 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012143482
1,114 Google Fusion Tables: Web-Centered Data Management and Collaboration 2010 SIGMOD 0.00011939972
1,275 Discovering Queries based on Example Tuples 2014 SIGMOD 0.00011213614
1,559 Summarizing Relational Databases 2009 VLDB 0.00010220719
1,751 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7128647e-05
1,787 Sample-Driven Schema Mapping 2012 SIGMOD 9.6333179e-05
2,141 Guided Interaction: Rethinking the Query-Result Paradigm 2011 VLDB 8.9671737e-05
2,686 FastQRE: Fast Query Reverse Engineering 2018 SIGMOD 8.1157127e-05
2,862 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.9096239e-05
2,975 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.7807277e-05
3,016 Gestural Query Specification 2014 VLDB 7.7360586e-05
3,126 VIIQ: Auto-Suggestion Enabled Visual Interface for Interactive Graph Query Formulation 2015 VLDB 7.604994e-05
3,323 Keyword Search on Structured and Semi-Structured Data 2009 SIGMOD 7.4116032e-05
4,073 Expressive Query Construction through Direct Manipulation of Nested Relational Results 2016 SIGMOD 6.8067223e-05
4,098 WYSIWYG Development of Data Driven Web Applications 2008 VLDB 6.7943146e-05
4,234 Interactive Mapping Specification with Exemplar Tuples 2017 SIGMOD 6.7034362e-05
4,312 NoDB in Action: Adaptive Query Processing on Raw Data 2012 VLDB 6.6567338e-05
4,465 SocialScope: Enabling Information Discovery on Social Content Sites 2009 CIDR 6.5742791e-05
4,638 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.4750914e-05
5,058 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.2817535e-05
5,149 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2382463e-05
5,160 Facilitating SQL Query Composition and Analysis 2020 SIGMOD 6.2354336e-05
5,168 Querying Without Keyboards 2013 CIDR 6.2335584e-05
5,374 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.140487e-05
6,024 Call to Order: A Hierarchical Browsing Approach to Eliciting Users' Preference 2010 SIGMOD 5.8919629e-05
6,054 PI2: End-to-end Interactive Visualization Interface Generation from Queries 2022 SIGMOD 5.8847669e-05
6,111 Interactive Browsing and Navigation in Relational Databases 2016 VLDB 5.8672641e-05
6,195 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.8374071e-05
6,741 GestureQuery: A Multitouch Database Query Interface 2013 VLDB 5.6772414e-05
6,745 Schema-free SQL 2014 SIGMOD 5.6743387e-05
7,479 Closing the functional and Performance Gap between SQL and NoSQL 2016 SIGMOD 5.5015337e-05
7,813 Qunits: queried units for database search 2009 CIDR 5.4312588e-05
8,090 Where To: Crowd-Aided Path Selection 2014 VLDB 5.3745898e-05
8,295 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.344057e-05
8,359 Databases will Visualize Queries too 2011 VLDB 5.3311423e-05
9,071 GBLENDER: Towards Blending Visual Query Formulation and Query Processing in Graph Databases 2010 SIGMOD 5.2118226e-05
9,161 CRIUS: User-Friendly Database Design 2011 VLDB 5.2036315e-05
10,057 The Data Interaction Game 2018 SIGMOD 5.0766855e-05
12,235 Enabling Data Science for the Majority 2019 VLDB 4.9605343e-05
12,557 The Case for Personal Data-Driven Decision Making 2014 VLDB 4.9605343e-05
12,722 DBWiki: A Structured Wiki for Curated Data and Collaborative Data Management 2011 SIGMOD 4.9605343e-05
12,768 Pay-As-You-Go - An Adaptive Approach to Provide Full Context-Aware Text Search over Document Content 2010 SIGMOD 4.9605343e-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
38 DISCOVER: Keyword Search in Relational Databases 2002 VLDB 0.00047300197
81 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00036224963
85 ULDBs: Databases with Uncertainty and Lineage 2006 VLDB 0.00035848027
127 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030337791
303 Proximity Search in Databases 1998 VLDB 0.00021577595
412 XSEarch: A Semantic Search Engine for XML 2003 VLDB 0.00018712693
493 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001735831
509 Schema-Free XQuery 2004 VLDB 0.00017102298
529 An Annotation Management System for Relational Databases 2004 VLDB 0.00016834919
592 Lineage Tracing for General Data Warehouse Transformations 2001 VLDB 0.0001583562
604 Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System 2000 VLDB 0.00015642703
994 Web-scale Data Integration: You can only afford to Pay As You Go 2007 CIDR 0.00012610224
1,120 Principles of Dataspace Systems 2006 PODS 0.00011920747
1,312 Assisted Querying using Instant-Response Interfaces 2007 SIGMOD 0.00011061014
1,739 Addressing Diverse User Preferences in SQL-Query-Result Navigation 2007 SIGMOD 9.7313713e-05
1,745 Schema Summarization 2006 VLDB 9.7195373e-05
2,160 Flexible Queries over Semistructured Data 2001 PODS 8.9217916e-05
2,186 Provenance Management in Curated Databases 2006 SIGMOD 8.8910881e-05
2,232 Effective Phrase Prediction 2007 VLDB 8.7867154e-05
2,291 A Platform for Personal Information Management and Integration 2005 CIDR 8.680498e-05
2,454 NaLIX: an Interactive Natural Language Interface for Querying XML 2005 SIGMOD 8.4238724e-05
2,524 VizQL: A Language for Query, Analysis and Visualization 2006 SIGMOD 8.3312108e-05
2,677 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.1266688e-05
3,574 QURSED: Querying and Reporting Semistructured Data 2002 SIGMOD 7.1772903e-05
4,225 Querying Complex Structured Databases 2007 VLDB 6.7098929e-05
5,121 Microsoft English Query 7.5: Automatic Extraction of Semantics from Relational Databases and OLAP Cubes 1999 VLDB 6.2516921e-05
5,976 DaNaLIX: a Domain-adaptive Natural Language Interface for Querying XML 2007 SIGMOD 5.9108167e-05
7,638 Database Usability 1983 SIGMOD 5.4627536e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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