{"links":{},"id":14005,"metadata":{"_oai":{"id":"oai:ipsj.ixsq.nii.ac.jp:00014005","sets":["581:755:766"]},"path":["766"],"owner":"1","recid":"14005","title":["関数従属性と包含従属性が存在する場合の正規形データベーススキーム設計一手法"],"pubdate":{"attribute_name":"公開日","attribute_value":"1995-02-15"},"_buckets":{"deposit":"3736cc3c-fde2-49d4-8d06-9ae16cfd8e73"},"_deposit":{"id":"14005","pid":{"type":"depid","value":"14005","revision_id":0},"owners":[1],"status":"published","created_by":1},"item_title":"関数従属性と包含従属性が存在する場合の正規形データベーススキーム設計一手法","author_link":["0","0"],"item_titles":{"attribute_name":"タイトル","attribute_value_mlt":[{"subitem_title":"関数従属性と包含従属性が存在する場合の正規形データベーススキーム設計一手法"},{"subitem_title":"A Method for Synthesizing Normal Form Database Schemes under Functional and Inclusion Dependencies","subitem_title_language":"en"}]},"item_keyword":{"attribute_name":"キーワード","attribute_value_mlt":[{"subitem_subject":"論文","subitem_subject_scheme":"Other"}]},"item_type_id":"2","publish_date":"1995-02-15","item_2_text_3":{"attribute_name":"著者所属","attribute_value_mlt":[{"subitem_text_value":"NTT情報通信網研究所"},{"subitem_text_value":"近畿大学生物理工学部"}]},"item_2_text_4":{"attribute_name":"著者所属(英)","attribute_value_mlt":[{"subitem_text_value":"NTT Network Information Systems Laboratories","subitem_text_language":"en"},{"subitem_text_value":"Faculty of Biology - Oriented Science and Technology, Kinki University","subitem_text_language":"en"}]},"item_language":{"attribute_name":"言語","attribute_value_mlt":[{"subitem_language":"jpn"}]},"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/14005/files/IPSJ-JNL3602018.pdf"},"date":[{"dateType":"Available","dateValue":"1997-02-15"}],"format":"application/pdf","billing":["billing_file"],"filename":"IPSJ-JNL3602018.pdf","filesize":[{"value":"2.1 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":"8"},{"tax":["include_tax"],"price":"0","billingrole":"44"}],"accessrole":"open_date","version_id":"640d024e-9341-4132-ade2-bc74fe185f56","displaytype":"detail","licensetype":"license_note","license_note":"Copyright (c) 1995 by the Information Processing Society of Japan"}]},"item_2_creator_5":{"attribute_name":"著者名","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"山田, 光博"},{"creatorName":"中川, 優"}],"nameIdentifiers":[{}]}]},"item_2_creator_6":{"attribute_name":"著者名(英)","attribute_type":"creator","attribute_value_mlt":[{"creatorNames":[{"creatorName":"Mitsuhiro, Yamada","creatorNameLang":"en"},{"creatorName":"Masaru, Nakagawa","creatorNameLang":"en"}],"nameIdentifiers":[{}]}]},"item_2_source_id_9":{"attribute_name":"書誌レコードID","attribute_value_mlt":[{"subitem_source_identifier":"AN00116647","subitem_source_identifier_type":"NCID"}]},"item_resource_type":{"attribute_name":"資源タイプ","attribute_value_mlt":[{"resourceuri":"http://purl.org/coar/resource_type/c_6501","resourcetype":"journal article"}]},"item_2_source_id_11":{"attribute_name":"ISSN","attribute_value_mlt":[{"subitem_source_identifier":"1882-7764","subitem_source_identifier_type":"ISSN"}]},"item_2_description_7":{"attribute_name":"論文抄録","attribute_value_mlt":[{"subitem_description":"従来、属性の全体集合の普遍関係上の関数従属性（FD）集含から、第三正規形（3NF）データベーススキーム（DBS）作成を行う手法が多数提案されてきた。ところがBemsteinの合成算法を代表とする従来手法には、互いに関数従属するキーが存在する場合、それをマージする前後で冗長な（redundant）FDおよび冗長な（extraneous）キー属性の排除を繰り返すものが多い。一方、普遍関係上にFDを与えるのみでなく、より思味表現力が高いモデルを補助的に用いる設計手法が議論されている。この場合、設計結果は普遍関係上で表現不可能な場合があるため、関係スキーム間の包合従属性（IND）をも考える設計法が議論されているが、ここで、各関係スキームを従来手法で第三正規化を行うと、INDとの相互作用によるFDの導出が対象とされていないため主キーに推移従属する属性を排除不可能な場合がある。この問題に対し、LingらはFDの導出律として、FD固有の導出律に加え、INDとの相互作用による導出に対するPull back規則を加えて、その条件下における拡張型3NF関係スキームおよびその作成方法を提案した。本稿では、同条件下で、3NFDBS作成を行うためのより形式的な手法を提案する。提案手法は、各関係の正規化を行う過程で、冗長なFDの排除を同値のキーのマージの前後で繰り返さないという特徴を持つ。","subitem_description_type":"Other"}]},"item_2_biblio_info_10":{"attribute_name":"書誌情報","attribute_value_mlt":[{"bibliographicPageEnd":"414","bibliographic_titles":[{"bibliographic_title":"情報処理学会論文誌"}],"bibliographicPageStart":"396","bibliographicIssueDates":{"bibliographicIssueDate":"1995-02-15","bibliographicIssueDateType":"Issued"},"bibliographicIssueNumber":"2","bibliographicVolumeNumber":"36"}]},"relation_version_is_last":true,"item_2_alternative_title_2":{"attribute_name":"その他タイトル","attribute_value_mlt":[{"subitem_alternative_title":"データベース"}]},"weko_creator_id":"1"},"created":"2025-01-18T22:47:56.344871+00:00","updated":"2025-01-23T00:59:48.763019+00:00"}