• DocumentCode
    2206811
  • 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
  • fYear
    1994
  • fDate
    28-30 Sep 1994
  • Firstpage
    97
  • Lastpage
    106
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Scientific and Statistical Database Management, 1994. Proceedings., Seventh International Working Conference on
  • Conference_Location
    Charlottesville, VA
  • Print_ISBN
    0-8186-6610-2
  • Type

    conf

  • DOI
    10.1109/SSDM.1994.336957
  • Filename
    336957