Efficient Placement and Processing in Shared-Nothing Data Warehouses

Efficient Placement and Processing in Shared-Nothing Data Warehouses

Pedro Nuno San-Bento Furtado (Universidade de Coimbra, Portugal)
DOI: 10.4018/978-1-59904-289-3.ch005
OnDemand PDF Download:


Some businesses generate giga or even terabytes of historical data that can be organized and analyzed for better decision making. This poses issues concerning systems and software for efficient processing over such data. While the traditional solution to this problem involves costly hardware and software, we focus on strategies for running large data warehouses over low-cost, non-dedicated nodes in a local-area network (LAN) and non-proprietary software. Once such a technology is in place, every data warehouse will be able to run in a small cost environment, but the system must be able to choose its placement and processing for maximum efficiency. We discuss the basic system architecture and the design of the data placement and processing strategy. We compare the shortcomings of a basic horizontal partitioning for the environment, with a simple design that produces efficient placements. Our discussion and results provide important insight into how low-cost efficient data warehouse systems can be obtained.

Complete Chapter List

Search this Book:
Table of Contents
Chapter 1
Mauri Leppänen
This chapter presents an ISD ontology, which aims to provide an integrated conceptualization of ISD through anchoring it upon a contextual approach.... Sample PDF
Towards an Ontology for Information Systems Development—A Contextual Approach
Chapter 2
Raimundas Matulevicius, Patrick Heymans, Andreas L. Opdahl
Goal modeling is emerging as a central requirements engineering (RE) technique. Unfortunately, current goal-oriented languages are not interoperable... Sample PDF
Ontological Analysis of KAOS using Separation of References
Chapter 3
Sergio Luján-Mora, Juan Trujillo
In previous work, we have shown how to use unified modeling language (UML) as the primary representation mechanism to model conceptual design... Sample PDF
Applying UML for Modeling the Physical Design of Data Warehouses
Chapter 4
Wil M.P. van der Aalst, Mariska Netjes, Hajo A. Reijers
Business process management (BPM) systems provide a broad range of facilities to enact and manage operational business processes. Ideally, these... Sample PDF
Supporting the Full BPM Life-Cycle Using Process Mining and Intelligent Redesign
Chapter 5
Pedro Nuno San-Bento Furtado
Some businesses generate giga or even terabytes of historical data that can be organized and analyzed for better decision making. This poses issues... Sample PDF
Efficient Placement and Processing in Shared-Nothing Data Warehouses
Chapter 6
Colleen Cunningham, Il-Yeol Song
Customer relationship management (CRM) is a strategy that integrates concepts of knowledge management, data mining, and data warehousing in order to... Sample PDF
Factors Affecting Design Decisions for Customer Relationship Management Data Warehouses
Chapter 7
Xuepeng Yin, Torben Bach Pedersen
In today’s OLAP systems, physically integrating fast-changing data, for example, stock quotes, into a cube is complex and time-consuming. This data... Sample PDF
Effective Processing of XML-Extended OLAP Queries Based on a Physical Algebra
Chapter 8
Keng Siau, John Erickson, Lih Yunn Lee
An on-going and major problem faced by information systems developers and business users alike is reaching a clear and consensual understanding of... Sample PDF
Is There a Difference Between the Theoretical and Practical Complexity of UML?
Chapter 9
Jeretta Horn Nord, G. Daryl Nord, Hongjiang Xu, Elizabeth S. Myrin
This chapter presents results from a large-scale survey of Australian CPA members regarding data quality. The research investigates and reports... Sample PDF
Data Quality: An Assessment
Chapter 10
Nenad Jukic, Svetlozar Nestorov, Susan V. Vrbsky, Allen Parrish
In this chapter, we extend the multi-level secure (MLS) data model to include nonkey related cover stories so that key attributes can have different... Sample PDF
Cover Stories for Key Attributes—Expanded Database Access Control
About the Contributors