11g BI Suite Data Mining, Business Intelligence and OLAP Oracle 11g New Features Tips by Burleson Consulting 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.

Conclusion

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.