11g BI Suite Data Mining, Business
Oracle 11g New Features Tips by Burleson
July 15, 2008
Oracle 11g SQL New Features Tips
Oracle warehouse guru Mark Rittman notes some of the upcoming
features with Oracle 11g BI suite and OLAP such as integration of
materialized view query rewrite with OLAP:
"However, in 10g OLAP although (one) could
register a view over aggregated data in an analytic workspace with
query rewrite, "normal" queries that used SUM(), AVG() and other
aggregation functions, together with GROUP BY, wouldn’t get
rewritten as the SQL views used over analytic workspaces were based
on fully-solved cubes, i.e. the view contained all levels of
aggregation and measures were already aggregated. . .
With this forthcoming release of Oracle OLAP,
just check a box in Analytic Workspace Manager to enable queries
against the source tables for the analytic workspace to be
re-written against the summary data in the analytic workspace, and
the OLAP cube will then act in the same way as a regular
materialized view, meaning the two technologies (in theory) will be
interchangeable as a way of summarizing warehouse data."
Oracle 11g data mining
With the release of the first book on ODM
"Oracle Data Mining", there is an increased interest in data mining
within 11g and there are rumors that ODM will be greatly enhanced by
moving data mining objects into the dictionary and improving the
interface for complex analytics.
There is an abundance of new features in
Oracle’s 11g that will be covered in this book. This chapter is a
synopsis of many of the features that are considered the most
important to a Remote DBA and are broken down by categories such as Remote DBA,
RAC, PL/SQL and RMAN new features. Each subsequent chapter will
discuss these categories in greater detail and provide answers to
the changes that are evident in 11g.
This is an
excerpt from the new book
Oracle 11g New Features: Expert Guide to the Important
New Features by John Garmany, Steve Karam, Lutz Hartmann, V. J.
Jain, Brian Carr.
You can buy it direct from the publisher
for 30% off.