A framework for designing materialized views in data warehousing environment

Author

Yang, Jian ; Karlapalem, Kamalakar ; Li, Qing

Author_Institution

Sch. of Comput. Sci., New South Wales Univ., Canberra, ACT, Australia

fYear

1997

fDate

27-30 May 1997

Firstpage

458

Lastpage

465

Abstract

Data warehouses are accessed by different queries with different frequencies. The portions of data accessed by a query can be treated as a view. When these views are related to each other and defined over overlapping portions of the base data, then it may be more efficient not to materialize all the views, but rather to materialize certain “shared views” from which the query results can be generated. We address some issues related to determining this set of shared views to be materialized in order to achieve the best combination of good performance and low maintenance, and provide an algorithm for achieving this goal

Keywords

distributed databases; query processing; software maintenance; very large databases; base data; data warehousing environment; materialized view design; overlapping portions; query processing; query results; shared views; Algorithm design and analysis; Australia; Computer science; Data warehouses; Delay; Distributed databases; Educational institutions; Frequency; Materials science and technology; Warehousing;

fLanguage

English

Publisher

ieee

Conference_Titel

Distributed Computing Systems, 1997., Proceedings of the 17th International Conference on

Conference_Location

Baltimore, MD

ISSN

1063-6927

Print_ISBN

0-8186-7813-5

Type

conf

DOI

10.1109/ICDCS.1997.603380

Filename

603380