Discussion Locked

What SLA for a Data Warehouse?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does traditional SLA templates fit DWH specificities?
According management needs and data warehousing techs constraints,
what classics areas must be developed or omitted ?
and what metrics must be defined for response time, availability and security ?

What thinking about the existing DHW SLA biblios and templates ?

1 reply

by gaston nusimovich

You should consider that most SLA templates are designed with transactional systems in mind. A DW has some peculiarities that you should take into account.

All DW client applications see "static" data. Transactional systems show "live" data, while a DW shows historical, data-cleansed data.

A DW's business is analysis, not operations. For that analysis to be successful, you need completely accurate data with different levels of summary and detailed data.

Besides, if you need the kind of analysis that a DW can offer, it means that your organization competes in a rather dynamic environment.

So you need that your DW's structure must change and adapt frequently to cater to the changing requirements of your organization.

Another point to consider is frequency of data updates. Data cleansing procedures put some constraints on this particular aspect, so you may have to define a balance between frequency of updates and data accuracy.

I hope this gives you some ideas on what to focus your SLA for a DW.

This discussion is closed to new replies.