Issues of Materialized Views in Datawarehousing for Efficient Management of Information

Multiple Views can be formed and materialized from a data warehouses per the user requirements specified in the queries being generated against the information contained in the warehouse. Selecting Views to be materialized is one of the most important decisions in designing a warehouse. Due to change in user requirements and constraints over time View definitions stored in a data warehouse are dynamic in nature. This paper focus on the issues of materialized views in Data warehousing to enable efficient Information Management. The issues include selection, maintenance and updating of Materialized views and how these issues create an impact in Business scenarios