{"created":"2025-01-19T01:34:34.137588+00:00","metadata":{"_oai":{"id":"oai:ipsj.ixsq.nii.ac.jp:00233243","sets":["1164:3925:11477:11523"]},"path":["11523"],"owner":"44499","recid":"233243","title":["集計処理をもとにした関係データベースとグラフデータベースの性能評価"],"pubdate":{"attribute_name":"公開日","attribute_value":"2024-03-11"},"_buckets":{"deposit":"143203b3-6586-43dc-8ae9-92e6baa2dcf3"},"_deposit":{"id":"233243","pid":{"type":"depid","value":"233243","revision_id":0},"owners":[44499],"status":"published","created_by":44499},"item_title":"集計処理をもとにした関係データベースとグラフデータベースの性能評価","author_link":["633164","633161","633165","633160","633162","633163"],"item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"集計処理をもとにした関係データベースとグラフデータベースの性能評価"},{"subitem_title":"Performance Evaluation of Relational and Graph databases in aggregation processing","subitem_title_language":"en"}]},"item_keyword":{"attribute_name":"キーワード","attribute_value_mlt":[{"subitem_subject":"開発・プログラミング・データベース","subitem_subject_scheme":"Other"}]},"item_type_id":"4","publish_date":"2024-03-11","item_4_text_3":{"attribute_name":"著者所属","attribute_value_mlt":[{"subitem_text_value":"三菱電機株式会社情報技術総合研究所"},{"subitem_text_value":"三菱電機株式会社情報技術総合研究所"},{"subitem_text_value":"三菱電機株式会社情報技術総合研究所"}]},"item_4_text_4":{"attribute_name":"著者所属(英)","attribute_value_mlt":[{"subitem_text_value":"Information Technology R&D Center, Mitsubishi Electric Corporation","subitem_text_language":"en"},{"subitem_text_value":"Information Technology R&D Center, Mitsubishi Electric Corporation","subitem_text_language":"en"},{"subitem_text_value":"Information Technology R&D Center, Mitsubishi Electric Corporation","subitem_text_language":"en"}]},"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/233243/files/IPSJ-CSEC24104029.pdf","label":"IPSJ-CSEC24104029.pdf"},"date":[{"dateType":"Available","dateValue":"2026-03-11"}],"format":"application/pdf","billing":["billing_file"],"filename":"IPSJ-CSEC24104029.pdf","filesize":[{"value":"1.9 MB"}],"mimetype":"application/pdf","priceinfo":[{"tax":["include_tax"],"price":"660","billingrole":"5"},{"tax":["include_tax"],"price":"330","billingrole":"6"},{"tax":["include_tax"],"price":"0","billingrole":"30"},{"tax":["include_tax"],"price":"0","billingrole":"44"}],"accessrole":"open_date","version_id":"e1f794f3-6457-42f1-94aa-742d868503ad","displaytype":"detail","licensetype":"license_note","license_note":"Copyright (c) 2024 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":[{}]},{"creatorNames":[{"creatorName":"永井, 幸政"}],"nameIdentifiers":[{}]}]},"item_4_creator_6":{"attribute_name":"著者名(英)","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Daiki, Tamura","creatorNameLang":"en"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"Yoshitsugu, Kawamura","creatorNameLang":"en"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"Yukimasa, Nagai","creatorNameLang":"en"}],"nameIdentifiers":[{}]}]},"item_4_source_id_9":{"attribute_name":"書誌レコードID","attribute_value_mlt":[{"subitem_source_identifier":"AA11235941","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-8655","subitem_source_identifier_type":"ISSN"}]},"item_4_description_7":{"attribute_name":"論文抄録","attribute_value_mlt":[{"subitem_description":"近年，IoT システムから得られるセンサデータやログ情報を分析して付加価値を生み出すシステムが一般的になっている．そうしたデータを保存・分析するためのデータベースとして，従来エンタープライズシステムで多く採用されてきた関係データベースだけでなくドキュメントやキーバリュー，グラフなど様々なデータモデルにもとづく NoSQL データベースが開発されている．これらの NoSQL データベースは関係データベースが抱える問題点に対処するための機能を持って開発されたものが多いが，データモデルや操作に使用する言語が異なるため，関係データベースとの処理性能の比較が難しいという課題がある．本稿では，関係データベース用のベンチマークツールであるTPCHを利用し，その処理時間をもとに関係データベース（PostgreSQL，MySQL）とグラフデータベース（Neo4j）の性能評価を行った．データモデルが異なるデータベース間の性能評価のために，TPC-H が生成する関係データベース向けのデータおよびクエリを Neo4j に対応した形式に変換することで，PostgreSQL，MySQLと Neo4j を同じユースケースで評価できるようにした．性能評価の結果，すべてのクエリの平均処理時間では PostgreSQL が最も短く，次いで MySQL，Neo4j の順に処理時間が長くなることが分かった．","subitem_description_type":"Other"}]},"item_4_biblio_info_10":{"attribute_name":"書誌情報","attribute_value_mlt":[{"bibliographicPageEnd":"8","bibliographic_titles":[{"bibliographic_title":"研究報告コンピュータセキュリティ（CSEC）"}],"bibliographicPageStart":"1","bibliographicIssueDates":{"bibliographicIssueDate":"2024-03-11","bibliographicIssueDateType":"Issued"},"bibliographicIssueNumber":"29","bibliographicVolumeNumber":"2024-CSEC-104"}]},"relation_version_is_last":true,"weko_creator_id":"44499"},"id":233243,"updated":"2025-01-19T10:09:42.786077+00:00","links":{}}