DBScholar

Back to papers

An Annotation Management System for Relational Databases

Summary: Annotation management for relational DBs; data items carry propagating annotations through queries. pSQL adds three provenance schemes: default, default-all, custom; a storage model with translation algorithms to produce annotation-preserving SQL. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h223003d6596297a8
Venue
VLDB
Year
2004
Pagerank
0.00016890994
Overall Rank
525 | 96.48%
DOI
10.1016/B978-012088469-8.50079-6

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{bhagwat_vldb04,
        title = {{An Annotation Management System for Relational Databases}},
        author = {Bhagwat, Deepavali and Chiticariu, Laura and Tan, Wang-Chiew and Vijayvargiya, Gaurav},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {900--911},
        doi = {10.1016/B978-012088469-8.50079-6},
        url = {https://doi.org/10.1016/B978-012088469-8.50079-6},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 36 of 36 citing papers.

Rank Citing Paper Year Venue Pagerank
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
319 Making Database Systems Usable 2007 SIGMOD 0.00021164857
391 Why Not? 2009 SIGMOD 0.00019238698
622 On the Provenance of Non-Answers to Queries over Extracted Data 2008 VLDB 0.00015484312
845 Debugging Schema Mappings with Routes 2006 VLDB 0.00013526977
1,076 Curated Databases 2008 PODS 0.00012159025
1,114 Principles of Dataspace Systems 2006 PODS 0.00011964697
1,588 DBNotes: A Post-It System for Relational Databases based on Provenance 2005 SIGMOD 0.00010140362
1,610 Efficient Provenance Storage 2008 SIGMOD 0.00010076616
1,746 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.7341914e-05
1,827 Querying Data Provenance 2010 SIGMOD 9.5545888e-05
1,913 Efficient Lineage Tracking For Scientific Workflows 2008 SIGMOD 9.3887234e-05
2,170 Provenance Management in Curated Databases 2006 SIGMOD 8.924429e-05
2,955 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.8102237e-05
4,183 Intensional Associations Between Data and Metadata 2007 SIGMOD 6.7550231e-05
5,713 Believe It or Not: Adding Belief Annotations to Databases 2009 VLDB 6.0216473e-05
5,835 PolicyReplay: Misconfiguration-Response Queries for Data Breach Reporting 2010 VLDB 5.9758831e-05
6,046 Your notebook is not crumby enough, REPLace it 2020 CIDR 5.9052121e-05
6,451 Tracing Lineage Beyond Relational Operators 2007 VLDB 5.7809609e-05
6,457 On Provenance Minimization 2011 PODS 5.7779266e-05
6,686 bdbms – A Database Management System for Biological Data 2007 CIDR 5.7085095e-05
7,152 A framework for annotating CSV-like data 2016 VLDB 5.5980734e-05
8,495 Provenance-based Data Skipping 2022 VLDB 5.3304338e-05
8,583 OneProvenance: Efficient Extraction of Dynamic Coarse-Grained Provenance From Database Query Event Logs 2023 VLDB 5.3092552e-05
9,468 InsightNotes: Summary-Based Annotation Management in Relational Databases 2014 SIGMOD 5.1716372e-05
9,894 Data Integration and Data Exchange: It’s Really About Time 2013 CIDR 5.1129187e-05
10,841 Bolt-on, Verifiable Provenance for LLM-Powered Data Processing 2026 VLDB 4.9793485e-05
11,120 Ultraverse: An Efficient What-if Analysis Framework for Software Applications Interacting with Database Systems 2025 SIGMOD 4.9793485e-05
12,400 Even Metadata is Getting Big: Annotation Summarization using InsightNotes 2015 SIGMOD 4.9793485e-05
12,414 Proactive Annotation Management in Relational Databases 2015 SIGMOD 4.9793485e-05
12,582 On Scaling Up Sensitive Data Auditing 2013 VLDB 4.9793485e-05
12,815 Tagging Stream Data for Rich Real-Time Services 2009 VLDB 4.9793485e-05
12,941 Provenance in Databases (Tutorial Outline) 2007 SIGMOD 4.9793485e-05
12,978 Meta-data Indexing for XPath Location Steps 2006 SIGMOD 4.9793485e-05
13,041 MIX: A Meta-data Indexing System for XML 2005 VLDB 4.9793485e-05
Previous Page 1 / 1 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
310 Optimization of Real Conjunctive Queries 1993 PODS 0.00021374145
590 On Propagation of Deletions and Annotations Through Views 2002 PODS 0.00015890019
899 Mapping Data in Peer-to-Peer Systems: Semantics and Algorithmic Issues 2003 SIGMOD 0.00013186809
2,095 A Polygen Model for Heterogeneous Database Systems: The Source Tagging Perspective 1990 VLDB 9.0564714e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,611 Annotated XML: Queries and Provenance 2008 PODS
2 2,170 Provenance Management in Curated Databases 2006 SIGMOD
3 6,299 Classification of Annotation Semirings over Query Containment 2012 PODS
4 1,827 Querying Data Provenance 2010 SIGMOD
5 819 Provenance for Aggregate Queries 2011 PODS
6 6,686 bdbms – A Database Management System for Biological Data 2007 CIDR
7 9,468 InsightNotes: Summary-Based Annotation Management in Relational Databases 2014 SIGMOD
8 590 On Propagation of Deletions and Annotations Through Views 2002 PODS
9 12,414 Proactive Annotation Management in Relational Databases 2015 SIGMOD
10 1,588 DBNotes: A Post-It System for Relational Databases based on Provenance 2005 SIGMOD