{"id":"https://openalex.org/W4403181906","doi":"https://doi.org/10.1109/tetc.2024.3471684","title":"A Comparative Analysis of Software Aging in Relational Database System Environments","display_name":"A Comparative Analysis of Software Aging in Relational Database System Environments","publication_year":2024,"publication_date":"2024-10-07","ids":{"openalex":"https://openalex.org/W4403181906","doi":"https://doi.org/10.1109/tetc.2024.3471684"},"language":"en","primary_location":{"id":"doi:10.1109/tetc.2024.3471684","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tetc.2024.3471684","pdf_url":null,"source":{"id":"https://openalex.org/S2496326734","display_name":"IEEE Transactions on Emerging Topics in Computing","issn_l":"2168-6750","issn":["2168-6750","2376-4562"],"is_oa":false,"is_in_doaj":false,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Emerging Topics in Computing","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/A5068677177","display_name":"Herderson Couto","orcid":"https://orcid.org/0000-0002-2308-0387"},"institutions":[{"id":"https://openalex.org/I62921916","display_name":"Universidade Federal Rural de Pernambuco","ror":"https://ror.org/02ksmb993","country_code":"BR","type":"education","lineage":["https://openalex.org/I62921916"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Herderson Couto","raw_affiliation_strings":["Department of Computing, Federal Rural University of Pernambuco, Recife, Brazil"],"affiliations":[{"raw_affiliation_string":"Department of Computing, Federal Rural University of Pernambuco, Recife, Brazil","institution_ids":["https://openalex.org/I62921916"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085003439","display_name":"Fumio Machida","orcid":null},"institutions":[{"id":"https://openalex.org/I146399215","display_name":"University of Tsukuba","ror":"https://ror.org/02956yf07","country_code":"JP","type":"education","lineage":["https://openalex.org/I146399215"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Fumio Machida","raw_affiliation_strings":["Department of Computer Science, University of Tsukuba, Tsukuba, Japan"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Tsukuba, Tsukuba, Japan","institution_ids":["https://openalex.org/I146399215"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009064591","display_name":"Gustavo Callou","orcid":"https://orcid.org/0000-0002-7997-374X"},"institutions":[{"id":"https://openalex.org/I62921916","display_name":"Universidade Federal Rural de Pernambuco","ror":"https://ror.org/02ksmb993","country_code":"BR","type":"education","lineage":["https://openalex.org/I62921916"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Gustavo Callou","raw_affiliation_strings":["Department of Computing, Federal Rural University of Pernambuco, Recife, Brazil"],"affiliations":[{"raw_affiliation_string":"Department of Computing, Federal Rural University of Pernambuco, Recife, Brazil","institution_ids":["https://openalex.org/I62921916"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018148576","display_name":"Ermeson Andrade","orcid":"https://orcid.org/0000-0002-9614-4492"},"institutions":[{"id":"https://openalex.org/I62921916","display_name":"Universidade Federal Rural de Pernambuco","ror":"https://ror.org/02ksmb993","country_code":"BR","type":"education","lineage":["https://openalex.org/I62921916"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Ermeson Andrade","raw_affiliation_strings":["Department of Computing, Federal Rural University of Pernambuco, Recife, Brazil"],"affiliations":[{"raw_affiliation_string":"Department of Computing, Federal Rural University of Pernambuco, Recife, Brazil","institution_ids":["https://openalex.org/I62921916"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5068677177"],"corresponding_institution_ids":["https://openalex.org/I62921916"],"apc_list":null,"apc_paid":null,"fwci":5.456,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.95971616,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"13","issue":"2","first_page":"370","last_page":"381"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.993399977684021,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.993399977684021,"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.9897000193595886,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9833999872207642,"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/computer-science","display_name":"Computer science","score":0.8330137729644775},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6729031205177307},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.509949803352356},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49542129039764404},{"id":"https://openalex.org/keywords/software-system","display_name":"Software system","score":0.4633648097515106},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.461883008480072},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4503244459629059},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.24148693680763245}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8330137729644775},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6729031205177307},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.509949803352356},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49542129039764404},{"id":"https://openalex.org/C149091818","wikidata":"https://www.wikidata.org/wiki/Q2429814","display_name":"Software system","level":3,"score":0.4633648097515106},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.461883008480072},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4503244459629059},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.24148693680763245}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tetc.2024.3471684","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tetc.2024.3471684","pdf_url":null,"source":{"id":"https://openalex.org/S2496326734","display_name":"IEEE Transactions on Emerging Topics in Computing","issn_l":"2168-6750","issn":["2168-6750","2376-4562"],"is_oa":false,"is_in_doaj":false,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Emerging Topics in Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1547122584","https://openalex.org/W1594235899","https://openalex.org/W1964739752","https://openalex.org/W1996131942","https://openalex.org/W2000551239","https://openalex.org/W2018764772","https://openalex.org/W2022232822","https://openalex.org/W2030895849","https://openalex.org/W2055864412","https://openalex.org/W2065325623","https://openalex.org/W2067433929","https://openalex.org/W2131934786","https://openalex.org/W2141644742","https://openalex.org/W2163782777","https://openalex.org/W2318680928","https://openalex.org/W2538159604","https://openalex.org/W2545090612","https://openalex.org/W2561897131","https://openalex.org/W2757251098","https://openalex.org/W2901313434","https://openalex.org/W2945643411","https://openalex.org/W2949021443","https://openalex.org/W3022195853","https://openalex.org/W3038986782","https://openalex.org/W3120034651","https://openalex.org/W3158229743","https://openalex.org/W4212773174","https://openalex.org/W4220907240","https://openalex.org/W4230948688","https://openalex.org/W4360584289","https://openalex.org/W4379742043","https://openalex.org/W4388290544","https://openalex.org/W6601433000"],"related_works":["https://openalex.org/W2505630977","https://openalex.org/W2383709723","https://openalex.org/W2267077731","https://openalex.org/W1567213510","https://openalex.org/W2626533837","https://openalex.org/W2386578196","https://openalex.org/W1981673052","https://openalex.org/W1988380406","https://openalex.org/W3022423983","https://openalex.org/W41949812"],"abstract_inverted_index":{"Computer":[0],"systems":[1,44,87],"that":[2],"operate":[3],"continuously":[4],"over":[5],"extended":[6],"periods":[7],"of":[8,28,55,83,96,104],"time":[9,109],"can":[10,22,60],"be":[11],"susceptible":[12],"to":[13,35,120,129],"a":[14],"phenomenon":[15,21,98],"known":[16],"as":[17],"software":[18,56,84],"aging.":[19],"This":[20,76],"result":[23,61],"in":[24,39,58,62,86,133],"the":[25,33,43,81],"gradual":[26],"depletion":[27],"computational":[29],"resources":[30],"and":[31,70,79,91,107,115,137],"has":[32],"potential":[34],"cause":[36],"performance":[37],"degradation":[38],"these":[40],"systems.":[41],"Among":[42],"affected,":[45],"Database":[46],"Management":[47],"Systems":[48],"(DBMSs)":[49],"are":[50],"particularly":[51],"crucial.":[52],"The":[53,94],"consequences":[54],"aging":[57,85],"DBMSs":[59],"data":[63],"loss,":[64],"compromised":[65],"database":[66,114],"integrity,":[67],"transaction":[68],"failures,":[69],"negative":[71],"effects":[72,82],"on":[73],"system":[74],"availability.":[75],"work":[77],"analyzes":[78],"compares":[80],"using":[88],"SQL":[89,135],"Server":[90,136],"MySQL":[92,138],"DBMSs.":[93],"presence":[95],"this":[97],"is":[99],"confirmed":[100],"through":[101],"statistical":[102],"analysis":[103,112],"memory":[105,121,131],"consumption":[106],"response":[108],"degradation.":[110],"Process-level":[111],"identified":[113],"server":[116],"processes":[117],"contributing":[118],"most":[119],"consumption.":[122],"Additionally,":[123],"we":[124],"developed":[125],"machine":[126],"learning":[127],"models":[128],"predict":[130],"exhaustion":[132],"both":[134],"environments":[139],"across":[140],"diverse":[141],"workloads.":[142]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}