{"created":"2025-01-18T22:51:44.643331+00:00","updated":"2025-01-22T22:19:17.230412+00:00","metadata":{"_oai":{"id":"oai:ipsj.ixsq.nii.ac.jp:00019219","sets":["1164:1165:1184:1186"]},"path":["1186"],"owner":"1","recid":"19219","title":["Towards Range Queries with Partial Dimensions in OLAP Applications"],"pubdate":{"attribute_name":"公開日","attribute_value":"2004-07-13"},"_buckets":{"deposit":"93bd9ee4-483e-4f8e-84ee-f87fbf9bad6f"},"_deposit":{"id":"19219","pid":{"type":"depid","value":"19219","revision_id":0},"owners":[1],"status":"published","created_by":1},"item_title":"Towards Range Queries with Partial Dimensions in OLAP Applications","author_link":["0","0"],"item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"Towards Range Queries with Partial Dimensions in OLAP Applications"},{"subitem_title":"Towards Range Queries with Partial Dimensions in OLAP Applications","subitem_title_language":"en"}]},"item_type_id":"4","publish_date":"2004-07-13","item_4_text_3":{"attribute_name":"著者所属","attribute_value_mlt":[{"subitem_text_value":"Graduate School of Information Science and Electrical Engineering  Department of Intelligent Systems  Kyushu University."},{"subitem_text_value":"Graduate School of Information Science and Electrical Engineering  Department of Intelligent Systems  Kyushu University."},{"subitem_text_value":"Graduate School of Information Science and Electrical Engineering  Department of Intelligent Systems  Kyushu University."},{"subitem_text_value":"GGraduate School of Information Science and Electrical Engineering  Department of Intelligent Systems  Kyushu University."}]},"item_4_text_4":{"attribute_name":"著者所属(英)","attribute_value_mlt":[{"subitem_text_value":"Graduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.","subitem_text_language":"en"},{"subitem_text_value":"Graduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.","subitem_text_language":"en"},{"subitem_text_value":"Graduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.","subitem_text_language":"en"},{"subitem_text_value":"GGraduate School of Information Science and Electrical Engineering, Department of Intelligent Systems, Kyushu University.","subitem_text_language":"en"}]},"item_language":{"attribute_name":"言語","attribute_value_mlt":[{"subitem_language":"eng"}]},"item_publisher":{"attribute_name":"出版者","attribute_value_mlt":[{"subitem_publisher":"情報処理学会","subitem_publisher_language":"ja"}]},"publish_status":"0","weko_shared_id":-1,"item_file_price":{"attribute_name":"Billing file","attribute_type":"file","attribute_value_mlt":[{"url":{"url":"https://ipsj.ixsq.nii.ac.jp/record/19219/files/IPSJ-DBS04134005.pdf"},"date":[{"dateType":"Available","dateValue":"2006-07-13"}],"format":"application/pdf","billing":["billing_file"],"filename":"IPSJ-DBS04134005.pdf","filesize":[{"value":"243.9 kB"}],"mimetype":"application/pdf","priceinfo":[{"tax":["include_tax"],"price":"660","billingrole":"5"},{"tax":["include_tax"],"price":"330","billingrole":"6"},{"tax":["include_tax"],"price":"0","billingrole":"13"},{"tax":["include_tax"],"price":"0","billingrole":"44"}],"accessrole":"open_date","version_id":"66878a73-6ff8-4743-ace9-e78839ff902c","displaytype":"detail","licensetype":"license_note","license_note":"Copyright (c) 2004 by the Information Processing Society of Japan"}]},"item_4_creator_5":{"attribute_name":"著者名","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Yaokai, Feng"},{"creatorName":"Zhibin, Wang"},{"creatorName":"Akifumi, Makinouchi"},{"creatorName":"Ryu, Hiroshi"}],"nameIdentifiers":[{}]}]},"item_4_creator_6":{"attribute_name":"著者名(英)","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Yaokai, Feng","creatorNameLang":"en"},{"creatorName":"Zhibin, Wang","creatorNameLang":"en"},{"creatorName":"Akifumi, Makinouchi","creatorNameLang":"en"},{"creatorName":"Ryu, Hiroshi","creatorNameLang":"en"}],"nameIdentifiers":[{}]}]},"item_4_source_id_9":{"attribute_name":"書誌レコードID","attribute_value_mlt":[{"subitem_source_identifier":"AN10112482","subitem_source_identifier_type":"NCID"}]},"item_4_textarea_12":{"attribute_name":"Notice","attribute_value_mlt":[{"subitem_textarea_value":"SIG Technical Reports are nonrefereed and hence may later appear in any journals, conferences, symposia, etc."}]},"item_resource_type":{"attribute_name":"資源タイプ","attribute_value_mlt":[{"resourceuri":"http://purl.org/coar/resource_type/c_18gh","resourcetype":"technical report"}]},"item_4_description_7":{"attribute_name":"論文抄録","attribute_value_mlt":[{"subitem_description":"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.","subitem_description_type":"Other"}]},"item_4_description_8":{"attribute_name":"論文抄録(英)","attribute_value_mlt":[{"subitem_description":"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.","subitem_description_type":"Other"}]},"item_4_biblio_info_10":{"attribute_name":"書誌情報","attribute_value_mlt":[{"bibliographicPageEnd":"38","bibliographic_titles":[{"bibliographic_title":"情報処理学会研究報告データベースシステム（DBS）"}],"bibliographicPageStart":"31","bibliographicIssueDates":{"bibliographicIssueDate":"2004-07-13","bibliographicIssueDateType":"Issued"},"bibliographicIssueNumber":"71(2004-DBS-134)","bibliographicVolumeNumber":"2004"}]},"relation_version_is_last":true,"weko_creator_id":"1"},"id":19219,"links":{}}