International Journal of Computer Science and Applications
One of the important issues in data warehousing is the selection of a set of views to materialize in order to minimize the cost. Materialized view can provide the massive improvement in query processing and it is the crucial decision in a database for optimal efficiency. Materialized views have been found to be very effective at speeding-up queries and are increasingly being supported by commercial databases or data warehouse systems. However, one encounters the problem of view maintenance if all possible views are materialized in advance.