Sciweavers

CASCON
1996

Modeling on-line rebalancing with priorities and executing on parallel database systems

13 years 5 months ago
Modeling on-line rebalancing with priorities and executing on parallel database systems
Because changes to the database (DB) and workload occur during a DB system's lifetime, the physical DB design must evolve to sustain good performance. These changes are carried out by on-line reorganizations which access the DB and execute concurrently with the DB workload. Dierent performance intrusions are placed on the workload when a reorganization is assigned dierent priorities compared to the workload processes. Our work studies the eects of the reorganization priority-level on performance. There are two performance aspects of interest: the time taken for a reorganization and the intrusion the reorganization places on the workload. The reorganization we consider is a redistribution (rebalancing) of a relation across the nodes of a parallel sharednothing system. A shared-nothing system contains multiple processors with their own local memory and disks, and these processors share only the interconnection network. We have seen that heavily loaded systems or highly imbalanced r...
Daniel C. Zilio
Added 02 Nov 2010
Updated 02 Nov 2010
Type Conference
Year 1996
Where CASCON
Authors Daniel C. Zilio
Comments (0)