{"id":"https://openalex.org/W2002110561","doi":"https://doi.org/10.1145/130283.130333","title":"Continuous queries over append-only databases","display_name":"Continuous queries over append-only databases","publication_year":1992,"publication_date":"1992-06-01","ids":{"openalex":"https://openalex.org/W2002110561","doi":"https://doi.org/10.1145/130283.130333","mag":"2002110561"},"language":"en","primary_location":{"id":"doi:10.1145/130283.130333","is_oa":false,"landing_page_url":"https://doi.org/10.1145/130283.130333","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1992 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5111484988","display_name":"Douglas B. Terry","orcid":"https://orcid.org/0009-0003-9720-5562"},"institutions":[{"id":"https://openalex.org/I173498003","display_name":"Palo Alto Research Center","ror":"https://ror.org/0529fxt39","country_code":"US","type":"facility","lineage":["https://openalex.org/I173498003","https://openalex.org/I4210132870"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Douglas Terry","raw_affiliation_strings":["Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","institution_ids":["https://openalex.org/I173498003"]},{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#","institution_ids":["https://openalex.org/I173498003"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009201543","display_name":"David Theo Goldberg","orcid":"https://orcid.org/0000-0001-9935-0411"},"institutions":[{"id":"https://openalex.org/I173498003","display_name":"Palo Alto Research Center","ror":"https://ror.org/0529fxt39","country_code":"US","type":"facility","lineage":["https://openalex.org/I173498003","https://openalex.org/I4210132870"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"David Goldberg","raw_affiliation_strings":["Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","institution_ids":["https://openalex.org/I173498003"]},{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#","institution_ids":["https://openalex.org/I173498003"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090840456","display_name":"David M. Nichols","orcid":"https://orcid.org/0000-0003-0321-7267"},"institutions":[{"id":"https://openalex.org/I173498003","display_name":"Palo Alto Research Center","ror":"https://ror.org/0529fxt39","country_code":"US","type":"facility","lineage":["https://openalex.org/I173498003","https://openalex.org/I4210132870"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"David Nichols","raw_affiliation_strings":["Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","institution_ids":["https://openalex.org/I173498003"]},{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#","institution_ids":["https://openalex.org/I173498003"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090439813","display_name":"Brian Oki","orcid":null},"institutions":[{"id":"https://openalex.org/I173498003","display_name":"Palo Alto Research Center","ror":"https://ror.org/0529fxt39","country_code":"US","type":"facility","lineage":["https://openalex.org/I173498003","https://openalex.org/I4210132870"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Brian Oki","raw_affiliation_strings":["Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA","institution_ids":["https://openalex.org/I173498003"]},{"raw_affiliation_string":"Xerox Corporation, Palo Alto Research Center, 3333 Coyote Hill Rd., Palo Altoj CA#TAB#","institution_ids":["https://openalex.org/I173498003"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I173498003"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":404,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"321","last_page":"330"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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/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/T11269","display_name":"Algorithms and Data Compression","score":0.9970999956130981,"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/append","display_name":"Append","score":0.9047714471817017},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.811490535736084},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5793079137802124},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3888908922672272},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.31198829412460327}],"concepts":[{"id":"https://openalex.org/C2777998813","wikidata":"https://www.wikidata.org/wiki/Q16869124","display_name":"Append","level":2,"score":0.9047714471817017},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.811490535736084},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5793079137802124},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3888908922672272},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.31198829412460327}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/130283.130333","is_oa":false,"landing_page_url":"https://doi.org/10.1145/130283.130333","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 1992 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W113037826","https://openalex.org/W138816814","https://openalex.org/W207305439","https://openalex.org/W1505054487","https://openalex.org/W1524011117","https://openalex.org/W1526124194","https://openalex.org/W1735558737","https://openalex.org/W2006299591","https://openalex.org/W2019580127","https://openalex.org/W2037717074","https://openalex.org/W2062851028","https://openalex.org/W2066636971","https://openalex.org/W2067481201","https://openalex.org/W2120052337","https://openalex.org/W4205167958","https://openalex.org/W4236015061","https://openalex.org/W4248319243","https://openalex.org/W6630119620","https://openalex.org/W6650784929"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2182311571","https://openalex.org/W2088586339","https://openalex.org/W2322447839","https://openalex.org/W1497439325","https://openalex.org/W2316107800","https://openalex.org/W2091059593","https://openalex.org/W2317738247"],"abstract_inverted_index":{"In":[0],"a":[1,14,79,90],"database":[2,80,109,160],"to":[3,12,54,74,103,127,136,178],"which":[4,147],"data":[5,21],"is":[6,45,166],"continually":[7],"added,":[8],"users":[9,73],"may":[10],"wish":[11],"issue":[13,75],"permanent":[15],"query":[16,117,121,130],"and":[17,83,112,153,171],"be":[18,35,55,155],"notified":[19],"whenever":[20],"matches":[22,126],"the":[23,50,108,116,128,137,142],"query.":[24],"If":[25],"such":[26,76,93],"continuous":[27],"queries":[28,64,77],"examine":[29],"only":[30,49],"single":[31],"records,":[32],"this":[33],"can":[34],"implemented":[36,156],"by":[37,104],"examining":[38],"each":[39],"record":[40,52],"as":[41,94,106,131],"it":[42],"arrives.":[43],"This":[44,57,139],"very":[46],"efficient":[47],"because":[48],"incoming":[51],"needs":[53],"scanned.":[56],"simple":[58],"approach":[59],"does":[60],"not":[61,149],"work":[62],"for":[63,168],"involving":[65],"joins":[66],"or":[67],"time.":[68],"The":[69,87],"Tapestry":[70,114,165],"system":[71],"allows":[72],"over":[78],"of":[81],"mail":[82,170],"bulletin":[84],"board":[85],"messages.":[86],"user":[88],"issues":[89],"static":[91],"query,":[92],"\u201cshow":[95],"me":[96],"all":[97],"messages":[98,133],"that":[99,122,161],"have":[100],"been":[101],"replied":[102],"Jones,\u201d":[105],"though":[107],"were":[110],"fixed":[111],"unchanging.":[113],"converts":[115],"into":[118],"an":[119],"incremental":[120],"efficiently":[123],"finds":[124],"new":[125,132],"original":[129],"are":[134,176],"added":[135],"database.":[138,181],"paper":[140],"describes":[141],"techniques":[143,175],"used":[144],"in":[145],"Tapestry,":[146],"do":[148],"depend":[150],"on":[151,157],"triggers":[152],"thus":[154],"any":[158,179],"commercial":[159],"supports":[162],"SQL.":[163],"Although":[164],"designed":[167],"filtering":[169],"news":[172],"messages,":[173],"its":[174],"applicable":[177],"append-only":[180]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":9},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":16},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":17},{"year":2012,"cited_by_count":17}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}