{"id":"https://openalex.org/W2923804366","doi":"https://doi.org/10.4018/ijncr.2019040101","title":"Handling Constraints Using Penalty Functions in Materialized View Selection","display_name":"Handling Constraints Using Penalty Functions in Materialized View Selection","publication_year":2019,"publication_date":"2019-03-21","ids":{"openalex":"https://openalex.org/W2923804366","doi":"https://doi.org/10.4018/ijncr.2019040101","mag":"2923804366"},"language":"en","primary_location":{"id":"doi:10.4018/ijncr.2019040101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijncr.2019040101","pdf_url":null,"source":{"id":"https://openalex.org/S1001844925","display_name":"International Journal of Natural Computing Research","issn_l":"1947-928X","issn":["1947-928X","1947-9298"],"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 Natural Computing Research","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/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":["USICT, GGSIPU, New Delhi, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"USICT, GGSIPU, New Delhi, India","institution_ids":["https://openalex.org/I105454292"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026304638","display_name":"Kavita Sachdeva","orcid":"https://orcid.org/0000-0002-5745-4586"},"institutions":[{"id":"https://openalex.org/I3130021832","display_name":"Shree Guru Gobind Singh Tricentenary University","ror":"https://ror.org/04kf25f32","country_code":"IN","type":"education","lineage":["https://openalex.org/I3130021832"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Kavita Sachdeva","raw_affiliation_strings":["SGT University, Gurugram, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SGT University, Gurugram, India","institution_ids":["https://openalex.org/I3130021832"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3272,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.52174459,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"8","issue":"2","first_page":"1","last_page":"17"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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.9998000264167786,"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.9995999932289124,"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.9966999888420105,"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.8208017349243164},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.7680913209915161},{"id":"https://openalex.org/keywords/penalty-method","display_name":"Penalty method","score":0.7508562803268433},{"id":"https://openalex.org/keywords/backtracking","display_name":"Backtracking","score":0.6971479654312134},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.6626137495040894},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6109293699264526},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.49226441979408264},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.4539657533168793},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4167085587978363},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3406006097793579},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.265880286693573},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2250952124595642},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11447316408157349},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.10936325788497925}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8208017349243164},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.7680913209915161},{"id":"https://openalex.org/C6180225","wikidata":"https://www.wikidata.org/wiki/Q3411771","display_name":"Penalty method","level":2,"score":0.7508562803268433},{"id":"https://openalex.org/C156884757","wikidata":"https://www.wikidata.org/wiki/Q798554","display_name":"Backtracking","level":2,"score":0.6971479654312134},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.6626137495040894},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6109293699264526},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.49226441979408264},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.4539657533168793},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4167085587978363},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3406006097793579},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.265880286693573},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2250952124595642},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11447316408157349},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.10936325788497925},{"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/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijncr.2019040101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijncr.2019040101","pdf_url":null,"source":{"id":"https://openalex.org/S1001844925","display_name":"International Journal of Natural Computing Research","issn_l":"1947-928X","issn":["1947-928X","1947-9298"],"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 Natural Computing Research","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jncr00:v:8:y:2019:i:2:p:1-17","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJNCR.2019040101","pdf_url":null,"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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.6800000071525574,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W2776818","https://openalex.org/W38346608","https://openalex.org/W79561920","https://openalex.org/W192938905","https://openalex.org/W208128215","https://openalex.org/W213183518","https://openalex.org/W588744243","https://openalex.org/W1482520531","https://openalex.org/W1520432709","https://openalex.org/W1533733105","https://openalex.org/W1573534773","https://openalex.org/W1591000919","https://openalex.org/W1595062593","https://openalex.org/W1620795784","https://openalex.org/W1635132392","https://openalex.org/W1793365533","https://openalex.org/W1816087582","https://openalex.org/W1971491582","https://openalex.org/W1987092188","https://openalex.org/W2006057663","https://openalex.org/W2017782374","https://openalex.org/W2020393234","https://openalex.org/W2025227784","https://openalex.org/W2088908211","https://openalex.org/W2089916605","https://openalex.org/W2100109822","https://openalex.org/W2103201239","https://openalex.org/W2104324382","https://openalex.org/W2105797904","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2121975403","https://openalex.org/W2124751909","https://openalex.org/W2126269902","https://openalex.org/W2128055706","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2147288474","https://openalex.org/W2151339633","https://openalex.org/W2156554027","https://openalex.org/W2167580870","https://openalex.org/W2185691065","https://openalex.org/W2307155028","https://openalex.org/W2334474926","https://openalex.org/W2415856871","https://openalex.org/W2474281234","https://openalex.org/W2551651401","https://openalex.org/W2611025146","https://openalex.org/W2891557719","https://openalex.org/W3102018295","https://openalex.org/W4247974938","https://openalex.org/W6638513500"],"related_works":["https://openalex.org/W2125738398","https://openalex.org/W2797440583","https://openalex.org/W2248831950","https://openalex.org/W2349550597","https://openalex.org/W1999594162","https://openalex.org/W3156363426","https://openalex.org/W2942097156","https://openalex.org/W1564408968","https://openalex.org/W175663584","https://openalex.org/W2092977233"],"abstract_inverted_index":{"Materialized":[0],"view":[1],"selection":[2],"(MVS)":[3],"plays":[4],"a":[5,13],"vital":[6],"role":[7],"for":[8,52,64],"efficiently":[9],"making":[10],"decisions":[11],"in":[12,96,146],"data":[14],"warehouse.":[15],"This":[16],"problem":[17,112],"is":[18],"NP-hard":[19],"and":[20,31,45,55,78,103,108,118,139,142],"constrained":[21],"optimization":[22],"problem.":[23],"The":[24,87,126],"authors":[25,127],"have":[26,49],"handled":[27],"both":[28],"the":[29,66,75,84,93,105,111,115,121,155],"space":[30,85],"maintenance":[32],"cost":[33,102,153],"constraint":[34],"using":[35],"penalty":[36,39,47,80,89],"functions.":[37],"Three":[38],"function":[40,90],"methods":[41],"i.e.":[42,137],"static,":[43,76],"dynamic":[44,77],"adaptive":[46,79,88],"functions":[48,81],"been":[50,62,131],"used":[51,63],"handling":[53],"constraints":[54],"Backtracking":[56],"Search":[57],"Optimization":[58],"algorithm":[59,141],"(BSA)":[60],"has":[61,130],"optimizing":[65],"total":[67,150],"query":[68,100,151],"processing":[69,101,152],"cost.":[70],"Experiments":[71],"were":[72],"conducted":[73],"comparing":[74],"on":[82,113,119],"varying":[83,114],"constraint.":[86],"method":[91],"yields":[92,143],"best":[94],"results":[95,145],"terms":[97,147],"of":[98,110,123,148,154],"minimum":[99,149],"achieves":[104],"optimality,":[106],"scalability":[107],"feasibility":[109],"lattice":[116],"dimensions":[117],"increasing":[120],"number":[122],"user":[124],"queries.":[125],"proposed":[128],"work":[129],"compared":[132],"with":[133],"other":[134],"evolutionary":[135],"algorithms":[136],"PSO":[138],"genetic":[140],"better":[144],"materialized":[156],"views.":[157]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2026-06-11T06:19:23.411458","created_date":"2025-10-10T00:00:00"}