Data warehouse enhancement manipulating materialized view hierarchy

Materialized Views usually used in distributed databases for replication and can also be used for well-organized delivery of data to a querying process. The process of data delivery to queries can further be accelerated if materialized views hierarchy is introduced to the existing materialized view. The newly generated sub views of the existing materialized views forms a materialized views hierarchy consists of parents and newly generated sub materialized views. The newly generated sub materialized views are dependent over the existing materialized views. Besides, these newly generated views are automatically created upon the creation of the parent materialized with some restrictions. This reduces the user dependency due to creation of materialized views based on some parameters. These parameters include the number of newly generated materialized views and the type of the data a view contain. In this paper, a stable approach is suggested to create newly generated materialized views to answer user queries without consulting the parent materialized view that requires no complex calculations and joining of multiple tables.