{"id":"https://openalex.org/W4296313435","doi":"https://doi.org/10.1145/253262.253277","title":"Maintenance of data cubes and summary tables in a warehouse","display_name":"Maintenance of data cubes and summary tables in a warehouse","alternate_titles":[],"publication_year":1997,"publication_date":"1997-06-01","ids":{"openalex":"https://openalex.org/W4296313435","doi":"https://doi.org/10.1145/253262.253277"},"language":"en","primary_location":{"id":"doi:10.1145/253262.253277","doi":"https://doi.org/10.1145/253262.253277","is_oa":true,"landing_page_url":"https://doi.org/10.1145/253262.253277","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/253262.253277","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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":"ACM SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4296313435"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/253262.253277","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5060258942","display_name":"Inderpal Singh Mumick","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4387152956","display_name":"Alcatel-Lucent (France)","ror":"https://ror.org/024850w61","country_code":"FR","type":"company","lineage":["https://openalex.org/I2738502077","https://openalex.org/I4210149358","https://openalex.org/I4387152956"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Inderpal Singh Mumick","raw_affiliation_strings":["Lucent Technologies"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Lucent Technologies","institution_ids":["https://openalex.org/I4387152956"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057412835","display_name":"Dallan Quass","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":"Dallan Quass","raw_affiliation_strings":["AT&T Laboratories Stanford University Lucent Technologies"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AT&T Laboratories Stanford University Lucent Technologies","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071580091","display_name":"Barinderpal Singh Mumick","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":"Barinderpal Singh Mumick","raw_affiliation_strings":["AT&T Laboratories Stanford University Lucent Technologies"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AT&T Laboratories Stanford University Lucent Technologies","institution_ids":["https://openalex.org/I97018004"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.5687,"has_fulltext":true,"cited_by_count":77,"citation_normalized_percentile":{"value":0.90169229,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":98},"biblio":{"volume":"26","issue":"2","first_page":"100","last_page":"111"},"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.9794999957084656,"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.9794999957084656,"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.017500000074505806,"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/T11106","display_name":"Data Management and Algorithms","score":0.00019999999494757503,"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-warehouse-maintenance","display_name":"data warehouse maintenance","score":0.7699999809265137},{"id":"https://openalex.org/keywords/summary-tables","display_name":"summary tables","score":0.9700000286102295},{"id":"https://openalex.org/keywords/olap","display_name":"OLAP","score":0.6620000004768372},{"id":"https://openalex.org/keywords/aggregate-queries","display_name":"aggregate queries","score":0.7369999885559082}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8719812631607056},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8381835222244263},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7925323247909546},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6453884243965149},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6204586029052734},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6174380779266357},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6139187216758728},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5620293021202087},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.42539915442466736},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3949461579322815},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33236587047576904},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.12623357772827148},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.11887148022651672},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"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/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.1145/253262.253277","doi":"https://doi.org/10.1145/253262.253277","is_oa":true,"landing_page_url":"https://doi.org/10.1145/253262.253277","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/253262.253277","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/253262.253277","doi":"https://doi.org/10.1145/253262.253277","is_oa":true,"landing_page_url":"https://doi.org/10.1145/253262.253277","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/253262.253277","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"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":"ACM SIGMOD Record","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4296313435.pdf","grobid_xml":"https://content.openalex.org/works/W4296313435.grobid-xml"},"referenced_works_count":26,"referenced_works":["https://openalex.org/W180056467","https://openalex.org/W1483342375","https://openalex.org/W1519039476","https://openalex.org/W1527356121","https://openalex.org/W1538786304","https://openalex.org/W1554917839","https://openalex.org/W1604952717","https://openalex.org/W1761301028","https://openalex.org/W1973382888","https://openalex.org/W1991054669","https://openalex.org/W1999276015","https://openalex.org/W2006426459","https://openalex.org/W2008907861","https://openalex.org/W2012670464","https://openalex.org/W2113789607","https://openalex.org/W2117242988","https://openalex.org/W2118260817","https://openalex.org/W2131165411","https://openalex.org/W2134600551","https://openalex.org/W2143401113","https://openalex.org/W2150282015","https://openalex.org/W2150950420","https://openalex.org/W2165456041","https://openalex.org/W2913593077","https://openalex.org/W4205167958","https://openalex.org/W4301352956"],"related_works":["https://openalex.org/W2980607435","https://openalex.org/W95505197","https://openalex.org/W2025296527","https://openalex.org/W7096601369","https://openalex.org/W1967901697","https://openalex.org/W4252373428","https://openalex.org/W1596854687","https://openalex.org/W7096135376","https://openalex.org/W2809297885","https://openalex.org/W2284737451"],"abstract_inverted_index":{"Data":[0],"warehouses":[1],"contain":[2],"large":[3,33,57,212],"amounts":[4],"of":[5,12,28,35,59,136,168,214,237],"information,":[6],"often":[7,145],"collected":[8,82],"from":[9],"a":[10,18,56,115,118,147,166,188,195,211,235],"variety":[11],"independent":[13],"sources.":[14],"Decision-support":[15],"functions":[16],"in":[17,117,183,187],"warehouse,":[19],"such":[20],"as":[21],"on-line":[22],"analytical":[23],"processing":[24],"(OLAP),":[25],"involve":[26],"hundreds":[27],"complex":[29],"aggregate":[30,65,170],"queries":[31,44],"over":[32,218],"volumes":[34],"data.":[36],"It":[37],"is":[38,124,131,144,153,241],"not":[39],"feasible":[40],"to":[41,67,99,141,155,179,192,209,231,245],"compute":[42],"these":[43],"by":[45],"scanning":[46],"the":[47,71,84,91,108,122,134,157,200,219,228,242],"data":[48,85,97,151],"sets":[49],"each":[50],"time.":[51],"Warehouse":[52],"applications":[53],"therefore":[54],"build":[55],"number":[58,135],"summary":[60,88,137,158,185,196,215,238,248],"tables":[61,89,138,159,186,216,249],",":[62],"or":[63],"materialized":[64],"views,":[66],"help":[68],"them":[69],"increase":[70],"system":[72],"performance.":[73],"As":[74],"changes,":[75],"most":[76],"notably":[77],"new":[78],"transactional":[79],"data,":[80],"are":[81,105],"at":[83,90,110],"sources,":[86],"all":[87],"warehouse":[92,109,123],"that":[93,139],"depend":[94],"upon":[95],"this":[96,162,240],"need":[98,140],"be":[100,142],"updated.":[101,132],"Usually,":[102],"source":[103],"changes":[104],"loaded":[106],"into":[107],"regular":[111],"intervals,":[112],"usually":[113],"once":[114],"day,":[116],"batch":[119,201],"window,":[120],"and":[121,176,206,233],"made":[125],"unavailable":[126],"for":[127,150,204],"querying":[128],"while":[129,198],"it":[130,178],"Since":[133],"maintained":[143],"large,":[146],"critical":[148],"issue":[149],"warehousing":[152],"how":[154,191,208],"maintain":[156,194,210],"efficiently.":[160,250],"In":[161],"paper":[163,244],"we":[164],"propose":[165],"method":[167],"maintaining":[169,184,247],"views":[171],"(the":[172],"summary-delta":[173],"table":[174,197],"method),":[175],"use":[177],"solve":[180],"two":[181],"problems":[182],"warehouse:":[189],"(1)":[190],"efficiently":[193],"minimizing":[199],"window":[202],"needed":[203],"maintenance,":[205],"(2)":[207],"set":[213,236],"defined":[217],"same":[220],"base":[221],"tables.":[222],"While":[223],"several":[224],"papers":[225],"have":[226],"addressed":[227],"issues":[229],"relating":[230],"choosing":[232],"materializing":[234],"tables,":[239],"first":[243],"address":[246]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4296313435","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2022-09-20T00:00:00"}
