Synthesizing Linked Data Under Cardinality and Integrity Constraints

Summary: Synthesizing linked data under cardinality and integrity constraints with missing FKs; imputes FK values between related relations while preserving constraints. NP-hard; two-phase approach: Phase I builds a CC-consistent draft (ILP for one CC type, efficient for others); Phase II enforces ICs via conflict-hypergraph coloring, yielding scalable, low CC error. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 6195
Venue: SIGMOD
Year: 2021
Pagerank: 5.7830386e-05
Overall Rank: 6,755 | 53.66%
DOI: 10.1145/3448016.3457242

Incoming Non-self Citations Over Time

Authors

1. Amir Gilad (Duke University)
2. Shweta Patwa (Duke University)
3. Ashwin Machanavajjhala (Duke University)

BibTeX Citation

@inproceedings{gilad_sigmod21,
        title = {{Synthesizing Linked Data Under Cardinality and Integrity Constraints}},
        author = {Gilad, Amir and Patwa, Shweta and Machanavajjhala, Ashwin},
        series = {{SIGMOD} '21},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3448016.3457242},
        url = {https://dl.acm.org/doi/10.1145/3448016.3457242},
        year = {2021}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,827	PrivLava: Synthesizing Relational Data with Foreign Keys under Differential Privacy	2023	SIGMOD	6.4895329e-05
9,985	Projection-Compliant Database Generation	2022	VLDB	5.1842045e-05
10,775	PrivPetal: Relational Data Synthesis via Permutation Relations	2025	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
105	Quickly Generating Billion-Record Synthetic Databases	1994	SIGMOD	0.00033877899
112	HoloClean: Holistic Data Repairs with Probabilistic Inference	2017	VLDB	0.00032801121
121	Boosting the Accuracy of Differentially Private Histograms Through Consistency	2010	VLDB	0.00031639377
130	Privacy, Accuracy, and Consistency Too: A Holistic Solution to Contingency Table Release	2007	PODS	0.00030604781
376	Discovering Denial Constraints	2013	VLDB	0.00019677674
734	QAGen: Generating Query-Aware Test Databases	2007	SIGMOD	0.00014525584
938	Flexible Database Generators	2005	VLDB	0.00013089351
1,144	PrivateSQL: A Differentially Private SQL Query Engine	2019	VLDB	0.00011999046
1,504	A Data- and Workload-Aware Algorithm for Range Queries Under Differential Privacy	2014	VLDB	0.00010548904
1,578	Simple and Realistic Data Generation	2006	VLDB	0.00010309264
1,955	Discovery of Approximate (and Exact) Denial Constraints	2020	VLDB	9.4166032e-05
2,167	Optimizing error of high-dimensional statistical queries under differential privacy	2018	VLDB	9.047803e-05
2,369	Data Generation using Declarative Constraints	2011	SIGMOD	8.682429e-05
2,562	Blowfish Privacy: Tuning Privacy-Utility Trade-offs using Policies	2014	SIGMOD	8.4127196e-05
2,685	Approximate Denial Constraints	2020	VLDB	8.2594662e-05
2,746	Dichotomies in the Complexity of Preferred Repairs	2015	PODS	8.1725014e-05
3,994	Generating Databases for Query Workloads	2010	VLDB	6.9686731e-05
5,992	Just can't get enough - Synthesizing Big Data	2015	SIGMOD	6.0160344e-05
6,664	On Multiple Semantics for Declarative Database Repairs	2020	SIGMOD	5.8090585e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,332	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB
2	6,723	Record Linkage with Uniqueness Constraints and Erroneous Values	2010	VLDB
3	10,317	Guardrail: Automated Integrity Constraint Synthesis From Noisy Data	2026	SIGMOD
4	4,094	Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints	1987	PODS
5	9,029	On the Satisfiability of Dependency Constraints in Entity-Relationship Schemata	1987	VLDB
6	874	On the Decidability and Complexity of Query Answering over Inconsistent and Incomplete Databases	2003	PODS
7	1,399	Computing Optimal Repairs for Functional Dependencies	2018	PODS
8	1,707	The Data Complexity of Consistent Query Answering for Self-Join-Free Conjunctive Queries Under Primary Key Constraints	2015	PODS
9	185	A Cost-Based Model and Effective Heuristic for Repairing Constraints by Value Modification	2005	SIGMOD
10	2,369	Data Generation using Declarative Constraints	2011	SIGMOD