Abstract:In this paper, the authors propose a general approach to selecting materialized views, and define a structure named BC graph(benefit-cost graph) as the basis for selection of materialized views. A algorithm based on BC graph is then presented for such selection. Finally, it extends BC graph to BC+ graph to take account of indices associated with views.