ComputingComputer ScienceAlgebraDatabasesMemoryRelational AlgebraRelational Data ModelRelational DatabasesDivisionsJoinJoin AlgorithmsJoin OperationsJoin ProcessingNatural Join
We show how relations can be modelled in fast memory by a distribution of tuples in a multidimensional space. Given distributions for operand relations we derive distributions for the relations that result from applying the relational algebra. We apply the result for the natural join to optimize the evaluation of an expression involving two joins. We suggest further applications. The analysis for division leads to a generalization of that operator.
11
A relational model of data for large shared data banks
E. F. Codd · Communications of the ACM · 1970 · 5.2K citations · Full text
A relational model of data for large shared data banks
E. F. Codd · Communications of the ACM · 1983 · 4.8K citations
Olle Dahl, E. Dijkstra, C. A. R. Hoare · 1972 · 890 citations
Storage and access in relational data bases
Michael W. Blasgen, Kapali P. Eswaran · IBM Systems Journal · 1977 · 229 citations