Entries from The Data Warehouse Insider tagged with 'Data Warehouse'
Next Generation Data Warehouse Platforms
Rather than entertain you all with my own theories I decided to be a literature critic and discuss a paper / survey done by TDWI's Philip Russom. The report goes into "what a next generation DW platform should try to...
Chunking of Updates
While I was looking at the Edition-based Redefinition I was puzzled by, or thinking about the performance of large data volumes moving across the edition. So I started thinking about how do I get that trigger to do stuff in...
Impressions from Openworld
Well, Openworld closed today with a wrap up party under (kind of) sunny skies. If nothing else it was a lot better than the weather on Tuesday. Wow, what a storm! Luckily the tents were all up and I think...
In-Memory Parallel Execution in Oracle Database 11gR2
As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out the following session: Tuesday, October 13 2009 5:30PM, Moscone South Room 308 Session...
500GB/sec and Database Machine Generation 2
Last Tuesday we announced the second generation of Database Machine. This second generation of Oracle Exadata is now running on Sun hardware. The premise for Database Machine is still the same: deliver extreme performance systems on commodity hardware with ease...
Announcing something very cool...
What are we announcing, well... you just have a look over here: http://www.oracle.com/features/larry-ellison-webcast.html Larry Ellison will be introducing a very cool new offering into the market. The webcast is tomorrow (Tuesday) September 15 at 1pm Pacific Time. Tune in, or...
Partitioning and/or/with Exadata?
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG session questions (see this post)....
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...
A follow up on "why does ETL take so long"
I got this comment from Oliver on the ETL posting: "in my opinion coding or modelling the etl-process is not the most time consuming part of building a data warehouse. The most time is spent on consolidating the dimensions and...
Why does it take forever to build ETL processes?
One of the discussion topics at ODTUG was whether or not ETL (or better data integration) still makes up 70% of the DW development time. At that session my answer was YES. For some more context take a quick look...
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...
Kindles, books and appliance style software licensing
Luckily I did have some spare time at ODTUG last week, got all settled for some reading only to realize I’d forgotten to bring the book I'm reading. I do like my books on paper and I like to own...
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....
Unloading data using External Table and Data Pump
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table. SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4 DEFAULT DIRECTORY dmp_dir 5...
Podcast: QXL Allegro on Database Machine
With the long weekend coming up I figured you all need something to listen to. Here is the latest discussion by an actual customer on the HP Oracle Database Machine. http://feedproxy.google.com/~r/OracleDatabaseInsider/~3/jbgZ7ZJ1ZGA/7643077_Christian_Maar_052009.mp3 Enjoy the long weekend, or if you are not...
More on Total Recall for the DW - Use "AS OF" to publish data
After writing the post on the ETL part I was talking to folks over here and we discussed some other interesting aspects of using time windows and "AS OF" query patterns with ETL like scenarios. The scenario goes a little...
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...
Total Recall for Data Warehousing
First of all, this is not a recall notice for your data warehouse...! This is one of those cool features that come with Oracle 11g that I think is usable in a different context (e.g. Data Warehousing). The first thing...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'Data Warehouse'.
