Partitioning databases

If you are at all familiar with database terminology, you know that partitioning a database, either relational or multidimensional, is almost always done as a performance consideration. In the relational database world, you are usually taking one very large database and partitioning it into smaller, more manageable databases.

In the Essbase multidimensional world, there are several reasons for partitioning:

  • To split a large, cumbersome database into smaller, more manageable pieces or slices
  • To create, in one database, selected pieces or slices of data from several similar but unrelated databases
  • To provide a consolidated look at an overall enterprise process
  • To control data level security more effectively
  • To increase system performance ...

Get Oracle Essbase 9 Implementation Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.