{"id":"https://openalex.org/W3195848939","doi":"https://doi.org/10.3233/jifs-202821","title":"Optimized execution method for queries with materialized views: Design and implementation","display_name":"Optimized execution method for queries with materialized views: Design and implementation","publication_year":2021,"publication_date":"2021-08-13","ids":{"openalex":"https://openalex.org/W3195848939","doi":"https://doi.org/10.3233/jifs-202821","mag":"3195848939"},"language":"en","primary_location":{"id":"doi:10.3233/jifs-202821","is_oa":false,"landing_page_url":"https://doi.org/10.3233/jifs-202821","pdf_url":null,"source":{"id":"https://openalex.org/S179157397","display_name":"Journal of Intelligent & Fuzzy Systems","issn_l":"1064-1246","issn":["1064-1246","1875-8967"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent & Fuzzy 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/A5076716328","display_name":"Abhijeet R. Raipurkar","orcid":"https://orcid.org/0000-0003-2327-8358"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Abhijeet R. Raipurkar","raw_affiliation_strings":["ShriRamdeobaba College of Engineering and Management, Gittikhadan, Nagpur"],"affiliations":[{"raw_affiliation_string":"ShriRamdeobaba College of Engineering and Management, Gittikhadan, Nagpur","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5005115148","display_name":"Manoj B. Chandak","orcid":"https://orcid.org/0000-0002-0103-4224"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Manoj B. Chandak","raw_affiliation_strings":["ShriRamdeobaba College of Engineering and Management, Gittikhadan, Nagpur"],"affiliations":[{"raw_affiliation_string":"ShriRamdeobaba College of Engineering and Management, Gittikhadan, Nagpur","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5076716328"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.1017,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.82615006,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"41","issue":"6","first_page":"6191","last_page":"6205"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991999864578247,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991999864578247,"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/T10273","display_name":"IoT and Edge/Fog Computing","score":0.9936000108718872,"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/T11106","display_name":"Data Management and Algorithms","score":0.9934999942779541,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.8866316676139832},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8836302161216736},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7508816719055176},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6634726524353027},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.633783757686615},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.603279709815979},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.603008508682251},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5395026206970215},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.49148595333099365},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.47944799065589905},{"id":"https://openalex.org/keywords/simulated-annealing","display_name":"Simulated annealing","score":0.47718632221221924},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.46381279826164246},{"id":"https://openalex.org/keywords/response-time","display_name":"Response time","score":0.46177351474761963},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.4421405792236328},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.42725038528442383},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4234156608581543},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3939054012298584},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3786226511001587},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3205433487892151},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.2664142847061157},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.20676419138908386},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.20409688353538513},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.09143540263175964}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8866316676139832},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8836302161216736},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7508816719055176},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6634726524353027},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.633783757686615},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.603279709815979},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.603008508682251},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5395026206970215},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.49148595333099365},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.47944799065589905},{"id":"https://openalex.org/C126980161","wikidata":"https://www.wikidata.org/wiki/Q863783","display_name":"Simulated annealing","level":2,"score":0.47718632221221924},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.46381279826164246},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.46177351474761963},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4421405792236328},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.42725038528442383},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4234156608581543},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3939054012298584},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3786226511001587},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3205433487892151},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.2664142847061157},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.20676419138908386},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.20409688353538513},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.09143540263175964},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/jifs-202821","is_oa":false,"landing_page_url":"https://doi.org/10.3233/jifs-202821","pdf_url":null,"source":{"id":"https://openalex.org/S179157397","display_name":"Journal of Intelligent & Fuzzy Systems","issn_l":"1064-1246","issn":["1064-1246","1875-8967"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent & Fuzzy Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.9200000166893005,"display_name":"Affordable and clean energy","id":"https://metadata.un.org/sdg/7"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":39,"referenced_works":["https://openalex.org/W909297397","https://openalex.org/W1965015069","https://openalex.org/W1967901697","https://openalex.org/W1986178474","https://openalex.org/W1988774479","https://openalex.org/W1998840913","https://openalex.org/W2006007226","https://openalex.org/W2014445347","https://openalex.org/W2018734416","https://openalex.org/W2021876375","https://openalex.org/W2026843124","https://openalex.org/W2056213438","https://openalex.org/W2061439717","https://openalex.org/W2062671376","https://openalex.org/W2065907517","https://openalex.org/W2081417442","https://openalex.org/W2087869882","https://openalex.org/W2089603131","https://openalex.org/W2096011757","https://openalex.org/W2143334744","https://openalex.org/W2179316847","https://openalex.org/W2220793891","https://openalex.org/W2283591667","https://openalex.org/W2468313013","https://openalex.org/W2468703436","https://openalex.org/W2609163169","https://openalex.org/W2792920932","https://openalex.org/W2809306865","https://openalex.org/W2890919505","https://openalex.org/W2922464275","https://openalex.org/W2939524222","https://openalex.org/W3003462408","https://openalex.org/W3033427183","https://openalex.org/W3082758363","https://openalex.org/W3092601902","https://openalex.org/W3138130029","https://openalex.org/W6681579804","https://openalex.org/W6719806161","https://openalex.org/W6980006592"],"related_works":["https://openalex.org/W3156363426","https://openalex.org/W2367311391","https://openalex.org/W3187848584","https://openalex.org/W2924854563","https://openalex.org/W2292457537","https://openalex.org/W3142323224","https://openalex.org/W2368479705","https://openalex.org/W3195848939","https://openalex.org/W3147906396","https://openalex.org/W185219737"],"abstract_inverted_index":{"A":[0],"query":[1,31,93,178,211,228,239],"application":[2],"for":[3],"On-Line":[4],"Analytical":[5],"Processing":[6],"(OLAP)":[7],"examines":[8],"various":[9,54],"kinds":[10],"of":[11,30,48,61,84,89,106,147,176,221,237],"data":[12,155],"stored":[13],"in":[14,38,53,195,226],"a":[15,46,82,199],"Data":[16],"Warehouse":[17],"(DW).":[18],"There":[19],"have":[20,126,131],"been":[21,127,132],"no":[22],"systematic":[23],"studies":[24],"that":[25],"look":[26],"at":[27],"the":[28,58,71,85,90,103,145,154,174,210,214,218,232,235,238,258,266],"impact":[29],"optimizations":[32],"on":[33,182,251],"performance":[34,236,260],"and":[35,40,56,79,129,139,180,212,242,246,255,263],"energy":[36,59],"consumption":[37],"relational":[39],"NoSQL":[41],"databases.":[42],"Indeed,":[43],"due":[44,135],"to":[45,136,152,167,208,265],"lack":[47],"precise":[49],"power":[50],"calculation":[51],"techniques":[52],"databases":[55],"queries,":[57],"activity":[60],"several":[62],"basic":[63],"database":[64,124],"operations":[65],"is":[66,163],"mostly":[67],"unknown,":[68],"as":[69,111,113,142,144],"are":[70,75,96],"queries":[72,108,130],"themselves,":[73],"which":[74],"very":[76],"complicated,":[77],"extensive,":[78],"exploratory.":[80],"As":[81],"result":[83],"rapidly":[86],"growing":[87],"size":[88],"DW":[91],"system,":[92],"response":[94,104,229],"times":[95],"regularly":[97],"increasing.":[98],"To":[99,115],"improve":[100],"decision-making":[101],"performance,":[102],"time":[105,241],"such":[107],"should":[109],"be":[110],"short":[112],"possible.":[114],"resolve":[116],"these":[117,169],"issues,":[118,170],"multiple":[119],"materialized":[120,183],"views":[121,162,184,222],"from":[122],"individual":[123],"tables":[125],"collected,":[128],"handled.":[133],"Similarly,":[134],"overall":[137],"maintenance":[138],"storage":[140,156],"expenses,":[141],"well":[143],"selection":[146],"an":[148],"optimal":[149,219],"view":[150],"set":[151],"increase":[153],"facility\u2019s":[157],"efficacy,":[158],"materializing":[159],"all":[160],"conceivable":[161],"not":[164],"viable.":[165],"Thus,":[166],"overcome":[168],"this":[171],"paper":[172],"proposed":[173],"method":[175],"energy-aware":[177],"optimization":[179],"processing,":[181],"using":[185],"enhanced":[186,227],"simulated":[187],"annealing":[188],"(EAQO-ESA).":[189],"This":[190],"work":[191],"was":[192,206,261],"carried":[193],"out":[194],"four":[196],"stages.":[197],"First,":[198],"Simulated":[200],"Annealing":[201],"(SA)":[202],"based":[203,250],"meta-heuristic":[204],"approach":[205],"used":[207],"pre-process":[209],"optimize":[213],"scheduling":[215],"performance.":[216],"Second,":[217],"sets":[220],"were":[223],"materialized,":[224],"resulting":[225],"efficiency.":[230],"Third,":[231],"authors":[233],"assessed":[234],"execution":[240],"computational":[243],"complexity":[244],"with":[245],"without":[247],"optimization.":[248],"Finally,":[249],"processing":[252],"time,":[253],"efficiency,":[254],"computing":[256],"cost,":[257],"system\u2019s":[259],"validated":[262],"compared":[264],"traditional":[267],"technique.":[268]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}