OLAP Friendly OLTP Design
I thought I would post a whitepaper I wrote earlier this year under the auspices of my employer, M. Miller & Associates. This whitepaper is basically a summary of things I have observed over the course of my career in IT, particularly in regard to database design. I can assure you that I eat my own dog food when it comes to the things I discuss. I’m in the trenches every day putting into practice these concepts in order to produce solid, forward thinking designs. We’ll eventually post this on the company website, but until then I make it available here in hopes it provokes thought and discussion. Let me know what you think.
OLAP Fiendly OLTP Design – Planning Ahead for the Inevitable Data Warehouse