Breadcrumb

  • Oracle Database 12c: Business Intelligence and Data Warehousing New Features

    There are several features in Oracle Database 12c Release 1 of which you can take advantage
    when it comes to Data Warehousing and Business Intelligence (BI).

    • You can use multipartition maintenance operations which enable adding multiple partitions to a table, dropping multiple partitions, merging multiple partitions into one partition, splitting of a single partition into multiple partitions, and truncating multiple partitions using a single SQL data definition language (DDL) statement.
    • You can also recognize patterns in a sequence of rows by using the MATCH_RECOGNIZE clause in native SQL which executes efficiently.
    • The new Synchronous Refresh feature will always keep a base table in sync with a Materialized View (MV) that is built on it.
    • You can also improve query performance against OLAP cubes.
    • Finally, local and global indexes can now be created on a subset of the partitions of a table. This feature provides more flexibility in index creation. Global index maintenance can now be delayed and decoupled using DROP and TRUNCATE partition without making a global index unusable. This new feature provides faster DROP and TRUNCATE partition operations. Index maintenance can be delayed to off-peak time.

    Duration: 89 minutes

    Release Date: 05-MAY-2014

    Created by: Lauran Serhal

Reviews (2)

  • 6.3 years ago
    wilson.b.bernal
    The chapter about synchronous refresh is great. Thanks for the explanations and demo illustrations.
    • 10.2 years ago
      oracle
      Lot's of things.. Go thru with high speed. Annoying thing was change of volume between chapters and some chapters had ambient noise of traffic and airplanes behind.

      Buttons