Oracle Open World 2008, Day 3 : New BI Technology & Keynotes

Wednesday, September 24th, 2008 by Mark Rittman

Now that’s more like it. After I mentioned that there didn’t appear to be much new BI information at this year’s Open World, I went to a session by Matt Bedin on “New Technologies in Oracle BI Suite Enterprise Edition” whilst Thomas Kurian’s keynote was almost all about the new BI and EPM products that […]

Oracle Open World 2008, Day 2 : Presentations and Keynotes

Tuesday, September 23rd, 2008 by Mark Rittman

Day 2 of Oracle Open World 2008 started off with Charles Phillips and Chuck Rozwat’s keynote setting out, at a high level, all the innovations around the various product lines over the past year. There wasn’t anything around BI in the session, it was mostly around what’s been happing with Fusion Middleware, the database and […]

Oracle Open World 2008, Day 1 : “The X is Coming”

Monday, September 22nd, 2008 by Mark Rittman

I was just walking back from the Thirsty Bear with Tim Hall, when we saw this teaser advert inside the Moscone Center:

Presumably this is the new Database Accelerator that hit the blogs and news sites last week, and that Oracle wouldn’t talk about at the ACE Director briefing today. If you follow the threads on […]

Oracle Open World 2008, Day 1 : User Groups and ACE Director Briefing

Sunday, September 21st, 2008 by Mark Rittman

Today was the first day of Oracle Open World in San Francisco, with most of today’s sessions being organized by the various user groups. For me, as usual on the first day over here, I was up at around 4am, so I used the time to get my demos sorted out for the two sessions […]

Loading OBIEE Data Into Essbase Using Essbase Studio 11.1

Saturday, September 20th, 2008 by Mark Rittman

I’m currently sitting on a British Airways flight over to San Francisco, getting my demos and presentations sorted out for tomorrow. I’ve got an early start in the morning with an 8.30 slot as part of the IOUG Forum, doing a session on extending and customizing the Oracle BI Applications data warehouse. After that I’ve […]

Tuning an Oracle 11g Data Warehouse Using the DBConsole Advisors

Wednesday, September 17th, 2008 by Mark Rittman

I’m currently back in Denmark running the first of my Oracle 11g Data Warehousing Masterclasses, today was the first day and I’m currently back in the hotel working through some material for tomorrow. One of the main demonstrations that I went through today was around using the SQL Access Advisor to recommend on indexes, materialized […]

Testing Advanced (OLTP) Compression in Oracle 11g

Sunday, September 14th, 2008 by Mark Rittman

Another new feature in Oracle 11g of interest to data warehouse developers is Advanced Compression. This new feature extends the capabilities of segment compression first introduced with Oracle 9i, but crucially makes it work for all DML operations, not just direct path inserts, direct path SQL*Loader operations and CREATE TABLE … AS SELECT operations. As […]

Investigating Oracle 11g Interval Partitioning

Saturday, September 13th, 2008 by Mark Rittman

If you’ve kept abreast of what’s new in the latest release of the database, you will probably be aware of three major enhancements to partitioning in Oracle 11g. Firstly, there’s the new reference (ref) partitioning where you can partition one table based on a key value in another, so that for example you can partition […]

So, What is “Oracle’s New Database Accelerator”?

Friday, September 12th, 2008 by Mark Rittman

I was just taking a look through the Open World session catalog when I came across what I presume is recently added session, “Oracle’s New Database Accelerator: Query Processing Revolutionized”. It’s actually running three times on the Thursday which indicates that it’s actually quite a big deal, and there’s a follow-up session later on entitled […]

Cube, Rollup, Grouping Sets and Grouping IDs

Wednesday, September 10th, 2008 by Mark Rittman

If you’ve kept up with the various new data warehousing features in Oracle over the past few years, you might have noticed extensions to the GROUP BY clause such as ROLLUP, CUBE, GROUPING SETS and so on. If like me you’ve glanced at these features and mentally noted them as being potentially useful, you might […]