|
IGI Global
Main Office
701 E. Chocolate Avenue
Hershey, PA 17033, USA
Tel: 717-533-8845 x100
Toll Free: 1-866-342-6657
Fax: 717-533-8661
or 717-533-7115
|
|
|
View Materialization in a Data Cube: Optimization Models and Heuristics:
| Our Price: |
$30.00 US |
| Article #: |
ITJ3702 |
| Number of pages: |
1-20 pages |
| Source: |
Journal of Database Management, Vol. 18, Issue 3 |
| Author(s): |
Agrawal, Vikas; Sundararaghavan, P. S.; Ahmed, Mesbah U.; Nandkeolyar, Udayan |
| Affiliation(s): |
Fayetteville State University, USA; The University of Toledo, USA; The University of Toledo, USA; The University of Toledo, USA |
Order Now!
This document will be delivered electronically. Terms of Delivery |
|
Description
Data warehouse has become an integral part in developing a DSS in any organization. One of the key architectural issues concerning the efficient design of a data warehouse is to determine the “right” number of views to be materialized in order to minimize the query response time experienced by the decision makers in the organization. We consider a bottleneck objective in designing such a materialization scheme which has the effect of guaranteeing a certain level of performance. We examine linear integer programming formulations, and develop heuristics and report on the performance of these heuristics. We also evaluate heuristics reported in the literature for the view materialization problem with a simpler objective. |
