{"id":"https://openalex.org/W3185986869","doi":"https://doi.org/10.1007/s11042-021-11181-8","title":"Materialized view selection applying differential evolution algorithm combined with ensembled constraint handling techniques","display_name":"Materialized view selection applying differential evolution algorithm combined with ensembled constraint handling techniques","publication_year":2021,"publication_date":"2021-07-16","ids":{"openalex":"https://openalex.org/W3185986869","doi":"https://doi.org/10.1007/s11042-021-11181-8","mag":"3185986869"},"language":"en","primary_location":{"id":"doi:10.1007/s11042-021-11181-8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s11042-021-11181-8","pdf_url":null,"source":{"id":"https://openalex.org/S110206669","display_name":"Multimedia Tools and Applications","issn_l":"1380-7501","issn":["1380-7501","1573-7721"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Multimedia Tools and Applications","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/A5026304638","display_name":"Kavita Sachdeva","orcid":"https://orcid.org/0000-0002-5745-4586"},"institutions":[{"id":"https://openalex.org/I105454292","display_name":"Guru Gobind Singh Indraprastha University","ror":"https://ror.org/034q1za58","country_code":"IN","type":"education","lineage":["https://openalex.org/I105454292"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Kavita Sachdeva","raw_affiliation_strings":["University School of Information, Communication and Technology, \n                           GGS Indraprastha University, New Delhi, 110078, India"],"affiliations":[{"raw_affiliation_string":"University School of Information, Communication and Technology, \n                           GGS Indraprastha University, New Delhi, 110078, India","institution_ids":["https://openalex.org/I105454292"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110784462","display_name":"Anjana Gosain","orcid":null},"institutions":[{"id":"https://openalex.org/I105454292","display_name":"Guru Gobind Singh Indraprastha University","ror":"https://ror.org/034q1za58","country_code":"IN","type":"education","lineage":["https://openalex.org/I105454292"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Anjana Gosain","raw_affiliation_strings":["University School of Information, Communication and Technology, \n                           GGS Indraprastha University, New Delhi, 110078, India"],"affiliations":[{"raw_affiliation_string":"University School of Information, Communication and Technology, \n                           GGS Indraprastha University, New Delhi, 110078, India","institution_ids":["https://openalex.org/I105454292"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5026304638"],"corresponding_institution_ids":["https://openalex.org/I105454292"],"apc_list":null,"apc_paid":null,"fwci":0.4616,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.61175997,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"80","issue":"21-23","first_page":"31619","last_page":"31645"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9993000030517578,"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.9991999864578247,"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/T10538","display_name":"Data Mining Algorithms and Applications","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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8555657267570496},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.7060232162475586},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5414093136787415},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5076783895492554},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4986882209777832},{"id":"https://openalex.org/keywords/differential-evolution","display_name":"Differential evolution","score":0.4886620342731476},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.46147868037223816},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.45879337191581726},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.4334113597869873},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4294581413269043},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4245617985725403},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4053795337677002},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.33914458751678467},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.17785951495170593},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.1763225793838501}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8555657267570496},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.7060232162475586},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5414093136787415},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5076783895492554},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4986882209777832},{"id":"https://openalex.org/C74750220","wikidata":"https://www.wikidata.org/wiki/Q2662197","display_name":"Differential evolution","level":2,"score":0.4886620342731476},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.46147868037223816},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.45879337191581726},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.4334113597869873},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4294581413269043},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4245617985725403},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4053795337677002},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.33914458751678467},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.17785951495170593},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.1763225793838501},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.0},{"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/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"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/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","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/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s11042-021-11181-8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/s11042-021-11181-8","pdf_url":null,"source":{"id":"https://openalex.org/S110206669","display_name":"Multimedia Tools and Applications","issn_l":"1380-7501","issn":["1380-7501","1573-7721"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Multimedia Tools and Applications","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":40,"referenced_works":["https://openalex.org/W10495479","https://openalex.org/W38346608","https://openalex.org/W49898676","https://openalex.org/W208128215","https://openalex.org/W588744243","https://openalex.org/W1511070613","https://openalex.org/W1520432709","https://openalex.org/W1595159159","https://openalex.org/W1981114175","https://openalex.org/W2006057663","https://openalex.org/W2008440502","https://openalex.org/W2017782374","https://openalex.org/W2020393234","https://openalex.org/W2025227784","https://openalex.org/W2066351984","https://openalex.org/W2072764742","https://openalex.org/W2084149434","https://openalex.org/W2088908211","https://openalex.org/W2103201239","https://openalex.org/W2106980278","https://openalex.org/W2107782179","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2121975403","https://openalex.org/W2124751909","https://openalex.org/W2137340504","https://openalex.org/W2140190241","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2151339633","https://openalex.org/W2151554678","https://openalex.org/W2156554027","https://openalex.org/W2161029074","https://openalex.org/W2165109867","https://openalex.org/W2167580870","https://openalex.org/W2334474926","https://openalex.org/W2768181028","https://openalex.org/W3102018295","https://openalex.org/W4247974938","https://openalex.org/W4289258943"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W2348265434","https://openalex.org/W2108498730","https://openalex.org/W2142569422","https://openalex.org/W2087983779","https://openalex.org/W152305489","https://openalex.org/W1635132392"],"abstract_inverted_index":null,"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}