The IRMA Community
Newsletters
Research IRM
Click a keyword to search titles using our InfoSci-OnDemand powered search:
|
View Materialization in a Data Cube: Optimization Models and Heuristics
|
|
Author(s): Vikas Agrawal (Fayetteville State University, USA), P. S. Sundararaghavan (The University of Toledo, USA), Mesbah U. Ahmed (The University of Toledo, USA)and Udayan Nandkeolyar (The University of Toledo, USA)
Copyright: 2009
Pages: 20
Source title:
Advanced Principles for Improving Database Design, Systems Modeling, and Software Development
Source Author(s)/Editor(s): Keng Siau (City University of Hong Kong, Hong Kong SAR)and John Erickson (University of Nebraska, Omaha, USA)
DOI: 10.4018/978-1-60566-172-8.ch012
Purchase
|
Abstract
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.
Related Content
|
Renjith V. Ravi, Mangesh M. Ghonge, P. Febina Beevi, Rafael Kunst.
© 2022.
24 pages.
|
|
Manimaran A., Chandramohan Dhasarathan, Arulkumar N., Naveen Kumar N..
© 2022.
20 pages.
|
|
Ram Singh, Rohit Bansal, Sachin Chauhan.
© 2022.
19 pages.
|
|
Subhodeep Mukherjee, Manish Mohan Baral, Venkataiah Chittipaka.
© 2022.
17 pages.
|
|
Vladimir Nikolaevich Kustov, Ekaterina Sergeevna Selanteva.
© 2022.
23 pages.
|
|
Krati Reja, Gaurav Choudhary, Shishir Kumar Shandilya, Durgesh M. Sharma, Ashish K. Sharma.
© 2022.
18 pages.
|
|
Nwosu Anthony Ugochukwu, S. B. Goyal.
© 2022.
23 pages.
|
|
|