The Twittersphere keeps chirping with definitional disputes about what exactly constitutes an enterprise data warehouse (EDW). This is the sort of debate that we geekier analysts love to engage in, since it gives us a chance to beat our chests and brandish our superior powers of cogitation.
Since I have exposed skin in this game, I’ll flex my cognitive muscle a little bit more for those who wonder what Forrester’s position is on all this. Given that my update to the Forrester Wave™ for EDW platforms will come out in a month or so, this is probably a good time to level-set the discussion. In this post, I will also point to some trends that are pushing the boundaries of what an EDW is and can do for you.
Some have argued that an EDW requires a DBMS, but is not, in itself, a DBMS. I’ve heard it said that a DBMS only becomes an EDW when it incorporates a schema and stores data. Still others argue that an EDW is something entirely distinct from a DW (without the “enterprise”) modifier, a data mart, or an operational data store (ODS).
I find all of these perspectives hairsplitting and misleading, in that they blur the actual distinctions among these architectural constructs. Paradoxically and obliquely, though, they all hint at the rapid evolution of the EDW into something more protean and virtualized.
Read more