{"id":"https://openalex.org/W1648759563","doi":null,"title":"Performance Issues in Incremental Warehouse Maintenance","display_name":"Performance Issues in Incremental Warehouse Maintenance","alternate_titles":[],"publication_year":2000,"publication_date":"2000-09-10","ids":{"openalex":"https://openalex.org/W1648759563","mag":"1648759563"},"language":"en","primary_location":{"id":"mag:1648759563","doi":null,"is_oa":false,"landing_page_url":"http://infolab.stanford.edu/~wilburt/publications/perf.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W1648759563"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5054683604","display_name":"Wilburt Juan Labio","orcid":null,"observed_orcids":[]},"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":false,"raw_author_name":"Wilburt Labio","raw_affiliation_strings":["Stanford University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101801967","display_name":"Jun Yang","orcid":"https://orcid.org/0000-0003-0604-6790","observed_orcids":["https://orcid.org/0000-0003-0604-6790","https://orcid.org/0000-0001-7888-2187"]},"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":false,"raw_author_name":"Jun Yang","raw_affiliation_strings":["Stanford University"],"raw_orcid":"https://orcid.org/0000-0001-7888-2187","affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108378689","display_name":"Yingwei Cui","orcid":null,"observed_orcids":[]},"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":false,"raw_author_name":"Yingwei Cui","raw_affiliation_strings":["Stanford University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055883336","display_name":"H\u00e9ctor Garc\u00eda-Molina","orcid":null,"observed_orcids":[]},"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":false,"raw_author_name":"H\u00e9ctor Garc\u00eda-Molina","raw_affiliation_strings":["Stanford University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010857944","display_name":"Jennifer Widom","orcid":null,"observed_orcids":[]},"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":false,"raw_author_name":"Jennifer Widom","raw_affiliation_strings":["Stanford University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford University","institution_ids":["https://openalex.org/I97018004"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I97018004"],"apc_list":null,"apc_paid":null,"fwci":4.8213,"has_fulltext":false,"cited_by_count":84,"citation_normalized_percentile":{"value":0.94791475,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"461","last_page":"472"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9585000276565552,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9585000276565552,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.032600000500679016,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.0010000000474974513,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.8090000152587891},{"id":"https://openalex.org/keywords/algorithm-performance","display_name":"algorithm performance","score":0.6610000133514404},{"id":"https://openalex.org/keywords/performance-evaluation","display_name":"performance evaluation","score":0.5619999766349792},{"id":"https://openalex.org/keywords/whips","display_name":"whips","score":0.8119999766349792}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8983488082885742},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7529481649398804},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5784814357757568},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.5596411824226379},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44094550609588623},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.4189063012599945},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3299879729747772},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.11639264225959778},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.0}],"mesh":[],"locations_count":6,"locations":[{"id":"mag:1648759563","doi":null,"is_oa":false,"landing_page_url":"http://infolab.stanford.edu/~wilburt/publications/perf.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.32.5402","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.32.5402","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.db.stanford.edu/~junyang/papers/lycgmw-vldb00.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.36.9038","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.36.9038","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ftp://db.stanford.edu/pub/papers/whips-wm.ps","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.46.4110","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.46.4110","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.stanford.edu/pub/papers/whips-wm.ps","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.521.4087","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.521.4087","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/398/1/1999-42.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.75.4249","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.75.4249","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/pub/papers/whips-wm.ps","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1572120187","https://openalex.org/W1590355100","https://openalex.org/W1943411325","https://openalex.org/W1968386702","https://openalex.org/W1973382888","https://openalex.org/W1979809502","https://openalex.org/W1998147193","https://openalex.org/W2012670464","https://openalex.org/W2072764742","https://openalex.org/W2091926418","https://openalex.org/W2117242988","https://openalex.org/W2131165411","https://openalex.org/W2132582487","https://openalex.org/W2136195851","https://openalex.org/W2158447492","https://openalex.org/W2248652221"],"related_works":["https://openalex.org/W7098090671","https://openalex.org/W2496528773","https://openalex.org/W87030728","https://openalex.org/W2004681204","https://openalex.org/W3024616655","https://openalex.org/W2981846407","https://openalex.org/W2373106838","https://openalex.org/W2181948357","https://openalex.org/W2008452859","https://openalex.org/W1485858653"],"abstract_inverted_index":{"A":[0],"well-known":[1],"challenge":[2],"in":[3,14,91,95,123],"data":[4,13,19,28,45,102,116,130],"warehousing":[5,103,111],"is":[6],"the":[7,15,39,65,80,88,124,144],"efficient":[8],"incremental":[9,106],"maintenance":[10],"of":[11,17,41,87,98],"warehouse":[12,125,132],"presence":[16],"source":[18,129],"updates.":[20],"In":[21],"this":[22,92],"paper,":[23],"we":[24,51,75],"identify":[25,52],"several":[26],"critical":[27],"representation":[29],"and":[30,55,74,114],"algorithmic":[31],"choices":[32],"that":[33,63,139],"must":[34],"be":[35,136],"made":[36],"when":[37],"developing":[38],"machinery":[40],"an":[42],"incrementally":[43],"maintained":[44,137],"warehouse.":[46],"For":[47],"each":[48],"decision":[49],"area,":[50],"various":[53],"alternatives":[54],"evaluate":[56],"them":[57],"through":[58],"extensive":[59],"experiments.":[60],"We":[61],"show":[62],"picking":[64],"right":[66,81],"alternative":[67],"can":[68],"lead":[69],"to":[70,135],"dramatic":[71],"performance":[72],"gains,":[73],"propose":[76],"guidelines":[77],"for":[78],"making":[79],"decisions":[82],"under":[83],"different":[84],"scenarios.":[85],"All":[86],"issues":[89],"addressed":[90],"paper":[93],"arose":[94],"our":[96],"development":[97],"WHIPS,":[99],"a":[100],"prototype":[101],"system":[104],"supporting":[105],"maintenance.":[107],"1":[108],"Introduction":[109],"Data":[110],"systems":[112],"integrate":[113],"store":[115],"from":[117],"remote":[118],"sources":[119],"as":[120],"materialized":[121],"views":[122,133],"[LW95,":[126],"CD97].":[127],"When":[128],"changes,":[131],"need":[134],"so":[138],"they":[140],"remain":[141],"consistent":[142],"with":[143],"so...":[145]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1648759563","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":7}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
