Information, tips, tricks and sample code for Big Data Warehousing in an autonomous, cloud-driven world

  • News
    February 5, 2010

Oracle Positioned in Leaders Quadrant of Gartner's latest EDW MQ

Keith Laker
Senior Principal Product Manager

Gartner has positioned Oracle in the Leaders Quadrant of its 2010 "Magic Quadrant (MQ) for Data Warehouse Database Management Systems (DBMS)" (written by Donald Feinberg and Mark A. Beyer, January 28, 2010). This report is widely used by many customers who consider it an authoritative guide which is valuable in making database investment decisions. Of course Oracle has been the leader in both the database and data warehouse markets for a considerable time, as you can see from our advertising:

Gartner's positioning of Oracle as a data warehouse leader within its EDW MQ is only natural. This latest MQ report highlights the main strengths of Oracle's data warehouse strategy and includes recognition for delivery to the market of our Database Machine platform. However, it is important to remember that Oracle has a broad range of data warehouse solutions ranging from fully pre-configured solutions delivered and supported by Oracle - Oracle Database Machine)-, optimized warehouse reference configurations with all the major hardware vendors, and stand-alone Oracle Database, 11g Release 2. No other data warehouse vendor offers this level of portability (although some have seen the error of their ways and are now trying to copy Oracle's approach).

The latest release of Oracle Database, 11g Release 2, contains many optimizations to enhance query performance with minimal intervention from the DBA. This is simply the continuation of a process which started a long time ago and is aimed at reducing both the setup, management and overall TCO. Optimizations have been added to improve refresh times for MVs and cube MVs. It is now much easier to define and maintain these transparent query optimization features and most importantly, they benefit every BI tool on the market.

To help DBAs and database designers create the best partitioning strategy, the partition advisor has been improved to take the guesswork out of partitioning and to help build a database structure that can deliver the very best levels of performance.

To help customers reduce their cost of storage, 11gR2 added columnar compression as part of Exadata. Oracle's database compression features also provide significant improvements in performance. 11g Release 2 now comes with a compression advisor which can be used to estimate the likely levels of compression to help define an optimal data/storage strategy.

Gartner recognized all the work Oracle has done to improve the automation and optimization of the Oracle data warehouse and as Gartner points out, these optimizations are unique to Oracle. No other database provides this level of support and guidance for the DBA to help simplify the manage of workloads within the data warehouse.

Both RAC and ASM are now seen as vital features, and key strengths, for extremely large data warehouses and the highlighting of these features within the MQ report validates our use of these two features within Oracle Database Machine. The use of both RAC and ASM provide the ability to flexibly scale any platform by adding additional servers and/or storage without having to take the data warehouse offline. In addition, RAC and ASM deliver an environment that provides the level of highly availability needed to support the demands of today's mission critical data warehouses.

Overall, this latest EDW MQ is an important and impressive acknowledgment of Oracle's data warehouse strategy. Taking a wider view of data warehousing it is important to understand that there are other factors which need to be considered, although the EDW MQ is definitely the foundation, or cornerstone MQ. There are a lot of other factors to consider when implementing a data warehouse such as ETL tools, data quality tools, data integration tools, BI platforms, enterprise content management etc etc. Therefore, a true leader in the data warehouse space needs to be in the leaders quadrant for all these areas - like Oracle:

This is the reason why Oracle is No1 in data warehousing!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.