{"id":"https://openalex.org/W2030059876","doi":"https://doi.org/10.1145/1007568.1007606","title":"Transaction support for indexed summary views","display_name":"Transaction support for indexed summary views","publication_year":2004,"publication_date":"2004-06-13","ids":{"openalex":"https://openalex.org/W2030059876","doi":"https://doi.org/10.1145/1007568.1007606","mag":"2030059876"},"language":"en","primary_location":{"id":"doi:10.1145/1007568.1007606","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007606","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","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/A5041862671","display_name":"Goetz Graefe","orcid":"https://orcid.org/0000-0003-0194-6466"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Goetz Graefe","raw_affiliation_strings":["Microsoft"],"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031053305","display_name":"Michael J. Zwilling","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Michael Zwilling","raw_affiliation_strings":["Microsoft"],"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5041862671"],"corresponding_institution_ids":["https://openalex.org/I4210164937"],"apc_list":null,"apc_paid":null,"fwci":0.5047,"has_fulltext":false,"cited_by_count":20,"citation_normalized_percentile":{"value":0.73055664,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"323","last_page":"334"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","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"}},"topics":[{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9947999715805054,"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/T11719","display_name":"Data Quality and Management","score":0.9894999861717224,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9023971557617188},{"id":"https://openalex.org/keywords/serializability","display_name":"Serializability","score":0.7341781258583069},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.6381735801696777},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5817855596542358},{"id":"https://openalex.org/keywords/concurrency","display_name":"Concurrency","score":0.549149751663208},{"id":"https://openalex.org/keywords/concurrency-control","display_name":"Concurrency control","score":0.5471304059028625},{"id":"https://openalex.org/keywords/compensating-transaction","display_name":"Compensating transaction","score":0.5251364707946777},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5201866626739502},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.5026874542236328},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.4666552245616913},{"id":"https://openalex.org/keywords/distributed-transaction","display_name":"Distributed transaction","score":0.44555097818374634},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3496285676956177},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.13721930980682373},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.08372083306312561}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9023971557617188},{"id":"https://openalex.org/C191558696","wikidata":"https://www.wikidata.org/wiki/Q137712","display_name":"Serializability","level":5,"score":0.7341781258583069},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6381735801696777},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5817855596542358},{"id":"https://openalex.org/C193702766","wikidata":"https://www.wikidata.org/wiki/Q1414548","display_name":"Concurrency","level":2,"score":0.549149751663208},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.5471304059028625},{"id":"https://openalex.org/C155951066","wikidata":"https://www.wikidata.org/wiki/Q5156254","display_name":"Compensating transaction","level":5,"score":0.5251364707946777},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5201866626739502},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.5026874542236328},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.4666552245616913},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.44555097818374634},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3496285676956177},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.13721930980682373},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08372083306312561}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1007568.1007606","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1007568.1007606","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2004 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7900000214576721,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W11669818","https://openalex.org/W105408422","https://openalex.org/W167327290","https://openalex.org/W1483342375","https://openalex.org/W1493875369","https://openalex.org/W1498065375","https://openalex.org/W1545155892","https://openalex.org/W1545270572","https://openalex.org/W1557189078","https://openalex.org/W1562880585","https://openalex.org/W1608305252","https://openalex.org/W1975637639","https://openalex.org/W2009712165","https://openalex.org/W2010042648","https://openalex.org/W2039861057","https://openalex.org/W2044667076","https://openalex.org/W2077401654","https://openalex.org/W2091416827","https://openalex.org/W2102959957","https://openalex.org/W2104954161","https://openalex.org/W2117917070","https://openalex.org/W2168262126","https://openalex.org/W2414883570"],"related_works":["https://openalex.org/W579270350","https://openalex.org/W590454891","https://openalex.org/W1987836127","https://openalex.org/W2614829662","https://openalex.org/W1529755872","https://openalex.org/W2091638338","https://openalex.org/W2390021406","https://openalex.org/W2154421011","https://openalex.org/W175215083","https://openalex.org/W2588999713"],"abstract_inverted_index":{"Materialized":[0],"views":[1,32],"have":[2,73],"become":[3],"a":[4,16,52],"standard":[5],"technique":[6],"for":[7,15,173],"performance":[8],"improvement":[9],"in":[10],"decision":[11],"support":[12],"databases":[13],"and":[14,26,33,63,85,107,126,165,169,176],"variety":[17],"of":[18,150],"monitoring":[19],"purposes.":[20],"In":[21],"order":[22],"to":[23,82],"avoid":[24],"inconsistencies":[25],"thus":[27,86],"unpredictable":[28],"query":[29],"results,":[30],"materialized":[31,53],"their":[34],"indexes":[35,45],"should":[36],"be":[37],"maintained":[38],"immediately":[39],"within":[40],"user":[41],"transaction":[42],"just":[43],"like":[44],"on":[46],"ordinary":[47],"tables.":[48],"Unfortunately,":[49],"the":[50,56,58],"smaller":[51],"view":[54],"is,":[55],"higher":[57],"concurrency":[59,102,149],"contention":[60,78,121,133,141],"between":[61,122],"queries":[62],"updates":[64],"as":[65,67,130,132,138,140,162],"well":[66,131,139],"among":[68,134,142],"concurrent":[69],"updates.":[70],"Therefore,":[71],"we":[72],"investigated":[74],"methods":[75,91],"that":[76],"reduce":[77],"without":[79],"forcing":[80],"users":[81],"sacrifice":[83],"serializability":[84],"predictable":[87],"application":[88],"semantics.":[89],"These":[90],"extend":[92],"escrow":[93],"locking":[94],"with":[95,154],"multi-granularity":[96],"(hierarchical)":[97],"locking,":[98,106],"snapshot":[99],"transactions,":[100,109],"multi-version":[101],"control,":[103],"key":[104],"range":[105],"system":[108,177],"i.e.,":[110],"multiple":[111],"proven":[112],"database":[113],"implementation":[114],"techniques.":[115],"The":[116],"complete":[117],"design":[118],"eliminates":[119],"all":[120],"pure":[123,127,135,143],"read":[124],"transactions":[125,129,137,153],"update":[128,136,144],"transactions;":[145,156],"it":[146,157,170],"enables":[147],"maximal":[148],"mixed":[151],"read-write":[152],"other":[155],"supports":[158],"bulk":[159],"operations":[160],"such":[161],"data":[163],"import":[164],"online":[166],"index":[167],"creation;":[168],"provides":[171],"recovery":[172],"transaction,":[174],"media,":[175],"failures.":[178]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":2}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}