Rittman Mead - Delivered Intelligence

A couple of weeks ago I posted an article on using Oracle Warehouse Builder 10gR2 in a production environment. Since then, I’ve had the opportunity to spend some time with customers doing just this, and I’ve come up with a few more observations that are worth adding to the original article. In the original blog [...]

One of the things that came out from the Netezza conference is the number of large databases (not just on that platform) out there. Ten terabytes plus is common, I was speaking to one person with a 100 TB system whose daily batch is the same size as some people’s data warehouses, I mean, 600 [...]

As we have all seen there has been significant consolidation with in the BI tool space in the past 18 months or so. Some of the bigger players have been (or soon will be) assimilated into the other vendors’ product portfolios. In the main it has been the database vendors who have been shopping, but [...]

Well as I wrote that I was going off to think up some new W words I knew it was a bad idea! Traditional dimensions in retail data warehousing have exciting names such as TIME, PRODUCT, CUSTOMER, STORE; see not a W in sight. Other data warehouse subject domains may have other dimensions in the [...]

It is quite a while since I blogged the mini-series on data warehouse design (it started here) and was proceeded by a series with the grand title of DW Wisdom – where I strayed into talking about parallel queries, RAID5 and massive disks. But I did not really write much about dimensions. So to make [...]