Selectively Materializing Data in Mediators by Analyzing User Queries

There is currently great interest in building information mediators that can integrate informationfrom multipledata sources such as databases or Web sources. The query response time in such mediators is typically quite high. We present an approach for optimizing the performance of information mediators by selectively materializing data. We first present our overall framework for materialization in a mediator environment. We then stress the need to materialize data selectively and outline the factors that must be considered to select data to materialize. We present an algorithm for identifying classes of data to materialize by analyzing one of the factors which is the distribution of user queries. We present results with an implemented version of our optimizationsystem for the Ariadne informationmediator, which show significant performance improvement over no materialization and existing schemes such as page level caching.

• Type: Conference
• Year: 1999
• Where: COOPIS
• Authors: Naveen Ashish, Craig A. Knoblock, Cyrus Shahabi
• Keywords: COOPIS 1999, Information Management, Information Mediators, Multipledata Sources, Query Response Time