{"id":"https://openalex.org/W4376855352","doi":"https://doi.org/10.32604/csse.2023.038951","title":"A Novel Hybrid Optimization Algorithm for Materialized View Selection from Data Warehouse Environments","display_name":"A Novel Hybrid Optimization Algorithm for Materialized View Selection from Data Warehouse Environments","publication_year":2023,"publication_date":"2023-01-01","ids":{"openalex":"https://openalex.org/W4376855352","doi":"https://doi.org/10.32604/csse.2023.038951"},"language":"en","primary_location":{"id":"doi:10.32604/csse.2023.038951","doi":"https://doi.org/10.32604/csse.2023.038951","is_oa":true,"landing_page_url":"https://doi.org/10.32604/csse.2023.038951","pdf_url":"https://www.techscience.com/csse/online/detail/19192/pdf","source":{"id":"https://openalex.org/S4210214087","display_name":"Computer Systems Science and Engineering","issn_l":"0267-6192","issn":["0267-6192","2766-4821"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1","poland-40","russia-white-list-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer Systems Science and Engineering","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://www.techscience.com/csse/online/detail/19192/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5102912348","display_name":"Popuri Srinivasarao","orcid":"https://orcid.org/0000-0002-3810-496X","observed_orcids":["https://orcid.org/0000-0002-3810-496X"]},"institutions":[{"id":"https://openalex.org/I4401726783","display_name":"VIT-AP University","ror":"https://ror.org/007v4hf75","country_code":"IN","type":"education","lineage":["https://openalex.org/I4401726783"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Popuri Srinivasarao","raw_affiliation_strings":["School of Computer Science and Engineering, VIT-AP University, Amaravati, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, VIT-AP University, Amaravati, India","institution_ids":["https://openalex.org/I4401726783"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5028340043","display_name":"Aravapalli Rama Satish","orcid":"https://orcid.org/0000-0002-4323-8073","observed_orcids":["https://orcid.org/0000-0002-4323-8073"]},"institutions":[{"id":"https://openalex.org/I4401726783","display_name":"VIT-AP University","ror":"https://ror.org/007v4hf75","country_code":"IN","type":"education","lineage":["https://openalex.org/I4401726783"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Aravapalli Rama Satish","raw_affiliation_strings":["School of Computer Science and Engineering, VIT-AP University, Amaravati, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science and Engineering, VIT-AP University, Amaravati, India","institution_ids":["https://openalex.org/I4401726783"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5028340043"],"corresponding_institution_ids":["https://openalex.org/I4401726783"],"apc_list":null,"apc_paid":null,"fwci":0.8954,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.75900064,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":95},"biblio":{"volume":"47","issue":"2","first_page":"1527","last_page":"1547"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.774399995803833,"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.774399995803833,"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/T10100","display_name":"Metaheuristic Optimization Algorithms Research","score":0.17249999940395355,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.01769999973475933,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view-selection","display_name":"materialized view selection","score":1.0},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.8790000081062317},{"id":"https://openalex.org/keywords/hybrid-metaheuristic-algorithm","display_name":"hybrid metaheuristic","score":0.7440000176429749},{"id":"https://openalex.org/keywords/coot-optimization-algorithm","display_name":"coot optimization algorithm","score":0.8119999766349792},{"id":"https://openalex.org/keywords/constraint-handling","display_name":"constraint handling","score":0.7009999752044678},{"id":"https://openalex.org/keywords/epsilon-parameter","display_name":"epsilon parameter","score":0.7149999737739563},{"id":"https://openalex.org/keywords/stochastic-ranking","display_name":"stochastic ranking","score":0.9950000047683716},{"id":"https://openalex.org/keywords/view-maintenance-cost","display_name":"view maintenance cost","score":0.8840000033378601},{"id":"https://openalex.org/keywords/query-cost","display_name":"query cost","score":0.9539999961853027},{"id":"https://openalex.org/keywords/tpc-h","display_name":"TPC-H","score":0.9700000286102295}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9456062316894531},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8791481256484985},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7097611427307129},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6546489596366882},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.5945547223091125},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.458753377199173},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4311203360557556},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1613720953464508},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.12766411900520325},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.09030976891517639},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.32604/csse.2023.038951","doi":"https://doi.org/10.32604/csse.2023.038951","is_oa":true,"landing_page_url":"https://doi.org/10.32604/csse.2023.038951","pdf_url":"https://www.techscience.com/csse/online/detail/19192/pdf","source":{"id":"https://openalex.org/S4210214087","display_name":"Computer Systems Science and Engineering","issn_l":"0267-6192","issn":["0267-6192","2766-4821"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1","poland-40","russia-white-list-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer Systems Science and Engineering","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.32604/csse.2023.038951","doi":"https://doi.org/10.32604/csse.2023.038951","is_oa":true,"landing_page_url":"https://doi.org/10.32604/csse.2023.038951","pdf_url":"https://www.techscience.com/csse/online/detail/19192/pdf","source":{"id":"https://openalex.org/S4210214087","display_name":"Computer Systems Science and Engineering","issn_l":"0267-6192","issn":["0267-6192","2766-4821"],"is_oa":true,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1","poland-40","russia-white-list-1"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computer Systems Science and Engineering","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4376855352.pdf","grobid_xml":"https://content.openalex.org/works/W4376855352.grobid-xml"},"referenced_works_count":37,"referenced_works":["https://openalex.org/W2056561256","https://openalex.org/W2395617438","https://openalex.org/W2736028630","https://openalex.org/W2743513849","https://openalex.org/W2792920932","https://openalex.org/W2796394805","https://openalex.org/W2809306865","https://openalex.org/W2849741571","https://openalex.org/W2888941620","https://openalex.org/W2890919505","https://openalex.org/W2925250396","https://openalex.org/W2945158851","https://openalex.org/W2945459156","https://openalex.org/W2950821398","https://openalex.org/W2964274783","https://openalex.org/W2968683814","https://openalex.org/W2981846407","https://openalex.org/W3000733809","https://openalex.org/W3010823339","https://openalex.org/W3016499880","https://openalex.org/W3035788562","https://openalex.org/W3035894368","https://openalex.org/W3046319801","https://openalex.org/W3046470293","https://openalex.org/W3083250282","https://openalex.org/W3120225099","https://openalex.org/W3133733881","https://openalex.org/W3153258780","https://openalex.org/W3163990883","https://openalex.org/W3166174009","https://openalex.org/W3168104563","https://openalex.org/W3195848939","https://openalex.org/W4210747461","https://openalex.org/W4214505893","https://openalex.org/W4214920055","https://openalex.org/W4247123173","https://openalex.org/W7111291576"],"related_works":["https://openalex.org/W4388180124","https://openalex.org/W3185986869","https://openalex.org/W2143515359","https://openalex.org/W2371256394","https://openalex.org/W4236335346","https://openalex.org/W2156554027","https://openalex.org/W2034594361","https://openalex.org/W1908544460","https://openalex.org/W4385557563","https://openalex.org/W2370299385"],"abstract_inverted_index":{"Responding":[0],"to":[1,38,58,76,144,192,196,210,219],"complex":[2],"analytical":[3],"queries":[4,40],"in":[5,48,177,226],"the":[6,13,31,50,60,74,84,111,115,120,146,158,165,173,194,198,202,212,215,247],"data":[7],"warehouse":[8],"(DW)":[9],"is":[10,54,142],"one":[11],"of":[12,23,64,81,129,162,182,214,231,236,241],"most":[14,32,61],"challenging":[15],"tasks":[16],"that":[17,35,118,156],"require":[18],"prompt":[19],"attention.":[20],"The":[21,69,90,222],"problem":[22,203],"materialized":[24],"view":[25,228],"(MV)":[26],"selection":[27,80],"relies":[28],"on":[29],"selecting":[30],"optimal":[33,62,147,160],"views":[34,66,82,117,163,183],"can":[36],"respond":[37],"more":[39],"simultaneously.":[41],"This":[42],"work":[43,71],"introduces":[44],"a":[45,78,124,178,227],"combined":[46,55],"approach":[47,217],"which":[49],"constraint":[51,86,105],"handling":[52,87],"process":[53],"with":[56,138,184],"metaheuristics":[57,155],"select":[59,114],"subset":[63],"DW":[65],"from":[67,164,201],"DWs.":[68],"proposed":[70,112,174,216,223],"initially":[72],"refines":[73],"solution":[75,200],"enable":[77,193],"feasible":[79],"using":[83,246],"ensemble":[85],"technique":[88],"(ECHT).":[89],"constraints":[91,109],"such":[92],"as":[93],"self-adaptive":[94],"penalty,":[95],"epsilon":[96],"(\u03b5)-parameter":[97],"and":[98,126,131,150,238],"stochastic":[99],"ranking":[100],"(SR)":[101],"are":[102,190,208],"considered":[103],"for":[104],"handling.":[106],"These":[107],"two":[108,171],"helped":[110],"model":[113],"finest":[116,199],"minimize":[119],"objective":[121],"function.":[122],"Further,":[123],"novel":[125],"effective":[127],"combination":[128],"Ebola":[130,137,149],"coot":[132,139],"optimization":[133,140],"algorithms":[134],"named":[135],"hybrid":[136],"(CHECO)":[141],"introduced":[143,154],"choose":[145,197],"MVs.":[148],"Coot":[151],"have":[152],"recently":[153],"identify":[157],"global":[159],"set":[161,181],"given":[166],"population.":[167],"By":[168],"combining":[169],"these":[170],"algorithms,":[172],"framework":[175,224],"resulted":[176,225],"highly":[179],"optimized":[180],"minimized":[185],"costs.":[186],"Several":[187],"cost":[188,230,235],"functions":[189],"described":[191],"algorithm":[195],"space.":[204],"Finally,":[205],"extensive":[206],"evaluations":[207],"conducted":[209],"prove":[211],"performance":[213],"compared":[218],"existing":[220],"algorithms.":[221],"maintenance":[229],"6,329,354,613,784,":[232],"query":[233],"processing":[234],"3,522,857,483,566":[237],"execution":[239],"time":[240],"226":[242],"s":[243],"when":[244],"analyzed":[245],"TPC-H":[248],"benchmark":[249],"dataset.":[250]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2023-05-18T00:00:00"}