Efficient Auditing For Complex SQL queries

Summary: Auditing arbitrary SQL queries (grouping, aggregation, correlated subqueries) to yield an audit trail of potentially sensitive access. Examines privacy-utility trade-offs and proposes scalable auditing techniques for complex queries beyond prior privacy-centric work. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4486
Venue: SIGMOD
Year: 2011
Pagerank: 5.7970786e-05
Overall Rank: 6,705 | 54.00%
DOI: 10.1145/1989323.1989396

Incoming Non-self Citations Over Time

Authors

1. Raghav Kaushik (Microsoft)
2. Ravi Ramamurthy (Microsoft)

BibTeX Citation

@inproceedings{kaushik_sigmod11,
        title = {{Efficient Auditing For Complex SQL queries}},
        author = {Kaushik, Raghav and Ramamurthy, Ravi},
        series = {{SIGMOD} '11},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1989323.1989396},
        url = {https://dl.acm.org/doi/10.1145/1989323.1989396},
        year = {2011}
}

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,105	Explanation-Based Auditing	2012	VLDB	7.7528586e-05
3,827	Automatic Enforcement of Data Use Policies with DataLawyer	2015	SIGMOD	7.0909359e-05
12,223	Stop That Query! The Need for Managing Data Use	2013	CIDR	5.093636e-05
12,248	The Power of Data Use Management in Action	2013	SIGMOD	5.093636e-05
12,291	On Scaling Up Sensitive Data Auditing	2013	VLDB	5.093636e-05
12,391	Whodunit: An Auditing Tool for Detecting Data Breaches	2011	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001682612
552	Extending Query Rewriting Techniques for Fine-Grained Access Control	2004	SIGMOD	0.00016630306
1,269	The Containment Problem for Real Conjunctive Queries with Inequalities	2006	PODS	0.000113935
2,107	Auditing Compliance with a Hippocratic Database	2004	VLDB	9.1554362e-05
3,816	Optimizing Nested Queries with Parameter Sort Orders	2005	VLDB	7.1002641e-05
4,159	On the Efficiency of Checking Perfect Privacy	2006	PODS	6.8626218e-05
5,711	PolicyReplay: Misconfiguration-Response Queries for Data Breach Reporting	2010	VLDB	6.1128939e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,838	Don’t Be a Tattle-Tale: Preventing Leakages through Data Dependencies on Access Control Protected Data	2022	VLDB
2	3,974	Epistemic Privacy	2008	PODS
3	4,760	Integrity Auditing of Outsourced Data	2007	VLDB
4	5,315	When Query Authentication Meets Fine-Grained Access Control: A Zero-Knowledge Approach	2018	SIGMOD
5	2,017	Auditing Boolean Attributes	2000	PODS
6	12,391	Whodunit: An Auditing Tool for Detecting Data Breaches	2011	VLDB
7	2,401	Simulatable Auditing	2005	PODS
8	2,107	Auditing Compliance with a Hippocratic Database	2004	VLDB
9	12,291	On Scaling Up Sensitive Data Auditing	2013	VLDB
10	3,296	Towards Robustness in Query Auditing	2006	VLDB