Warlock: A Data Allocation Tool for Parallel Warehouses

Authors: 
Stöhr, Thomas
Rahm, Erhard
Year: 
2001
Language: 
English
Abstract: 
We present the Warlock tool to automatically determine a parallel data warehouse’s 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.
Appeared / Erschienen in: 
Proc. 27th Intl. Conference on Very Large Databases (VLDB), Rome, Italy
Pubdate / Erscheinungsdatum: 
2001
Pages / Seitenanzahl: 
2
AttachmentSize
2001-23.pdf128.41 KB