O'Reilly logo

Oracle Essbase 9 Implementation Guide by Joseph Sydney Gomez, Sarma Anantapantula

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required