WARLOCK: A Data Allocation Tool for Parallel Warehouses
Thomas Stöhr, Erhard Rahm · Qucosa (Saxon State and University Library Dresden) · 2001
We present the Warlock tool to automatically determine a parallel data warehouses allocation to disk. This GUI-equipped 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.