CONCLUSIONS

The reasons for the success of view materialization in multidimensional databases are twofold: first, the extremely high ratio between queries and updates, typical of all data analysis systems, makes considerably easier the task to maintain all the materialized views; also, the restricted variety of queries typically supported by multidimensional databases permits the design of sophisticated models that are able to represent well the contribution that a view materialization can offer to view computation.

This chapter presented the main problems that arise in the adoption of materialized views for data analysis systems using conventional DBMS technology. The importance of these techniques is demonstrated by their rapid adoption in industrial DBMS systems.