SPS: Distributed view indexing

Abstract

Real time massive amounts of data has led the enterprise to maintain a distributed architecture so as to achieve higher storage benefits and parallelized query processing. Consistent improvement in query processing time is achieved using distributed materialized views and indexing. So the present olap technology is very much influenced by distributing fragments of views over multiple sites. To address the storage constraint only needed views are materialized and the views materialized at various sites need not be same. One of the common problem encountered in distributed View management scheme is multiple query redirects. User queries are redirected if the requested view is not located and materialized at a particular site. Much work is done on distributed view maintenance, addressing functionalities like view updates and deletions. To our knowledge there is no better view management scheme under distributed scenario following distribution of vertical fragments. In this paper we propose a novel distributed view management scheme called the signature proxy, which will identify where the required views are located and materialized and directs the query to the respective site. The model is designed to reduce the number of query redirects and the communication cost.