Towards Range Queries with Partial Dimensions in OLAP Applications

• Item type: SIG Technical Reports(1)
• 公開日: 2004-07-13
• タイトル: Towards Range Queries with Partial Dimensions in OLAP Applications
• タイトル / 言語: en
• タイトル: Towards Range Queries with Partial Dimensions in OLAP Applications
• 言語: eng
• 資源タイプ / 資源タイプ識別子: http://purl.org/coar/resource_type/c_18gh
• 資源タイプ: technical report
• 著者所属: Graduate School of Information Science and Electrical Engineering Department of Intelligent Systems Kyushu University.
• 著者所属: Graduate School of Information Science and Electrical Engineering Department of Intelligent Systems Kyushu University.
• 著者所属: Graduate School of Information Science and Electrical Engineering Department of Intelligent Systems Kyushu University.
• 著者所属: GGraduate School of Information Science and Electrical Engineering Department of Intelligent Systems Kyushu University.
• 著者所属(英): en
• 著者所属(英): Graduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.
• 著者所属(英): en
• 著者所属(英): Graduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.
• 著者所属(英): en
• 著者所属(英): Graduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.
• 著者所属(英): en
• 著者所属(英): GGraduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.
• 著者名: Yaokai, Feng; Zhibin, Wang; Akifumi, Makinouchi; Ryu, Hiroshi
• 著者名(英): Yaokai, Feng; Zhibin, Wang; Akifumi, Makinouchi; Ryu, Hiroshi
• 論文抄録 / 内容記述タイプ: Other
• 論文抄録 / 内容記述: Multidimensional indices are very helpful to improve query performance on multidimensional data including relational data in ROLAP systems. The existing multidimensional indices are directed to "queries with all dimensions" (called QAD in this study). That is the dimensions used in each query are all the dimensions in the whole space. However in many applications especially in OLAP-related ones the queries may be only with some (partial) dimensions (not all) of the whole space which is called QPD (Queries with Partial Dimensions) in this study. This study focuses on range queries with partial dimensions (RQPD) which is popular in OLAP applications. If the existing multidimensional indices are used in RQPD the dimensions unused in the query are thought as spanning the whole data ranges which often lead to not-good search performance. In these cases certainly we also can construct many indices with all the necessary combination of dimensions. However this is very space/time-consuming since many indices have to be constructed and some dimensions may be used many times in different indices which is not always feasible. In this study we propose a novel solution to RQPD problem. With our solution only one index is necessary to such applications. The performance of our solution is discussed in detail and is examined by experiments.
• 論文抄録(英) / 内容記述タイプ: Other
• 論文抄録(英) / 内容記述: Multidimensional indices are very helpful to improve query performance on multidimensional data including relational data in ROLAP systems. The existing multidimensional indices are directed to "queries with all dimensions" (called QAD in this study). That is, the dimensions used in each query are all the dimensions in the whole space. However, in many applications, especially in OLAP-related ones, the queries may be only with some (partial) dimensions (not all) of the whole space, which is called QPD (Queries with Partial Dimensions) in this study. This study focuses on range queries with partial dimensions (RQPD), which is popular in OLAP applications. If the existing multidimensional indices are used in RQPD, the dimensions unused in the query are thought as spanning the whole data ranges, which often lead to not-good search performance. In these cases, certainly, we also can construct many indices with all the necessary combination of dimensions. However, this is very space/time-consuming since many indices have to be constructed and some dimensions may be used many times in different indices, which is not always feasible. In this study, we propose a novel solution to RQPD problem. With our solution, only one index is necessary to such applications. The performance of our solution is discussed in detail and is examined by experiments.
• 書誌レコードID / 収録物識別子タイプ: NCID
• 書誌レコードID / 収録物識別子: AN10112482
• 書誌情報: 情報処理学会研究報告データベースシステム（DBS）; 巻 2004, 号 71(2004-DBS-134), p. 31-38, 発行日 2004-07-13
• Notice: SIG Technical Reports are nonrefereed and hence may later appear in any journals, conferences, symposia, etc.
• 出版者 / 言語: ja
• 出版者: 情報処理学会