Role of Materialized View Maintenance withOn-line analytical Processing

The OLAP operation are very useful for application and query different dataset,the operators aggregate data from variant levels which can be efficiently used fordata presentation in data warehouse environment. Materialized view anotherimportant issues fore DW and OLAP operates, materialized views are found usefulfor fast query processing. The process of updating materialized view in response tochange is a great challenge in data warehousing. Maintenance of materialized viewsefficiently with OLAP operators is also a challenge today in the field of RDBMSas well as data warehouse. In this paper, we discuss capabilities of OLAP operator,materialized view maintenance; achieve the principle of consistency MV with DW,view maintenance action with OLAP operators. The proposed system is implementedusing Microsoft visual studio C#.NET2010programming language with embeddedSQL server management studio 2008 R2, and all test results are found as close asthey were expected. The results proved the correctness of system design and itsreasonable considerations and choices.