I’ll start off ’07 with a tip blog. As information systems get more complex and need to be more reliable, usage information BY USER is becoming more essential for meeting the expectations. The 80/20 rule is certainly evident over time in data warehouse usage among the user community. Those 20% of users who put the 80% of the load on the system also may provide upwards of 80% of the value the user community is getting from the data warehouse. They need to be cared for, sometimes close to the personal level. With the built-in DBMS tools, it’s difficult or impossible to get a good profile of usage by user.
Appfluent is a vendor that provides insight into how users interact with applications and data over time. The Appfluent Product Suite then helps optimize query performance. What I like about it is the ability for DBAs to target their support to the user’s specific needs. I have watched this product in action and now believe it merits strong consideration oversighting any data warehouse that a company is bent on relying on.
Technorati tags: Data WarehouseTechnorati tags: Appfluent
Posted January 3, 2007 8:15 AM
Permalink | No Comments |
Twitter 
LinkedIn 
YouTube