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.00021164857
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
518 Query by Output 2009 SIGMOD 0.00016944862
540 An Analytical Study of Large SPARQL Query Logs 2018 VLDB 0.00016726545
791 How to ConQueR Why-Not Questions 2010 SIGMOD 0.00013976192
861 SnipSuggest: Context-Aware Autocompletion for SQL 2011 VLDB 0.00013402933
943 Provenance and Scientific Workflows: Challenges and Opportunities 2008 SIGMOD 0.00012945546
1,069 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012185253
1,112 Google Fusion Tables: Web-Centered Data Management and Collaboration 2010 SIGMOD 0.00011980744
1,272 Discovering Queries based on Example Tuples 2014 SIGMOD 0.00011248674
1,558 Summarizing Relational Databases 2009 VLDB 0.00010257165
1,737 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7494976e-05
1,776 Sample-Driven Schema Mapping 2012 SIGMOD 9.6674087e-05
2,129 Guided Interaction: Rethinking the Query-Result Paradigm 2011 VLDB 8.9960018e-05
2,679 FastQRE: Fast Query Reverse Engineering 2018 SIGMOD 8.1453935e-05
2,854 JSON Data Management – Supporting Schema-less Development in RDBMS 2014 SIGMOD 7.9394584e-05
2,955 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.8102237e-05
3,003 Gestural Query Specification 2014 VLDB 7.7645915e-05
3,116 VIIQ: Auto-Suggestion Enabled Visual Interface for Interactive Graph Query Formulation 2015 VLDB 7.6338057e-05
3,312 Keyword Search on Structured and Semi-Structured Data 2009 SIGMOD 7.4385614e-05
4,046 Expressive Query Construction through Direct Manipulation of Nested Relational Results 2016 SIGMOD 6.8325379e-05
4,073 WYSIWYG Development of Data Driven Web Applications 2008 VLDB 6.8200839e-05
4,215 Interactive Mapping Specification with Exemplar Tuples 2017 SIGMOD 6.7285738e-05
4,294 NoDB in Action: Adaptive Query Processing on Raw Data 2012 VLDB 6.6819514e-05
4,441 SocialScope: Enabling Information Discovery on Social Content Sites 2009 CIDR 6.5991946e-05
4,617 QueryVis: Logic-based Diagrams help Users Understand Complicated SQL Queries Faster 2020 SIGMOD 6.49965e-05
5,031 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.3055788e-05
5,131 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2602133e-05
5,158 Facilitating SQL Query Composition and Analysis 2020 SIGMOD 6.2492918e-05
5,168 Querying Without Keyboards 2013 CIDR 6.2460238e-05
5,353 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.1637765e-05
6,012 Call to Order: A Hierarchical Browsing Approach to Eliciting Users' Preference 2010 SIGMOD 5.9143092e-05
6,039 PI2: End-to-end Interactive Visualization Interface Generation from Queries 2022 SIGMOD 5.9070865e-05
6,093 Interactive Browsing and Navigation in Relational Databases 2016 VLDB 5.8894913e-05
6,182 Evaluating Interactive Data Systems: Workloads, Metrics, and Guidelines 2018 SIGMOD 5.8588933e-05
6,724 Schema-free SQL 2014 SIGMOD 5.6950798e-05
6,762 GestureQuery: A Multitouch Database Query Interface 2013 VLDB 5.6877106e-05
7,456 Closing the functional and Performance Gap between SQL and NoSQL 2016 SIGMOD 5.5223997e-05
7,791 Qunits: queried units for database search 2009 CIDR 5.4518584e-05
8,137 Where To: Crowd-Aided Path Selection 2014 VLDB 5.3924339e-05
8,272 NOAH: Interactive Spreadsheet Exploration with Dynamic Hierarchical Overviews 2021 VLDB 5.3643259e-05
8,343 Databases will Visualize Queries too 2011 VLDB 5.3513352e-05
9,043 GBLENDER: Towards Blending Visual Query Formulation and Query Processing in Graph Databases 2010 SIGMOD 5.2315718e-05
9,129 CRIUS: User-Friendly Database Design 2011 VLDB 5.2233677e-05
10,016 The Data Interaction Game 2018 SIGMOD 5.0959403e-05
12,186 Enabling Data Science for the Majority 2019 VLDB 4.9793485e-05
12,508 The Case for Personal Data-Driven Decision Making 2014 VLDB 4.9793485e-05
12,673 DBWiki: A Structured Wiki for Curated Data and Collaborative Data Management 2011 SIGMOD 4.9793485e-05
12,719 Pay-As-You-Go - An Adaptive Approach to Provide Full Context-Aware Text Search over Document Content 2010 SIGMOD 4.9793485e-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.00047394041
81 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00036346781
84 ULDBs: Databases with Uncertainty and Lineage 2006 VLDB 0.00035963861
126 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030439683
303 Proximity Search in Databases 1998 VLDB 0.0002164278
410 XSEarch: A Semantic Search Engine for XML 2003 VLDB 0.00018778082
491 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017413042
505 Schema-Free XQuery 2004 VLDB 0.00017161757
525 An Annotation Management System for Relational Databases 2004 VLDB 0.00016890994
591 Lineage Tracing for General Data Warehouse Transformations 2001 VLDB 0.00015888097
604 Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System 2000 VLDB 0.0001566686
991 Web-scale Data Integration: You can only afford to Pay As You Go 2007 CIDR 0.00012647155
1,114 Principles of Dataspace Systems 2006 PODS 0.00011964697
1,311 Assisted Querying using Instant-Response Interfaces 2007 SIGMOD 0.00011065979
1,729 Addressing Diverse User Preferences in SQL-Query-Result Navigation 2007 SIGMOD 9.7679275e-05
1,733 Schema Summarization 2006 VLDB 9.7551427e-05
2,148 Flexible Queries over Semistructured Data 2001 PODS 8.955397e-05
2,170 Provenance Management in Curated Databases 2006 SIGMOD 8.924429e-05
2,214 Effective Phrase Prediction 2007 VLDB 8.8195986e-05
2,273 A Platform for Personal Information Management and Integration 2005 CIDR 8.7118476e-05
2,452 NaLIX: an Interactive Natural Language Interface for Querying XML 2005 SIGMOD 8.445374e-05
2,520 VizQL: A Language for Query, Analysis and Visualization 2006 SIGMOD 8.3479795e-05
2,666 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.1566309e-05
3,564 QURSED: Querying and Reporting Semistructured Data 2002 SIGMOD 7.204119e-05
4,208 Querying Complex Structured Databases 2007 VLDB 6.7339511e-05
5,095 Microsoft English Query 7.5: Automatic Extraction of Semantics from Relational Databases and OLAP Cubes 1999 VLDB 6.2746229e-05
5,961 DaNaLIX: a Domain-adaptive Natural Language Interface for Querying XML 2007 SIGMOD 5.9332159e-05
7,618 Database Usability 1983 SIGMOD 5.4832736e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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