{"id":"https://openalex.org/W1984939239","doi":"https://doi.org/10.1137/0214026","title":"Some Results on the Representative Instance in Relational Databases","display_name":"Some Results on the Representative Instance in Relational Databases","publication_year":1985,"publication_date":"1985-05-01","ids":{"openalex":"https://openalex.org/W1984939239","doi":"https://doi.org/10.1137/0214026","mag":"1984939239"},"language":"en","primary_location":{"id":"doi:10.1137/0214026","is_oa":false,"landing_page_url":"https://doi.org/10.1137/0214026","pdf_url":null,"source":{"id":"https://openalex.org/S153560523","display_name":"SIAM Journal on Computing","issn_l":"0097-5397","issn":["0097-5397","1095-7111"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320508","host_organization_name":"Society for Industrial and Applied Mathematics","host_organization_lineage":["https://openalex.org/P4310320508"],"host_organization_lineage_names":["Society for Industrial and Applied Mathematics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SIAM Journal on Computing","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/A5113923123","display_name":"Minoru Ito","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Minoru Ito","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Motoaki Iwasaki","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Motoaki Iwasaki","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5108359594","display_name":"Tadao Kasami","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Tadao Kasami","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5113923123"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.8261,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.94672805,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":null,"biblio":{"volume":"14","issue":"2","first_page":"334","last_page":"354"},"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.9997000098228455,"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.9997000098228455,"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/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"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"}},{"id":"https://openalex.org/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9977999925613403,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.6676366925239563},{"id":"https://openalex.org/keywords/functional-dependency","display_name":"Functional dependency","score":0.6049193739891052},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.5647572875022888},{"id":"https://openalex.org/keywords/projection","display_name":"Projection (relational algebra)","score":0.5455365777015686},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.5442654490470886},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5160579085350037},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.45941007137298584},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4353835880756378},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.3999590277671814},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.34092989563941956},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.268115758895874}],"concepts":[{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.6676366925239563},{"id":"https://openalex.org/C26320393","wikidata":"https://www.wikidata.org/wiki/Q597053","display_name":"Functional dependency","level":3,"score":0.6049193739891052},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.5647572875022888},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.5455365777015686},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.5442654490470886},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5160579085350037},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.45941007137298584},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4353835880756378},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.3999590277671814},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34092989563941956},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.268115758895874},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1137/0214026","is_oa":false,"landing_page_url":"https://doi.org/10.1137/0214026","pdf_url":null,"source":{"id":"https://openalex.org/S153560523","display_name":"SIAM Journal on Computing","issn_l":"0097-5397","issn":["0097-5397","1095-7111"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320508","host_organization_name":"Society for Industrial and Applied Mathematics","host_organization_lineage":["https://openalex.org/P4310320508"],"host_organization_lineage_names":["Society for Industrial and Applied Mathematics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SIAM Journal on Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1973125170","https://openalex.org/W1984149034","https://openalex.org/W1985581502","https://openalex.org/W2032386524","https://openalex.org/W2135105491","https://openalex.org/W2146899290","https://openalex.org/W2185907055"],"related_works":["https://openalex.org/W2039445786","https://openalex.org/W2185054849","https://openalex.org/W2884840983","https://openalex.org/W2361244046","https://openalex.org/W2126493028","https://openalex.org/W2582695666","https://openalex.org/W1629972737","https://openalex.org/W1504218574","https://openalex.org/W3111672439","https://openalex.org/W2274317205"],"abstract_inverted_index":{"Recently,":[0],"the":[1,12,66,107,112,121,129,150,160,163,216,220],"representative":[2,67,108,221],"instance":[3,68,109,222],"has":[4],"been":[5],"proposed":[6],"as":[7],"a":[8,34,42,50,191,207,245,249],"generalized":[9],"concept":[10],"of":[11,44,52,69,80,128,152,162,165,194,219,228,234],"pure":[13],"universal":[14],"relation.":[15],"Let":[16],"${\\bf":[17,58,81,143,174,186,229],"R}":[18],"=":[19,73],"\\{":[20,74],"\\langle":[21,28],"R_1":[22],",F_1":[23],"\\rangle":[24,31],",":[25,27,76],"\\cdots":[26,77,88,197],"R_n":[29,199],",F_n":[30],"\\}$":[32,79],"be":[33,63,137],"database":[35,71,227],"scheme,":[36],"where":[37,147],"each":[38,96],"$R_i":[39,56],"$":[40,48,99],"is":[41,49,60,145,149,159,176,178,188,215],"set":[43,51],"attributes":[45],"and":[46,157,238,240],"$F_i":[47,105],"functional":[53,103,113,153],"dependencies":[54,104,114,154],"over":[55],"$.":[57],"R}$":[59,82,144,175,187],"said":[61],"to":[62],"consistent":[64,177],"if":[65,94],"every":[70,226],"$I":[72],"r_1":[75],",r_n":[78],"satisfies":[83,100,110],"$F":[84],"(=":[85],"F_1":[86],"\\cup":[87,89,196,198],"F_n":[90],")$,":[91],"that":[92,185,211],"is,":[93],"whenever":[95],"relation":[97],"$r_i":[98],"its":[101,213],"own":[102],"$,":[106,200],"all":[111],"F.":[115,166],"In":[116],"this":[117],"paper,":[118],"we":[119,201],"present":[120],"following":[122],"two":[123],"results,":[124],"which":[125],"are":[126],"generalizations":[127],"previous":[130],"results":[131],"by":[132],"[Sag2].":[133],"(1)":[134],"It":[135],"can":[136,202],"determined":[138],"in":[139,155,181,204],"$O(n|F|\\|F\\|)$":[140,205],"time":[141,169,206],"whether":[142,173],"consistent,":[146],"$|F|$":[148],"number":[151],"F":[156],"$||F||$":[158],"size":[161],"description":[164],"(A":[167],"polynomial":[168],"algorithm":[170],"for":[171,225],"determining":[172],"presented,":[179],"independently,":[180],"[GY].)":[182],"(2)":[183],"Suppose":[184],"consistent.":[189],"Given":[190],"subset":[192],"V":[193,224],"$R_1":[195],"construct":[203],"relational":[208],"expression":[209],"such":[210],"(a)":[212],"value":[214],"total":[217],"projection":[218],"onto":[223],"R}$,":[230],"(b)":[231],"it":[232,242],"consists":[233],"projection,":[235],"extension":[236],"join,":[237],"union,":[239],"(c)":[241],"contains":[243],"neither":[244],"redundant":[246,250],"union":[247],"nor":[248],"join.":[251]},"counts_by_year":[],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}