Independent and Separable Database Schemes

Summary: Introduces 'separability' to formalize independently updatable decompositions and proves equivalence to Bancilhon–Spyratos independent mappings. Characterizes separable schemes under FDs and the join dependency (and for dependency-preserving schemes) and gives a polynomial-time test. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 664
Venue: PODS
Year: 1983
Pagerank: 5.9569613e-05
Overall Rank: 6,153 | 57.79%
DOI: 10.1145/588058.588091

Incoming Non-self Citations Over Time

Authors

1. Edward P. F. Chan (University of Toronto)
2. Alberto O. Mendelzon (University of Toronto)

BibTeX Citation

@inproceedings{chan_pods83,
        address = {New York, NY, USA},
        series = {{PODS} '83},
        title = {{Independent and Separable Database Schemes}},
        url = {https://dl.acm.org/doi/10.1145/588058.588091},
        doi = {10.1145/588058.588091},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Chan, Edward P. F. and Mendelzon, Alberto O.},
        year = {1983}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,527	Functional Dependencies on Cyclic Database Schemes	1983	SIGMOD	7.3428228e-05
3,551	Efficient Query Answering in the Representative Instance Approach	1985	PODS	7.3196924e-05
4,094	Formal Limits on the Automatic Generation and Maintenance of Integrity Constraints	1987	PODS	6.906603e-05
7,132	Optimal Computation of Total Projections with Unions of Simple Chase Join Expressions	1984	SIGMOD	5.694968e-05

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
40	Testing Implications Of Data Dependencies	1979	SIGMOD	0.00046918506
266	Can We Use The Universal Instance Assumption Without Using Nulls?	1981	SIGMOD	0.00022823892
742	Independent Database Schemas (Extended Abstract)	1982	PODS	0.00014426824
4,843	Notions of Dependency Satisfaction	1982	PODS	6.482729e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	742	Independent Database Schemas (Extended Abstract)	1982	PODS
2	13,266	Physical Design of Network Model Databases Using the Property of Separability	1982	VLDB
3	13,171	On Designing Database Schemes Bounded or Constant-time-maintainable with respect to Functional Dependencies	1987	PODS
4	9,332	Unifying Functional and Multivalued Dependencies for Relational Database Design	1986	PODS
5	6,698	Properties Of Database Schemata With Functional Dependencies	1984	PODS
6	3,222	Comprehensive Approach to the Design of Relational Database Schemes	1984	VLDB
7	13,120	Polynomial Time Designs toward Both BCNF and Efficient Data Manipulation	1990	SIGMOD
8	7,808	A New Characterization of Independence	1983	SIGMOD
9	8,297	Independence-reducible Database Schemes	1988	PODS
10	13,184	Independent Database Schemes Under Functional and Inclusion Dependencies	1987	VLDB