General discussion

Locked

What SLA for a Data Warehouse?

By Eric Colomb ·
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 ?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Gast?n Nusimovich In reply to What SLA for a Data Wareh ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums