{"id":"https://openalex.org/W2925250396","doi":"https://doi.org/10.4018/ijoris.2019040101","title":"A Multi-Objective Approach for Materialized View Selection","display_name":"A Multi-Objective Approach for Materialized View Selection","publication_year":2019,"publication_date":"2019-03-21","ids":{"openalex":"https://openalex.org/W2925250396","doi":"https://doi.org/10.4018/ijoris.2019040101","mag":"2925250396"},"language":"en","primary_location":{"id":"doi:10.4018/ijoris.2019040101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijoris.2019040101","pdf_url":null,"source":{"id":"https://openalex.org/S176018216","display_name":"International Journal of Operations Research and Information Systems","issn_l":"1947-9328","issn":["1947-9328","1947-9336"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Operations Research and Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=225812&isxn=9781522566151","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5037554221","display_name":"Jay Prakash","orcid":"https://orcid.org/0000-0002-6167-2412"},"institutions":[{"id":"https://openalex.org/I152429107","display_name":"Jawaharlal Nehru University","ror":"https://ror.org/0567v8t28","country_code":"IN","type":"education","lineage":["https://openalex.org/I152429107"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Jay Prakash","raw_affiliation_strings":["School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, India"],"raw_orcid":"https://orcid.org/0000-0002-6167-2412","affiliations":[{"raw_affiliation_string":"School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, India","institution_ids":["https://openalex.org/I152429107"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5082586952","display_name":"T. V. Vijay Kumar","orcid":"https://orcid.org/0000-0001-7652-903X"},"institutions":[{"id":"https://openalex.org/I152429107","display_name":"Jawaharlal Nehru University","ror":"https://ror.org/0567v8t28","country_code":"IN","type":"education","lineage":["https://openalex.org/I152429107"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"T.V. Vijay Kumar","raw_affiliation_strings":["School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, India","institution_ids":["https://openalex.org/I152429107"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I152429107"],"apc_list":null,"apc_paid":null,"fwci":5.065,"has_fulltext":true,"cited_by_count":16,"citation_normalized_percentile":{"value":0.95646353,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"10","issue":"2","first_page":"1","last_page":"19"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","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/T10538","display_name":"Data Mining Algorithms and Applications","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/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/T11106","display_name":"Data Management and Algorithms","score":0.9973999857902527,"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.8426452875137329},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7617586851119995},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6628584861755371},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.608032763004303},{"id":"https://openalex.org/keywords/pareto-principle","display_name":"Pareto principle","score":0.49060383439064026},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.48820430040359497},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.48474475741386414},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.44068387150764465},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3690558969974518},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.1940099596977234},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.1476350724697113},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11708253622055054},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.11112895607948303},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.08237478137016296}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8426452875137329},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7617586851119995},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6628584861755371},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.608032763004303},{"id":"https://openalex.org/C137635306","wikidata":"https://www.wikidata.org/wiki/Q182667","display_name":"Pareto principle","level":2,"score":0.49060383439064026},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.48820430040359497},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.48474475741386414},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.44068387150764465},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3690558969974518},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.1940099596977234},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.1476350724697113},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11708253622055054},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.11112895607948303},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08237478137016296},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijoris.2019040101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijoris.2019040101","pdf_url":null,"source":{"id":"https://openalex.org/S176018216","display_name":"International Journal of Operations Research and Information Systems","issn_l":"1947-9328","issn":["1947-9328","1947-9336"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Operations Research and Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:joris0:v:10:y:2019:i:2:p:1-19","is_oa":true,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJORIS.2019040101","pdf_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=225812&isxn=9781522566151","source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:RePEc:igg:joris0:v:10:y:2019:i:2:p:1-19","is_oa":true,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJORIS.2019040101","pdf_url":"https://www.igi-global.com/ViewTitle.aspx?TitleId=225812&isxn=9781522566151","source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.7200000286102295,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320320719","display_name":"Department of Science and Technology, Ministry of Science and Technology, India","ror":"https://ror.org/0101xrq71"},{"id":"https://openalex.org/F4320323641","display_name":"Vedeck\u00e1 Grantov\u00e1 Agent\u00fara M\u0160VVa\u0160 SR a SAV","ror":"https://ror.org/044gwpv05"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2925250396.pdf","grobid_xml":"https://content.openalex.org/works/W2925250396.grobid-xml"},"referenced_works_count":57,"referenced_works":["https://openalex.org/W2776818","https://openalex.org/W12572031","https://openalex.org/W38346608","https://openalex.org/W76102122","https://openalex.org/W79561920","https://openalex.org/W188350572","https://openalex.org/W332208005","https://openalex.org/W1482520531","https://openalex.org/W1521939327","https://openalex.org/W1538267625","https://openalex.org/W1541435301","https://openalex.org/W1563141923","https://openalex.org/W1563990524","https://openalex.org/W1581805425","https://openalex.org/W1589975099","https://openalex.org/W1595498733","https://openalex.org/W1620795784","https://openalex.org/W1977786400","https://openalex.org/W1981726942","https://openalex.org/W1995999642","https://openalex.org/W2000196822","https://openalex.org/W2006057663","https://openalex.org/W2017782374","https://openalex.org/W2030148067","https://openalex.org/W2042986967","https://openalex.org/W2046215905","https://openalex.org/W2065907517","https://openalex.org/W2100109822","https://openalex.org/W2100799582","https://openalex.org/W2103201239","https://openalex.org/W2111845378","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2126002471","https://openalex.org/W2132681112","https://openalex.org/W2140066605","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2152150600","https://openalex.org/W2155978299","https://openalex.org/W2188551693","https://openalex.org/W2220793891","https://openalex.org/W2229587172","https://openalex.org/W2274264247","https://openalex.org/W2288602726","https://openalex.org/W2331884292","https://openalex.org/W2412063311","https://openalex.org/W2474281234","https://openalex.org/W2530441558","https://openalex.org/W2570863224","https://openalex.org/W2609163169","https://openalex.org/W2747458874","https://openalex.org/W2809306865","https://openalex.org/W2888941620","https://openalex.org/W4289258943","https://openalex.org/W6634765471","https://openalex.org/W6992659470"],"related_works":["https://openalex.org/W2751504412","https://openalex.org/W2354398425","https://openalex.org/W1493232818","https://openalex.org/W1505830310","https://openalex.org/W2751772240","https://openalex.org/W1564204921","https://openalex.org/W1486410254","https://openalex.org/W2301096354","https://openalex.org/W2361700643","https://openalex.org/W2379870809"],"abstract_inverted_index":{"In":[0,121],"today's":[1],"world,":[2],"business":[3],"transactional":[4,25],"data":[5,26,48,59],"has":[6],"become":[7],"the":[8,29,58,102,145,149,158,164,172,177],"critical":[9],"part":[10],"of":[11,43,68,91,105,110,112,144,181],"all":[12,74],"business-related":[13],"decisions.":[14],"For":[15],"this":[16,122],"purpose,":[17],"complex":[18,38,70],"analytical":[19,71,106,182],"queries":[20,39,183],"have":[21],"been":[22],"run":[23],"on":[24],"to":[27,45,64,80,95,116],"get":[28],"relevant":[30,92],"information,":[31],"from":[32,137],"therein,":[33],"for":[34,98,135],"decision":[35,188],"making.":[36,189],"These":[37],"consume":[40],"a":[41,89,124,138],"lot":[42],"time":[44,104,180],"execute":[46],"as":[47],"is":[49,77,114,129],"spread":[50],"across":[51],"multiple":[52],"disparate":[53],"locations.":[54],"Materializing":[55,73],"views":[56,76,93,113,134,168],"in":[57,187],"warehouse":[60],"can":[61],"be":[62,96,117],"used":[63],"speed":[65],"up":[66],"processing":[67],"these":[69],"queries.":[72,107],"possible":[75],"infeasible":[78],"due":[79],"storage":[81],"space":[82],"constraint":[83],"and":[84,184],"view":[85,152],"maintenance":[86],"cost.":[87],"Hence,":[88],"subset":[90,111],"needs":[94],"selected":[97,169],"materialization":[99,136],"that":[100,131,157],"reduces":[101],"response":[103,179],"Optimal":[108],"selection":[109,153],"shown":[115],"an":[118],"NP-Complete":[119],"problem.":[120],"article,":[123],"non-Pareto":[125],"based":[126],"genetic":[127],"algorithm,":[128,154],"proposed,":[130],"selects":[132],"Top-K":[133],"multidimensional":[139],"lattice.":[140],"An":[141],"experiments-based":[142],"comparison":[143],"proposed":[146,173],"algorithm":[147,174],"with":[148],"most":[150],"fundamental":[151],"HRUA,":[155],"shows":[156],"former":[159],"performs":[160],"comparatively":[161],"better":[162],"than":[163],"latter.":[165],"Thus,":[166],"materializing":[167],"by":[170],"using":[171],"would":[175],"improve":[176],"query":[178],"thereby":[185],"facilitate":[186]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2}],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}