Compressed data cube for approximate OLAP query processing

被引:0
|
作者
Yu Feng
Shan Wang
机构
[1] Renmin University of China,School of Information
关键词
OLAP; approximate query processing; clustering data cube;
D O I
暂无
中图分类号
学科分类号
摘要
Approximate query processing has emerged as an approach to dealing with the huge data volume and complex queries in the environment of data warehouse. In this paper, we present a novel method that provides approximate answers to OLAP queries. Our method is based on building a compressed (approximate) data cube by a clustering technique and using this compressed data cube to provide answers to queries directly, so it improves the performance of the queries. We also provide the algorithm of the OLAP queries and the confidence intervals of query results. An extensive experimental study with the OLAP council benchmark shows the effectiveness and scalability of our cluster-based approach compared to sampling.
引用
收藏
页码:625 / 635
页数:10
相关论文
共 50 条
  • [1] Compressed data cube for approximate OLAP query processing
    Feng, Y
    Wang, S
    [J]. JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY, 2002, 17 (05) : 625 - 635
  • [2] Approximate query processing in cube streams
    Hsieh, Ming-Jyh
    Chen, Ming-Syan
    Yu, Philip S.
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2007, 19 (11) : 1557 - 1570
  • [3] Approximate Query Processing Using Wavelets in OLAP with Arbitrarily Sized Data and Bounded Errors
    Burdakov, A.
    Grigorev, U.
    Ukharov, A.
    Ploutenko, A.
    [J]. 2016 24TH EUROMICRO INTERNATIONAL CONFERENCE ON PARALLEL, DISTRIBUTED, AND NETWORK-BASED PROCESSING (PDP), 2016, : 66 - 73
  • [4] OLAP query processing for XML data in RDBMS
    Kit, Chantola
    Amagasa, Toshiyuki
    Kitagawa, Hiroyuki
    [J]. 2007 IEEE INTERNATIONAL WORKSHOP ON DATABASES FOR NEXT GENERATION RESEARCHERS, 2007, : 7 - +
  • [5] Efficient OLAP query processing in distributed data warehouses
    Akinde, M
    Böhlen, M
    Johnson, T
    Lakshmanan, LVS
    Srivastava, D
    [J]. 18TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2002, : 262 - 262
  • [6] Efficient OLAP query processing in distributed data warehouses
    Akinde, MO
    Böhlen, MH
    Johnson, T
    Lakshmanan, LVS
    Srivastava, D
    [J]. ADVANCES IN DATABASE TECHNOLOGY - EDBT 2002, 2002, 2287 : 336 - 353
  • [7] Efficient OLAP query processing in distributed data warehouses
    Akinde, MO
    Böhlen, MH
    Johnson, T
    Lakshmanan, LVS
    Srivastava, D
    [J]. INFORMATION SYSTEMS, 2003, 28 (1-2) : 111 - 135
  • [8] Parallel OLAP query processing in database clusters with data replication
    Alexandre A. B. Lima
    Camille Furtado
    Patrick Valduriez
    Marta Mattoso
    [J]. Distributed and Parallel Databases, 2009, 25 : 97 - 123
  • [9] Parallel OLAP query processing in database clusters with data replication
    Lima, Alexandre A. B.
    Furtado, Camille
    Valduriez, Patrick
    Mattoso, Marta
    [J]. DISTRIBUTED AND PARALLEL DATABASES, 2009, 25 (1-2) : 97 - 123
  • [10] Overcoming limitations of approximate query answering in OLAP
    Cuzzocrea, A
    [J]. 9TH INTERNATIONAL DATABASE ENGINEERING & APPLICATION SYMPOSIUM, PROCEEDINGS, 2005, : 200 - 209