Oracle BIWA User Community

I am getting ready to listen to LARRY Ellison's talk on OLTP version of Exadata using SUN hardware. I see that this may be useful for mixed workload boxes. Larry had said last year while announcing Exadata in Sep '08, that 70% of the workload of OLTP's are for querying of data. Oracle is claiming "The result is a quantum leap in performance over Oracle's previous generation Exadata machine, including a 20x increase in random I/O and a 5x I/O bandwidth speedup with FlashFire Technology, as well as a 2x speedup in compute and network performance capacity." Let us see how Larry is going to explain this.

I had posted about my BIWA SIG Techcast here . I would like this to follow up the event, if you had a question that you wanted to follow up, please use the comments here. I will try to answer those.

Today Oracle 11g R2 was released. It is interesting to note that Linux version is the first to be out as usual, even though Oracle is on verge of owning Solaris OS. Sun and Windows version are expected later this year. The timing is good, it's about 1 1/2 months to Oracle Openworld. I am sure the 11g R2 related session will be a good draw. So what's new in this release: 1) Enhancements to Real Application Cluster, Oracle RAC One Node option is now available for relatively less critical systems. The ASM get's a face lift with intelligent data placement leading to better retrieval rate for data. 2) Advanced data partitioning to allow more online application upgrades. 3) One of the Exadata related feature is called “Warehouse” Compression and is based upon Exadata Hybrid Columnar Compression. This technique delivers a typical compression ratio of up to 10:1 for data warehouses, with virtually no negative impact on query performance, per Oracle. The "archive" compr...

Here is my personal invitation to come and attend the next Oracle BIWA SIG Techcast called: OBIEE Analytics/Reporting Solutions for E-Business Suite I p l a n to discuss the following high level topics: 1) Oracle BI Applications for supported Oracle E-Business Suite Modules and other Oracle Applications. It will include real world experiences for implementing BI Apps Version 7.9.6 {yes I have brought a 7.9.6 implementation to production recently!} 2) Custom OBIEE Development against E-Business Suite (when no BI apps are available) 3) Migration of Discoverer EUL to OBIEE RPD using Migration Utility While OBIEE and BI Apps are clearly the strategic analytics reporting direction from Oracle, only certain Analytics applications are available. Sometimes all customer needs for BI reporting may not be met by these pre-built analytics. For instance, JD Edwards has pre-built ETL connectors only for Financial Analytics. While more BI Apps and ETL connectors are in the pipeline, how can users...

Dear Shyam Varan These are exciting times for SPSS and for you, our customer. By now you have probably heard the news that SPSS Inc. has entered into an agreement to be acquired by IBM Corporation. First, I want to personally thank you for your patronage over the years and for enabling us to reach this pinnacle event. Second, I want to assure you that, as we go through the process of finalizing the acquisition, our level of support and dedication to academia will remain as strong as ever. During this time, account management and support infrastructure will be at the forefront of our focus and, of course, we will continue to honor our outstanding commitments and contracts. In short, our action plan for the immediate future is business as usual. This agreement is a momentous step, as becoming part of IBM will provide us with the scale and resources to better meet academia’s need for the most advanced data analysis and decision-making tools. We are firmly committed to: Providing acade...

It has been a while since I blogged, BIWA hosted a webcast on Data Mining by Charlie Berger and is ready for another one tomorrow on Oracle database 11g optimizer by Maria Colgan . Her talks are generally "sold out." In my opinion her topic is not mainstream BI, yet something that all BIDW professionals need to know to drive performance out of the Oracle DB based data warehouses. We have a few more talks lined up such as Oracle OLAP at Gallup: A Scalable Unified Approach to BI Reporting by the Gallup folks and then mine on OBIEE Analytics/Reporting Solutions for E-Business Suite Now that my Blogger status for Oracle Openworld 2009, registration is approved, I am "licensed to blog." :) You might have observed that the title of this section is " The Business Case for Social Networks " yet I start talking about BIWA Techcasts. Well, I want to build the business case implicitly and not explicitly. You can note that today almost all the BI experts quote...

Wednesday, July 8, 12 noon Eastern BIWA Wednesday TechCast Series - Second Event! Tales from the Front: Strategies for a Successful OBIEE Implementation Click here for details Are you starting a new OBIEE project? Or perhaps you're mired in the muck of an existing project, and things aren't going well. No matter what your experience with OBIEE has been so far, no matter what industry your company is in, this session will provide you with helpful tips and techniques to guide you toward a successful OBIEE implementation. We'll discuss topics such as: Divide and Conquer: The key strengths you need on your OBIEE implementation team. Nothing Stops a Train: But a lack of proper training can stop your project in its tracks. Any Way You Slice It: Why your security model should be one of the first, second, and third things you consider. What's In a Name?: Ideas for implementing a standardized naming convention for the objects in your OBIEE schema. Who's On First? The first,...