{"id":"https://openalex.org/W2913010849","doi":"https://doi.org/10.1142/s0218843019300018","title":"Materialized View Maintenance: Issues, Classification, and Open Challenges","display_name":"Materialized View Maintenance: Issues, Classification, and Open Challenges","publication_year":2019,"publication_date":"2019-01-25","ids":{"openalex":"https://openalex.org/W2913010849","doi":"https://doi.org/10.1142/s0218843019300018","mag":"2913010849"},"language":"en","primary_location":{"id":"doi:10.1142/s0218843019300018","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218843019300018","pdf_url":null,"source":{"id":"https://openalex.org/S17147961","display_name":"International Journal of Cooperative Information Systems","issn_l":"0218-8430","issn":["0218-8430","1793-6365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Cooperative Information Systems","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/A5049814728","display_name":"Abderrazak Sebaa","orcid":"https://orcid.org/0000-0002-8742-1240"},"institutions":[{"id":"https://openalex.org/I187560010","display_name":"University of B\u00e9ja\u00efa","ror":"https://ror.org/03yb2hp88","country_code":"DZ","type":"education","lineage":["https://openalex.org/I187560010"]}],"countries":["DZ"],"is_corresponding":true,"raw_author_name":"Abderrazak Sebaa","raw_affiliation_strings":["LIMED Laboratory, Faculty of Exact Sciences, University of Bejaia, 06000 Bejaia, Algeria"],"raw_orcid":"https://orcid.org/0000-0002-8742-1240","affiliations":[{"raw_affiliation_string":"LIMED Laboratory, Faculty of Exact Sciences, University of Bejaia, 06000 Bejaia, Algeria","institution_ids":["https://openalex.org/I187560010"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5107337666","display_name":"Abdelkamel Tari","orcid":"https://orcid.org/0000-0002-0679-6180"},"institutions":[{"id":"https://openalex.org/I187560010","display_name":"University of B\u00e9ja\u00efa","ror":"https://ror.org/03yb2hp88","country_code":"DZ","type":"education","lineage":["https://openalex.org/I187560010"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Abdelkamel Tari","raw_affiliation_strings":["LIMED Laboratory, Faculty of Exact Sciences, University of Bejaia, 06000 Bejaia, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LIMED Laboratory, Faculty of Exact Sciences, University of Bejaia, 06000 Bejaia, Algeria","institution_ids":["https://openalex.org/I187560010"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5049814728"],"corresponding_institution_ids":["https://openalex.org/I187560010"],"apc_list":null,"apc_paid":null,"fwci":2.1749,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.87761621,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"28","issue":"01","first_page":"1930001","last_page":"1930001"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9993000030517578,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9993000030517578,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9943000078201294,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9911999702453613,"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.8843917846679688},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.689995527267456},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.6246207356452942},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.6040194034576416},{"id":"https://openalex.org/keywords/open-research","display_name":"Open research","score":0.4758717119693756},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.4214267134666443},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.40888214111328125},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.31027665734291077},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.18704506754875183},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.08131977915763855},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.08093637228012085}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8843917846679688},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.689995527267456},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6246207356452942},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.6040194034576416},{"id":"https://openalex.org/C2778464652","wikidata":"https://www.wikidata.org/wiki/Q309849","display_name":"Open research","level":2,"score":0.4758717119693756},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.4214267134666443},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.40888214111328125},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.31027665734291077},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.18704506754875183},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.08131977915763855},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08093637228012085},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1142/s0218843019300018","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s0218843019300018","pdf_url":null,"source":{"id":"https://openalex.org/S17147961","display_name":"International Journal of Cooperative Information Systems","issn_l":"0218-8430","issn":["0218-8430","1793-6365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319815","host_organization_name":"World Scientific","host_organization_lineage":["https://openalex.org/P4310319815"],"host_organization_lineage_names":["World Scientific"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Cooperative Information Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":49,"referenced_works":["https://openalex.org/W170024517","https://openalex.org/W1480149093","https://openalex.org/W1495399242","https://openalex.org/W1504461341","https://openalex.org/W1588786932","https://openalex.org/W1968210840","https://openalex.org/W1975359105","https://openalex.org/W1979331021","https://openalex.org/W1979577883","https://openalex.org/W1980467166","https://openalex.org/W1994642127","https://openalex.org/W2003041563","https://openalex.org/W2020603728","https://openalex.org/W2021305529","https://openalex.org/W2025227784","https://openalex.org/W2034347604","https://openalex.org/W2034964304","https://openalex.org/W2043657122","https://openalex.org/W2053835787","https://openalex.org/W2064390618","https://openalex.org/W2072647642","https://openalex.org/W2073301711","https://openalex.org/W2081417442","https://openalex.org/W2089646370","https://openalex.org/W2101942871","https://openalex.org/W2123520467","https://openalex.org/W2126471648","https://openalex.org/W2128098711","https://openalex.org/W2132461362","https://openalex.org/W2137871487","https://openalex.org/W2141739881","https://openalex.org/W2141975087","https://openalex.org/W2145700552","https://openalex.org/W2155995060","https://openalex.org/W2159457668","https://openalex.org/W2166597031","https://openalex.org/W2168117830","https://openalex.org/W2169530972","https://openalex.org/W2252148092","https://openalex.org/W2296195275","https://openalex.org/W2579124921","https://openalex.org/W2734568115","https://openalex.org/W2739671574","https://openalex.org/W2952451116","https://openalex.org/W3012782266","https://openalex.org/W4230201548","https://openalex.org/W4235149680","https://openalex.org/W4239086110","https://openalex.org/W4291720518"],"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/W2290480557","https://openalex.org/W2135054431","https://openalex.org/W2081307663","https://openalex.org/W4313246833","https://openalex.org/W4313893854"],"abstract_inverted_index":{"Views":[0],"materialization":[1],"is":[2],"a":[3,63,108],"powerful":[4],"technique":[5],"for":[6],"optimization":[7],"of":[8,36,40,69,102,111,128],"query":[9],"evaluation.":[10],"However,":[11],"when":[12],"data":[13],"sources":[14],"are":[15],"updated,":[16],"these":[17],"materialized":[18],"views":[19],"(MVs)":[20],"should":[21],"be":[22],"maintained":[23],"in":[24,57,123],"order":[25],"to":[26,74],"get":[27],"appropriate":[28],"queries\u2019":[29],"answers.":[30],"This":[31],"work":[32],"provides":[33],"an":[34],"overview":[35],"the":[37,52,58,67,84,91,96,124],"research":[38],"field":[39],"view":[41,45,70,85,103,121],"maintenance,":[42],"focusing":[43],"on":[44,120],"maintenance":[46,71,86,104,122],"issues":[47],"and":[48,65,90],"dimensions":[49],"that":[50],"cover":[51],"most":[53,97],"important":[54,98,113],"ones":[55],"proposed":[56],"literature":[59],"review.":[60],"We":[61,94],"provide":[62,95],"classification":[64],"review":[66],"state-of-the-art":[68],"approaches":[72],"according":[73],"several":[75],"parameters":[76],"characterizing":[77],"their":[78],"algorithms,":[79],"including":[80],"information":[81],"considered":[82],"during":[83],"process,":[87],"principle":[88],"used,":[89],"execution":[92],"mechanism.":[93],"performance":[99],"evaluation":[100],"metrics":[101],"process":[105],"while":[106],"performing":[107],"comparative":[109],"study":[110],"some":[112],"approaches.":[114],"Lastly,":[115],"we":[116],"give":[117],"comprehensive":[118],"perspectives":[119],"different":[125],"promising":[126],"environments":[127],"MV":[129],"applications.":[130]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}
