{"id":"https://openalex.org/W2172205144","doi":"https://doi.org/10.1109/icde.1987.7272364","title":"Design and evaluation of algorithms to compute the transitive closure of a database relation","display_name":"Design and evaluation of algorithms to compute the transitive closure of a database relation","publication_year":1987,"publication_date":"1987-02-01","ids":{"openalex":"https://openalex.org/W2172205144","doi":"https://doi.org/10.1109/icde.1987.7272364","mag":"2172205144"},"language":"en","primary_location":{"id":"doi:10.1109/icde.1987.7272364","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1987.7272364","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1987 IEEE Third International Conference on Data Engineering","raw_type":"proceedings-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/A5103551313","display_name":"Hongjun L\u00fc","orcid":null},"institutions":[{"id":"https://openalex.org/I82514191","display_name":"Honeywell (United States)","ror":"https://ror.org/02t71h845","country_code":"US","type":"company","lineage":["https://openalex.org/I82514191"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Hongjun Lu","raw_affiliation_strings":["Honeywell Computer Sciences Center, Golden Valley, Minnesota, USA"],"affiliations":[{"raw_affiliation_string":"Honeywell Computer Sciences Center, Golden Valley, Minnesota, USA","institution_ids":["https://openalex.org/I82514191"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035186096","display_name":"Krishna Mikkilineni","orcid":null},"institutions":[{"id":"https://openalex.org/I82514191","display_name":"Honeywell (United States)","ror":"https://ror.org/02t71h845","country_code":"US","type":"company","lineage":["https://openalex.org/I82514191"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Krishna Mikkilineni","raw_affiliation_strings":["Honeywell Computer Sciences Center, Golden Valley, Minnesota, USA"],"affiliations":[{"raw_affiliation_string":"Honeywell Computer Sciences Center, Golden Valley, Minnesota, USA","institution_ids":["https://openalex.org/I82514191"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5105414121","display_name":"James P. Richardson","orcid":"https://orcid.org/0009-0005-9591-5338"},"institutions":[{"id":"https://openalex.org/I82514191","display_name":"Honeywell (United States)","ror":"https://ror.org/02t71h845","country_code":"US","type":"company","lineage":["https://openalex.org/I82514191"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James P. Richardson","raw_affiliation_strings":["Honeywell Computer Sciences Center, Golden Valley, Minnesota, USA"],"affiliations":[{"raw_affiliation_string":"Honeywell Computer Sciences Center, Golden Valley, Minnesota, USA","institution_ids":["https://openalex.org/I82514191"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5103551313"],"corresponding_institution_ids":["https://openalex.org/I82514191"],"apc_list":null,"apc_paid":null,"fwci":10.0761,"has_fulltext":false,"cited_by_count":51,"citation_normalized_percentile":{"value":0.98336887,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"112","last_page":"119"},"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.9998999834060669,"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.9998999834060669,"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.9984999895095825,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9926000237464905,"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/transitive-closure","display_name":"Transitive closure","score":0.9095592498779297},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.6861560940742493},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.676169216632843},{"id":"https://openalex.org/keywords/binary-relation","display_name":"Binary relation","score":0.6701372861862183},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.6289519667625427},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.627997100353241},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6197805404663086},{"id":"https://openalex.org/keywords/transitive-relation","display_name":"Transitive relation","score":0.6165079474449158},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.510901153087616},{"id":"https://openalex.org/keywords/closure","display_name":"Closure (psychology)","score":0.5014958381652832},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4548845589160919},{"id":"https://openalex.org/keywords/convergence","display_name":"Convergence (economics)","score":0.4406660199165344},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.4388561248779297},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.43035799264907837},{"id":"https://openalex.org/keywords/iterative-method","display_name":"Iterative method","score":0.41123926639556885},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.38343295454978943},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3382190465927124},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2976152300834656},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.1391540765762329}],"concepts":[{"id":"https://openalex.org/C128896722","wikidata":"https://www.wikidata.org/wiki/Q1501387","display_name":"Transitive closure","level":2,"score":0.9095592498779297},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.6861560940742493},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.676169216632843},{"id":"https://openalex.org/C65180967","wikidata":"https://www.wikidata.org/wiki/Q130901","display_name":"Binary relation","level":2,"score":0.6701372861862183},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.6289519667625427},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.627997100353241},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6197805404663086},{"id":"https://openalex.org/C191399111","wikidata":"https://www.wikidata.org/wiki/Q64861","display_name":"Transitive relation","level":2,"score":0.6165079474449158},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.510901153087616},{"id":"https://openalex.org/C146834321","wikidata":"https://www.wikidata.org/wiki/Q2979672","display_name":"Closure (psychology)","level":2,"score":0.5014958381652832},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4548845589160919},{"id":"https://openalex.org/C2777303404","wikidata":"https://www.wikidata.org/wiki/Q759757","display_name":"Convergence (economics)","level":2,"score":0.4406660199165344},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.4388561248779297},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.43035799264907837},{"id":"https://openalex.org/C159694833","wikidata":"https://www.wikidata.org/wiki/Q2321565","display_name":"Iterative method","level":2,"score":0.41123926639556885},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.38343295454978943},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3382190465927124},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2976152300834656},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.1391540765762329},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C50522688","wikidata":"https://www.wikidata.org/wiki/Q189833","display_name":"Economic growth","level":1,"score":0.0},{"id":"https://openalex.org/C34447519","wikidata":"https://www.wikidata.org/wiki/Q179522","display_name":"Market economy","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.1987.7272364","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.1987.7272364","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"1987 IEEE Third International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W147240463","https://openalex.org/W2043934800","https://openalex.org/W2104734478","https://openalex.org/W2105775150"],"related_works":["https://openalex.org/W2362009423","https://openalex.org/W2394135826","https://openalex.org/W1548215338","https://openalex.org/W2414883570","https://openalex.org/W2547521957","https://openalex.org/W1569140596","https://openalex.org/W1968210840","https://openalex.org/W1495953346","https://openalex.org/W336879522","https://openalex.org/W2172205144"],"abstract_inverted_index":{"Recursive":[0],"query":[1],"evaluation":[2],"is":[3,51,198],"a":[4,31,69,77,82,92,97,103],"capability":[5],"of":[6,26,30,60,68,81,99,125,134,148,159,166,195,237],"deductively-augmented":[7],"database":[8,12,105],"systems":[9,13,219],"that":[10,152,186,216],"conventional":[11],"do":[14],"not":[15,207],"support":[16],"well,":[17],"if":[18],"at":[19,156],"all.":[20],"Many":[21],"recursive":[22],"queries":[23],"involve":[24],"computation":[25],"the":[27,65,112,119,123,132,149,157,164,167,193,201,235,244],"transitive":[28,37,66,113],"closure":[29,38,67,114],"relation.":[32,70,120],"Previously":[33],"published":[34],"algorithms":[35,136,168],"for":[36,63,76,89,169],"are":[39,206,249],"iterative":[40,142,150,241],"in":[41,102,115,217],"nature,":[42],"performing":[43],"repeated":[44],"joins,":[45],"unions,":[46],"and":[47,128,144,179,203,229],"differences":[48],"until":[49],"convergence":[50],"obtained.":[52],"In":[53],"this":[54,126],"paper,":[55],"we":[56,85],"present":[57],"an":[58,141,145,240],"adaptation":[59,194],"Warren's":[61,71,196,224],"algorithm":[62,72,110,151,188,197,225,242],"computing":[64],"was":[73],"originally":[74],"designed":[75],"bit":[78],"matrix":[79],"representation":[80],"binary":[83,93],"relation;":[84],"have":[86],"adapted":[87,109],"it":[88,130],"use":[90],"with":[91,220,234],"relation":[94,172],"represented":[95],"as":[96,101],"set":[98],"tuples,":[100],"relational":[104,139],"management":[106],"system.":[107],"This":[108],"computes":[111],"two":[116,135],"passes":[117],"over":[118],"We":[121,162,214],"analyze":[122],"performance":[124,133,165],"algorithm,":[127,143],"compare":[129],"to":[131,239],"based":[137],"on":[138],"algebra:":[140],"improved":[146],"version":[147],"eliminates":[153],"unnecessary":[154],"I/O":[155],"expense":[158],"more":[160],"computation.":[161],"evaluate":[163],"different":[170],"source":[171,202,245],"sizes,":[173,176],"available":[174],"memory":[175],"join":[177],"selectivities,":[178],"maximum":[180],"path":[181],"length.":[182],"Our":[183],"results":[184],"show":[185],"no":[187],"has":[189],"uniformly":[190],"superior":[191,199],"performance;":[192],"when":[200,243],"result":[204,247],"relations":[205],"too":[208],"much":[209],"larger":[210],"than":[211],"main":[212,222],"memory.":[213],"conclude":[215],"future":[218],"large":[221],"memory,":[223],"generally":[226],"performs":[227],"best,":[228],"thus":[230],"should":[231],"be":[232],"implemented":[233],"option":[236],"switching":[238],"or":[246],"sizes":[248],"very":[250],"large.":[251]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}