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.00021155013
Overall Rank
319 | 97.86%
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
519 Query by Output 2009 SIGMOD 0.00016937515
540 An Analytical Study of Large SPARQL Query Logs 2018 VLDB 0.0001671863
791 How to ConQueR Why-Not Questions 2010 SIGMOD 0.00013970743
862 SnipSuggest: Context-Aware Autocompletion for SQL 2011 VLDB 0.0001339689
943 Provenance and Scientific Workflows: Challenges and Opportunities 2008 SIGMOD 0.00012939577
1,070 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012179575
1,112 Google Fusion Tables: Web-Centered Data Management and Collaboration 2010 SIGMOD 0.00011975206
1,273 Discovering Queries based on Example Tuples 2014 SIGMOD 0.00011243661
1,558 Summarizing Relational Databases 2009 VLDB 0.00010252433
1,739 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7448851e-05
1,776 Sample-Driven Schema Mapping 2012 SIGMOD 9.6631141e-05
2,132 Guided Interaction: Rethinking the Query-Result Paradigm 2011 VLDB 8.991777e-05
2,679 FastQRE: Fast Query Reverse Engineering 2018 SIGMOD 8.1415698e-05
2,854 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.93571e-05
2,958 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.80653e-05
3,005 Gestural Query Specification 2014 VLDB 7.7609244e-05
3,118 VIIQ: Auto-Suggestion Enabled Visual Interface for Interactive Graph Query Formulation 2015 VLDB 7.6301919e-05
3,313 Keyword Search on Structured and Semi-Structured Data 2009 SIGMOD 7.4350441e-05
4,048 Expressive Query Construction through Direct Manipulation of Nested Relational Results 2016 SIGMOD 6.8293035e-05
4,075 WYSIWYG Development of Data Driven Web Applications 2008 VLDB 6.8168554e-05
4,217 Interactive Mapping Specification with Exemplar Tuples 2017 SIGMOD 6.725391e-05
4,294 NoDB in Action: Adaptive Query Processing on Raw Data 2012 VLDB 6.6788179e-05
4,443 SocialScope: Enabling Information Discovery on Social Content Sites 2009 CIDR 6.5960716e-05
4,619 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.4965731e-05
5,033 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.3025938e-05
5,134 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2573427e-05
5,159 Facilitating SQL Query Composition and Analysis 2020 SIGMOD 6.2464819e-05
5,169 Querying Without Keyboards 2013 CIDR 6.243071e-05
5,359 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.1608586e-05
6,012 Call to Order: A Hierarchical Browsing Approach to Eliciting Users' Preference 2010 SIGMOD 5.9115096e-05
6,041 PI2: End-to-end Interactive Visualization Interface Generation from Queries 2022 SIGMOD 5.9042901e-05
6,095 Interactive Browsing and Navigation in Relational Databases 2016 VLDB 5.8867043e-05
6,185 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.8561596e-05
6,729 Schema-free SQL 2014 SIGMOD 5.6924451e-05
6,768 GestureQuery: A Multitouch Database Query Interface 2013 VLDB 5.6850207e-05
7,460 Closing the functional and Performance Gap between SQL and NoSQL 2016 SIGMOD 5.5197855e-05
7,798 Qunits: queried units for database search 2009 CIDR 5.4492775e-05
8,144 Where To: Crowd-Aided Path Selection 2014 VLDB 5.3898812e-05
8,279 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.3617864e-05
8,346 Databases will Visualize Queries too 2011 VLDB 5.3488022e-05
9,051 GBLENDER: Towards Blending Visual Query Formulation and Query Processing in Graph Databases 2010 SIGMOD 5.2290958e-05
9,139 CRIUS: User-Friendly Database Design 2011 VLDB 5.220895e-05
10,021 The Data Interaction Game 2018 SIGMOD 5.0935279e-05
12,192 Enabling Data Science for the Majority 2019 VLDB 4.9769913e-05
12,514 The Case for Personal Data-Driven Decision Making 2014 VLDB 4.9769913e-05
12,679 DBWiki: A Structured Wiki for Curated Data and Collaborative Data Management 2011 SIGMOD 4.9769913e-05
12,725 Pay-As-You-Go - An Adaptive Approach to Provide Full Context-Aware Text Search over Document Content 2010 SIGMOD 4.9769913e-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.00047373961
81 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00036330407
84 ULDBs: Databases with Uncertainty and Lineage 2006 VLDB 0.00035960573
126 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030430114
303 Proximity Search in Databases 1998 VLDB 0.00021632881
411 XSEarch: A Semantic Search Engine for XML 2003 VLDB 0.00018769329
492 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017406029
505 Schema-Free XQuery 2004 VLDB 0.00017153776
525 An Annotation Management System for Relational Databases 2004 VLDB 0.00016889428
590 Lineage Tracing for General Data Warehouse Transformations 2001 VLDB 0.00015884721
604 Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System 2000 VLDB 0.00015664234
992 Web-scale Data Integration: You can only afford to Pay As You Go 2007 CIDR 0.00012641942
1,114 Principles of Dataspace Systems 2006 PODS 0.00011959287
1,311 Assisted Querying using Instant-Response Interfaces 2007 SIGMOD 0.00011061025
1,732 Addressing Diverse User Preferences in SQL-Query-Result Navigation 2007 SIGMOD 9.7633187e-05
1,736 Schema Summarization 2006 VLDB 9.7505629e-05
2,150 Flexible Queries over Semistructured Data 2001 PODS 8.9511631e-05
2,172 Provenance Management in Curated Databases 2006 SIGMOD 8.9202679e-05
2,215 Effective Phrase Prediction 2007 VLDB 8.8154455e-05
2,276 A Platform for Personal Information Management and Integration 2005 CIDR 8.7080472e-05
2,452 NaLIX: an Interactive Natural Language Interface for Querying XML 2005 SIGMOD 8.4419506e-05
2,522 VizQL: A Language for Query, Analysis and Visualization 2006 SIGMOD 8.3440526e-05
2,666 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.1527901e-05
3,566 QURSED: Querying and Reporting Semistructured Data 2002 SIGMOD 7.200715e-05
4,208 Querying Complex Structured Databases 2007 VLDB 6.7308334e-05
5,098 Microsoft English Query 7.5: Automatic Extraction of Semantics from Relational Databases and OLAP Cubes 1999 VLDB 6.271756e-05
5,963 DaNaLIX: a Domain-adaptive Natural Language Interface for Querying XML 2007 SIGMOD 5.9304072e-05
7,624 Database Usability 1983 SIGMOD 5.4806821e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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