loyd.net

The system transactional,
With tables quite rational
Works well to record.
But what for reporting needs?
A warehouse for data feeds,
Where they can be stored.

If you have an Enterprise
To Manage Performance-wise,
You need something smart.
Your data you must Extract,
Transform, and Load into: Fact,
Dimension to start.

So that you can analyze--
What's normal, denormalize,
Materialize views.
Place these in your datamarts
And now you've got business smarts!
With dashboards to choose.

You've Answers for questioning,
Requests for that pestering
And need-to-know type.
Now, with no distorting, say...
You've got great reporting!  Yay!
At least that's the hype.

Time to Upgrade! PeoplePoems