Online Balancing of Range-Partitioned Data with Applications to Peer-to-Peer Systems Prasanna Ganesan, Mayank Bawa, and Hector Garcia-Molina   View Paper (PDF)   Return to RESEARCH SESSION 11:DISTRIBUTED SEARCH AND QUERY PROCESSING Abstract We consider the problem of horizontally partitioning a dynamic relation across a large number of disks/nodes by the use of range partitioning. Such partitioning is often desirable in large-scale parallel databases, a swell as in peer-to-peer (P2P) systems. As tuples are inserted and deleted, the partitioning may need to be adjusted, and data moved, in order to achieve storage balance across the participant disks/nodes. We propose efficient, asymptotically optimal algorithms that ensure storage balance at all times, even against an adversarial insertion and deletion of tuples. We combine the above algorithms with distributed routing structures to architect a P2P system that supports efficient range queries, while simultaneously guaranteeing storage balance. ©2005 Association for Computing Machinery