{"id":"https://openalex.org/W4417056712","doi":"https://doi.org/10.3390/cryptography9040077","title":"Evaluation of the Impact of AES Encryption on Query Read Performance Across Oracle, MySQL, and SQL Server Databases","display_name":"Evaluation of the Impact of AES Encryption on Query Read Performance Across Oracle, MySQL, and SQL Server Databases","publication_year":2025,"publication_date":"2025-11-29","ids":{"openalex":"https://openalex.org/W4417056712","doi":"https://doi.org/10.3390/cryptography9040077"},"language":"en","primary_location":{"id":"doi:10.3390/cryptography9040077","is_oa":true,"landing_page_url":"https://doi.org/10.3390/cryptography9040077","pdf_url":"https://www.mdpi.com/2410-387X/9/4/77/pdf?version=1764401373","source":{"id":"https://openalex.org/S4210223320","display_name":"Cryptography","issn_l":"2410-387X","issn":["2410-387X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Cryptography","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2410-387X/9/4/77/pdf?version=1764401373","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5004463535","display_name":"M. Carvalho","orcid":"https://orcid.org/0000-0002-9195-5640"},"institutions":[{"id":"https://openalex.org/I293362453","display_name":"Polytechnic Institute of Coimbra","ror":"https://ror.org/01n8x4993","country_code":"PT","type":"education","lineage":["https://openalex.org/I293362453"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"M\u00e1rcio Carvalho","raw_affiliation_strings":["Institute of Engineering, Polytechnic University of Coimbra, Rua da Miseric\u00f3rdia, Lagar dos Corti\u00e7os, S. Martinho do Bispo, 3045-093 Coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"Institute of Engineering, Polytechnic University of Coimbra, Rua da Miseric\u00f3rdia, Lagar dos Corti\u00e7os, S. Martinho do Bispo, 3045-093 Coimbra, Portugal","institution_ids":["https://openalex.org/I293362453"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054134720","display_name":"Filipe S\u00e1","orcid":"https://orcid.org/0000-0002-7846-8397"},"institutions":[{"id":"https://openalex.org/I293362453","display_name":"Polytechnic Institute of Coimbra","ror":"https://ror.org/01n8x4993","country_code":"PT","type":"education","lineage":["https://openalex.org/I293362453"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Filipe S\u00e1","raw_affiliation_strings":["Institute of Engineering, Polytechnic University of Coimbra, Rua da Miseric\u00f3rdia, Lagar dos Corti\u00e7os, S. Martinho do Bispo, 3045-093 Coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"Institute of Engineering, Polytechnic University of Coimbra, Rua da Miseric\u00f3rdia, Lagar dos Corti\u00e7os, S. Martinho do Bispo, 3045-093 Coimbra, Portugal","institution_ids":["https://openalex.org/I293362453"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007020545","display_name":"Jorge Bernardino","orcid":"https://orcid.org/0000-0001-9660-2011"},"institutions":[{"id":"https://openalex.org/I293362453","display_name":"Polytechnic Institute of Coimbra","ror":"https://ror.org/01n8x4993","country_code":"PT","type":"education","lineage":["https://openalex.org/I293362453"]},{"id":"https://openalex.org/I4210125590","display_name":"Institute for Systems Engineering and Computers","ror":"https://ror.org/033wn8m60","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590"]},{"id":"https://openalex.org/I76903346","display_name":"University of Coimbra","ror":"https://ror.org/04z8k9a98","country_code":"PT","type":"education","lineage":["https://openalex.org/I76903346"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jorge Bernardino","raw_affiliation_strings":["Centre for Informatics and Systems, University of Coimbra (CISUC), Polo II, Pinhal de Marrocos, 3030-290 Coimbra, Portugal","Institute of Engineering, Polytechnic University of Coimbra, Rua da Miseric\u00f3rdia, Lagar dos Corti\u00e7os, S. Martinho do Bispo, 3045-093 Coimbra, Portugal"],"affiliations":[{"raw_affiliation_string":"Centre for Informatics and Systems, University of Coimbra (CISUC), Polo II, Pinhal de Marrocos, 3030-290 Coimbra, Portugal","institution_ids":["https://openalex.org/I76903346","https://openalex.org/I4210125590"]},{"raw_affiliation_string":"Institute of Engineering, Polytechnic University of Coimbra, Rua da Miseric\u00f3rdia, Lagar dos Corti\u00e7os, S. Martinho do Bispo, 3045-093 Coimbra, Portugal","institution_ids":["https://openalex.org/I293362453"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5054134720"],"corresponding_institution_ids":["https://openalex.org/I293362453"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1732},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1732},"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.51035175,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"9","issue":"4","first_page":"77","last_page":"77"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.08489999920129776,"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/T12479","display_name":"Web Application Security Vulnerabilities","score":0.08489999920129776,"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/T10951","display_name":"Cryptographic Implementations and Security","score":0.07500000298023224,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.06270000338554382,"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/encryption","display_name":"Encryption","score":0.8238000273704529},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6626999974250793},{"id":"https://openalex.org/keywords/advanced-encryption-standard","display_name":"Advanced Encryption Standard","score":0.6021999716758728},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5647000074386597},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4733999967575073},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4205000102519989},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.3889999985694885}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8424000144004822},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.8238000273704529},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6626999974250793},{"id":"https://openalex.org/C94520183","wikidata":"https://www.wikidata.org/wiki/Q190746","display_name":"Advanced Encryption Standard","level":3,"score":0.6021999716758728},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5654000043869019},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5647000074386597},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4733999967575073},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4205000102519989},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.3889999985694885},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.3765999972820282},{"id":"https://openalex.org/C178489894","wikidata":"https://www.wikidata.org/wiki/Q8789","display_name":"Cryptography","level":2,"score":0.3467999994754791},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.3465000092983246},{"id":"https://openalex.org/C10511746","wikidata":"https://www.wikidata.org/wiki/Q899388","display_name":"Data security","level":3,"score":0.3239000141620636},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.299699991941452},{"id":"https://openalex.org/C198104137","wikidata":"https://www.wikidata.org/wiki/Q974688","display_name":"Communication source","level":2,"score":0.27709999680519104},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.25760000944137573},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.25049999356269836}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/cryptography9040077","is_oa":true,"landing_page_url":"https://doi.org/10.3390/cryptography9040077","pdf_url":"https://www.mdpi.com/2410-387X/9/4/77/pdf?version=1764401373","source":{"id":"https://openalex.org/S4210223320","display_name":"Cryptography","issn_l":"2410-387X","issn":["2410-387X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Cryptography","raw_type":"journal-article"},{"id":"pmh:oai:comum.rcaap.pt:10400.26/62087","is_oa":true,"landing_page_url":"http://hdl.handle.net/10400.26/62087","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","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":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"master thesis"},{"id":"pmh:oai:doaj.org/article:6231330b36e94678b8c99dde4c45dc67","is_oa":true,"landing_page_url":"https://doaj.org/article/6231330b36e94678b8c99dde4c45dc67","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cryptography, Vol 9, Iss 4, p 77 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/cryptography9040077","is_oa":true,"landing_page_url":"https://doi.org/10.3390/cryptography9040077","pdf_url":"https://www.mdpi.com/2410-387X/9/4/77/pdf?version=1764401373","source":{"id":"https://openalex.org/S4210223320","display_name":"Cryptography","issn_l":"2410-387X","issn":["2410-387X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Cryptography","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4417056712.pdf","grobid_xml":"https://content.openalex.org/works/W4417056712.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W28784159","https://openalex.org/W1025240641","https://openalex.org/W1520715875","https://openalex.org/W1607071617","https://openalex.org/W2006089711","https://openalex.org/W2059103530","https://openalex.org/W2134169464","https://openalex.org/W2478538150","https://openalex.org/W3027054693","https://openalex.org/W3115367704","https://openalex.org/W3158087444","https://openalex.org/W4206328606","https://openalex.org/W4231869782","https://openalex.org/W4297990590","https://openalex.org/W4313245853","https://openalex.org/W4324093415","https://openalex.org/W4381599258","https://openalex.org/W4386207833","https://openalex.org/W4389622541","https://openalex.org/W4402940123"],"related_works":[],"abstract_inverted_index":{"Data":[0,67],"security":[1],"is":[2],"essential":[3],"for":[4],"protecting":[5],"sensitive":[6],"information":[7],"that":[8],"could":[9],"compromise":[10],"both":[11],"the":[12,15,21,41,44,51,56,71,107,110],"sender":[13],"and":[14,62,91,99],"receiver.":[16],"Encryption":[17,23,68],"mechanisms,":[18],"such":[19,87],"as":[20,88],"Advanced":[22],"Standard":[24],"(AES),":[25],"play":[26],"a":[27],"key":[28],"role":[29],"in":[30],"this":[31],"protection.":[32],"However,":[33,113],"encrypting":[34],"or":[35],"decrypting":[36],"data":[37],"can":[38],"significantly":[39],"impact":[40,52],"performance":[42,57,100,116],"of":[43,53,58,97],"database.":[45],"This":[46],"study":[47],"aims":[48],"to":[49,105,119],"evaluate":[50],"AES":[54],"on":[55],"SQL":[59,102],"Server,":[60],"Oracle,":[61],"MySQL":[63],"when":[64],"using":[65,85],"Transparent":[66],"(TDE)":[69],"with":[70],"Transaction":[72],"Processing":[73],"Performance":[74,82],"Council-H":[75],"(TPC-H)":[76],"benchmark":[77],"at":[78],"different":[79],"Scale":[80],"Factors.":[81],"was":[83],"assessed":[84],"metrics":[86],"elapsed":[89],"time":[90],"system":[92],"resource":[93],"usage.":[94],"In":[95],"terms":[96],"scalability":[98],"efficiency,":[101],"Server":[103],"proved":[104],"be":[106],"best":[108],"among":[109],"databases":[111],"tested.":[112],"TDE":[114],"introduced":[115],"overhead":[117],"compared":[118],"non-encryption":[120],"test":[121],"cases.":[122]},"counts_by_year":[],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-12-05T00:00:00"}