Framework for designing materialized views in data warehousing environment

Jian Yang; Kamalakar Karlapalem; Qing Li

Framework for designing materialized views in data warehousing environment

Jian Yang, Kamalakar Karlapalem, Qing Li

Research output: Unpublished conference presentation (presented paper, abstract, poster) › Conference presentation (not published in journal/proceeding/book) › Academic research › peer-review

34 Citations (Scopus)

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. In this paper, 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.

Original language	English
Pages	458-465
Number of pages	8
Publication status	Published - 1 Jan 1997
Externally published	Yes
Event	Proceedings of the 1997 17th International Conference on Distributed Computing Systems - Baltimore, MD, USA Duration: 27 May 1997 → 30 May 1997

Conference

Conference	Proceedings of the 1997 17th International Conference on Distributed Computing Systems
City	Baltimore, MD, USA
Period	27/05/97 → 30/05/97

ASJC Scopus subject areas

Hardware and Architecture

Cite this

@conference{50734825a6a14e8ab41afda2767b7d82,

title = "Framework for designing materialized views in data warehousing environment",

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. In this paper, 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.",

author = "Jian Yang and Kamalakar Karlapalem and Qing Li",

year = "1997",

month = jan,

day = "1",

language = "English",

pages = "458--465",

note = "Proceedings of the 1997 17th International Conference on Distributed Computing Systems ; Conference date: 27-05-1997 Through 30-05-1997",

}

Framework for designing materialized views in data warehousing environment. / Yang, Jian; Karlapalem, Kamalakar; Li, Qing.
1997. 458-465 Paper presented at Proceedings of the 1997 17th International Conference on Distributed Computing Systems, Baltimore, MD, USA.

Research output: Unpublished conference presentation (presented paper, abstract, poster) › Conference presentation (not published in journal/proceeding/book) › Academic research › peer-review

TY - CONF

T1 - Framework for designing materialized views in data warehousing environment

AU - Yang, Jian

AU - Karlapalem, Kamalakar

AU - Li, Qing

PY - 1997/1/1

Y1 - 1997/1/1

N2 - 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. In this paper, 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.

AB - 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. In this paper, 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.

UR - http://www.scopus.com/inward/record.url?scp=0030646563&partnerID=8YFLogxK

M3 - Conference presentation (not published in journal/proceeding/book)

AN - SCOPUS:0030646563

SP - 458

EP - 465

T2 - Proceedings of the 1997 17th International Conference on Distributed Computing Systems

Y2 - 27 May 1997 through 30 May 1997

ER -

Framework for designing materialized views in data warehousing environment

Abstract

Conference

ASJC Scopus subject areas

Other files and links

Fingerprint

Cite this