{"updated":"2025-01-20T10:59:35.392420+00:00","metadata":{"_oai":{"id":"oai:ipsj.ixsq.nii.ac.jp:00164086","sets":["6504:8291:8753"]},"path":["8753"],"owner":"6748","recid":"164086","title":["PostgreSQLベースのカラムナ機構へのトランザクション実現検討"],"pubdate":{"attribute_name":"公開日","attribute_value":"2015-03-17"},"_buckets":{"deposit":"333ec290-cdd9-44b1-9e91-cd130e8ef1d0"},"_deposit":{"id":"164086","pid":{"type":"depid","value":"164086","revision_id":0},"owners":[6748],"status":"published","created_by":6748},"item_title":"PostgreSQLベースのカラムナ機構へのトランザクション実現検討","author_link":["322775","322772","322773","322774","322776","322771"],"item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"PostgreSQLベースのカラムナ機構へのトランザクション実現検討"}]},"item_keyword":{"attribute_name":"キーワード","attribute_value_mlt":[{"subitem_subject":"データとウェブ","subitem_subject_scheme":"Other"}]},"item_type_id":"22","publish_date":"2015-03-17","item_language":{"attribute_name":"言語","attribute_value_mlt":[{"subitem_language":"jpn"}]},"item_22_text_3":{"attribute_name":"著者所属","attribute_value_mlt":[{"subitem_text_value":"富士通研"},{"subitem_text_value":"富士通研"},{"subitem_text_value":"富士通研"},{"subitem_text_value":"富士通研"},{"subitem_text_value":"富士通研"},{"subitem_text_value":"富士通研"}]},"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/164086/files/IPSJ-Z77-2C-02.pdf","label":"IPSJ-Z77-2C-02.pdf"},"date":[{"dateType":"Available","dateValue":"2016-06-10"}],"format":"application/pdf","billing":["billing_file"],"filename":"IPSJ-Z77-2C-02.pdf","filesize":[{"value":"373.6 kB"}],"mimetype":"application/pdf","priceinfo":[{"tax":["include_tax"],"price":"0","billingrole":"6"},{"tax":["include_tax"],"price":"0","billingrole":"8"},{"tax":["include_tax"],"price":"0","billingrole":"44"}],"accessrole":"open_date","version_id":"f2b98d8f-4480-4ff9-a8cf-a6bc5d4a1341","displaytype":"detail","licensetype":"license_note","license_note":"Copyright (c) 2015 by the Information Processing Society of Japan"}]},"item_22_creator_5":{"attribute_name":"著者名","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"橋田, 拓志"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"田原, 司睦"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"中村, 実"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"宇治橋, 善史"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"河場, 基行"}],"nameIdentifiers":[{}]},{"creatorNames":[{"creatorName":"原田, リリアン"}],"nameIdentifiers":[{}]}]},"item_resource_type":{"attribute_name":"資源タイプ","attribute_value_mlt":[{"resourceuri":"http://purl.org/coar/resource_type/c_5794","resourcetype":"conference paper"}]},"item_22_source_id_9":{"attribute_name":"書誌レコードID","attribute_value_mlt":[{"subitem_source_identifier":"AN00349328","subitem_source_identifier_type":"NCID"}]},"item_22_description_7":{"attribute_name":"論文抄録","attribute_value_mlt":[{"subitem_description":"近年、トランザクション処理と高速分析処理を兼ね備えたOLXPが提案されている。こうした背景を踏まえ、我々はOSSのRDBMSであるPosgreSQLベースのOLXPシステムの設計を行っている。このシステムは、トランザクション処理については従来のPostgreSQLのテーブルデータ、分析処理についてはカラムナ構造の複製テーブルを参照して高速化を図っている。OLXP実現に際して課題の一つにトランザクション実現がある。機能面では複製テーブルアクセス時のMVCCサポート、また性能面ではトランザクション処理に伴うデータ更新速度の低下の抑制が課題となっている。本発表ではPostgreSQLベースのOLXPシステムに向けたトランザクション実現方式に焦点を絞り、検討結果を報告する。","subitem_description_type":"Other"}]},"item_22_biblio_info_10":{"attribute_name":"書誌情報","attribute_value_mlt":[{"bibliographicPageEnd":"494","bibliographic_titles":[{"bibliographic_title":"第77回全国大会講演論文集"}],"bibliographicPageStart":"493","bibliographicIssueDates":{"bibliographicIssueDate":"2015-03-17","bibliographicIssueDateType":"Issued"},"bibliographicIssueNumber":"1","bibliographicVolumeNumber":"2015"}]},"relation_version_is_last":true,"weko_creator_id":"6748"},"created":"2025-01-19T00:35:56.379868+00:00","id":164086,"links":{}}