The Data Warehouse Insider

Edition Based Redefinition

By jean-pierre.dijcks on October 21, 2009 2:16 PM

Or, how can I use 11gR2 to update my operational data warehouse with real time data loads and still patch the schema to deal with errors or with upgrades due to changing business demands. The Theory In a time when...

Comments (0)

Data Warehouse Vendor Comparison

By jean-pierre.dijcks on April 29, 2009 12:56 PM

Spent some time looking at various vendors and their offerings and tried to compare it with the HP Oracle Database Machine offering from a customer perspective... In other words, what would I be looking at if I was looking at...

Comments (0)

New HP Oracle Database Machine offering

By jean-pierre.dijcks on March 19, 2009 7:00 AM

Oracle is now offering a new member of the HP Oracle Database Machine product line. As you all know we offered a fully configured rack containing the following (at a high level): A database server grid containing 8 HP DL360...

Comments (2)

We are you-tubed...

By jean-pierre.dijcks on March 7, 2009 8:05 AM

I had forgotten about this interview, just noticed it in the database insider news letter. You can subscribe to it here, just look for the Oracle Database Insider check box. One of the guys on the PM team (Hamid) is...

Comments (0)

Pivot, extract and more fun SQL stuff

By jean-pierre.dijcks on March 4, 2009 12:40 PM

I was thinking back to the Warehouse Builder days and the pivot and unpivot operators we built into the tool. Wanted to check out the SQL commands in 11g and see how that works, so I dug around in the...

Comments (2)