{"id":"https://openalex.org/W1996982345","doi":"https://doi.org/10.1145/1093382.1093384","title":"Incremental maintenance of shortest distance and transitive closure in first-order logic and SQL","display_name":"Incremental maintenance of shortest distance and transitive closure in first-order logic and SQL","publication_year":2005,"publication_date":"2005-09-01","ids":{"openalex":"https://openalex.org/W1996982345","doi":"https://doi.org/10.1145/1093382.1093384","mag":"1996982345"},"language":"en","primary_location":{"id":"doi:10.1145/1093382.1093384","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1093382.1093384","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","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/A5068251664","display_name":"Chaoyi Pang","orcid":"https://orcid.org/0000-0001-7038-3789"},"institutions":[{"id":"https://openalex.org/I1292875679","display_name":"Commonwealth Scientific and Industrial Research Organisation","ror":"https://ror.org/03qn8fb07","country_code":"AU","type":"funder","lineage":["https://openalex.org/I1292875679","https://openalex.org/I2801453606","https://openalex.org/I4387156119"]},{"id":"https://openalex.org/I4210141844","display_name":"Australian e-Health Research Centre","ror":"https://ror.org/04ywhbc61","country_code":"AU","type":"facility","lineage":["https://openalex.org/I1292875679","https://openalex.org/I2801244131","https://openalex.org/I2801453606","https://openalex.org/I4210141844","https://openalex.org/I4387156119"]}],"countries":["AU"],"is_corresponding":true,"raw_author_name":"Chaoyi Pang","raw_affiliation_strings":["CSIRO ICT Center/E-Health Research Center, Australia"],"affiliations":[{"raw_affiliation_string":"CSIRO ICT Center/E-Health Research Center, Australia","institution_ids":["https://openalex.org/I4210141844","https://openalex.org/I1292875679"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5104084428","display_name":"Guozhu Dong","orcid":null},"institutions":[{"id":"https://openalex.org/I19648265","display_name":"Wright State University","ror":"https://ror.org/04qk6pt94","country_code":"US","type":"education","lineage":["https://openalex.org/I19648265"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Guozhu Dong","raw_affiliation_strings":["Wright State University, Dayton, Ohio"],"affiliations":[{"raw_affiliation_string":"Wright State University, Dayton, Ohio","institution_ids":["https://openalex.org/I19648265"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069895484","display_name":"Kotagiri Ramamohanarao","orcid":"https://orcid.org/0000-0003-3304-9268"},"institutions":[{"id":"https://openalex.org/I165779595","display_name":"University of Melbourne","ror":"https://ror.org/01ej9dk98","country_code":"AU","type":"education","lineage":["https://openalex.org/I165779595"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Kotagiri Ramamohanarao","raw_affiliation_strings":["University of Melbourne, Australia"],"affiliations":[{"raw_affiliation_string":"University of Melbourne, Australia","institution_ids":["https://openalex.org/I165779595"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5068251664"],"corresponding_institution_ids":["https://openalex.org/I1292875679","https://openalex.org/I4210141844"],"apc_list":null,"apc_paid":null,"fwci":1.6424,"has_fulltext":false,"cited_by_count":28,"citation_normalized_percentile":{"value":0.86264651,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"30","issue":"3","first_page":"698","last_page":"721"},"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.9995999932289124,"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.9995999932289124,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9994000196456909,"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.9979000091552734,"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/transitive-closure","display_name":"Transitive closure","score":0.8596234917640686},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7730651497840881},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5568260550498962},{"id":"https://openalex.org/keywords/transitive-reduction","display_name":"Transitive reduction","score":0.48902639746665955},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4676489531993866},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.43702957034111023},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4165794551372528},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4098953604698181},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.3187926411628723},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.29055726528167725},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.25596868991851807}],"concepts":[{"id":"https://openalex.org/C128896722","wikidata":"https://www.wikidata.org/wiki/Q1501387","display_name":"Transitive closure","level":2,"score":0.8596234917640686},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7730651497840881},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5568260550498962},{"id":"https://openalex.org/C129691609","wikidata":"https://www.wikidata.org/wiki/Q3088151","display_name":"Transitive reduction","level":5,"score":0.48902639746665955},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4676489531993866},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.43702957034111023},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4165794551372528},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4098953604698181},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.3187926411628723},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.29055726528167725},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.25596868991851807},{"id":"https://openalex.org/C22149727","wikidata":"https://www.wikidata.org/wiki/Q7940747","display_name":"Voltage graph","level":4,"score":0.0},{"id":"https://openalex.org/C203776342","wikidata":"https://www.wikidata.org/wiki/Q1378376","display_name":"Line graph","level":3,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1093382.1093384","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1093382.1093384","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.106.8879","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.106.8879","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://e-hrc.net/pubs/papers/pdf/RP-CP-GD-KR-incr-maint-short-dist-trans-clos-logic-sql.pdf","raw_type":"text"},{"id":"pmh:oai:jupiter.its.unimelb.edu.au:11343/30054","is_oa":false,"landing_page_url":"http://hdl.handle.net/11343/30054","pdf_url":null,"source":{"id":"https://openalex.org/S4377196259","display_name":"Minerva Access (University of Melbourne)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I165779595","host_organization_name":"The University of Melbourne","host_organization_lineage":["https://openalex.org/I165779595"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Journal Article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W58132975","https://openalex.org/W125053135","https://openalex.org/W205976932","https://openalex.org/W241260042","https://openalex.org/W1480867517","https://openalex.org/W1499442191","https://openalex.org/W1515426019","https://openalex.org/W1533191552","https://openalex.org/W1562540297","https://openalex.org/W1573094568","https://openalex.org/W1709754610","https://openalex.org/W1814445252","https://openalex.org/W1965176035","https://openalex.org/W1967389135","https://openalex.org/W1968023964","https://openalex.org/W1979750070","https://openalex.org/W1982440947","https://openalex.org/W1991054669","https://openalex.org/W2002614628","https://openalex.org/W2004769865","https://openalex.org/W2012670464","https://openalex.org/W2037504708","https://openalex.org/W2067253808","https://openalex.org/W2069938443","https://openalex.org/W2072987259","https://openalex.org/W2081236112","https://openalex.org/W2094724468","https://openalex.org/W2094867116","https://openalex.org/W2106439532","https://openalex.org/W2116476518","https://openalex.org/W2139666321","https://openalex.org/W2911756228","https://openalex.org/W3003174730","https://openalex.org/W3195132513","https://openalex.org/W4205167958","https://openalex.org/W6608375579","https://openalex.org/W6631959366"],"related_works":["https://openalex.org/W1964535718","https://openalex.org/W90346837","https://openalex.org/W2143599938","https://openalex.org/W1519942618","https://openalex.org/W2134295301","https://openalex.org/W2069038411","https://openalex.org/W1548215338","https://openalex.org/W40760629","https://openalex.org/W2037875188","https://openalex.org/W1996982345"],"abstract_inverted_index":{"Given":[0],"a":[1,18,40,84,140],"database,":[2],"the":[3,10,14,24,29,34,37,44,48,52,55,79,123],"view":[4,20,30,45],"maintenance":[5,31,154,167],"problem":[6,32,58],"is":[7,46,81,122,139,145],"concerned":[8],"with":[9,100],"efficient":[11],"computation":[12],"of":[13,17,88,118,125,142,166],"new":[15],"contents":[16],"given":[19],"when":[21,36],"updates":[22],"to":[23,54,83],"database":[25,38,151,160],"happen.":[26],"We":[27,62],"consider":[28],"for":[33,66,133,159],"situation":[35],"contains":[39],"weighted":[41],"graph":[42],"and":[43,74,103,127,144],"either":[47],"transitive":[49,77],"closure":[50],"or":[51],"answer":[53],"all-pairs":[56],"shortest-distance":[57],"(":[59,107,113],"APSD":[60,67],").":[61],"give":[63],"incremental":[64],"algorithms":[65,95,155],",":[68],"which":[69],"support":[70],"both":[71],"edge":[72],"insertions":[73],"deletions.":[75],"For":[76],"closure,":[78],"algorithm":[80],"applicable":[82],"more":[85,157],"general":[86],"class":[87],"graphs":[89],"than":[90,162],"those":[91],"previously":[92],"explored.":[93],"Our":[94],"use":[96],"first-order":[97],"queries,":[98],"along":[99],"addition":[101],"(+)":[102],"less-than":[104],"(<)":[105],"operations":[106],"FO":[108,137],"(+,<));":[109],"they":[110],"store":[111],"O":[112],"n":[114,121],"2":[115],")":[116],"number":[117,124],"tuples,":[119],"where":[120],"vertices,":[126],"have":[128],"AC":[129],"0":[130],"data":[131],"complexity":[132],"integer":[134],"weights.":[135],"Since":[136],"(+,<)":[138],"sublanguage":[141],"SQL":[143],"supported":[146],"by":[147],"almost":[148],"all":[149],"current":[150],"systems,":[152],"our":[153],"are":[156],"appropriate":[158],"applications":[161],"nondatabase":[163],"query":[164],"types":[165],"algorithms.":[168]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":4},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}