{"id":"https://openalex.org/W7225319345","doi":"https://doi.org/10.65725/jcise/2/4/008","title":"EXPLAINABLE CNN-BASED CLASSIFICATION OF HETEROGENEOUS DATABASE WORKLOADS USING RUNTIME PERFORMANCE FEATURES","display_name":"EXPLAINABLE CNN-BASED CLASSIFICATION OF HETEROGENEOUS DATABASE WORKLOADS USING RUNTIME PERFORMANCE FEATURES","publication_year":2026,"publication_date":"2026-11-05","ids":{"openalex":"https://openalex.org/W7225319345","doi":"https://doi.org/10.65725/jcise/2/4/008"},"language":"en","primary_location":{"id":"doi:10.65725/jcise/2/4/008","doi":"https://doi.org/10.65725/jcise/2/4/008","is_oa":false,"landing_page_url":"https://doi.org/10.65725/jcise/2/4/008","pdf_url":null,"source":{"id":"https://openalex.org/S5407055385","display_name":"RCHUB JOURNAL OF COMPUTATIONAL INTELLIGENCE SCIENCE AND ENGINEERING (JCISE)","issn_l":"3107-8168","issn":["3107-8168"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"RCHUB JOURNAL OF COMPUTATIONAL INTELLIGENCE SCIENCE AND ENGINEERING (JCISE)","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"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/A5056991313","display_name":"K. Jaya Bharathi","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"K. Jaya Bharathi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5160983031","display_name":"Dr. S. Krishna Mohan Rao","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dr. S. Krishna Mohan Rao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"2","issue":"4","first_page":"89","last_page":"89"},"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.9657999873161316,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9657999873161316,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.006599999964237213,"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/T12127","display_name":"Software System Performance and Reliability","score":0.005400000140070915,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/heterogeneous-workloads","display_name":"heterogeneous workloads","score":0.9020000100135803},{"id":"https://openalex.org/keywords/explainable-machine-learning","display_name":"explainable machine learning","score":0.7540000081062317},{"id":"https://openalex.org/keywords/convolutional-neural-networks","display_name":"convolutional neural networks","score":0.9700000286102295},{"id":"https://openalex.org/keywords/shap","display_name":"SHAP","score":0.8849999904632568},{"id":"https://openalex.org/keywords/query-execution-time","display_name":"query execution time","score":0.7940000295639038},{"id":"https://openalex.org/keywords/adaptive-query-processing","display_name":"adaptive query processing","score":0.6660000085830688},{"id":"https://openalex.org/keywords/database-optimization","display_name":"database optimization","score":0.7250000238418579},{"id":"https://openalex.org/keywords/tpc-h","display_name":"TPC-H","score":0.9049999713897705},{"id":"https://openalex.org/keywords/tpc-ds","display_name":"TPC-DS","score":0.9309999942779541},{"id":"https://openalex.org/keywords/interpretability","display_name":"interpretability","score":0.5009999871253967}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8659999966621399},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6876999735832214},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5393999814987183},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5072000026702881},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4230000078678131},{"id":"https://openalex.org/C12267149","wikidata":"https://www.wikidata.org/wiki/Q282453","display_name":"Support vector machine","level":2,"score":0.4108000099658966},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.4049000144004822},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.399399995803833},{"id":"https://openalex.org/C12426560","wikidata":"https://www.wikidata.org/wiki/Q189569","display_name":"Basis (linear algebra)","level":2,"score":0.3873000144958496},{"id":"https://openalex.org/C81363708","wikidata":"https://www.wikidata.org/wiki/Q17084460","display_name":"Convolutional neural network","level":2,"score":0.3767000138759613},{"id":"https://openalex.org/C50644808","wikidata":"https://www.wikidata.org/wiki/Q192776","display_name":"Artificial neural network","level":2,"score":0.3610999882221222},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.35580000281333923},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.33009999990463257},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.32179999351501465},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.3165000081062317},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.31060001254081726},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.30959999561309814},{"id":"https://openalex.org/C179799912","wikidata":"https://www.wikidata.org/wiki/Q205084","display_name":"Computational complexity theory","level":2,"score":0.3046000003814697},{"id":"https://openalex.org/C29202148","wikidata":"https://www.wikidata.org/wiki/Q287260","display_name":"Resource allocation","level":2,"score":0.3012000024318695},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.28189998865127563},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.28139999508857727},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.2802000045776367},{"id":"https://openalex.org/C2777115002","wikidata":"https://www.wikidata.org/wiki/Q7168246","display_name":"Performance prediction","level":2,"score":0.2671999931335449},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.26660001277923584},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.2556000053882599},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.25360000133514404},{"id":"https://openalex.org/C110083411","wikidata":"https://www.wikidata.org/wiki/Q1744628","display_name":"Statistical classification","level":2,"score":0.25029999017715454}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.65725/jcise/2/4/008","doi":"https://doi.org/10.65725/jcise/2/4/008","is_oa":false,"landing_page_url":"https://doi.org/10.65725/jcise/2/4/008","pdf_url":null,"source":{"id":"https://openalex.org/S5407055385","display_name":"RCHUB JOURNAL OF COMPUTATIONAL INTELLIGENCE SCIENCE AND ENGINEERING (JCISE)","issn_l":"3107-8168","issn":["3107-8168"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"RCHUB JOURNAL OF COMPUTATIONAL INTELLIGENCE SCIENCE AND ENGINEERING (JCISE)","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W2970148517","https://openalex.org/W3119448165","https://openalex.org/W4221142004","https://openalex.org/W4379261288"],"related_works":["https://openalex.org/W2026024369","https://openalex.org/W2316326038","https://openalex.org/W4323294158","https://openalex.org/W2167454987","https://openalex.org/W7132844025","https://openalex.org/W1963942472","https://openalex.org/W1507724384","https://openalex.org/W2143524712","https://openalex.org/W2095458406","https://openalex.org/W2182561294"],"abstract_inverted_index":{"The":[0,82,180],"current":[1],"database":[2,37,59],"management":[3],"systems":[4],"handle":[5],"heterogeneous":[6,58],"workloads,":[7,168],"such":[8,66,145],"as":[9,67,146],"transactional,":[10],"analytical,":[11],"reporting,":[12],"and":[13,22,38,80,87,118,136,154,158,189,193,202],"mixed":[14],"workloads":[15,28,60,174],"that":[16,113,175],"have":[17],"varied":[18],"patterns":[19],"of":[20,27,35,129,197,204],"execution":[21,69],"resource":[23],"demands.":[24],"Proper":[25],"classification":[26,120,134,192],"can":[29],"be":[30,164],"used":[31,105,165],"to":[32,56,95,106,115,142,163,185],"monitor":[33],"performance":[34,64],"the":[36,45,111,127,177,187,195,205],"optimize":[39],"it":[40],"based":[41,61],"on":[42,62],"workload.":[43],"In":[44],"paper,":[46],"a":[47,92],"explainable":[48],"Convolutional":[49],"Neural":[50],"Network":[51],"(CNN)-based":[52],"model":[53,94,176],"is":[54,104,124,140],"proposed":[55,181],"classify":[57],"runtime":[63],"characteristics,":[65],"query":[68,78,200],"time,":[70],"CPU":[71],"use,":[72,74],"memory":[73],"disk":[75],"input/output":[76],"activity,":[77],"complexity":[79],"parallelist.":[81],"features":[83,112],"gathered":[84],"are":[85,89,161,170],"pre-processed":[86],"they":[88],"fed":[90],"into":[91],"CNN":[93],"determine":[96],"four":[97],"workload":[98,191],"categories.":[99,179],"SHapley":[100],"Additive":[101],"exPlanations":[102],"(SHAP)":[103],"enhance":[107],"interpretability,":[108],"by":[109,172],"determining":[110],"contributed":[114],"individual":[116],"predictions":[117],"overall":[119],"behavior.":[121],"This":[122],"framework":[123,182],"assessed":[125],"in":[126],"form":[128],"accuracy,":[130],"precision,":[131],"recall,":[132],"F1-score,":[133],"latency,":[135],"computational":[137],"overhead.":[138],"It":[139],"compared":[141],"conventional":[143],"classifiers,":[144],"Decision":[147],"Tree,":[148],"Random":[149],"Forest,":[150],"Support":[151],"Vector":[152],"Machine,":[153],"Multilayer":[155],"Perceptron.":[156],"TPC-H":[157],"TPC-DS":[159],"benchmarks":[160],"assumed":[162],"with":[166],"analytical":[167],"which":[169],"complemented":[171],"other":[173,178],"will":[183],"help":[184],"offer":[186],"correct":[188],"understandable":[190],"establish":[194],"basis":[196],"future":[198],"adaptive":[199],"processing":[201],"optimization":[203],"database.":[206]},"counts_by_year":[],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2026-11-06T00:00:00"}