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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
