Hash-based Placement and Processing for Efficient Node Partitioned Query-Intensive Databases

  • Authors:
  • Pedro Furtado

  • Affiliations:
  • Universidade de Coimbra, Portugal

  • Venue:
  • ICPADS '04 Proceedings of the Parallel and Distributed Systems, Tenth International Conference
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper discusses efficient hash-partitioning usingworkload access patterns to place and process relationsin a cluster or distributed query-intensive databaseenvironment.In such an environment, there is usuallymore than one partitioning alternative for each relation.We discuss a method and algorithm to determine the haspartitioning attributes and placement.Among thealternatives, our algorithm chooses a placement thatreduces repartitioning overheads using expected orhistorical query workloads.The paper includes asimulation study showing how our strategy outperformsad-hoc placement and previously proposed distributeddatabase strategies.