{"id":"https://openalex.org/W2120996593","doi":"https://doi.org/10.4018/jdm.2000040102","title":"Binary Equivalents of Ternary Relationships in Entity-Relationship Modeling","display_name":"Binary Equivalents of Ternary Relationships in Entity-Relationship Modeling","publication_year":2000,"publication_date":"2000-04-01","ids":{"openalex":"https://openalex.org/W2120996593","doi":"https://doi.org/10.4018/jdm.2000040102","mag":"2120996593"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2000040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2000040102","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068890909","display_name":"Trevor H. Jones","orcid":null},"institutions":[{"id":"https://openalex.org/I165102784","display_name":"Duquesne University","ror":"https://ror.org/02336z538","country_code":"US","type":"education","lineage":["https://openalex.org/I165102784"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Trevor H. Jones","raw_affiliation_strings":["Duquesne University, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Duquesne University, USA","institution_ids":["https://openalex.org/I165102784"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067437365","display_name":"Il\u2010Yeol Song","orcid":"https://orcid.org/0000-0001-7706-959X"},"institutions":[{"id":"https://openalex.org/I72816309","display_name":"Drexel University","ror":"https://ror.org/04bdffz58","country_code":"US","type":"education","lineage":["https://openalex.org/I72816309"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Il-Yeol Song","raw_affiliation_strings":["Drexel University, USA","#N# Drexel University, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Drexel University, USA","institution_ids":["https://openalex.org/I72816309"]},{"raw_affiliation_string":"#N# Drexel University, USA","institution_ids":["https://openalex.org/I72816309"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.0086,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.92208339,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"11","issue":"2","first_page":"12","last_page":"19"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/ternary-operation","display_name":"Ternary operation","score":0.7917892932891846},{"id":"https://openalex.org/keywords/binary-number","display_name":"Binary number","score":0.6146899461746216},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5963513851165771},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5957192778587341},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5096333026885986},{"id":"https://openalex.org/keywords/premise","display_name":"Premise","score":0.5009853839874268},{"id":"https://openalex.org/keywords/binary-relation","display_name":"Binary relation","score":0.421196311712265},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3497058153152466},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.34230032563209534},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2836858630180359},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.27630990743637085},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.22040751576423645},{"id":"https://openalex.org/keywords/arithmetic","display_name":"Arithmetic","score":0.14167696237564087},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.08431518077850342}],"concepts":[{"id":"https://openalex.org/C64452783","wikidata":"https://www.wikidata.org/wiki/Q1524945","display_name":"Ternary operation","level":2,"score":0.7917892932891846},{"id":"https://openalex.org/C48372109","wikidata":"https://www.wikidata.org/wiki/Q3913","display_name":"Binary number","level":2,"score":0.6146899461746216},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5963513851165771},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5957192778587341},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5096333026885986},{"id":"https://openalex.org/C2778023277","wikidata":"https://www.wikidata.org/wiki/Q321703","display_name":"Premise","level":2,"score":0.5009853839874268},{"id":"https://openalex.org/C65180967","wikidata":"https://www.wikidata.org/wiki/Q130901","display_name":"Binary relation","level":2,"score":0.421196311712265},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3497058153152466},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34230032563209534},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2836858630180359},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.27630990743637085},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.22040751576423645},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.14167696237564087},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.08431518077850342},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.2000040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2000040102","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:11:y:2000:i:2:p:12-19","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.2000040102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W43035074","https://openalex.org/W196112555","https://openalex.org/W1967291753","https://openalex.org/W2035549722","https://openalex.org/W2138635944","https://openalex.org/W2144192824","https://openalex.org/W2162779498","https://openalex.org/W2751199251"],"related_works":["https://openalex.org/W2161073421","https://openalex.org/W1965291578","https://openalex.org/W4253128163","https://openalex.org/W2059661740","https://openalex.org/W3039944263","https://openalex.org/W4287750387","https://openalex.org/W2789243146","https://openalex.org/W2044964419","https://openalex.org/W2023587177","https://openalex.org/W2003123666"],"abstract_inverted_index":{"Little":[0],"work":[1],"has":[2,55],"been":[3,56],"completed":[4],"which":[5,69,153,164,179,188],"addresses":[6],"the":[7,43,74,90,95,115,123,126,142,185],"logical":[8,91,117],"composition":[9],"and":[10,21,33,98,119,140,149,162],"use":[11,182],"of":[12,49,76,85,114,125,133,137,172],"ternary":[13,29,36,59,86,96,154,177,192],"relationships":[14,60,92,155,178,193],"in":[15,73,176,187,194],"entity-relationship":[16],"modeling.":[17,196],"Many":[18],"modeling":[19],"notations":[20],"most":[22],"CASE":[23],"tools":[24],"do":[25,39,70,165],"not":[26,40,71],"allow":[27,112],"for":[28,35],"relationships.":[30,78,87],"Alternative":[31],"methods":[32],"substitutes":[34],"relationship":[37],"structures":[38],"necessarily":[41],"reflect":[42],"original":[44,127],"logic,":[45],"semantics":[46,124],"or":[47],"constraints":[48,68,147],"a":[50],"given":[51],"situation.":[52],"Furthermore,":[53],"it":[54],"shown":[57],"that":[58],"can":[61,181],"be":[62],"constrained":[63],"by":[64],"additional":[65],"implicit":[66,93,116],"binary":[67,77,106,110,160],"occur":[72],"logic":[75],"This":[79],"paper":[80],"develops":[81],"an":[82,169],"analytical":[83],"perspective":[84],"We":[88,151,167],"investigate":[89],"to":[94,144,183],"structure":[97],"then":[99],"identify":[100,152],"potential":[101],"simplification":[102],"through":[103],"decomposition":[104],"into":[105],"equivalents.":[107],"These":[108],"alternative":[109],"equivalents":[111,161],"retention":[113],"structure,":[118],"consequently":[120],"also":[121],"retain":[122],"structure.":[128],"The":[129],"analysis":[130,171],"investigates":[131],"equivalency":[132],"lossless":[134],"decompositions,":[135],"preservation":[136],"functional":[138],"dependencies":[139],"finally":[141],"ability":[143],"preserve":[145],"update":[146],"(insertions":[148],"deletions).":[150],"have":[156],"true,":[157],"fully":[158],"equivalent,":[159],"those":[163],"not.":[166],"provide":[168],"exhaustive":[170],"cardinality":[173],"combinations":[174],"found":[175],"practitioners":[180],"guide":[184],"way":[186],"they":[189],"deal":[190],"with":[191],"conceptual":[195]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2016-06-24T00:00:00"}