1. A method for use in a database system having plural nodes, comprising: storing, in the nodes, a materialized join view based on at least two base relations, wherein each of the plural nodes has at least one processor and database management software executable on the at least one processor; storing, in the nodes, at least one auxiliary relation containing one or more attributes of one of the base relations, the auxiliary relation partitioned across the plural nodes according to a join attribute; updating, by at least one of the nodes, the at least one auxiliary relation in response to modification of the one base relation; and storing the one base relation that is partitioned across the plural nodes according to an attribute that is different from the join attribute.