ConsAD: A Real-Time Consistency Anomalies Detector

Summary: ConsAD detects real-time consistency anomalies under non-serializable isolation. It pinpoints exact transactions and data items, classifies anomalies by patterns and frequency, guiding isolation tuning or transactional redesign via a live GUI. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4633
Venue: SIGMOD
Year: 2012
Pagerank: 5.3193423e-05
Overall Rank: 9,122 | 37.42%
DOI: 10.1145/2213836.2213920

Incoming Non-self Citations Over Time

Authors

1. Kamal Zellag (McGill University)
2. Bettina Kemme (McGill University)

BibTeX Citation

@inproceedings{zellag_sigmod12,
        title = {{ConsAD: A Real-Time Consistency Anomalies Detector}},
        author = {Zellag, Kamal and Kemme, Bettina},
        series = {{SIGMOD} '12},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2213836.2213920},
        url = {https://dl.acm.org/doi/10.1145/2213836.2213920},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,303	Possible and Certain SQL Keys	2015	VLDB	6.7711902e-05

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058720861

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,439	The Homeostasis Protocol: Avoiding Transaction Coordination Through Program Analysis	2015	SIGMOD
2	6,544	Properties of Inconsistency Measures for Databases	2021	SIGMOD
3	5,020	Unsupervised Contextual Anomaly Detection for Database Systems	2022	SIGMOD
4	9,025	Tolerating Bounded Inconsistency for Increasing Concurrency in Database Systems	1992	PODS
5	8,715	Efficient Black-box Checking of Snapshot Isolation in Databases	2023	VLDB
6	4,315	Consistency and Transactions in CAD Database	1982	VLDB
7	11,775	AUDITOR: A System Designed for Automatic Discovery of Complex Integrity Constraints in Relational Databases	2020	SIGMOD
8	245	Serializable Isolation for Snapshot Databases	2008	SIGMOD
9	5,330	ConQuer: A System for Efficient Querying Over Inconsistent Databases	2005	VLDB
10	2,057	Automating the Detection of Snapshot Isolation Anomalies	2007	VLDB