Entries from The Data Warehouse Insider tagged with 'Database'

Edition Based Redefinition

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...

In-Database MapReduce (Map-Reduce)

The Map-Reduce model has become a popular way for programmers to describe and implement parallel programs. These custom map-reduce programs are often used to process a large data set in parallel. This post shows how to implement Map-Reduce Programs within...

A not so fabulous new release

According to recent blog entries, Netezza is claiming a 10x – 15x increase in price-performance. At first glance that sounds pretty impressive. According to the bloggers, the performance increase supposedly comes from a 3x cut in price per TB and...

Class: Optimizer - Good things get even better (Aug 5)

This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific Time. Since its introduction in Oracle7, people have been fascinated...

Lock up your data warehouse - Part 1

Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few weeks ago most of the major systems, including the data warehouse, of a...

Best Practices at ODTUG

Today was the last day in Monterey. Bye bye aquarium and all the other wonderful things Monterey has to offer. I got lucky with owning one of the sessions in the last block of the conference. But if there is...

What is going on in the BI/DW world?

Well, lots of fun things as I got to experience in the BI/DW panel at ODTUG. There were some interesting questions from both the audience and Mark (Rittman that is…). The folks on the panel were Michael Armstrong-Smith, Mike Durran...

What's going on: HP Technology Forum and Expo

Should you be in the neighborhood, come visit Hamid and me at the HP Technology Expo in Las Vegas this week. We'll be sharing details on HP Oracle Database Machine with the folks out there in a set of workshops....

More Exadata Deep Dive Webcasts

It is time to tune in to Kevin Closson's next deep dive into the Exadata secret sauce. He will be doing part III of his deep dive series via IOUG. Here are the details: IOUG EXADATA SIG Webinar on May...

Sun and HP Oracle Database Machine

Ok, before you all get excited and make up all sorts of cool stories, better to go to the source and figure out what is going on. First of all, the following is the only place where you hear the...

Oracle Releases Industry Data Models

There is a lot of interesting news coming out of Oracle these days... And while the sun is shining here in California there are interesting things going on. We just made the first in a series of industry data models...

M-Tel's Case Study Using HP Oracle Exadata Storage Server

Are you interested in hearing real customers using HP Oracle Exadata Storage Servers? Intelligent Enterprise is hosting M-Tel who will tell us all about their business case for extreme performance. When: April 22nd - 9am Pacific Time Where: Sign in...

Oracle Exadata Storage Server class now available

Oracle University is now offering a class on Oracle Exadata Storage. The class is a Live Virtual Class (LVC) allowing your resources and our resources to come together in class without traveling. After all, greener is better! The class outline,...

New HP Oracle Database Machine offering

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...

Pivot, extract and more fun SQL stuff

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...

Augment or Replace and what product to use?

There is a lot said and discussed on the HP Oracle Database Machine offering from Oracle. But , at a high level, I think it is important to understand the two offerings Oracle introduced. These offerings allow various solutions for...

Oracle at TDWI Las Vegas

The TDWI Winter conference has just started. Oracle is one of the premier data warehouse vendors at the show. This time around we are demonstrating: - HP Oracle Database Machine and the Exadata Storage Servers - Data Warehousing with Oracle...