Welcome to the InfoSci Platform
Reference Hub2
Efficient and Robust Node-Partitioned Data Warehouses

Efficient and Robust Node-Partitioned Data Warehouses

Pedro Furtado
Copyright: © 2009 |Pages: 20
ISBN13: 9781605660585|ISBN10: 1605660582|EISBN13: 9781605660592
DOI: 10.4018/978-1-60566-058-5.ch040
Cite Chapter Cite Chapter

MLA

Furtado, Pedro. "Efficient and Robust Node-Partitioned Data Warehouses." Database Technologies: Concepts, Methodologies, Tools, and Applications, edited by John Erickson, IGI Global, 2009, pp. 658-677. https://doi.org/10.4018/978-1-60566-058-5.ch040

APA

Furtado, P. (2009). Efficient and Robust Node-Partitioned Data Warehouses. In J. Erickson (Ed.), Database Technologies: Concepts, Methodologies, Tools, and Applications (pp. 658-677). IGI Global. https://doi.org/10.4018/978-1-60566-058-5.ch040

Chicago

Furtado, Pedro. "Efficient and Robust Node-Partitioned Data Warehouses." In Database Technologies: Concepts, Methodologies, Tools, and Applications, edited by John Erickson, 658-677. Hershey, PA: IGI Global, 2009. https://doi.org/10.4018/978-1-60566-058-5.ch040

Export Reference

Mendeley
Favorite

Abstract

Running large data warehouses (DWs) efficiently over low cost platforms places special requirements on the design of system architecture. The idea is to have the DW on a set of low-cost nodes in a nondedicated local area network (LAN). Nodes can run any relational database engine, and the system relies on a partitioning strategy and query processing middle layer. These characteristics are in contrast with typical parallel database systems, which rely on fast dedicated interconnects and hardware, as well as a specialized parallel query optimizer for a specific database engine. This chapter describes the architecture of the nodepartitioned data warehouse (NPDW), designed to run on the low cost environment, focusing on the design for partitioning, efficient parallel join and query transformations. Given the low reliability of the target environment, we also show how replicas are incorporated in the design of a robust NPDW strategy with availability guarantees and how the replicas are used for always-on, always efficient behavior in the presence of periodic load and maintenance tasks.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.