{"id":"https://openalex.org/W2068010682","doi":"https://doi.org/10.1109/icde.2007.367921","title":"Partial Materialized Views","display_name":"Partial Materialized Views","alternate_titles":[],"publication_year":2007,"publication_date":"2007-04-01","ids":{"openalex":"https://openalex.org/W2068010682","doi":"https://doi.org/10.1109/icde.2007.367921","mag":"2068010682"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2007.367921","doi":"https://doi.org/10.1109/icde.2007.367921","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2007.367921","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2068010682"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"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/A5080086968","display_name":"Gang Luo","orcid":"https://orcid.org/0000-0001-7217-4008","observed_orcids":["https://orcid.org/0000-0001-7217-4008"]},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Gang Luo","raw_affiliation_strings":["IBM Thomas J. Watson Research Center, USA","IBM T.J. Watson Research Center, luog@us.ibm.com"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Thomas J. Watson Research Center, USA","institution_ids":["https://openalex.org/I4210114115"]},{"raw_affiliation_string":"IBM T.J. Watson Research Center, luog@us.ibm.com","institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5080086968"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"],"apc_list":null,"apc_paid":null,"fwci":1.0331,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.73815129,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"756","last_page":"765"},"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.9984999895095825,"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.9984999895095825,"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/T11106","display_name":"Data Management and Algorithms","score":0.0006000000284984708,"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/T10101","display_name":"Cloud Computing and Resource Management","score":9.999999747378752e-05,"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/query-result-caching","display_name":"query result caching","score":0.7120000123977661},{"id":"https://openalex.org/keywords/transaction-consistency","display_name":"transaction consistency","score":0.7039999961853027},{"id":"https://openalex.org/keywords/query-execution-time","display_name":"query execution time","score":0.5059999823570251},{"id":"https://openalex.org/keywords/memory-caching","display_name":"memory caching","score":0.6029999852180481},{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":0.39899998903274536},{"id":"https://openalex.org/keywords/relational-database-management-systems","display_name":"relational database management systems","score":0.550000011920929}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9436272382736206},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8430600166320801},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6775736212730408},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6166288256645203},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5163506269454956},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.4639453887939453},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35362544655799866},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3482963442802429},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3288067877292633},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2728254795074463},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.19565847516059875},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2007.367921","doi":"https://doi.org/10.1109/icde.2007.367921","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2007.367921","pdf_url":null,"source":{"id":"https://openalex.org/S4210210321","display_name":"IEEE International Conference on Data Engineering (ICDE)","issn_l":"1084-4627","issn":["1084-4627","2375-0286"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","norway-2"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W1495105959","https://openalex.org/W1508869423","https://openalex.org/W1526145227","https://openalex.org/W1534469055","https://openalex.org/W1553825122","https://openalex.org/W1562880585","https://openalex.org/W1604794355","https://openalex.org/W1647250085","https://openalex.org/W1678889691","https://openalex.org/W1890845846","https://openalex.org/W1964857063","https://openalex.org/W1993482412","https://openalex.org/W2020147322","https://openalex.org/W2038281398","https://openalex.org/W2041414515","https://openalex.org/W2044564105","https://openalex.org/W2047221353","https://openalex.org/W2054170837","https://openalex.org/W2077515046","https://openalex.org/W2081628764","https://openalex.org/W2098388305","https://openalex.org/W2108699731","https://openalex.org/W2117242988","https://openalex.org/W2117348908","https://openalex.org/W2120108467","https://openalex.org/W2121350579","https://openalex.org/W2122816893","https://openalex.org/W2130476464","https://openalex.org/W2134195632","https://openalex.org/W2138525793","https://openalex.org/W2140102533","https://openalex.org/W2143682328","https://openalex.org/W2144570882","https://openalex.org/W2148322068","https://openalex.org/W2149728808","https://openalex.org/W2151406030","https://openalex.org/W2152191782","https://openalex.org/W2160770337","https://openalex.org/W2161569281","https://openalex.org/W2171492933","https://openalex.org/W2201552871","https://openalex.org/W2212047990","https://openalex.org/W2268311336","https://openalex.org/W2296677182","https://openalex.org/W2751601659","https://openalex.org/W3152703111","https://openalex.org/W4229903866","https://openalex.org/W4237172715","https://openalex.org/W4251617391","https://openalex.org/W4254357460","https://openalex.org/W4255671299","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W7095432241","https://openalex.org/W7098892468","https://openalex.org/W7126430925","https://openalex.org/W1489872200","https://openalex.org/W2038176938","https://openalex.org/W2913201029","https://openalex.org/W2104704499","https://openalex.org/W2129261178","https://openalex.org/W4385270183","https://openalex.org/W2165456041"],"abstract_inverted_index":{"Early":[0],"access":[1],"to":[2,19,45,61,99,127,131],"partial":[3,24,40,104],"query":[4,130],"results":[5,25,53],"is":[6,17,113,142],"highly":[7],"desirable":[8],"during":[9,72],"exploration":[10],"of":[11,48,88,110,138],"massive":[12],"data":[13],"sets.":[14],"However,":[15],"it":[16],"challenging":[18],"provide":[20],"transactionally":[21],"consistent,":[22],"immediate":[23],"without":[26],"significantly":[27],"increasing":[28],"queries'":[29],"execution":[30],"time.":[31],"To":[32],"address":[33],"this":[34,36,117],"problem,":[35],"paper":[37],"proposes":[38],"a":[39,89,107,121,145,148],"materialized":[41,63],"view":[42],"(PMV)":[43],"method":[44,141],"cache":[46],"some":[47],"the":[49,57,65,86,91,95,100,102,111,124,129,133],"most":[50],"frequently":[51],"accessed":[52],"rather":[54],"than":[55],"all":[56],"possible":[58],"results.":[59,105,135],"Compared":[60],"traditional":[62],"views,":[64],"proposed":[66],"PMVs":[67],"do":[68],"not":[69],"require":[70],"maintenance":[71,83],"insertion":[73],"into":[74],"base":[75],"relations,":[76],"and":[77,82,97,151],"have":[78],"much":[79],"smaller":[80],"storage":[81],"overhead.":[84],"Upon":[85],"arrival":[87],"query,":[90],"RDBMS":[92,125],"first":[93],"searches":[94],"PMV":[96,112,140],"returns":[98],"user":[101],"cached":[103,114],"Since":[106],"large":[108],"portion":[109],"in":[115,155],"memory,":[116],"usually":[118],"finishes":[119],"within":[120],"millisecond.":[122],"Then":[123],"continues":[126],"execute":[128],"find":[132],"remaining":[134],"The":[136],"efficiency":[137],"our":[139],"evaluated":[143],"through":[144],"simulation":[146],"study,":[147],"theoretical":[149],"analysis,":[150],"an":[152],"initial":[153],"implementation":[154],"PostgreSQL.":[156]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2068010682","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
