Efficient Query Processing with Associated Horizontal Class Partitioning in an Object Relational Data Warehousing Environment

DMCA

Efficient Query Processing with Associated Horizontal Class Partitioning in an Object Relational Data Warehousing Environment (2000)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Vivekanand Gopalkrishnan , Q. Li , K. Karlapalem

Citations:

5 - 1 self

BibTeX

@MISC{Gopalkrishnan00efficientquery,
    author = {Vivekanand Gopalkrishnan and Q. Li and K. Karlapalem},
    title = {Efficient Query Processing with Associated Horizontal Class Partitioning in an Object Relational Data Warehousing Environment},
    year = {2000}
}

OpenURL

Abstract

In an Object Relational Data Warehousing (ORDW) environment, the semantics of data and queries can be explicitly captured, represented, and utilized based on is-a and class composition hierarchies, thereby resulting in more efficient OLAP query processing. In this paper, we show the efficacy in building semantic-rich hybrid class partitions by incorporating the Associated Horizontal Class Partitioning (AHCP) technique on the ORDW schema. Given a set of queries, we use primary and derived partitioning algorithms to select (near) optimal AHCPs, thereby embedding query semantics into the partitioned framework. Finally, by a cost model, we analyze the effectiveness of our approach visa -vis the unpartitioned approach. 1 Introduction Data warehouse (DW) equips users with more effective decision support tools by integrating enterprise-wide corporate data into a single repository from which business end-users can run reports and perform ad hoc data analysis [CD97]. As DWs con...

Keyphrases

associated horizontal class partitioning efficient query processing object relational data warehousing environment semantic-rich hybrid class partition optimal ahcps business end-users efficient olap query processing introduction data warehouse ad hoc data analysis cd97 partitioned framework object relational data warehousing query semantics cost model class composition hierarchy ordw schema unpartitioned approach approach visa single repository enterprise-wide corporate data dws con effective decision support tool

DMCA