The Oracle Australia and New Zealand Middleware and Technology Blog.
Showing posts with label BI. Show all posts
Showing posts with label BI. Show all posts

Friday, March 13, 2009

First thoughts on the Oracle Database Machine in Australia

Well its been a little over 4 months now since i started been involved with the Oracle Database Machine or DBM as i will call it here. The DBM is Oracle's first foray into the hardware appliance market.

In this tough economic climate its no surprise that every organisation wants to drive cost out of the business, in the front end and especially at the back end. The DBM couldn't have arrived at a better time to the market for our customers, here is an appliance datawarehouse designed for massive throughput from loading data, executing queries and presenting the important business intelligence back to the business. Speed in everything is essential but speed alone doesn't reduce costs, the real value in the DBM is the fact its an appliance. This is underrated IMHO especially now in this economic cliamate.

This week i needed to re image my laptop, Oracle gives you the option of Linux or Windows and being a secret techno i thought i would give Linux a try. Now i used to dabble in Unix but it was 20 years ago, and i was hoping not to venture near the text based utility vi. Anyway Linux did install pretty easy, actually i was surprised but then when i wanted to tailor it with dual head display, tool bars, gadgets, desktop search and adobe air for tweekdeck (the coolest twitter app) i suddenly realised all is not what it seemed. Suddenly i was thrust upon with desperate searches to see how to install RPM/BIN and remembering syntax for commands that mean nothing to me like chmod, bash and sudo. Wow i cant tell you how many hours i have sat at home getting this just right. Its hard since building Linux desktops isn't my profession so i wasted a lot of time taking in the knowledge of configuring a Linux.

This now takes me back to the appliance concept and specifically the DBM. Customers initially look at this box and dont appreciate the sum of the parts is far greater than any bill of materials can suggest. The DBM contains 8xHP DL360's, 14 Exadata Storage Cells with 12 disk in each, Infiniband,Oracle Unbreakable Linux, Enterprise Edition Database, RAC and Partitioning. So if you wanted an new warehouse and went to the effort of procuring the hardware, software and then looked and building the hardware units, loading drivers, os, database, RAC and ensuring its all up to date you are talking abut serious hours here. And in reality for most organisations its months not hours because your never going to dedicate resourcing 100%.

In these economic times we need to look at efficiency and productivity closer than ever. IT departments are there to make sure the user community and the business have the tools at their disposal to be productive, to automate repeatable processes and build a secure and compliant infrastructure. Its such a drain on resources to build a linux desktop as in my case or to procure a crate of hardware and a library of software to build something when you can just plug in an appliance.

The DBM offers great value when you consider Oracle with HP has done all this work for you, you can then focus on getting the most out of your new datawarehouse with new queries for the business, better ETL performance and headroom to cover the expected growth when the world recovers.

So today i have just touched on the appliance value of the Database Machine, over the next few weeks i will look at what really makes this box scream. The "Secret Sauce" will be my next post when i will discuss how the Storage Cells in the Database Machine are accelerating customers queries by factors over x100 times.
 



The Oracle Database Machine

Friday, September 26, 2008

Oracle CFO Accounting Luncheon with ACCA

Oracle ran a CFO Luncheon around ANZ with ACCA Industry Accounting body. This Planning best practices lunch with guest speaker, Malcolm Ferguson, Committee member of ACCA Australia & New Zealand and guest Oracle customer presentations.

Malcolm is an expert in business intelligence, specialising in planning systems for large organisations, mainly in the areas of budget forecasting and long term planning. Malcolm has occupied a number of financial management positions in the UK and Australia and is currently Practice Lead for BI and Analytics. As part of this role, he has spent the past few years working in-house at BHP Billiton. Malcolm’s presentation will focus on case studies from his experience, from a Financial Manager’s perspective.

This was an opportunity to learn from Industry experts ACCA Australia & New Zealand, and Oracle customers; how performance management will help reduce your planning, forecasting, budgeting time, and improve the predictability of your future results.




Malcolm Acca
View SlideShare presentation or Upload your own. (tags: oracle bi)
To view the case studies please go here

Friday, March 14, 2008

Enterprise Information Management

On the 3rd March 2008, Oracle announced enhancements to the Enterprise Content Management platform at the AIIM conference and expo in Boston. Amongst the new feature and integration capability information was the announcement that the UCM platform integrates with the Oracle Business Intelligence Publisher. This is a core part of an organisations Enterprise Information Management (EIM) strategy and it is exciting that Oracle has brought together two acquired technologies with its own to provide this solution for our customers. This is highlighted in the following graphic:


Oracle's BI server provides the ability to abstract, model, cache, calculate, optimise, analyse and report upon data from a wide-variety of information sources – including relational databases and applications. The UCM platform provides four key capabilities to the enterprise include document and records management, collaboration, process management and web-content management – all falling under the ECM umbrella.

ThThis announcement brings these two technologies together by:

  1. Providing the ability for information (e.g. reports) generated by the BI server to be stored and managed in Oracle’s UCM repository leveraging this environment’s version management and security features.
  2. Providing the capability for the information to be published, under tight content management control, to an intranet or portal environment

Of course, the integration provides for more than a simple repository and publishing mechanism for our BI customers. The UCM platform is able to provide an unstructured repository that itself can be analysed and reported upon by the BI application which leads itself well into the world of eDiscovery. Supporting information can also be published by the UCM platform to support a report or a dashboard view of the enterprise, e.g. a set of scanned invoices can be made available to a report detailing accounts payable transactions from the ERP system.

Paul