DBScholar

Back to papers

DISCOVER: Keyword Search in Relational Databases

Summary: Schema-agnostic keyword search over relational databases, returning tuple-joining networks covering all query terms. DISCOVER enumerates nonredundant, schema-bounded candidate networks and reuses common subexpressions; optimal planning is NP-complete, motivating a near-optimal greedy algorithm. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h8a0c91320616afc0
Venue
VLDB
Year
2002
Pagerank
0.00047373961
Overall Rank
38 | 99.75%
DOI
10.1016/B978-155860869-6/50065-2

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{hristidis_vldb02,
        title = {{DISCOVER: Keyword Search in Relational Databases}},
        author = {Hristidis, Vagelis and Papakonstantinou, Yannis},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50065-2},
        url = {https://doi.org/10.1016/B978-155860869-6/50065-2},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 99 citing papers.

Rank Citing Paper Year Venue Pagerank
51 Efficient Query Evaluation on Probabilistic Databases 2004 VLDB 0.00042926566
81 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00036330407
89 WebTables: Exploring the Power of Tables on the Web 2008 VLDB 0.00035115118
180 Constructing an Interactive Natural Language Interface for Relational Databases 2015 VLDB 0.00026541021
217 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.00024454844
270 BLINKS: Ranked Keyword Searches on Graphs 2007 SIGMOD 0.00022588961
290 ObjectRank: Authority-Based Keyword Search in Databases 2004 VLDB 0.00021944946
293 Bidirectional Expansion For Keyword Search on Graph Databases 2005 VLDB 0.00021933539
319 Making Database Systems Usable 2007 SIGMOD 0.00021155013
439 ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores 2016 VLDB 0.00018253425
505 Schema-Free XQuery 2004 VLDB 0.00017153776
715 Data Integration with Uncertainty 2007 VLDB 0.00014552507
770 Effective Keyword Search in Relational Databases 2006 SIGMOD 0.00014099513
825 Efficient Keyword Search for Smallest LCAs in XML Databases 2005 SIGMOD 0.00013636905
942 SPARK: Top-k Keyword Query in Relational Databases 2007 SIGMOD 0.00012950177
1,183 SQAK: Doing More with Keywords 2008 SIGMOD 0.0001161406
1,221 SODA: Generating SQL for Business Users 2012 VLDB 0.00011469979
1,273 Discovering Queries based on Example Tuples 2014 SIGMOD 0.00011243661
1,319 LSH Ensemble: Internet-Scale Domain Search 2016 VLDB 0.00011042864
1,446 Finding and Approximating Top-k Answers in Keyword Proximity Search 2006 PODS 0.00010625633
1,501 Keyword Search in Databases: The Power of RDBMS 2009 SIGMOD 0.00010456517
1,565 Keyword Proximity Search in Complex Data Graphs 2008 SIGMOD 0.00010216262
1,759 Structured Querying of Web Text: A Technical Challenge 2007 CIDR 9.7090189e-05
1,776 Sample-Driven Schema Mapping 2012 SIGMOD 9.6631141e-05
1,883 BANKS: Browsing and Keyword Searching in Relational Databases 2002 VLDB 9.4358776e-05
1,887 Probabilistic Ranking of Database Query Results 2004 VLDB 9.4295364e-05
1,907 EASE: An Effective 3-in-1 Keyword Search Method for Unstructured, Semi-structured and Structured Data 2008 SIGMOD 9.3936687e-05
2,027 OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment 2025 SIGMOD 9.159284e-05
2,243 Automatic Categorization of Query Results 2004 SIGMOD 8.7643883e-05
2,256 Relational link-based ranking 2004 VLDB 8.7407334e-05
2,263 Identifying Meaningful Return Information for XML Keyword Search 2007 SIGMOD 8.729319e-05
2,397 Integrating DB and IR Technologies: What is the Sound of One Hand Clapping? * 2005 CIDR 8.5238625e-05
2,413 S4: Top-k Spreadsheet-Style Search for Query Discovery 2015 SIGMOD 8.5063082e-05
2,415 Structured Search Result Differentiation 2009 VLDB 8.5041001e-05
2,472 Keyword++: A Framework to Improve Keyword Search Over Entity Databases 2010 VLDB 8.410222e-05
2,679 FastQRE: Fast Query Reverse Engineering 2018 SIGMOD 8.1415698e-05
2,757 Answering (Unions of) Conjunctive Queries using Random Access and Random-Order Enumeration 2020 PODS 8.0487636e-05
2,843 Towards Keyword-Driven Analytical Processing 2007 SIGMOD 7.9468236e-05
2,882 Expressive and Flexible Access to Web-Extracted Data: A Keyword-based Structured Query Language 2010 SIGMOD 7.9108026e-05
2,886 DB&IR: Both Sides Now (Extended Abstract) 2007 SIGMOD 7.9047629e-05
3,090 Learning to Create Data-Integrating Queries 2008 VLDB 7.6561778e-05
3,289 Ten Years of WebTables 2018 VLDB 7.4500131e-05
3,313 Keyword Search on Structured and Semi-Structured Data 2009 SIGMOD 7.4350441e-05
3,349 Reverse Engineering Aggregation Queries 2017 VLDB 7.3878253e-05
3,461 REGAL+: Reverse Engineering SPJA Queries 2018 VLDB 7.2806224e-05
3,504 Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity 2019 VLDB 7.2483123e-05
3,509 Keyword Search on External Memory Data Graphs 2008 VLDB 7.24401e-05
3,730 Keyword Search over Relational Databases: A Metadata Approach 2011 SIGMOD 7.0663712e-05
3,903 CSV: Visualizing and Mining Cohesive Subgraphs 2008 SIGMOD 6.9307809e-05
4,141 Efficient Type-Ahead Search on Relational Data: a TASTIER Approach 2009 SIGMOD 6.7822757e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank Cited Paper Year Venue Pagerank
129 Efficient and Extensible Algorithms for Multi Query Optimization 2000 SIGMOD 0.00030395767
155 Common Expression Analysis in Database Applications 1982 SIGMOD 0.0002851688
303 Proximity Search in Databases 1998 VLDB 0.00021632881
2,169 An Approximate Search Engine for Structural Databases 2000 SIGMOD 8.9248214e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 10,519 Succinct Structure Representations for Efficient Query Optimization 2026 SIGMOD
2 4,307 Discovering Topical Structures of Databases 2008 SIGMOD
3 9,980 A Graph Method for Keyword-based Selection of the top-K Databases 2008 SIGMOD
4 217 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB
5 5,846 Effective Keyword-based Selection of Relational Databases 2007 SIGMOD
6 770 Effective Keyword Search in Relational Databases 2006 SIGMOD
7 1,273 Discovering Queries based on Example Tuples 2014 SIGMOD
8 3,730 Keyword Search over Relational Databases: A Metadata Approach 2011 SIGMOD
9 4,449 Keyword Search on Relational Data Streams 2007 SIGMOD
10 1,501 Keyword Search in Databases: The Power of RDBMS 2009 SIGMOD