Rittman Mead - Delivered Intelligence

The other day I posted an article on migrating OWB modules to production, and I said that I’d come back shortly with some OMB*Plus code to automate the migration process. As good as my word, I’m now back with the said code.
In this example, we have a module called “CUSTOMERS” in an OWB10gR2 proiject called […]

I have written recently about the trend towards ever larger databases. But what should we call these VLDB systems?
A few years back a set of terms seem to fit well, DSS, MIS, data warehouse, datamart; sometimes the distinction between them was very blurred. But by and large we were dividing the reporting from the transactional. […]

Back at the start of February I mentioned that I was leaving my consulting job and moving in to the world of independent consultancy; now that the move is complete and I’ve started the new business up, I can finally start talking about what I’ve got planned for the future. As you’ve probably noticed from […]

Yesterday I ungraciously forgot to mention Nuno Souto’s blog piece from January where he was talking about just the same sort of issues with access to massive databases. Please go and read Noons’ work, it is well worth it.
I mentioned two challenges yesterday, putting the data into the database and finding it again. Systems that […]

If you’re reading this, it means the migration of my blog to the new company site has been successful.
I’ll post more news on what this means over the next few days, but for now, welcome to Rittman Mead Consulting, the name of our new consulting venture.

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 posting, […]

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 core […]

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 […]