#EDW Data Stored in Multiple Places

One reason the Enterprise Data Warehouse is so expensive, in addition to the length of time to create, is the fact that data is stored in multiple places.  And somebody has to pay for that storage.

Because if you think about it, you have your source data.  In the source data repository.

And you move that data into Staging database.

Then you move that same data to Data Warehouse database.

Then you move that same data to the SSAS Cube.

So just right there you have 4 points of data along the trail.

By moving to Hadoop for this reason alone, you can save your organization money.

Then throw in the fact that you can process huge volumes of data, variety of data sources, semi and unstructured data, process in parallel processes across commodity hardware and reduce user licenses Hadoop may be just what you're looking for.

No comments:

Post a Comment