tag:blogger.com,1999:blog-38200314715245037312024-02-24T23:29:38.383-08:00Oracle OLAPThe most powerful, open Analytic EngineBrian Macdonaldhttp://www.blogger.com/profile/18408740222558531436noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-3820031471524503731.post-83775938738899467602010-02-11T08:03:00.000-08:002010-02-11T08:08:26.015-08:00Oracle Exadata: A Single Source of Truth (New Video)<p style="clear: both">Over the last 6-9 months we have been releasing a series of videos on YouTube under the banner of "DBA2.0" (a quick search on YouTube will list all these videos). These videos follow the work of a dedicated team of DBAs and business users as they try to get their jobs done in an environment that just keeps throwing up new challenges. Fortunately, Oracle is there to save the day...</p><p style="clear: both">This latest scenario deals with data warehousing and specifically Exadata. It is in two parts and the first installment has just been released - "<strong><em>Oracle Exadata: A Single Source of Truth</em></strong>". Here is the story so far:</p><blockquote style="clear: both"><p><i>A stroll through the halls of your IT department may reveal that there is no love lost between the DBAs and business analysts they support. In today's hyper competitive environment, business analysts need to perform more and more predictive analytics and they want the answers yesterday, but managing separate BI and OLAP servers and ensuring fast query performance can be a challenge for DBAs.</i></p></blockquote><p style="clear: both">Watch this short video to see how the dynamic DBA duo address this challenge using Oracle Exadata, forging a truce with their new business analyst and even getting her to crack a smile - sort of.</p><p style="clear: both"><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://www.youtube.com/watch?v=WgVSu-4Mizs"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 308px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim0XxXtW38Fwhs2K-0NR6w4ysfuPiLmrljM0h0h7gHsy9GYstBd79JnfYkcsjsvG_4Xugg0WWS_TkS7ix8yxdk5gws0_uFpu_v1O67F24ImVJzXWiDfmX9HNf1ZJrEBI_wVi4EQqS241VU/s400/YouTube.jpg" border="0" alt="" id="BLOGGER_PHOTO_ID_5437017827921039986" /></a><br /></p><p style="clear: both"> Enjoy this video at <a href="http://www.youtube.com/watch?v=WgVSu-4Mizs" title="Oracle Exadata:Single Source of Truth!" target="_blank">http://www.youtube.com/watch?v=WgVSu-4Mizs</a> and stay tuned for Part 2 which will be available shortly...</p><p style="clear: both">(<em><u>Please Note: </u></em><em><u>No DBAs or Business Analysts were harmed in the making of these videos</u></em>)</p>ASQLBaristahttp://www.blogger.com/profile/13350994132294695189noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-74838880975850393632009-02-05T16:36:00.000-08:002009-02-06T02:05:20.721-08:00Oracle OLAP Newsletter - February 2009The latest Oracle OLAP newsletter, February 2009, has been posted onto OTN and is available by clicking <a href="http://www.oracle.com/technology/products/bi/olap/olapref/newsletter/oracleolapnewsletter_feb09.html">here</a><br /><br />The customer feature this time is R.L. Polk who have used 11g OLAP to simplify their delivery of aggregate data through the use of cube organised materialised views. This is a fantastic case study which captures the true value of this functionality (note the dramatic improvements in both build and query times), and of having Oracle OLAP embedded in the Oracle Database.<br /><br />The highlights of the Product Update section this time are the release of <a href="http://download.oracle.com/otndocs/products/warehouse/awm11.1.0.7.0B.zip">the latest version of AWM 11g</a> (11.1.0.7B), and also a new version of the <a href="http://www.oracle.com/technology/products/bi/spreadsheet_addin/index.html">BI Spreadsheet Add-in</a> (10.1.2.3.0.1 - enough digits?!) which now includes support for Excel 2007.Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-68313195634313901882008-12-23T04:55:00.000-08:002008-12-23T06:22:12.049-08:00Oracle OLAP Newsletter - December 2008The latest Oracle OLAP newsletter, December 2008, has been posted to the <a href="http://www.oracle.com/technology/products/bi/olap/index.html">OLAP Home Page</a> on OTN and is available by clicking <a href="http://www.oracle.com/technology/products/bi/olap/olapref/newsletter/oracleolapnewsletter_dec08.html">here</a>.<br /><br />As usual, it contains very useful information about what is happening in the world of Oracle OLAP and includes regular features such as the OLAP skills corner and DBA tips, as well as useful links for those wanting to download the software or get training or assistance.<br /><br /><a href="http://www.oracle.com/technology/products/bi/olap/olapref/newsletter/oracleolapnewsletter_dec08.html#story1">The featured customer this time is JD Sports in the UK</a>. This is an excellent example of Oracle OLAP being used as part of a wider Data Warehouse solution. It is also a significant endorsement of Oracle's Data Warehouse strategy to bring smart, embedded analytics to the data and highlights the benefits of an embedded OLAP server; JD Sports has been able to leverage other advanced Oracle technologies such as <a href="http://www.oracle.com/technology/products/database/clustering/index.html">Real Application Clusters</a> (to deliver scalability and availability), whilst additionally benefiting from many of the features taken for granted by Oracle's RDBMS customers (DW integrated security, storage, backup, transaction control, etc) but often not so easily delivered by stand-alone OLAP engines. <br /><br />This customer feature is also a good example of the scalability of the Oracle OLAP engine itself. Whilst far from being the largest implementation (there are customers managing several Terabytes of data in Oracle OLAP cubes), this example shows how relatively large volumes of DW data can be loaded and aggregated in Oracle OLAP, and how the cube compression and partitioning features first introduced in 10g OLAP have completely changed the game compared to what was previously possible. Taken in isolation, loading 300 million source records is not a major achievement (not for Oracle OLAP anyway), neither is having a 10 dimensional cube, or indeed is aggregating across 28 hierarchical levels. What is more impressive is doing all of these three things combined in a single cube (which is only one cube out of a total of six), and still being able to deliver all of the key benefits you would associate with an well implemented OLAP system - fast query performance and lots of advanced calcs (literally 100's in this case) serving a reasonably sized user community.<br /><br />All things considered, it is easy to see why Oracle OLAP is a key, strategic component of the Oracle Data Warehouse platform.<br /><br />Let's hope for some more customer features in the near future.<br /><br />Greetings of the season to everyone!<br /><br />BTW - you can have the OLAP newsletter sent directly to your email box each quarter by following the link at the top of the current newsletter (Unsubscribe/Subscribe to this Newsletter)Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-2429851685503863132008-12-16T09:50:00.000-08:002008-12-23T06:22:44.752-08:00ComputerWeekly.com : E.on transforms financial insight with Oracle OLAP Option<a title="http://www.computerweekly.com/Articles/2008/12/11/233863/e.on+transforms+financial+insights+with+bare-knuckle.htm" href="http://www.computerweekly.com/Articles/2008/12/11/233863/e.on+transforms+financial+insights+with+bare-knuckle.htm" send="true">http://www.computerweekly.com/Articles/2008/12/11/233863/e.on+transforms+financial+insights+with+bare-knuckle.htm</a><br /><br />The article above, published last week in ComputerWeekly, follows an earlier <a href="http://www.oracle.com/customers/snapshots/e-on-uk-snapshot.pdf">customer profile posted on OTN</a>. E.on, one of Europe's leading energy suppliers, has gone live with a financial transformation software project that will give it an accurate view of the profits generated by each customer and provide better forecasting of future demand. E.on has accounts with over eight million customers in the UK. To quote directly from the project leader Lawrence Edwards: "It (accurate forecasting of demand, and, therefore, margin) is a massive problem because of the data volumes and complexity. Others have tried and failed, but we persevered."<br /><br />It provides excellent proof points for the use of Oracle OLAP to solve business problems that require rapid data loading and analysis of large data volumes. The E.on system is currently operating at about 6Tb and is growing rapidly, with 150Gb of new data added every 14 hours. There is a great quote from Lawrence in the <a href="http://www.oracle.com/customers/snapshots/e-on-uk-snapshot.pdf">OTN PDF</a> explaining what they have achieved using Oracle OLAP Option:<br /><br />"The analytical power, centralized administration, and scalability of Oracle OLAP have allowed us to process and present data in a way that was not previously possible. This has provided us with an unprecedented depth of understanding of customers’ energy use and the demand for all our products and offerings"Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-76448889629435310942008-12-08T10:19:00.000-08:002008-12-08T10:31:33.331-08:00Oracle Database 11g: OLAP Essentials - First dates announcedFollowing <a href="http://oracleolap.blogspot.com/2008/12/new-oracle-olap-11g-oracle-university.html">the announcement last week about the new Oracle OLAP 11g Oracle University Training Course</a>, the dates and locations for the first classes have been announced.<br /><br />The very first class will be in Bridgewater, New Jersey, US from 20-Jan-2009 through to 22-Jan-2009. <br /><br />The first class in Europe will be in Reading, UK from 21-Jan-2009 through to 23-Jan-2009.<br /><br />The code for the course is <span><span>D70039GC10 and </span></span>more details on both events can be found on the <a href="http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=4&dc=D70039GC10">Oracle University web site</a><br /><br />Be sure to register early if you wish to attend as places are sure to be high in demand.Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-18837788568108118092008-12-04T01:50:00.000-08:002008-12-04T02:02:37.725-08:00New! Oracle OLAP 11g Oracle University Training CourseA brand new OLAP 11g training class has been added to the Oracle University schedule.<br /><br />Here is a brief synopsis:<br /><br /><span style="font-style: italic;"><span style="color:black;">Oracle OLAP 11g, a fully-integrated component of Oracle Database 11g, provides a full featured multidimensional data model and calculation engine that is easily accessible to any SQL based business intelligence application or tool.<br /><br /></span></span><span style="font-style: italic;">In this course, students learn to progressively build an OLAP data model to support a wide range of business intelligence requirements. Students learn to design OLAP cubes to serve as a summary management resource for existing SQL table queries. Students also learn to leverage the power of Oracle OLAP by adding rich analytic content to your data model.</span><br /><br /><span style="font-style: italic;">Students learn to create sophisticated reports of OLAP data by using simple SQL queries. Students also create and execute OLAP queries in SQL Developer, Oracle Application Express (APEX), and in Oracle BI Enterprise Edition. Students learn to implement cube security, including how to authorize access to cube data and methods for scoping user views of data. Finally, students learn to design OLAP cubes for performance and scalability.</span><br /><br /><span style="font-style: italic;">Learn To:</span><br /><br /><span style="font-style: italic;"> * Design and create an Oracle OLAP data model</span><br /><span style="font-style: italic;"> * Enable query rewrite to OLAP Cube MVs for relational summary management</span><br /><span style="font-style: italic;"> * Easily create OLAP calculations that enrich the analytic content of your data model</span><br /><span style="font-style: italic;"> * Query OLAP data using simple SQL</span><br /><span style="font-style: italic;"> * Implement cube security</span><br /><span style="font-style: italic;"> * Efficiently design cubes for performance and scalability</span><br /><br />More details and scheduling information can be found on the <a href="http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D70039GC10&p_org_id=1001&lang=US&source_call=">Oracle University Website</a>Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-36645776388495544822008-10-21T12:32:00.000-07:002008-10-23T03:40:31.883-07:00New article on 11g OLAP Cube-Organised Materialized Views published onto OTNOracle ACE Director Arup Nanda has published a series of articles onto <a href="http://www.oracle.com/technology/index.html">OTN</a> covering important new features in Oracle Database 11g titled <a href="http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/index.html">'Oracle Database 11g: Top Features for DBAs and Developers'</a>.<br /><br />The series includes a feature on <a href="http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-dw-olap.html">'Data Warehousing and OLAP'</a> which looks at how Cube-Organized Materialized Views can be implemented alongside other features to deliver a compelling platform for data warehousing.<br /><br />With Oracle's data warehousing proposition featured heavily in the news at the moment following the <a href="http://oracleolap.blogspot.com/2008/09/oracle-open-world-2008-hp-oracle.html">recent announcement at Oracle Open World on the availability of the Exadata Storage Server and Database Machine</a>, this is an excellently timed reminder that Oracle OLAP is a core part of this data warehousing proposition.Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-2773880730369842822008-10-10T05:58:00.000-07:002008-10-10T06:30:17.967-07:00New Oracle OLAP White Paper released to OTNA new Oracle OLAP white paper has been released to OTN titled <a href="http://www.oracle.com/technology/products/bi/olap/Oracle_OLAP_11g_BIEE_TWP.pdf">"Using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle Database 11g"</a><br /><br />This contains a guide on how to configure the OBIEE metadata layer to leverage the 11g Oracle OLAP option, both indirectly via OLAP cube based materialized views, and directly via OLAP cube views. For those working with 10g OLAP (cube views only), the best guide to configuring OBIEE is found in the <a href="http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/olap/index.html">online tutorial on OTN</a>.<br /><br />Personally, I think that it is great that this white paper captures an explanation of how to write SQL that is optimised for Oracle OLAP cube views. This is something I find customers initially struggle with - they write what they believe is a simple query and then cannot understand why the performance is not good.<br /><br />This is because there are a few golden rules to writing optimal SQL for OLAP cube views and while they are simple to understand, they are not obvious to those who are new to the technology. I hope to write a more detailed Blog entry on this subject very soon, but for the time being take a look at the white paper (particularly pages 10 & 11) to see what I mean.Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-79135749365813525032008-10-10T04:14:00.000-07:002008-12-16T09:36:30.712-08:00More 11.1.0.7 ports now availableThe <a href="https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6890831">Oracle Database 11g Release 11.1.0.7.0 Server Patch</a> has now been released for several other ports, including Windows 32-bit.<br /><br />The full list of operating systems currently supported is:<br /><ul><li>Linux x86</li><li>Linux x86-64</li><li>Solaris (SPARC) (64-bit)</li><li>IBM AIX (64-bit)<br /></li><li>HP-UX Itanium</li><li>Microsoft Windows (32-bit)</li></ul>I would recommend that all 11g OLAP users apply the 11.1.0.7 patch as soon as it is available for their operating system.<br /><br />I would also recommend that all 11g OLAP users upgrade their AWM client to the 11.1.0.7A release which can be downloaded from <a href="https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=7420490">Metalink</a> or <a href="http://download.oracle.com/otndocs/products/warehouse/awm11.1.0.7.0A.zip">OTN</a><br /><br />As always, the best source of information for recommended releases and patches is the <a href="http://www.oracle.com/technology/products/bi/olap/collateral/olap_certification.html">Oracle OLAP certification page on OTN</a><br /><br />I'm now going to download the Windows 32-bit patch (all 1.5GB of it!), and give it a roadtest....Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-28064977607311350842008-10-06T02:46:00.000-07:002008-10-10T04:10:59.631-07:00Analytic Workspace Manager 11.1.0.7A released to MetalinkThe 11.1.0.7A version of AWM has been released to Metalink as patch <a href="https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=7420490">7420490</a><br /><br />It includes important fixes and new features including:<br /><ul><li>the ability to add multiple languages to a single analytic workspace</li><li>individual aggregation definitions may now be defined for each measure of a cube</li><li>the Create Dimension user interface has been modified to allow levels of the dimension to be created at the same time as the dimension</li><li>the functionality of dimension and cube mapping has been enhanced to allow the application to refresh the definitions of database objects interactively to reflect the current state of database schema tables</li></ul><br />To take advantage of all the new fixes and features, the <a href="https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=6890831">Oracle Database 11g Release 11.1.0.7.0 Server Patch</a> must be installed as well. This is currently only available for Linux 32-bit & Linux 64-bit, but other ports are likely to be available soon.Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-29695066729112061122008-09-29T04:05:00.000-07:002008-12-23T06:23:27.184-08:00Oracle OLAP Newsletter - September 2008The latest edition of the excellent Oracle OLAP Newsletter has just been released <a href="http://www.oracle.com/technology/products/bi/olap/olapref/newsletter/oracleolapnewsletter_sep08.html">here</a><br /><br />Highlights this time include a customer feature on Oss Council in the Netherlands who use Oracle OLAP for management reporting, details of the new 11.1.0.7 release, and a guide to delivering summary management through cube materialized views.Stuart Bunbyhttp://www.blogger.com/profile/10781347144821555643noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-10840625687087223572008-07-09T02:46:00.000-07:002008-07-09T03:54:22.666-07:00Article : Closing the Ad Hoc Query Performance Gap for GoodI found an interesting article today in amongst my Google alerts. It related to a topic of conversation at the recent TDWI conference in May about the issue of adhoc query performance within data warehouse environments. The article, on the whole, was very good (in my opinion) and included comments by Oracle's vice-president of database marketing, Willie Hardie.<br /><br />The full article in <span style="FONT-WEIGHT: bold">Enterprise Systems</span> is available <a href="http://www.esj.com/business_intelligence/article.aspx?EditorialsID=9034">here</a>.<br /><br />The article examines the reasons why business users feel their queries are taking too long and what steps companies are taking to try to improve query performance. The basic reasons for poor query performance was given as being down to two issues:<br /><ul><li>success of pervasive BI - so more users are running adhoc queries</li><li>more data - users want access to more and more data, both in terms of level of detail and time span.</li></ul>I would add a third reason, which is increasing sophistication. Simply presenting users with reports that show revenue and expenses for the latest month, quarter and year to date are not adequate in today's highly competitive environment. Business users want to know about trends - this period vs last period, this year vs last year, this period vs the same period last year, like-for-like, shares, ranks, forecast, customer segmentation, market basket analysis. The list goes on and on and on.<br /><br />Here is a direct quote from the article:<br /><br /><span style="FONT-STYLE: italic">......The RDBMS -- or, more specifically, the </span><em style="FONT-STYLE: italic">Oracle</em><span style="FONT-STYLE: italic"> RDBMS -- is an unmatched analytic workhorse, Hardie argues. Oracle is one of the biggest data warehousing players in the business, he points out, and the Oracle database powers some of the largest DWs in existence.</span> <p style="FONT-STYLE: italic">"The Oracle database is proven to be the fastest database out there for both transactional systems and data warehousing systems, across all scales, from small to extremely large systems. You ask any Oracle customer out there and they'll all give you the same answer: Oracle is the fastest database out there on the market right now," he claims. </p>What I would add is the Oracle Database is the only database with embedded multidimensional OLAP, which is fine tuned for adhoc query performance, query scaleability and, most importantly, calculation power. As I stated above it is no longer about simply what is happened in the last trading period, BI analysis is now all about comparisons, trends and KPIs (calculations) at aggregate levels with the ability to drill right through to the lowest level of detail.<br /><br />As the article quite clearly acknowledges there is a trend to opening up the corporate data warehouse to more and more users, which means query performance and scalability are becoming increasingly important. Only Oracle Database has specific built-in optimisations, such as OLAP and data mining, to meet these growing requirements.<br /><br />For those of you new to Oracle OLAP Option and Oracle Data Warehousing you can get more information from these links:<br /><br /><a href="http://www.oracle.com/technology/products/bi/olap/index.html">Oracle OLAP Option on OTN<br /></a><a href="http://forums.oracle.com/forums/forum.jspa?forumID=16">Oracle OLAP Option Forum on OTN</a><br /><a href="http://wiki.oracle.com/page/Oracle+OLAP+Option">Oracle OLAP Option Wiki</a><br /><a href="http://wiki.oracle.com/page/Oracle+OLAP+Option"></a><a href="http://www.oracle.com/solutions/business_intelligence/olap.html">Oracle OLAP Option on Oracle.com</a><br /><a href="http://www.oracle.com/technology/products/bi/db/11g/index.html">Oracle Data Warehousing on OTN</a><br /><a href="http://www.oracle.com/solutions/business_intelligence/dw_home.html">Oracle Data Warehousing on Oracle.com</a><br /><a href="http://www.oracle.com/solutions/business_intelligence/optimized-warehouse-initiative.html">Optimised Warehouse Initiative</a>ASQLBaristahttp://www.blogger.com/profile/13350994132294695189noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-49952091219858371592008-01-11T01:24:00.000-08:002008-01-11T01:53:32.579-08:00The first reported case of the use of BI?This is not really about Oracle OLAP, or even Oracle Database. This relates to a recent article in the Economist, Dec 17 2007, about the historical uses of business intelligence. This is interesting from my perspective because I spend a good proportion of my time trying to convert data into useful information, or "business intelligence". Sometimes it is easy and sometimes the process is extremely frustrating. But this whole process of trying to make data useful and meaningful has been going on for a lot longer than you might think.<br /><br />The article outlines the possible start of the whole business intelligence process as being 1821 and the person responsible, William Playfair. He drew a chart comparing tax levels in various countries in order to show that Britain's was too high. He was the first to show imports and exports on one chart, shading the area between the two to indicate the balance of trade and explaining that the intersection of the lines showed a shift in favour of one country or the other.<br /><br />You can read the full article by going to the Economist Website (<a href="http://www.economist.com/">www. economist.com</a>) and searching on "Worth a Thousand Words", or by clicking <a href="http://www.economist.com/world/europe/displaystory.cfm?story_id=10278643&CFID=7346564&CFTOKEN=97b33a8906b29819-68278417-B27C-BB00-0127EC160A26E549">here</a> to go directly to the article.<br /><br />Another interesting aspect of this article relates to the way the data is presented. All the examples use graphs to visualise a dataset. In the past in my role as a consultant I have found many companies reluctant to publish anything other than basic tables of data to their business users, including board level members. There is a terrible fear of not being able to see real numbers. However, as the article shows sometimes a graph is worth a thousand tables.Keith Lakerhttp://www.blogger.com/profile/01039869313455611230noreply@blogger.com0tag:blogger.com,1999:blog-3820031471524503731.post-23805451514628019562008-01-10T01:07:00.000-08:002008-01-10T01:37:15.449-08:00Oracle Database 11g One of 2007's Most Important ProductsToday eWeek named <span style="color: rgb(255, 0, 0); font-weight: bold;">Oracle</span><span style="font-weight: bold;"> </span>Database 11g "One of the Most Important Products of 2007". To be honest, this is not really surprising given the huge number of new features that comprised the 11g release. Well, what else would you expect from the worldwide leader in database technology. In recognition of the product, eWEEK Labs stated, "Oracle's Database 11g is the cornerstone of the vendor's dynamically allocated computing grids and should garner the attention of database managers with its improved management, recovery and table compression capabilities." In response <a href="http://www.oracle.com/corporate/pressroom/html/pressportal/exec/amendelsohn.html">Andy Mendelsohn</a>, senior vice president, Oracle Database Server Technologies, stated:<br /><br /> "As the worldwide database leader,<span style="font-weight: bold; color: rgb(255, 0, 0);"> Oracle </span>distinguishes itself from competitors with leading security, scalability, availability, and data centre automation capabilities, Oracle Database 11g represents years of experience solving our customers' business and IT challenges, and it gives us great pride to be recognized by eWEEK."<br /><br /><span style="font-weight: bold; color: rgb(255, 0, 0);">Oracle</span> Database 11g has delivered over 400 new features many of which will be of direct benefit to data warehouse projects. Not only is Oracle the worldwide leader in database technology, it is also the world wide leader in providing best-of-breed functionality for data warehouses and data marts. Oracle Database 11g also provides a uniquely integrated platform for managing business driven analytics; by embedding OLAP, Data Mining, and statistical capabilities directly into the database, Oracle 11g delivers all of the functionality of standalone OLAP engines with the enterprise scalability, security, and reliability of the Oracle's world class Database. Oracle Database 11g includes the proven ETL capabilities of Oracle Warehouse Builder; robust ETL is critical for any DW/BI project, and OWB provides a solution for every Oracle Database including design, deployment and management of solutions that use the OLAP option.<br /><br /><br />For more information on the eWeek story go here : <a href="http://www.eweek.com/c/a/Infrastructure/eWEEK-Labs-The-Most-Important-Products-of-2007/7/">http://www.eweek.com/c/a/Infrastructure/eWEEK-Labs-The-Most-Important-Products-of-2007/7/</a><br />For more information on Oracle Database 11g go here: <a href="http://www.oracle.com/technology/database/index.html">http://www.oracle.com/technology/database/index.html</a><br />For more information on Oracle Database 11g for data warehousing go here: <a href="http://www.oracle.com/technology/products/bi/db/11g/index.html">http://www.oracle.com/technology/products/bi/db/11g/index.html</a><br /><br />If you want to take 11g for a test drive you can download the software directly from OTN by going here: <a href="http://www.oracle.com/technology/software/products/database/index.html">http://www.oracle.com/technology/software/products/database/index.html</a><br /><br />where you will find all links for the following platforms are available:<br /><ul><li>Microsoft Windows (32-bit)</li><li>Microsoft Windows (x64)</li><li>Linux x86 (1.7 GB)</li><li>Linux x86-64 (1.8 GB)</li><li>Solaris (SPARC) (64-bit)</li><li>AIX (PPC64)</li><li>HP-UX Itanium</li><li>HP-UX PA-RISC (64-bit)</li></ul>Keith Lakerhttp://www.blogger.com/profile/01039869313455611230noreply@blogger.com0