Practical experiences with materialized views in a very large data store for telecommunication service management

This paper presents our enhancements to the work of Harinarayan (1996) on the use of materialized views for query execution speed-up. The enhancements were developed when trying to apply the basic approach in a real-life situation on a very large data store with a complex multidimensional model of 18 million views. Our contributions are an extension of the basic model, the development of an efficient implementation, and a heuristic for view size estimation. In addition, we experimented with different cost functions and validated our enhancements in actual experiments. The paper shows that the approach of Harinarayan (augmented with our enhancements) is applicable in practical situations with large view lattices