{"id":"https://openalex.org/W2570863224","doi":"https://doi.org/10.4018/ijiit.2017010102","title":"Materialized View Selection using Artificial Bee Colony Optimization","display_name":"Materialized View Selection using Artificial Bee Colony Optimization","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2570863224","doi":"https://doi.org/10.4018/ijiit.2017010102","mag":"2570863224"},"language":"en","primary_location":{"id":"doi:10.4018/ijiit.2017010102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijiit.2017010102","pdf_url":null,"source":{"id":"https://openalex.org/S116626079","display_name":"International Journal of Intelligent Information Technologies","issn_l":"1548-3657","issn":["1548-3657","1548-3665"],"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 Intelligent Information Technologies","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/A5060404559","display_name":"Biri Arun","orcid":null},"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":true,"raw_author_name":"Biri Arun","raw_affiliation_strings":["Jawaharlal Nehru University, School of Computer and Systems Sciences, New Delhi, India"],"affiliations":[{"raw_affiliation_string":"Jawaharlal Nehru University, School of Computer and Systems Sciences, 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":["Jawaharlal Nehru University, School of Computer and Systems Sciences, New Delhi, India"],"affiliations":[{"raw_affiliation_string":"Jawaharlal Nehru University, School of Computer and Systems Sciences, New Delhi, India","institution_ids":["https://openalex.org/I152429107"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5060404559"],"corresponding_institution_ids":["https://openalex.org/I152429107"],"apc_list":null,"apc_paid":null,"fwci":3.108,"has_fulltext":false,"cited_by_count":28,"citation_normalized_percentile":{"value":0.92526546,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"13","issue":"1","first_page":"26","last_page":"49"},"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.998199999332428,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"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.9965999722480774,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.994700014591217,"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/online-analytical-processing","display_name":"Online analytical processing","score":0.9313222169876099},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8759310245513916},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.8496633768081665},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8083935976028442},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6423713564872742},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6306344866752625},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.530885636806488},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5276331305503845},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.47492581605911255},{"id":"https://openalex.org/keywords/response-time","display_name":"Response time","score":0.43949854373931885},{"id":"https://openalex.org/keywords/genetic-algorithm","display_name":"Genetic algorithm","score":0.42270010709762573},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36310529708862305},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33242154121398926},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.21628105640411377},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21159768104553223},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.18891334533691406}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9313222169876099},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8759310245513916},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8496633768081665},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8083935976028442},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6423713564872742},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6306344866752625},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.530885636806488},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5276331305503845},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.47492581605911255},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.43949854373931885},{"id":"https://openalex.org/C8880873","wikidata":"https://www.wikidata.org/wiki/Q187787","display_name":"Genetic algorithm","level":2,"score":0.42270010709762573},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36310529708862305},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33242154121398926},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.21628105640411377},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21159768104553223},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.18891334533691406},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"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/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","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},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijiit.2017010102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijiit.2017010102","pdf_url":null,"source":{"id":"https://openalex.org/S116626079","display_name":"International Journal of Intelligent Information Technologies","issn_l":"1548-3657","issn":["1548-3657","1548-3665"],"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 Intelligent Information Technologies","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jiit00:v:13:y:2017:i:1:p:26-49","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJIIT.2017010102","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","id":"https://metadata.un.org/sdg/16","score":0.7699999809265137}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":84,"referenced_works":["https://openalex.org/W2776818","https://openalex.org/W12572031","https://openalex.org/W38346608","https://openalex.org/W76102122","https://openalex.org/W78817961","https://openalex.org/W79561920","https://openalex.org/W84428182","https://openalex.org/W188350572","https://openalex.org/W1482520531","https://openalex.org/W1482980260","https://openalex.org/W1510891359","https://openalex.org/W1521939327","https://openalex.org/W1544591346","https://openalex.org/W1563141923","https://openalex.org/W1595062593","https://openalex.org/W1606507025","https://openalex.org/W1620795784","https://openalex.org/W1623444038","https://openalex.org/W1629051378","https://openalex.org/W1635132392","https://openalex.org/W1850323027","https://openalex.org/W1963962412","https://openalex.org/W1973705510","https://openalex.org/W1981726942","https://openalex.org/W1986053976","https://openalex.org/W1995595910","https://openalex.org/W2000196822","https://openalex.org/W2000435640","https://openalex.org/W2003519217","https://openalex.org/W2004843387","https://openalex.org/W2006057663","https://openalex.org/W2007249344","https://openalex.org/W2008440502","https://openalex.org/W2016826240","https://openalex.org/W2017426530","https://openalex.org/W2017782374","https://openalex.org/W2020381385","https://openalex.org/W2020393234","https://openalex.org/W2028002822","https://openalex.org/W2033720408","https://openalex.org/W2037063559","https://openalex.org/W2047626401","https://openalex.org/W2051387747","https://openalex.org/W2058600646","https://openalex.org/W2060623431","https://openalex.org/W2061660313","https://openalex.org/W2065907517","https://openalex.org/W2072764742","https://openalex.org/W2086694651","https://openalex.org/W2089916605","https://openalex.org/W2093284687","https://openalex.org/W2100251446","https://openalex.org/W2100799582","https://openalex.org/W2101426101","https://openalex.org/W2103201239","https://openalex.org/W2108971776","https://openalex.org/W2110847724","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2115132667","https://openalex.org/W2124751909","https://openalex.org/W2126002471","https://openalex.org/W2128995918","https://openalex.org/W2134816084","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2147288474","https://openalex.org/W2156554027","https://openalex.org/W2163620558","https://openalex.org/W2164793889","https://openalex.org/W2171926055","https://openalex.org/W2188551693","https://openalex.org/W2220793891","https://openalex.org/W2229587172","https://openalex.org/W2274264247","https://openalex.org/W2287814884","https://openalex.org/W2288602726","https://openalex.org/W2331884292","https://openalex.org/W2380041392","https://openalex.org/W2412063311","https://openalex.org/W2474281234","https://openalex.org/W2530441558","https://openalex.org/W2609163169","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W1988774479","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2381646725"],"abstract_inverted_index":{"Data":[0],"warehouse":[1,42],"is":[2,25,66,89,96,135],"an":[3,67,103,180],"essential":[4],"component":[5],"of":[6,17,28,50,83,166],"almost":[7],"every":[8],"modern":[9],"enterprise":[10],"information":[11],"system.":[12],"It":[13,24],"stores":[14],"huge":[15],"amount":[16],"subject-oriented,":[18],"time-stamped,":[19],"non-volatile":[20],"and":[21,69,120,169],"integrated":[22],"data.":[23],"highly":[26],"required":[27],"the":[29,145,153,162],"system":[30],"to":[31,33,75,91,127],"respond":[32],"complex":[34],"online":[35,51],"analytical":[36,52],"queries":[37,168],"posed":[38],"against":[39],"its":[40],"data":[41],"in":[43,60,173,179],"seconds":[44],"for":[45,87],"efficient":[46,68],"decision":[47],"making.":[48],"Optimization":[49],"query":[53,61,72,77,163],"processing":[54],"(OLAP)":[55],"could":[56],"substantially":[57],"minimize":[58,76],"delays":[59],"response":[62,78,164],"time.":[63,79],"Materialized":[64],"view":[65,93,109,148],"effective":[70,181],"OLAP":[71,167],"optimization":[73],"technique":[74],"Selecting":[80],"a":[81,97,132],"set":[82],"such":[84],"appropriate":[85],"views":[86,130,154],"materialization":[88,159],"referred":[90],"as":[92],"selection,":[94],"which":[95,113],"nontrivial":[98],"task.":[99],"In":[100],"this":[101],"regard,":[102],"Artificial":[104],"Bee":[105],"Colony":[106],"(ABC)":[107],"based":[108,122],"selection":[110,149],"algorithm":[111,150],"(ABCVSA),":[112],"has":[114],"been":[115],"adapted":[116],"by":[117],"incorporating":[118],"N-point":[119,123],"GBFS":[121],"random":[124],"insertion":[125],"operations,":[126],"select":[128],"Top-K":[129],"from":[131],"multidimensional":[133],"lattice":[134],"proposed.":[136],"Experimental":[137],"results":[138],"show":[139],"that":[140],"ABCVSA":[141,157],"performs":[142],"better":[143],"than":[144],"most":[146],"fundamental":[147],"HRUA.":[151],"Thus,":[152],"selected":[155],"using":[156],"on":[158],"would":[160],"reduce":[161],"time":[165],"thereby":[170],"aid":[171],"analysts":[172],"arriving":[174],"at":[175],"strategic":[176],"business":[177],"decisions":[178],"manner.":[182]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}