The Art of Dimensional Modelling

A Parallel Database allows you to arrange the data such that a single JOIN can be sub-divided among multiple individual processors each joining with their own set of data (some fraction of the tables) independent of other processors.  This allows queries to deal with very large amounts of data in a fraction of the time…