{"id":"https://openalex.org/W2124711321","doi":"https://doi.org/10.1145/1559845.1559866","title":"Asynchronous view maintenance for VLSD databases","display_name":"Asynchronous view maintenance for VLSD databases","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2124711321","doi":"https://doi.org/10.1145/1559845.1559866","mag":"2124711321"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559866","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559866","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 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/A5075956031","display_name":"Parag Agrawal","orcid":"https://orcid.org/0009-0005-0759-8484"},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Parag Agrawal","raw_affiliation_strings":["Stanford University, Stanford, CA, USA"],"affiliations":[{"raw_affiliation_string":"Stanford University, Stanford, CA, USA","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002175828","display_name":"Adam Silberstein","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Adam Silberstein","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA","Yahoo! Research, Santa Clara , CA, USA"],"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]},{"raw_affiliation_string":"Yahoo! Research, Santa Clara , CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112027889","display_name":"Brian F. Cooper","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Brian F. Cooper","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA","Yahoo! Research, Santa Clara , CA, USA"],"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]},{"raw_affiliation_string":"Yahoo! Research, Santa Clara , CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101897152","display_name":"Utkarsh Srivastava","orcid":"https://orcid.org/0009-0002-7952-559X"},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Utkarsh Srivastava","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA","Yahoo! Research, Santa Clara , CA, USA"],"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]},{"raw_affiliation_string":"Yahoo! Research, Santa Clara , CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051301731","display_name":"Raghu Ramakrishnan","orcid":"https://orcid.org/0009-0007-5086-7664"},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Raghu Ramakrishnan","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA","Yahoo! Research, Santa Clara , CA, USA"],"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]},{"raw_affiliation_string":"Yahoo! Research, Santa Clara , CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5075956031"],"corresponding_institution_ids":["https://openalex.org/I97018004"],"apc_list":null,"apc_paid":null,"fwci":6.8884,"has_fulltext":false,"cited_by_count":68,"citation_normalized_percentile":{"value":0.97104097,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"179","last_page":"192"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998999834060669,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11478","display_name":"Caching and Content Delivery","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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8813844919204712},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.6290832161903381},{"id":"https://openalex.org/keywords/asynchronous-communication","display_name":"Asynchronous communication","score":0.615145206451416},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.5425238609313965},{"id":"https://openalex.org/keywords/eventual-consistency","display_name":"Eventual consistency","score":0.5405797362327576},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.47573137283325195},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.4480307400226593},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.4289800822734833},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.42762428522109985},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.39797133207321167},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.37289655208587646},{"id":"https://openalex.org/keywords/data-consistency","display_name":"Data consistency","score":0.3011813759803772},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.19562694430351257},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.15374621748924255}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8813844919204712},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6290832161903381},{"id":"https://openalex.org/C151319957","wikidata":"https://www.wikidata.org/wiki/Q752739","display_name":"Asynchronous communication","level":2,"score":0.615145206451416},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.5425238609313965},{"id":"https://openalex.org/C34422012","wikidata":"https://www.wikidata.org/wiki/Q6125872","display_name":"Eventual consistency","level":4,"score":0.5405797362327576},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47573137283325195},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.4480307400226593},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4289800822734833},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.42762428522109985},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.39797133207321167},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.37289655208587646},{"id":"https://openalex.org/C93361087","wikidata":"https://www.wikidata.org/wiki/Q4426698","display_name":"Data consistency","level":2,"score":0.3011813759803772},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.19562694430351257},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.15374621748924255},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C37279795","wikidata":"https://www.wikidata.org/wiki/Q2492305","display_name":"Consistency model","level":3,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1559845.1559866","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559866","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.161.5326","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.161.5326","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://infolab.stanford.edu/~usriv/papers/vlsdviews.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.216.7546","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.216.7546","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://ilpubs.stanford.edu:8090/916/1/views.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.41999998688697815,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W180056467","https://openalex.org/W1981420413","https://openalex.org/W1990080756","https://openalex.org/W1994642127","https://openalex.org/W2012670464","https://openalex.org/W2073824505","https://openalex.org/W2075451706","https://openalex.org/W2101610060","https://openalex.org/W2102959957","https://openalex.org/W2116476518","https://openalex.org/W2118260817","https://openalex.org/W2118385974","https://openalex.org/W2122928210","https://openalex.org/W2126321570","https://openalex.org/W2129412326","https://openalex.org/W2129531726","https://openalex.org/W2131165411","https://openalex.org/W2142644005","https://openalex.org/W2149728808","https://openalex.org/W2150013559","https://openalex.org/W2152389926","https://openalex.org/W2153704625","https://openalex.org/W2160825121","https://openalex.org/W2252148092","https://openalex.org/W3147052988","https://openalex.org/W4205167958","https://openalex.org/W4238925974","https://openalex.org/W6677702014"],"related_works":["https://openalex.org/W2916847028","https://openalex.org/W2152367200","https://openalex.org/W4250503143","https://openalex.org/W2329431478","https://openalex.org/W2797563685","https://openalex.org/W2004687507","https://openalex.org/W2100872225","https://openalex.org/W2974289255","https://openalex.org/W1574320195","https://openalex.org/W2736736734"],"abstract_inverted_index":{"The":[0],"query":[1,39,50,62],"models":[2],"of":[3,7,52,95,114,183,194,206],"the":[4,49,93,106,181,191,204],"recent":[5],"generation":[6],"very":[8],"large":[9],"scale":[10,78],"distributed":[11,79],"(VLSD)":[12],"shared-nothing":[13],"data":[14],"storage":[15],"systems,":[16],"including":[17],"our":[18,195],"own":[19],"PNUTS":[20],"and":[21,35,37,45,61,73,98,109,122,133,142,147,160,166,197],"others":[22],"(e.g.":[23],"BigTable,":[24],"Dynamo,":[25],"Cassandra,":[26],"etc.)":[27],"are":[28],"intentionally":[29],"simple,":[30],"focusing":[31],"on":[32],"simple":[33],"lookups":[34],"scans":[36],"trading":[38],"expressiveness":[40,51],"for":[41,175],"massive":[42,77],"scale.":[43],"Indexes":[44],"views":[46,74,97,159],"can":[47,150,201],"expand":[48],"such":[53,144],"systems":[54],"by":[55],"materializing":[56],"more":[57],"complex":[58,208],"access":[59],"paths":[60],"results.":[63],"In":[64],"this":[65],"paper,":[66],"we":[67,90],"examine":[68,105],"mechanisms":[69],"to":[70,140,153,178],"implement":[71,154],"indexes":[72,99],"in":[75],"a":[76,168],"database.":[80],"For":[81],"web":[82],"applications,":[83],"minimizing":[84,134],"update":[85],"latencies":[86],"is":[87],"critical,":[88],"so":[89],"advocate":[91],"deferring":[92],"work":[94],"maintaining":[96],"as":[100,102],"much":[101],"possible.":[103],"We":[104,137,163],"design":[107],"space,":[108],"conclude":[110],"that":[111,171,199],"two":[112],"types":[113],"view":[115,119,124,135,145,185],"implementations,":[116],"called":[117],"remote":[118],"tables":[120,125],"(RVTs)":[121],"local":[123],"(LVTs),":[126],"provide":[127],"good":[128],"tradeoff":[129],"between":[130],"system":[131],"throughput":[132],"staleness.":[136],"describe":[138],"how":[139,148],"construct":[141],"maintain":[143],"tables,":[146],"they":[149,200],"be":[151],"used":[152],"indexes,":[155],"group-by-aggregate":[156],"views,":[157,196],"equijoin":[158],"selection":[161],"views.":[162],"also":[164],"introduce":[165],"analyze":[167],"consistency":[169],"model":[170],"makes":[172],"it":[173],"easier":[174],"application":[176],"developers":[177],"cope":[179],"with":[180],"impact":[182],"deferred":[184],"maintenance.":[186],"An":[187],"empirical":[188],"evaluation":[189],"quantifies":[190],"maintenance":[192],"costs":[193],"shows":[198],"significantly":[202],"improve":[203],"cost":[205],"evaluating":[207],"queries.":[209]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":6},{"year":2013,"cited_by_count":9},{"year":2012,"cited_by_count":7}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}