{"id":"https://openalex.org/W3033036590","doi":"https://doi.org/10.1109/access.2020.3000139","title":"A Novel Optimized Case-Based Reasoning Approach With K-Means Clustering and Genetic Algorithm for Predicting Multi-Class Workload Characterization in Autonomic Database and Data Warehouse System","display_name":"A Novel Optimized Case-Based Reasoning Approach With K-Means Clustering and Genetic Algorithm for Predicting Multi-Class Workload Characterization in Autonomic Database and Data Warehouse System","publication_year":2020,"publication_date":"2020-01-01","ids":{"openalex":"https://openalex.org/W3033036590","doi":"https://doi.org/10.1109/access.2020.3000139","mag":"3033036590"},"language":"en","primary_location":{"id":"doi:10.1109/access.2020.3000139","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2020.3000139","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8948470/09108249.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://ieeexplore.ieee.org/ielx7/6287639/8948470/09108249.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5059575970","display_name":"Nusrat Shaheen","orcid":"https://orcid.org/0000-0002-3010-2150"},"institutions":[{"id":"https://openalex.org/I16076960","display_name":"COMSATS University Islamabad","ror":"https://ror.org/00nqqvk19","country_code":"PK","type":"education","lineage":["https://openalex.org/I16076960"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Nusrat Shaheen","raw_affiliation_strings":["Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad, Pakistan","Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad 45550, Pakistan"],"raw_orcid":"https://orcid.org/0000-0002-3010-2150","affiliations":[{"raw_affiliation_string":"Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad, Pakistan","institution_ids":["https://openalex.org/I16076960"]},{"raw_affiliation_string":"Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad 45550, Pakistan","institution_ids":["https://openalex.org/I16076960"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081280784","display_name":"Basit Raza","orcid":"https://orcid.org/0000-0001-6711-2363"},"institutions":[{"id":"https://openalex.org/I16076960","display_name":"COMSATS University Islamabad","ror":"https://ror.org/00nqqvk19","country_code":"PK","type":"education","lineage":["https://openalex.org/I16076960"]}],"countries":["PK"],"is_corresponding":true,"raw_author_name":"Basit Raza","raw_affiliation_strings":["Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad, Pakistan","Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad 45550, Pakistan"],"raw_orcid":"https://orcid.org/0000-0001-6711-2363","affiliations":[{"raw_affiliation_string":"Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad, Pakistan","institution_ids":["https://openalex.org/I16076960"]},{"raw_affiliation_string":"Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad 45550, Pakistan","institution_ids":["https://openalex.org/I16076960"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101954987","display_name":"Ahmad Raza Shahid","orcid":"https://orcid.org/0000-0002-7520-6770"},"institutions":[{"id":"https://openalex.org/I16076960","display_name":"COMSATS University Islamabad","ror":"https://ror.org/00nqqvk19","country_code":"PK","type":"education","lineage":["https://openalex.org/I16076960"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Ahmad Raza Shahid","raw_affiliation_strings":["Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad, Pakistan","Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad 45550, Pakistan"],"raw_orcid":"https://orcid.org/0000-0002-7520-6770","affiliations":[{"raw_affiliation_string":"Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad, Pakistan","institution_ids":["https://openalex.org/I16076960"]},{"raw_affiliation_string":"Department of Computer Science, COMSATS University Islamabad (CUI), Islamabad 45550, Pakistan","institution_ids":["https://openalex.org/I16076960"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090343976","display_name":"Hani Alquhayz","orcid":"https://orcid.org/0000-0001-8445-7742"},"institutions":[{"id":"https://openalex.org/I195631090","display_name":"Majmaah University","ror":"https://ror.org/01mcrnj60","country_code":"SA","type":"education","lineage":["https://openalex.org/I195631090"]}],"countries":["SA"],"is_corresponding":false,"raw_author_name":"Hani Alquhayz","raw_affiliation_strings":["Department of Computer Science and Information, College of Science in Zulfi, Majmaah University, Al-Majmaah, Saudi Arabia","Department of Computer Science and Information, College of Science in Zulfi, Majmaah University, Al-Majmaah 11952, Saudi Arabia"],"raw_orcid":"https://orcid.org/0000-0001-8445-7742","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Information, College of Science in Zulfi, Majmaah University, Al-Majmaah, Saudi Arabia","institution_ids":["https://openalex.org/I195631090"]},{"raw_affiliation_string":"Department of Computer Science and Information, College of Science in Zulfi, Majmaah University, Al-Majmaah 11952, Saudi Arabia","institution_ids":["https://openalex.org/I195631090"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5081280784"],"corresponding_institution_ids":["https://openalex.org/I16076960"],"apc_list":{"value":1850,"currency":"USD","value_usd":1850},"apc_paid":{"value":1850,"currency":"USD","value_usd":1850},"fwci":1.043,"has_fulltext":true,"cited_by_count":12,"citation_normalized_percentile":{"value":0.81943704,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"8","issue":null,"first_page":"105713","last_page":"105727"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T12761","display_name":"Data Stream Mining Techniques","score":0.996399998664856,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.993399977684021,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9933000206947327,"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/workload","display_name":"Workload","score":0.8200839757919312},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.8032331466674805},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7930641174316406},{"id":"https://openalex.org/keywords/cluster-analysis","display_name":"Cluster analysis","score":0.6651024222373962},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5431907773017883},{"id":"https://openalex.org/keywords/genetic-algorithm","display_name":"Genetic algorithm","score":0.4754340648651123},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4435533583164215},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4395443797111511},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.4312559962272644},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.429458349943161},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.30942869186401367},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.2946571707725525},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.29314756393432617},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.25955116748809814},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.0978204607963562}],"concepts":[{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.8200839757919312},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.8032331466674805},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7930641174316406},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.6651024222373962},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5431907773017883},{"id":"https://openalex.org/C8880873","wikidata":"https://www.wikidata.org/wiki/Q187787","display_name":"Genetic algorithm","level":2,"score":0.4754340648651123},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4435533583164215},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4395443797111511},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.4312559962272644},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.429458349943161},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.30942869186401367},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.2946571707725525},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.29314756393432617},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.25955116748809814},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0978204607963562}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/access.2020.3000139","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2020.3000139","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8948470/09108249.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:9c16f0e466f143498a54f86b747ebecc","is_oa":true,"landing_page_url":"https://doaj.org/article/9c16f0e466f143498a54f86b747ebecc","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"IEEE Access, Vol 8, Pp 105713-105727 (2020)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1109/access.2020.3000139","is_oa":true,"landing_page_url":"https://doi.org/10.1109/access.2020.3000139","pdf_url":"https://ieeexplore.ieee.org/ielx7/6287639/8948470/09108249.pdf","source":{"id":"https://openalex.org/S2485537415","display_name":"IEEE Access","issn_l":"2169-3536","issn":["2169-3536"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Access","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3033036590.pdf","grobid_xml":"https://content.openalex.org/works/W3033036590.grobid-xml"},"referenced_works_count":38,"referenced_works":["https://openalex.org/W32689398","https://openalex.org/W1479758699","https://openalex.org/W1505991794","https://openalex.org/W1507724384","https://openalex.org/W1565746575","https://openalex.org/W1918608199","https://openalex.org/W2009120315","https://openalex.org/W2026024369","https://openalex.org/W2064449033","https://openalex.org/W2079648353","https://openalex.org/W2127209666","https://openalex.org/W2133232294","https://openalex.org/W2156988719","https://openalex.org/W2158502128","https://openalex.org/W2167454987","https://openalex.org/W2257437519","https://openalex.org/W2295101122","https://openalex.org/W2303238616","https://openalex.org/W2331344729","https://openalex.org/W2560531208","https://openalex.org/W2582355770","https://openalex.org/W2766474394","https://openalex.org/W2767559763","https://openalex.org/W2776428598","https://openalex.org/W2790415032","https://openalex.org/W2799015892","https://openalex.org/W2799995494","https://openalex.org/W2892076037","https://openalex.org/W2908959329","https://openalex.org/W2997672980","https://openalex.org/W3006962611","https://openalex.org/W3009499317","https://openalex.org/W3013995528","https://openalex.org/W3017276009","https://openalex.org/W6630531358","https://openalex.org/W6648812800","https://openalex.org/W6698199933","https://openalex.org/W6758414931"],"related_works":["https://openalex.org/W2980304303","https://openalex.org/W3115756817","https://openalex.org/W4213297968","https://openalex.org/W2372588967","https://openalex.org/W2348308981","https://openalex.org/W144220414","https://openalex.org/W2035309212","https://openalex.org/W289877171","https://openalex.org/W2084266952","https://openalex.org/W2362400912"],"abstract_inverted_index":{"Data":[0],"management":[1,37],"systems":[2,68,75],"are":[3,222,242],"essential":[4],"elements":[5,202],"for":[6,35,174,214,271],"any":[7],"organization":[8],"which":[9],"is":[10,45,102,130,153,212,229],"dealing":[11],"with":[12,56,59,194,278],"large":[13],"volume":[14],"of":[15,48,66,86,114,119,191,203,236,274],"data":[16,24,92],"now":[17],"a":[18,46,50,87,122,149,155,164],"days.":[19],"Due":[20],"to":[21,39,148,200,244,264],"increase":[22],"in":[23,136,224,231,260,276],"volume,":[25],"and":[26,91,111,128,197,218,233,252],"its":[27,41],"complexities,":[28],"it":[29,199,246],"has":[30],"become":[31],"more":[32,156],"challenging":[33,157],"job":[34],"workload":[36,79,85,120,142,178,219],"system":[38,51,94],"maintain":[40],"performance.":[42],"So,":[43],"there":[44],"need":[47],"such":[49,57,125],"that":[52,101,146,255,287,289],"can":[53,69,95],"autonomically":[54,175],"deal":[55],"complexities":[58],"less":[60],"or":[61],"without":[62],"human":[63],"involvement.":[64],"Performance":[65],"these":[67],"be":[70,96],"improved":[71],"by":[72],"making":[73],"the":[74,78,82,137,141,177,185,201,256,272,284,290,296],"well-aware":[76],"about":[77],"entering":[80,183],"into":[81,98,121,143,179,184],"system.":[83,186],"The":[84],"prevalent":[88],"typical":[89],"database":[90],"warehouse":[93],"characterized":[97],"three":[99,144],"types":[100,145,181,220],"Online":[103],"Transaction":[104],"Processing":[105],"(OLTP),":[106],"Decision":[107],"Support":[108],"Systems":[109],"(DSS)":[110],"Mixed":[112],"type":[113],"workload.":[115],"Currently,":[116],"autonomic":[117,204,239],"characterization":[118],"binary":[123],"class":[124],"as":[126,134,262,295],"OLTP":[127],"DSS":[129],"being":[131],"carried":[132],"out":[133,294],"reported":[135],"literature,":[138],"however,":[139],"characterizing":[140,176],"refers":[147],"multi-class":[150,180],"classification":[151],"problem":[152],"relatively":[154],"task.":[158],"In":[159,207],"this":[160],"study,":[161],"we":[162],"propose":[163],"novel":[165],"optimized":[166],"Case-based":[167],"Reasoning":[168],"(CBR)":[169],"approach":[170],"based":[171],"on":[172],"clustering":[173,211],"before":[182],"We":[187,248,267],"implement":[188],"four":[189],"phases":[190],"CBR":[192],"along":[193],"case-base":[195],"generation":[196],"map":[198],"MAPE-K":[205],"model.":[206],"Retrieve":[208],"phase,":[209],"k-means":[210],"used":[213,230],"enhancing":[215],"retrieval":[216],"efficiency":[217],"predictions":[221],"made":[223],"Reuse":[225],"phase.":[226],"Genetic":[227],"Algorithm":[228],"Revise":[232],"Adapt":[234],"phase":[235],"CBR.":[237],"Few":[238],"self_*":[240],"characteristics":[241],"incorporated":[243],"make":[245],"autonomic.":[247],"performed":[249,268],"various":[250],"experiments":[251],"results":[253,275],"show":[254,288],"proposed":[257,291],"model":[258,292],"outperforms":[259],"prediction":[261],"compared":[263],"existing":[265],"approaches.":[266],"post-hoc":[269],"test":[270,286],"validation":[273],"comparison":[277],"other":[279],"machine":[280],"learning":[281],"classifiers":[282],"using":[283],"Friedman":[285],"stands":[293],"best":[297],"classifier.":[298]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}