CHAPTER 7 Oracle Database BI and Data Warehousing New Features

Oracle Database 11g offers a wealth of new features that relate to business intelligence (BI) and the Oracle Data Warehouse. Several new partitioning features are introduced, in addition to virtual columns and features related to statistics collection. Additionally Oracle Data Pump is improved, as are materialized views. The pivot and unpivot clauses are introduced, and finally, table compression is much improved. In this chapter, we will cover all these features in much more detail.

Partitioning

New partitioning features introduced in Oracle Database 11g include:

image Interval partitioning ...

Get Oracle Database 11g New Features 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.