Title :
A physical storage model for efficient statistical query processing
Author :
Ng, Wee K. ; Ravishankar, Chinya V.
Author_Institution :
Dept. of Electr. Eng. & Comput. Sci., Michigan Univ., Ann Arbor, MI, USA
Abstract :
A common approach to improving the performance of statistical query processing is to use precomputed results. Another lower-level approach would be to redesign the storage structure for statistical databases. This avenue is relatively unexplored. The objective of this paper is to present a physical storage structure for statistical databases, whose design is motivated by the characteristics of statistical queries. We show that our proposal enhances multi-attribute clustering efficiency, and improves the performance of statistical and aggregational queries. This customized structure reduces the amount of I/O incurred statistical query processing, thus decreasing the response time
Keywords :
database theory; performance evaluation; query processing; storage management; I/O incurred statistical query processing; aggregational queries; input output incurred query processing; lower-level approach; multi-attribute clustering efficiency; physical storage model; physical storage structure; query processing performance; response time; statistical databases; statistical queries; statistical query processing; storage structure redesign; Data models; Database languages; Delay; Geoscience; Proposals; Query processing; Statistics;
Conference_Titel :
Scientific and Statistical Database Management, 1994. Proceedings., Seventh International Working Conference on
Conference_Location :
Charlottesville, VA
Print_ISBN :
0-8186-6610-2
DOI :
10.1109/SSDM.1994.336957