{"id":"https://openalex.org/W4291720518","doi":"https://doi.org/10.14778/2824032.2824037","title":"Stale view cleaning","display_name":"Stale view cleaning","publication_year":2015,"publication_date":"2015-08-01","ids":{"openalex":"https://openalex.org/W4291720518","doi":"https://doi.org/10.14778/2824032.2824037"},"language":"en","primary_location":{"id":"doi:10.14778/2824032.2824037","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2824032.2824037","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5018480426","display_name":"Sanjay Krishnan","orcid":"https://orcid.org/0000-0001-6968-4090"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sanjay Krishnan","raw_affiliation_strings":["UC Berkeley"],"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101850961","display_name":"Jiannan Wang","orcid":"https://orcid.org/0009-0002-8978-312X"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jiannan Wang","raw_affiliation_strings":["UC Berkeley"],"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090643027","display_name":"Michael J. Franklin","orcid":"https://orcid.org/0000-0001-9600-4150"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael J. Franklin","raw_affiliation_strings":["UC Berkeley"],"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010019244","display_name":"Ken Goldberg","orcid":"https://orcid.org/0000-0001-6747-9499"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]},{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ken Goldberg","raw_affiliation_strings":["UC Berkeley"],"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"institutions":[{"id":"https://openalex.org/I175594653","display_name":"John Brown University","ror":"https://ror.org/02ct41q97","country_code":"US","type":"education","lineage":["https://openalex.org/I175594653"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Tim Kraska","raw_affiliation_strings":["Brown University"],"affiliations":[{"raw_affiliation_string":"Brown University","institution_ids":["https://openalex.org/I175594653"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5018480426"],"corresponding_institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":3.9938,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.9448266,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"8","issue":"12","first_page":"1370","last_page":"1381"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9975000023841858,"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.9975000023841858,"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.9915000200271606,"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/T11719","display_name":"Data Quality and Management","score":0.9858999848365784,"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.7966928482055664},{"id":"https://openalex.org/keywords/outlier","display_name":"Outlier","score":0.6512006521224976},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.6237923502922058},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.6008961796760559},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5835315585136414},{"id":"https://openalex.org/keywords/sample","display_name":"Sample (material)","score":0.5602394938468933},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5310319662094116},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5118826627731323},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4929368495941162},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.368150532245636},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.21156078577041626},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.14176979660987854},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.08525791764259338},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.08350706100463867}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7966928482055664},{"id":"https://openalex.org/C79337645","wikidata":"https://www.wikidata.org/wiki/Q779824","display_name":"Outlier","level":2,"score":0.6512006521224976},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.6237923502922058},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6008961796760559},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5835315585136414},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.5602394938468933},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5310319662094116},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5118826627731323},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4929368495941162},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.368150532245636},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21156078577041626},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.14176979660987854},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08525791764259338},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08350706100463867},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2824032.2824037","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2824032.2824037","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5299999713897705,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W99733817","https://openalex.org/W253264081","https://openalex.org/W1249613807","https://openalex.org/W1510252230","https://openalex.org/W1586825695","https://openalex.org/W1592355944","https://openalex.org/W1610496399","https://openalex.org/W1638185811","https://openalex.org/W1647250085","https://openalex.org/W1845494277","https://openalex.org/W1943411325","https://openalex.org/W1963898916","https://openalex.org/W1973761208","https://openalex.org/W1975184797","https://openalex.org/W1992023276","https://openalex.org/W1993803315","https://openalex.org/W1995339490","https://openalex.org/W2000042664","https://openalex.org/W2022858489","https://openalex.org/W2025387515","https://openalex.org/W2034964304","https://openalex.org/W2039548475","https://openalex.org/W2047182010","https://openalex.org/W2068634907","https://openalex.org/W2074489032","https://openalex.org/W2093402788","https://openalex.org/W2100153179","https://openalex.org/W2112452856","https://openalex.org/W2115010808","https://openalex.org/W2126915543","https://openalex.org/W2131111873","https://openalex.org/W2141739881","https://openalex.org/W2149576945","https://openalex.org/W2153160273","https://openalex.org/W2161768947","https://openalex.org/W2169982181","https://openalex.org/W2260305637","https://openalex.org/W2296195275","https://openalex.org/W2752885492","https://openalex.org/W2914354916","https://openalex.org/W2950906527","https://openalex.org/W2952451116","https://openalex.org/W2952470184","https://openalex.org/W3103362336","https://openalex.org/W4205724807","https://openalex.org/W4210949648","https://openalex.org/W4235092540","https://openalex.org/W4239086110","https://openalex.org/W4291720518","https://openalex.org/W4299841484","https://openalex.org/W4388892785","https://openalex.org/W6636177537"],"related_works":["https://openalex.org/W2125738398","https://openalex.org/W2038176938","https://openalex.org/W2376402673","https://openalex.org/W2953224074","https://openalex.org/W1606751452","https://openalex.org/W2585331044","https://openalex.org/W2588278736","https://openalex.org/W2114713465","https://openalex.org/W2104704499","https://openalex.org/W1591045846"],"abstract_inverted_index":{"Materialized":[0],"views":[1],"(MVs),":[2],"stored":[3],"pre-computed":[4],"results,":[5],"are":[6,135,191],"widely":[7],"used":[8],"to":[9,27,37,58,96,117,127],"facilitate":[10],"fast":[11],"queries":[12],"on":[13,156],"large":[14],"datasets.":[15],"When":[16],"new":[17],"records":[18],"arrive":[19],"at":[20],"a":[21,33,74,83,88,157,165,205],"high":[22],"rate,":[23],"it":[24],"is":[25,36,180,202],"infeasible":[26],"continuously":[28],"update":[29],"(maintain)":[30],"MVs":[31,47],"and":[32,54,91,146,164,199],"common":[34],"solution":[35],"defer":[38],"maintenance":[39,141],"by":[40,143],"batching":[41],"updates":[42],"together.":[43],"Between":[44],"batches":[45],"the":[46,93,103,108,132,161,188,196],"become":[48],"increasingly":[49,59],"stale":[50,89,197],"with":[51],"incorrect,":[52],"missing,":[53],"superfluous":[55],"rows":[56,86],"leading":[57],"inaccurate":[60],"query":[61,99,105,148],"results.":[62,100],"We":[63,152],"propose":[64],"Stale":[65],"View":[66],"Cleaning":[67],"(SVC)":[68],"which":[69],"addresses":[70],"this":[71],"problem":[72],"from":[73,87,160],"data":[75,133],"cleaning":[76,176],"perspective.":[77],"In":[78],"SVC,":[79],"we":[80,120],"efficiently":[81],"clean":[82,94],"sample":[84,95,179],"of":[85,208],"MV,":[90,198],"use":[92],"estimate":[97],"aggregate":[98],"While":[101],"approximate,":[102],"estimated":[104,189],"results":[106,190],"reflect":[107],"most":[109],"recent":[110],"data.":[111],"As":[112],"sampling":[113],"can":[114],"be":[115],"sensitive":[116],"long-tailed":[118],"distributions,":[119],"further":[121],"explore":[122],"an":[123,177],"outlier":[124],"indexing":[125],"technique":[126],"give":[128],"increased":[129],"accuracy":[130],"when":[131],"distributions":[134],"skewed.":[136],"SVC":[137,201],"complements":[138],"existing":[139],"deferred":[140],"approaches":[142],"giving":[144],"accurate":[145,193],"bounded":[147],"answers":[149],"between":[150],"maintenance.":[151],"evaluate":[153],"our":[154,172],"method":[155],"generated":[158],"dataset":[159],"TPC-D":[162],"benchmark":[163],"real":[166],"video":[167],"distribution":[168],"application.":[169],"Experiments":[170],"confirm":[171],"theoretical":[173],"results:":[174],"(1)":[175],"MV":[178],"more":[181,192],"efficient":[182],"than":[183,194],"full":[184],"view":[185],"maintenance,":[186],"(2)":[187],"using":[195],"(3)":[200],"applicable":[203],"for":[204],"wide":[206],"variety":[207],"MVs.":[209]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2022-08-16T00:00:00"}