{"id":"https://openalex.org/W2801381807","doi":"https://doi.org/10.23919/icitst.2017.8356402","title":"Performance vs. security: Implementing an immutable database in MySQL","display_name":"Performance vs. security: Implementing an immutable database in MySQL","publication_year":2017,"publication_date":"2017-12-01","ids":{"openalex":"https://openalex.org/W2801381807","doi":"https://doi.org/10.23919/icitst.2017.8356402","mag":"2801381807"},"language":"en","primary_location":{"id":"doi:10.23919/icitst.2017.8356402","is_oa":false,"landing_page_url":"https://doi.org/10.23919/icitst.2017.8356402","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 12th International Conference for Internet Technology and Secured Transactions (ICITST)","raw_type":"proceedings-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/A5110568632","display_name":"Thomas Nash","orcid":null},"institutions":[{"id":"https://openalex.org/I204593131","display_name":"College of Charleston","ror":"https://ror.org/00390t168","country_code":"US","type":"education","lineage":["https://openalex.org/I204593131"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Thomas Nash","raw_affiliation_strings":["Department of Computer Science, College of Charleston, Charleston, SC"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, College of Charleston, Charleston, SC","institution_ids":["https://openalex.org/I204593131"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037716101","display_name":"Aspen Olmsted","orcid":"https://orcid.org/0000-0003-2652-0154"},"institutions":[{"id":"https://openalex.org/I204593131","display_name":"College of Charleston","ror":"https://ror.org/00390t168","country_code":"US","type":"education","lineage":["https://openalex.org/I204593131"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Aspen Olmsted","raw_affiliation_strings":["Department of Computer Science, College of Charleston, Charleston, SC"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, College of Charleston, Charleston, SC","institution_ids":["https://openalex.org/I204593131"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5110568632"],"corresponding_institution_ids":["https://openalex.org/I204593131"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.27962211,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"290","last_page":"291"},"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.9995999932289124,"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.9995999932289124,"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.9973000288009644,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9962000250816345,"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.7787026166915894},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7147862911224365},{"id":"https://openalex.org/keywords/database-security","display_name":"Database security","score":0.5435968637466431},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.5160719752311707},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5059911608695984},{"id":"https://openalex.org/keywords/prime","display_name":"Prime (order theory)","score":0.47256559133529663},{"id":"https://openalex.org/keywords/transactional-leadership","display_name":"Transactional leadership","score":0.43930381536483765},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.42878058552742004},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.3893834948539734},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.07683518528938293}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7787026166915894},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7147862911224365},{"id":"https://openalex.org/C2778553114","wikidata":"https://www.wikidata.org/wiki/Q1035293","display_name":"Database security","level":2,"score":0.5435968637466431},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.5160719752311707},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5059911608695984},{"id":"https://openalex.org/C184992742","wikidata":"https://www.wikidata.org/wiki/Q7243229","display_name":"Prime (order theory)","level":2,"score":0.47256559133529663},{"id":"https://openalex.org/C68489960","wikidata":"https://www.wikidata.org/wiki/Q2370659","display_name":"Transactional leadership","level":2,"score":0.43930381536483765},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.42878058552742004},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.3893834948539734},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07683518528938293},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","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},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.23919/icitst.2017.8356402","is_oa":false,"landing_page_url":"https://doi.org/10.23919/icitst.2017.8356402","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 12th International Conference for Internet Technology and Secured Transactions (ICITST)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W8287904","https://openalex.org/W1977330283","https://openalex.org/W2609999151","https://openalex.org/W6600354236","https://openalex.org/W6737523574"],"related_works":["https://openalex.org/W2129469317","https://openalex.org/W2357102580","https://openalex.org/W1603016012","https://openalex.org/W1588786827","https://openalex.org/W2591891926","https://openalex.org/W2105333333","https://openalex.org/W1501673548","https://openalex.org/W2015535627","https://openalex.org/W2919458629","https://openalex.org/W2349570899"],"abstract_inverted_index":{"Maintaining":[0],"transactional":[1],"history":[2],"is":[3,20,34,70,74],"crucial":[4],"to":[5,13,30,43,61,77,96],"unraveling":[6],"the":[7,56,68,72,108],"changes":[8],"any":[9],"unauthorized":[10],"user":[11],"makes":[12],"a":[14,22,46,78,98],"system,":[15],"and":[16,58,84,91,112,115],"this":[17,32],"logging":[18],"database":[19,47,73,110],"often":[21],"prime":[23],"target":[24],"for":[25],"attackers.":[26],"One":[27],"common":[28],"approach":[29],"maintaining":[31],"security":[33,51],"through":[35],"an":[36],"immutable":[37],"database.":[38],"There":[39],"are":[40],"many":[41],"ways":[42],"implement":[44],"such":[45],"which":[48],"maintains":[49],"appropriate":[50],"requirements,":[52],"each":[53],"ranging":[54],"in":[55,107],"complexity":[57],"effort":[59],"required":[60],"configure.":[62],"What":[63],"remains":[64],"constant":[65],"amongst":[66,117],"all":[67],"methods":[69,106],"that":[71,85],"available":[75],"only":[76,88],"restricted,":[79],"defined":[80],"set":[81],"of":[82,104],"users":[83],"records":[86],"may":[87],"be":[89],"inserted":[90],"not":[92],"updated":[93],"or":[94],"deleted":[95],"maintain":[97],"proper":[99],"history.":[100],"We":[101],"demonstrate":[102],"two":[103],"these":[105],"MySQL":[109],"system":[111],"compare":[113],"performance":[114],"capabilities":[116],"them.":[118]},"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}