SAND CDBMS Administration Guide
Massively Parallel Processing (MPP)


Chapter Index
Next Topic:



SAND CDBMS supports a form of "Massively Parallel Processing" (MPP), where a table's data is partitioned among multiple computers in a network to take advantage of simultaneous intra-query processing. When intra-query results are received from each node, they are combined, and the full query results are transparently returned to the end user.

Benefits of MPP include the following:

Furthermore, dimension tables and domains can be automatically replicated and maintained on all of the partition nodes, so that a partitioned table can be used as a central fact table with fast dimension lookups at each node.