Tackling the challenges of materialized view design in data warehousing environment

Jian Yang; Kamalakar Karlapalem; Qing Li

Tackling the challenges of materialized view design 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

5 Citations (Scopus)

Abstract

How to design materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If we regard data warehouse queries as integrated views over the base databases, then there exists a need of selecting a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. In this paper, we compare materialized view design (MVD) work with such related problems as common subexpressions and multiple query processing, discuss the unique requirements of MVD, and outline possible solutions of addressing some of the challenging issues of MVD.

Original language	English
Pages	32-41
Number of pages	10
Publication status	Published - 1 Jan 1997
Externally published	Yes
Event	Proceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97 - Birmingham, UK Duration: 7 Apr 1997 → 8 Apr 1997

Conference

Conference	Proceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97
City	Birmingham, UK
Period	7/04/97 → 8/04/97

ASJC Scopus subject areas

Hardware and Architecture
Software
Engineering (miscellaneous)

Cite this

@conference{5f9f07935d274916919f251bd51ba120,

title = "Tackling the challenges of materialized view design in data warehousing environment",

abstract = "How to design materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If we regard data warehouse queries as integrated views over the base databases, then there exists a need of selecting a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. In this paper, we compare materialized view design (MVD) work with such related problems as common subexpressions and multiple query processing, discuss the unique requirements of MVD, and outline possible solutions of addressing some of the challenging issues of MVD.",

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

year = "1997",

month = jan,

day = "1",

language = "English",

pages = "32--41",

note = "Proceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97 ; Conference date: 07-04-1997 Through 08-04-1997",

}

Tackling the challenges of materialized view design in data warehousing environment. / Yang, Jian; Karlapalem, Kamalakar; Li, Qing.
1997. 32-41 Paper presented at Proceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97, Birmingham, UK.

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

TY - CONF

T1 - Tackling the challenges of materialized view design in data warehousing environment

AU - Yang, Jian

AU - Karlapalem, Kamalakar

AU - Li, Qing

PY - 1997/1/1

Y1 - 1997/1/1

N2 - How to design materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If we regard data warehouse queries as integrated views over the base databases, then there exists a need of selecting a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. In this paper, we compare materialized view design (MVD) work with such related problems as common subexpressions and multiple query processing, discuss the unique requirements of MVD, and outline possible solutions of addressing some of the challenging issues of MVD.

AB - How to design materialized views in a data warehousing environment is an important problem which has been largely overlooked in the past. If we regard data warehouse queries as integrated views over the base databases, then there exists a need of selecting a set of views to be materialized so that the best combination of good performance and low maintenance cost can be achieved. In this paper, we compare materialized view design (MVD) work with such related problems as common subexpressions and multiple query processing, discuss the unique requirements of MVD, and outline possible solutions of addressing some of the challenging issues of MVD.

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

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

AN - SCOPUS:0030697617

SP - 32

EP - 41

T2 - Proceedings of the 1997 7th International Workshop on Research Issues in Data Engineering, RIDE'97

Y2 - 7 April 1997 through 8 April 1997

ER -

Tackling the challenges of materialized view design in data warehousing environment

Abstract

Conference

ASJC Scopus subject areas

Other files and links

Fingerprint

Cite this