|
|
|
| Business Performance and Information Excellence Practice
|
|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Vendor- IT Tool Domain →
SECTION - BI platform Tools →
|
CHAPTER - OLAP Server Administration, Security and Tuning
|
This chapter covers the areas which are the domain of OLAP and Database Administrator.
|
|
| |
Topics
|
|
|
OLAP Database and Data model tuning are two different subjects. However, they are closely linked to deliver an adequate response time and performance, while maintaining an optimum database size. In this page, we are going to talk about the Database Tuning.
|
| |
|
|
As mentioned in the previous topic page, there are two kinds of tuning you can do around OLAP Database. One is the 'database Tuning' (as covered in the previous topic), and one is the Database Structure/model tuning. This tuning has to do with changes in the dimensions, attributes, levels (as in hierarchy paths), the level of aggregations, pre-calculated v/s stored vs. on-line aggregations and the data-cut across OLAP and Data-warehouse (what we call Hybrid OLAP- the combination of MOLAP and ROLAP).
|
| |
|
|
An OLAP server should be providing wide and friendly set of administrative capabilities in terms of Administrative console, integration with 3rd party resource administration tools etc.
|
| |
|
|
OLAP Server security encompasses various objects and data elements. This ranges from the cell level security to the task based security.
|
| |
|
|
|
|
|
|
All Chapters in "BI platform Tools." Section
|
|
|
|
| |
| |
| Back |
|
|
|
|
|
