German English

Warlock: A Data Allocation Tool for Parallel Warehouses.

PDF
further information
Google Scholar
Stöhr, T.; Rahm, E.
Warlock: A Data Allocation Tool for Parallel Warehouses.
Proc. 27th Intl. Conference on Very Large Databases (VLDB), Rome, Italy, Sep. 2001 (software demonstration)
2001

Further information: http://lips.informatik.uni-leipzig.de/pub/2001-23/

Description

We present the WARLOCK tool to automatically determine a
parallel data warehouse’s allocation to disk. This GUIequipped
tool is implemented in Java and utilizes an internal
cost model and heuristics to determine a disk allocation
minimizing both I/O work and query response times. WARLOCK
recommends a ranked list of fragmentation candidates,
a detailed query performance analysis and a tailored
physical allocation scheme for relational star schemas and
bitmap indexes. It supports multi-dimensional fragmentations
and can deal with data skew for parallel data warehouses
based on a Shared Everything or Shared Disk
architecture.