BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation










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.


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.

Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.



Remote DBA Service

Oracle Tuning Book


Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software







BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.

Hit Counter