{"id":"https://openalex.org/W4288861841","doi":"https://doi.org/10.1007/978-3-031-01873-2_4","title":"Concurrent Queries and Updates in Summary Views and Their Indexes","display_name":"Concurrent Queries and Updates in Summary Views and Their Indexes","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W4288861841","doi":"https://doi.org/10.1007/978-3-031-01873-2_4"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-031-01873-2_4","pdf_url":null,"source":{"id":"https://openalex.org/S982029923","display_name":"Synthesis lectures on data management","issn_l":"2153-5418","issn":["2153-5418","2153-5426"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":true,"host_organization":"https://openalex.org/P4310322570","host_organization_name":"Morgan & Claypool Publishers","host_organization_lineage":["https://openalex.org/P4310322570"],"host_organization_lineage_names":["Morgan & Claypool Publishers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"book-chapter","type_crossref":"book-chapter","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":[],"countries":[],"is_corresponding":true,"raw_author_name":"Goetz Graefe","raw_affiliation_strings":[],"affiliations":[]}],"institution_assertions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5041862671"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.404,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.45122,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":61,"max":69},"biblio":{"volume":null,"issue":null,"first_page":"75","last_page":"127"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9997,"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.9997,"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.9935,"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.9813,"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/commit","display_name":"Commit","score":0.75526524},{"id":"https://openalex.org/keywords/serializability","display_name":"Serializability","score":0.69694155},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.591676},{"id":"https://openalex.org/keywords/compensating-transaction","display_name":"Compensating transaction","score":0.5821199},{"id":"https://openalex.org/keywords/two-phase-locking","display_name":"Two-phase locking","score":0.4935187}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.88157487},{"id":"https://openalex.org/C153180980","wikidata":"https://www.wikidata.org/wiki/Q19776675","display_name":"Commit","level":2,"score":0.75526524},{"id":"https://openalex.org/C191558696","wikidata":"https://www.wikidata.org/wiki/Q137712","display_name":"Serializability","level":5,"score":0.69694155},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.591676},{"id":"https://openalex.org/C155951066","wikidata":"https://www.wikidata.org/wiki/Q5156254","display_name":"Compensating transaction","level":5,"score":0.5821199},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.56828266},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.52817506},{"id":"https://openalex.org/C193702766","wikidata":"https://www.wikidata.org/wiki/Q1414548","display_name":"Concurrency","level":2,"score":0.502963},{"id":"https://openalex.org/C131346163","wikidata":"https://www.wikidata.org/wiki/Q2290484","display_name":"Two-phase locking","level":5,"score":0.4935187},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.48767245},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.43103752},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.38858497},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.35441715},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.33406204},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.14931741},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.07605678}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-031-01873-2_4","pdf_url":null,"source":{"id":"https://openalex.org/S982029923","display_name":"Synthesis lectures on data management","issn_l":"2153-5418","issn":["2153-5418","2153-5426"],"is_oa":false,"is_in_doaj":false,"is_indexed_in_scopus":false,"is_core":true,"host_organization":"https://openalex.org/P4310322570","host_organization_name":"Morgan & Claypool Publishers","host_organization_lineage":["https://openalex.org/P4310322570"],"host_organization_lineage_names":["Morgan & Claypool Publishers"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":30,"referenced_works":["https://openalex.org/W105408422","https://openalex.org/W1492213400","https://openalex.org/W1515932031","https://openalex.org/W1545155892","https://openalex.org/W1545270572","https://openalex.org/W1608305252","https://openalex.org/W1972634640","https://openalex.org/W2000467305","https://openalex.org/W2010042648","https://openalex.org/W2039861057","https://openalex.org/W2044667076","https://openalex.org/W2059444570","https://openalex.org/W2070742144","https://openalex.org/W2070941848","https://openalex.org/W2077401654","https://openalex.org/W2091416827","https://openalex.org/W2099623813","https://openalex.org/W2104954161","https://openalex.org/W2116476518","https://openalex.org/W2122350904","https://openalex.org/W2125691260","https://openalex.org/W2133386065","https://openalex.org/W2146791244","https://openalex.org/W2149934115","https://openalex.org/W2152030485","https://openalex.org/W2168043428","https://openalex.org/W3004616691","https://openalex.org/W3142109266","https://openalex.org/W4238675359","https://openalex.org/W4239321933"],"related_works":["https://openalex.org/W4288861841","https://openalex.org/W2400812042","https://openalex.org/W2162564537","https://openalex.org/W2161561644","https://openalex.org/W2142585279","https://openalex.org/W2130926824","https://openalex.org/W2090951080","https://openalex.org/W2053888684","https://openalex.org/W1565132773","https://openalex.org/W1486594064"],"abstract_inverted_index":{"Materialized":[0],"views":[1,29],"have":[2,76],"become":[3],"a":[4,13,55],"standard":[5],"technique":[6],"in":[7,178,183],"decision":[8],"support":[9],"databases":[10],"and":[11,23,30,44,50,66,88,110,130,161,171,174],"for":[12,168],"variety":[14],"of":[15,146],"monitoring":[16],"purposes.1":[17],"In":[18],"order":[19],"to":[20,85],"avoid":[21],"inconsistencies":[22],"thus":[24,51,89],"unpredictable":[25],"query":[26],"results,":[27],"materialized":[28,56],"their":[31,45],"indexes":[32],"should":[33],"be":[34],"maintained":[35],"immediately":[36],"within":[37],"user":[38],"transactions":[39,129,133,149],"just":[40],"like":[41],"ordinary":[42],"tables":[43],"indexes.":[46],"Unfortunately,":[47],"the":[48,52,59,61],"smaller":[49],"more":[53],"effective":[54],"view":[57],"is,":[58],"higher":[60],"concurrency":[62,102,145],"contention":[63,81,125,137],"between":[64,126],"queries":[65],"updates":[67],"as":[68,70,134,136,158],"well":[69,135],"among":[71,138],"concurrent":[72],"updates.":[73],"Therefore,":[74],"we":[75],"investigated":[77],"methods":[78,94],"that":[79],"reduce":[80],"without":[82],"forcing":[83],"users":[84],"sacrifice":[86],"serializability":[87],"predictable":[90],"application":[91],"semantics.":[92],"These":[93],"extend":[95],"escrow":[96],"locking":[97],"with":[98,114,150],"snapshot":[99],"transactions,":[100,112],"multi-version":[101],"control,":[103],"multi-granularity":[104],"(hierarchical)":[105],"locking,":[106,109],"key":[107],"range":[108],"system":[111,172],"i.e.,":[113],"multiple":[115],"proven":[116],"database":[117],"implementation":[118],"techniques.":[119],"The":[120],"complete":[121],"design":[122],"eliminates":[123],"all":[124],"pure":[127,131,139],"read":[128],"update":[132,140],"transactions;":[141,152],"it":[142,153,165,175],"enables":[143],"maximal":[144],"mixed":[147],"read-write":[148],"other":[151],"supports":[154],"bulk":[155],"operations":[156],"such":[157],"data":[159],"import":[160],"online":[162],"index":[163],"creation;":[164],"provides":[166],"recovery":[167],"transaction,":[169],"media,":[170],"failures;":[173],"can":[176],"participate":[177],"coordinated":[179],"commit":[180],"processing,":[181],"e.g.,":[182],"two-phase":[184],"commit.":[185]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4288861841","counts_by_year":[{"year":2019,"cited_by_count":1}],"updated_date":"2025-04-22T09:56:19.602405","created_date":"2022-07-31"}