{"id":211244,"updated":"2025-01-19T17:52:01.766235+00:00","links":{},"created":"2025-01-19T01:12:25.760494+00:00","metadata":{"_oai":{"id":"oai:ipsj.ixsq.nii.ac.jp:00211244","sets":["1164:1867:10528:10599"]},"path":["10599"],"owner":"44499","recid":"211244","title":["DBMSのメモリオブジェクトに基づいたCPUキャッシュ分割手法"],"pubdate":{"attribute_name":"公開日","attribute_value":"2021-05-20"},"_buckets":{"deposit":"a4882035-e6ac-4331-8626-33cb97994f3b"},"_deposit":{"id":"211244","pid":{"type":"depid","value":"211244","revision_id":0},"owners":[44499],"status":"published","created_by":44499},"item_title":"DBMSのメモリオブジェクトに基づいたCPUキャッシュ分割手法","author_link":["536338","536339"],"item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"DBMSのメモリオブジェクトに基づいたCPUキャッシュ分割手法"}]},"item_keyword":{"attribute_name":"キーワード","attribute_value_mlt":[{"subitem_subject":"性能改善","subitem_subject_scheme":"Other"}]},"item_type_id":"4","publish_date":"2021-05-20","item_4_text_3":{"attribute_name":"著者所属","attribute_value_mlt":[{"subitem_text_value":"東京農工大学工学府情報工学専攻"},{"subitem_text_value":"東京農工大学工学府情報工学専攻"}]},"item_language":{"attribute_name":"言語","attribute_value_mlt":[{"subitem_language":"jpn"}]},"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/211244/files/IPSJ-OS21152009.pdf","label":"IPSJ-OS21152009.pdf"},"date":[{"dateType":"Available","dateValue":"2023-05-20"}],"format":"application/pdf","billing":["billing_file"],"filename":"IPSJ-OS21152009.pdf","filesize":[{"value":"834.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":"11"},{"tax":["include_tax"],"price":"0","billingrole":"44"}],"accessrole":"open_date","version_id":"94dbaa5d-ab2c-4dce-9634-d4b2de52e58d","displaytype":"detail","licensetype":"license_note","license_note":"Copyright (c) 2021 by the Information Processing Society of Japan"}]},"item_4_creator_5":{"attribute_name":"著者名","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"清水, 彰文"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"山田, 浩史"}],"nameIdentifiers":[{}]}]},"item_4_source_id_9":{"attribute_name":"書誌レコードID","attribute_value_mlt":[{"subitem_source_identifier":"AN10444176","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_source_id_11":{"attribute_name":"ISSN","attribute_value_mlt":[{"subitem_source_identifier":"2188-8795","subitem_source_identifier_type":"ISSN"}]},"item_4_description_7":{"attribute_name":"論文抄録","attribute_value_mlt":[{"subitem_description":"データベース管理システム (DBMS) は Web システムにおいて必要不可欠なコンポーネントとなっている．近年 DBMS では多くのデータアイテムをメインメモリ上で管理している．これらの DBMS ではでは実行順序によってクエリの性能が大きく変わることがある．クエリの実行順序によって CPU キャッシュからデータアイテムが排出されてしまうとその後のクエリ実行に大きな影響を与える．本研究では DBMS のクエリ内でアクセスされるデータを CPU キャッシュに留める手法を提案する．事前にクエリを実行してから，CPU キャッシュのパーティショニングを行いそのデータを CPU キャッシュ内に留め保護する．提案手法を SQLite3.29.0 上に実装し，JOIN を含む単純なクエリでは実行時間をおよそ 25% 程度，TPC-H を用いた実践的なクエリでは実行時間をおよそ 25% 程度高速化できることを確認した．","subitem_description_type":"Other"}]},"item_4_biblio_info_10":{"attribute_name":"書誌情報","attribute_value_mlt":[{"bibliographicPageEnd":"8","bibliographic_titles":[{"bibliographic_title":"研究報告システムソフトウェアとオペレーティング・システム（OS）"}],"bibliographicPageStart":"1","bibliographicIssueDates":{"bibliographicIssueDate":"2021-05-20","bibliographicIssueDateType":"Issued"},"bibliographicIssueNumber":"9","bibliographicVolumeNumber":"2021-OS-152"}]},"relation_version_is_last":true,"weko_creator_id":"44499"}}