arXiv · 2406.14094
Logical reduction of relations: from relational databases to Peirce's reduction thesis
Abstract
We study logical reduction (factorization) of relations into relations of lower arity by Boolean or relative products that come from applying conjunctions and existential quantifiers to predicates, i.e. by primitive positive formulas of predicate calculus. Our algebraic framework unifies natural joins and data dependencies of database theory and relational algebra of clone theory with the bond algebra of C.S. Peirce. We also offer new constructions of reductions, systematically study irreducible relations and reductions to them, and introduce a new characteristic of relations, ternarity, that measures their `complexity of relating' and allows to refine reduction results. In particular, we refine Peirce's controversial reduction thesis, and show that reducibility behavior is dramatically different on finite and infinite domains.
Explore related subjects
Keep this discovery
Explore connections, maps & timelines
Sergiy Koshkin. 2024-06-20. Logical reduction of relations: from relational databases to Peirce's reduction thesis. https://doi.org/10.1093/jigpal%2Fjzad010
Cite the original work for its findings. Save a collection to share your selection of sources.