{"id":"https://openalex.org/W1569140596","doi":"https://doi.org/10.1145/68012.68015","title":"Updating derived relations: detecting irrelevant and autonomously computable updates","display_name":"Updating derived relations: detecting irrelevant and autonomously computable updates","publication_year":1989,"publication_date":"1989-09-01","ids":{"openalex":"https://openalex.org/W1569140596","doi":"https://doi.org/10.1145/68012.68015","mag":"1569140596"},"language":"en","primary_location":{"id":"doi:10.1145/68012.68015","is_oa":true,"landing_page_url":"https://doi.org/10.1145/68012.68015","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/68012.68015","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":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/68012.68015","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083815095","display_name":"Jos\u00e9 A. Blakeley","orcid":null},"institutions":[{"id":"https://openalex.org/I4210119109","display_name":"Indiana University Bloomington","ror":"https://ror.org/02k40bc56","country_code":"US","type":"education","lineage":["https://openalex.org/I4210119109","https://openalex.org/I592451"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jos\u00e9 A. Blakeley","raw_affiliation_strings":["Indiana Univ., Bloomington"],"affiliations":[{"raw_affiliation_string":"Indiana Univ., Bloomington","institution_ids":["https://openalex.org/I4210119109"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059630110","display_name":"Neil Coburn","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Neil Coburn","raw_affiliation_strings":["Univ. of Waterloo, Waterloo, Ont., Canada"],"affiliations":[{"raw_affiliation_string":"Univ. of Waterloo, Waterloo, Ont., Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109039470","display_name":"Per-\u00c5ke Larson","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Per-\u00c5ke Larson","raw_affiliation_strings":["Univ. of Waterloo, Waterloo, Ont., Canada"],"affiliations":[{"raw_affiliation_string":"Univ. of Waterloo, Waterloo, Ont., Canada","institution_ids":["https://openalex.org/I151746483"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5083815095"],"corresponding_institution_ids":["https://openalex.org/I4210119109"],"apc_list":null,"apc_paid":null,"fwci":4.0783,"has_fulltext":true,"cited_by_count":29,"citation_normalized_percentile":{"value":0.93162606,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"14","issue":"3","first_page":"369","last_page":"400"},"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.9991999864578247,"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.9991999864578247,"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.9977999925613403,"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.996399998664856,"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/joins","display_name":"Joins","score":0.8452602624893188},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.8449928760528564},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.8148036003112793},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7515338659286499},{"id":"https://openalex.org/keywords/base","display_name":"Base (topology)","score":0.6784673929214478},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6773220896720886},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5620065331459045},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5561105012893677},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5554119348526001},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.5435410141944885},{"id":"https://openalex.org/keywords/binary-relation","display_name":"Binary relation","score":0.5070381164550781},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.47567999362945557},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.43981409072875977},{"id":"https://openalex.org/keywords/algebra-over-a-field","display_name":"Algebra over a field","score":0.38174521923065186},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.33931946754455566},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2833460569381714},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.26487964391708374},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.22661679983139038},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.17327892780303955},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.11713847517967224},{"id":"https://openalex.org/keywords/pure-mathematics","display_name":"Pure mathematics","score":0.10538005828857422}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8452602624893188},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.8449928760528564},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.8148036003112793},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7515338659286499},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.6784673929214478},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6773220896720886},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5620065331459045},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5561105012893677},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5554119348526001},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5435410141944885},{"id":"https://openalex.org/C65180967","wikidata":"https://www.wikidata.org/wiki/Q130901","display_name":"Binary relation","level":2,"score":0.5070381164550781},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.47567999362945557},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.43981409072875977},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.38174521923065186},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.33931946754455566},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2833460569381714},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.26487964391708374},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.22661679983139038},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.17327892780303955},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.11713847517967224},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.10538005828857422},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/68012.68015","is_oa":true,"landing_page_url":"https://doi.org/10.1145/68012.68015","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/68012.68015","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.55.2768","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.55.2768","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ftp://ftp.research.microsoft.com/users/palarson/tods89_3.ps","raw_type":"text"},{"id":"mag:1569140596","is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb86.html#BlakeleyCL86","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"Very Large Data Bases","raw_type":null},{"id":"mag:2414883570","is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=310709.310757","pdf_url":null,"source":{"id":"https://openalex.org/S4306463626","display_name":"MIT Press eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"MIT Press eBooks","raw_type":null}],"best_oa_location":{"id":"doi:10.1145/68012.68015","is_oa":true,"landing_page_url":"https://doi.org/10.1145/68012.68015","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/68012.68015","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"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G8284766523","display_name":null,"funder_award_id":"(NSERC)","funder_id":"https://openalex.org/F4320334593","funder_display_name":"Natural Sciences and Engineering Research Council of Canada"}],"funders":[{"id":"https://openalex.org/F4320321739","display_name":"Consejo Nacional de Ciencia y Tecnolog\u00eda","ror":"https://ror.org/059ex5q34"},{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W1569140596.pdf","grobid_xml":"https://content.openalex.org/works/W1569140596.grobid-xml"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W99733817","https://openalex.org/W151906112","https://openalex.org/W1499001767","https://openalex.org/W1992553671","https://openalex.org/W2007572995","https://openalex.org/W2016580249","https://openalex.org/W2065419751","https://openalex.org/W2071395959","https://openalex.org/W2082070582","https://openalex.org/W2115822498","https://openalex.org/W2116476518","https://openalex.org/W2125123273","https://openalex.org/W2150282015","https://openalex.org/W4205167958","https://openalex.org/W4242968380"],"related_works":["https://openalex.org/W1495953346","https://openalex.org/W2116476518","https://openalex.org/W1968210840","https://openalex.org/W2058978608","https://openalex.org/W1499001767","https://openalex.org/W99733817","https://openalex.org/W2167679350","https://openalex.org/W2047809518","https://openalex.org/W2247274357","https://openalex.org/W1548215338","https://openalex.org/W970107847","https://openalex.org/W2066711169","https://openalex.org/W2324136837","https://openalex.org/W133146348","https://openalex.org/W2815919238","https://openalex.org/W2562731034","https://openalex.org/W2286968949","https://openalex.org/W2308842842","https://openalex.org/W1522300458","https://openalex.org/W3022707827"],"abstract_inverted_index":{"Consider":[0],"a":[1,20,50,55,65,149],"database":[2],"containing":[3,122],"not":[4],"only":[5],"base":[6,21,51],"relations":[7,12,94],"but":[8],"also":[9,27],"stored":[10],"derived":[11,35,56,66,78,93],"(also":[13],"called":[14],"materialized":[15],"or":[16,144],"concrete":[17],"views).":[18],"When":[19],"relation":[22,52,57,67,79,156],"is":[23,96,146],"updated,":[24],"it":[25],"may":[26],"be":[28,69,142],"necessary":[29,42],"to":[30,98,141],"update":[31,48,84,128],"some":[32],"of":[33,49,92,115,127,131,139,154],"the":[34,77,82,137,155],"relations.":[36],"This":[37],"paper":[38],"gives":[39],"sufficient":[40],"and":[41,61,81,118,134],"conditions":[43],"for":[44,62],"detecting":[45,63],"when":[46,64],"an":[47,112],"cannot":[53],"affect":[54],"(an":[58,86],"irrelevant":[59],"update),":[60],"can":[68],"correctly":[70],"updated":[71],"using":[72],"no":[73,123],"data":[74],"other":[75],"than":[76],"itself":[80],"given":[83],"operation":[85],"autonomously":[87],"computable":[88],"update).":[89],"The":[90,125],"class":[91,126],"considered":[95],"restricted":[97],"those":[99],"defined":[100],"by":[101,148],"PSJ":[102],"-expressions,":[103],"that":[104],"is,":[105],"any":[106],"relational":[107],"algebra":[108],"expressions":[109],"constructed":[110],"from":[111],"arbitrary":[113],"number":[114],"project,":[116],"select":[117],"join":[119],"operations":[120,129],"(but":[121],"self-joins).":[124],"consists":[130],"insertions,":[132],"deletions,":[133],"modifications,":[135],"where":[136],"set":[138],"tuples":[140],"deleted":[143],"modified":[145],"specified":[147],"selection":[150],"condition":[151],"on":[152],"attributes":[153],"being":[157],"updated.":[158]},"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2016,"cited_by_count":3}],"updated_date":"2026-04-21T08:09:41.155169","created_date":"2025-10-10T00:00:00"}