{"id":"https://openalex.org/W3035788562","doi":"https://doi.org/10.1142/s021884302050001x","title":"MVPP-Based Materialized View Selection in Data Warehouses Using Simulated Annealing","display_name":"MVPP-Based Materialized View Selection in Data Warehouses Using Simulated Annealing","publication_year":2020,"publication_date":"2020-06-18","ids":{"openalex":"https://openalex.org/W3035788562","doi":"https://doi.org/10.1142/s021884302050001x","mag":"3035788562"},"language":"en","primary_location":{"id":"doi:10.1142/s021884302050001x","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s021884302050001x","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/A5023490221","display_name":"Mohsen Mohseni","orcid":null},"institutions":[{"id":"https://openalex.org/I4210104301","display_name":"Islamic Azad University Semnan","ror":"https://ror.org/01abrxp85","country_code":"IR","type":"education","lineage":["https://openalex.org/I110525433","https://openalex.org/I4210104301"]}],"countries":["IR"],"is_corresponding":false,"raw_author_name":"Mohsen Mohseni","raw_affiliation_strings":["Department of Computer Engineering, Semnan Branch, Islamic Azad University, Semnan, Iran"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Engineering, Semnan Branch, Islamic Azad University, Semnan, Iran","institution_ids":["https://openalex.org/I4210104301"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045821587","display_name":"Mohammad Karim Sohrabi","orcid":"https://orcid.org/0000-0001-8066-0356"},"institutions":[{"id":"https://openalex.org/I4210104301","display_name":"Islamic Azad University Semnan","ror":"https://ror.org/01abrxp85","country_code":"IR","type":"education","lineage":["https://openalex.org/I110525433","https://openalex.org/I4210104301"]}],"countries":["IR"],"is_corresponding":true,"raw_author_name":"Mohammad Karim Sohrabi","raw_affiliation_strings":["Department of Computer Engineering, Semnan Branch, Islamic Azad University, Semnan, Iran"],"raw_orcid":"https://orcid.org/0000-0001-8066-0356","affiliations":[{"raw_affiliation_string":"Department of Computer Engineering, Semnan Branch, Islamic Azad University, Semnan, Iran","institution_ids":["https://openalex.org/I4210104301"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5045821587"],"corresponding_institution_ids":["https://openalex.org/I4210104301"],"apc_list":null,"apc_paid":null,"fwci":1.3363,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.80731412,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"29","issue":"03","first_page":"2050001","last_page":"2050001"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987000226974487,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9947999715805054,"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/materialized-view","display_name":"Materialized view","score":0.9345331192016602},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.892052173614502},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8291397094726562},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8180602788925171},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5209187865257263},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4939435124397278},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.47795724868774414},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.467768132686615},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4443446099758148},{"id":"https://openalex.org/keywords/simulated-annealing","display_name":"Simulated annealing","score":0.4400056004524231},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.43650007247924805},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41657203435897827},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.37723055481910706},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.21420204639434814},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.19543343782424927},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.14125677943229675},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.12328952550888062}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9345331192016602},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.892052173614502},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8291397094726562},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8180602788925171},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5209187865257263},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4939435124397278},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.47795724868774414},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.467768132686615},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4443446099758148},{"id":"https://openalex.org/C126980161","wikidata":"https://www.wikidata.org/wiki/Q863783","display_name":"Simulated annealing","level":2,"score":0.4400056004524231},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.43650007247924805},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41657203435897827},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.37723055481910706},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.21420204639434814},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.19543343782424927},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.14125677943229675},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.12328952550888062},{"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/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"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/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1142/s021884302050001x","is_oa":false,"landing_page_url":"https://doi.org/10.1142/s021884302050001x","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W2776818","https://openalex.org/W1998298161","https://openalex.org/W2006057663","https://openalex.org/W2017782374","https://openalex.org/W2024060531","https://openalex.org/W2024569314","https://openalex.org/W2054675302","https://openalex.org/W2070168269","https://openalex.org/W2081579241","https://openalex.org/W2084007999","https://openalex.org/W2086028392","https://openalex.org/W2087869882","https://openalex.org/W2088908211","https://openalex.org/W2098416578","https://openalex.org/W2100109822","https://openalex.org/W2100251446","https://openalex.org/W2117654209","https://openalex.org/W2124751909","https://openalex.org/W2143515359","https://openalex.org/W2147288474","https://openalex.org/W2156554027","https://openalex.org/W2307155028","https://openalex.org/W2330487032","https://openalex.org/W2474281234","https://openalex.org/W2570863224","https://openalex.org/W2583603977","https://openalex.org/W2595531993","https://openalex.org/W2743513849","https://openalex.org/W2792920932","https://openalex.org/W2797440583","https://openalex.org/W2888941620","https://openalex.org/W2890919505","https://openalex.org/W2901478555","https://openalex.org/W2913010849","https://openalex.org/W2945459156","https://openalex.org/W2950821398","https://openalex.org/W3152002993","https://openalex.org/W4246565613","https://openalex.org/W4289258943","https://openalex.org/W4313341246"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W1988774479","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2353410296","https://openalex.org/W2381646725","https://openalex.org/W2084266952"],"abstract_inverted_index":{"The":[0,256],"process":[1],"of":[2,31,44,56,59,62,72,85,89,107,113,115,133,161,168,170,207,213,241,262,275,279,283,293,308,314],"extracting":[3],"data":[4,8,33,40],"from":[5],"different":[6],"heterogeneous":[7],"sources,":[9],"transforming":[10],"them":[11],"into":[12],"an":[13,110,181,204,210],"integrated,":[14],"unified":[15],"and":[16,19,47,101,122,142,239,286],"cleaned":[17],"repository,":[18],"storing":[20],"the":[21,29,42,80,86,99,103,108,116,129,137,162,227,236,253,263,273,280,290,296,302,309,312,315],"result":[22],"as":[23],"a":[24,32,76,165,198,220,242],"single":[25],"entity":[26],"leads":[27],"to":[28,39,52,67,97,128,136,157,202,266],"construction":[30],"warehouse":[34],"(DW),":[35],"which":[36,74],"facilitates":[37],"access":[38,135],"for":[41,120,126,172,234,251,271],"users":[43],"information":[45],"systems":[46,65],"decision":[48,63],"support":[49,64],"systems.":[50],"Due":[51],"their":[53],"enormous":[54],"volumes":[55],"data,":[57,73],"processing":[58,92,230],"analytical":[60,91,130],"queries":[61,240,294],"need":[66],"scan":[68],"very":[69],"large":[70],"amounts":[71],"has":[75,186],"negative":[77],"effect":[78],"on":[79],"systems\u2019":[81],"response":[82,105],"time.":[83],"Because":[84],"special":[87],"importance":[88],"online":[90],"(OLAP)":[93],"in":[94,154,189,248,277,295],"these":[95],"systems,":[96],"enhance":[98],"performance":[100,261],"improve":[102],"query":[104,287],"time":[106],"system,":[109],"appropriate":[111,205],"number":[112,274],"views":[114,143,160,169,208],"DW":[117,171,244,316],"are":[118,146],"selected":[119],"materialization":[121],"will":[123],"be":[124],"utilized":[125],"responding":[127],"queries,":[131,276],"instead":[132],"direct":[134],"base":[138],"relations.":[139],"Memory":[140],"constraint":[141],"maintenance":[144,285],"overhead":[145],"two":[147],"main":[148],"limitations":[149],"that":[150,185,218],"make":[151],"it":[152],"impossible,":[153],"most":[155],"cases,":[156],"materialize":[158],"all":[159],"DW.":[163],"Selecting":[164],"proper":[166,221],"set":[167,206],"materialization,":[173],"called":[174,200],"materialized":[175],"view":[176,229,284],"selection":[177,223],"(MVS)":[178],"problem,":[179],"is":[180,298,317],"important":[182,304],"research":[183],"issue":[184],"been":[187,246],"focused":[188],"various":[190],"papers.":[191],"In":[192],"this":[193],"paper,":[194],"we":[195],"have":[196,245],"proposed":[197],"method,":[199],"P-SA,":[201],"select":[203],"using":[209],"improved":[211],"version":[212],"simulated":[214],"annealing":[215],"(SA)":[216],"algorithm":[217],"utilizes":[219],"neighborhood":[222],"strategy.":[224],"P-SA":[225,264,297],"uses":[226],"multiple":[228],"plan":[231],"(MVPP)":[232],"structure":[233],"selecting":[235],"views.":[237],"Data":[238],"benchmark":[243],"used":[247],"experimental":[249,257],"results":[250,258],"evaluating":[252],"introduced":[254],"method.":[255],"show":[259],"better":[260,300],"compared":[265],"other":[267,303],"SA-based":[268,305],"MVS":[269,306],"methods":[270,307],"increasing":[272],"terms":[278],"total":[281,291],"cost":[282,292],"processing.":[288],"Moreover,":[289],"also":[299],"than":[301],"literature":[310],"when":[311],"size":[313],"increased.":[318]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}