{"id":"https://openalex.org/W2030201711","doi":"https://doi.org/10.1109/tdsc.2014.2306675","title":"Risk Aware Query Replacement Approach for Secure Databases Performance Management","display_name":"Risk Aware Query Replacement Approach for Secure Databases Performance Management","publication_year":2014,"publication_date":"2014-04-21","ids":{"openalex":"https://openalex.org/W2030201711","doi":"https://doi.org/10.1109/tdsc.2014.2306675","mag":"2030201711"},"language":"en","primary_location":{"id":"doi:10.1109/tdsc.2014.2306675","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tdsc.2014.2306675","pdf_url":null,"source":{"id":"https://openalex.org/S133795288","display_name":"IEEE Transactions on Dependable and Secure Computing","issn_l":"1545-5971","issn":["1545-5971","1941-0018","2160-9209"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","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 Dependable and Secure 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/A5056253313","display_name":"Ousmane Amadou Dia","orcid":null},"institutions":[{"id":"https://openalex.org/I155781252","display_name":"University of South Carolina","ror":"https://ror.org/02b6qw903","country_code":"US","type":"education","lineage":["https://openalex.org/I155781252"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ousmane Amadou Dia","raw_affiliation_strings":["Computer Science and Engineering Department, University of South Carolina, Columbia, South Carolina","Computer Science and Engineering Department University of South Carolina  Columbia South Carolina"],"affiliations":[{"raw_affiliation_string":"Computer Science and Engineering Department, University of South Carolina, Columbia, South Carolina","institution_ids":["https://openalex.org/I155781252"]},{"raw_affiliation_string":"Computer Science and Engineering Department University of South Carolina  Columbia South Carolina","institution_ids":["https://openalex.org/I155781252"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5059899524","display_name":"Csilla Farkas","orcid":"https://orcid.org/0000-0002-6848-1790"},"institutions":[{"id":"https://openalex.org/I155781252","display_name":"University of South Carolina","ror":"https://ror.org/02b6qw903","country_code":"US","type":"education","lineage":["https://openalex.org/I155781252"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Csilla Farkas","raw_affiliation_strings":["Computer Science and Engineering Department, University of South Carolina, Columbia, South Carolina","Computer Science and Engineering Department University of South Carolina  Columbia South Carolina"],"affiliations":[{"raw_affiliation_string":"Computer Science and Engineering Department, University of South Carolina, Columbia, South Carolina","institution_ids":["https://openalex.org/I155781252"]},{"raw_affiliation_string":"Computer Science and Engineering Department University of South Carolina  Columbia South Carolina","institution_ids":["https://openalex.org/I155781252"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5056253313"],"corresponding_institution_ids":["https://openalex.org/I155781252"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.1201077,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":"12","issue":"2","first_page":"217","last_page":"229"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998000264167786,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998000264167786,"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/T10927","display_name":"Access Control and Trust","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/3312","display_name":"Sociology and Political Science"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9994000196456909,"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/computer-science","display_name":"Computer science","score":0.8864923119544983},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7218021750450134},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6335291266441345},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.6074087023735046},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.549331784248352},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5278275609016418},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.5260101556777954},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4976253807544708},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.48255103826522827},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.47170281410217285},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.4630091190338135},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.45533910393714905},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4451585114002228},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.44295650720596313},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4212809205055237},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.4171295762062073},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3515591025352478},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2675066590309143},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2601613998413086},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.16354769468307495}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8864923119544983},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7218021750450134},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6335291266441345},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.6074087023735046},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.549331784248352},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5278275609016418},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.5260101556777954},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4976253807544708},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.48255103826522827},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.47170281410217285},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.4630091190338135},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.45533910393714905},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4451585114002228},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.44295650720596313},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4212809205055237},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4171295762062073},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3515591025352478},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2675066590309143},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2601613998413086},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.16354769468307495},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tdsc.2014.2306675","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tdsc.2014.2306675","pdf_url":null,"source":{"id":"https://openalex.org/S133795288","display_name":"IEEE Transactions on Dependable and Secure Computing","issn_l":"1545-5971","issn":["1545-5971","1941-0018","2160-9209"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","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 Dependable and Secure Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6100000143051147,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W27149491","https://openalex.org/W299741479","https://openalex.org/W1569403765","https://openalex.org/W1590824348","https://openalex.org/W1973007193","https://openalex.org/W1979093255","https://openalex.org/W1980437932","https://openalex.org/W1989813731","https://openalex.org/W1997888312","https://openalex.org/W2002638946","https://openalex.org/W2022901032","https://openalex.org/W2030453903","https://openalex.org/W2037013499","https://openalex.org/W2049211546","https://openalex.org/W2054507370","https://openalex.org/W2058347046","https://openalex.org/W2060690494","https://openalex.org/W2065246078","https://openalex.org/W2099353173","https://openalex.org/W2101911890","https://openalex.org/W2107113299","https://openalex.org/W2127470768","https://openalex.org/W2151406030","https://openalex.org/W2151449617","https://openalex.org/W2154889864","https://openalex.org/W2168035053","https://openalex.org/W2176363081","https://openalex.org/W3134410366","https://openalex.org/W7033643797"],"related_works":["https://openalex.org/W2912995176","https://openalex.org/W2079690139","https://openalex.org/W29343545","https://openalex.org/W2134740279","https://openalex.org/W4252101311","https://openalex.org/W2604963418","https://openalex.org/W2030201711","https://openalex.org/W2112474496","https://openalex.org/W2102166438","https://openalex.org/W1824813896"],"abstract_inverted_index":{"Large":[0],"amount":[1],"of":[2,19,58,68,95,99,132,150,174,191],"data":[3,14,42],"and":[4,10,35,56,112,180],"increased":[5,52],"demand":[6],"to":[7,32,76,108,113,120,128,156,171],"extract,":[8],"analyze":[9],"derive":[11],"knowledge":[12],"from":[13,81,102],"are":[15,169],"impairing":[16],"nowadays":[17],"performance":[18,78,149,190],"enterprise":[20,69],"mission-critical":[21],"systems":[22],"such":[23],"as":[24],"databases.":[25],"For":[26],"databases,":[27],"the":[28,66,93,148,151,157,172,175,189,192],"challenging":[29],"problem":[30,67],"is":[31,75,178],"manage":[33],"complex":[34],"sometimes":[36],"non-optimized":[37],"queries":[38,101],"executed":[39],"on":[40],"enormous":[41],"sets":[43],"stored":[44],"across":[45],"several":[46],"tables.":[47],"This":[48,117],"generally":[49],"results":[50,167,173],"in":[51,124,139],"query":[53,135,161,165],"response":[54],"time":[55],"loss":[57],"employees":[59],"productivity.":[60],"In":[61],"this":[62],"paper,":[63],"we":[64,154],"investigate":[65],"computing":[70,129],"resources":[71,123],"availability.":[72],"Our":[73],"goal":[74],"minimize":[77],"degradation":[79],"arising":[80],"resource":[82,97,130],"intensive":[83],"queries.":[84,133],"We":[85,105],"propose":[86,155],"a":[87,125,140,159],"risk":[88],"aware":[89],"approach":[90],"that":[91,168],"decouples":[92],"process":[94],"analyzing":[96],"requirements":[98],"sql":[100],"their":[103],"execution.":[104],"leverage":[106],"XACML":[107],"control":[109],"users'":[110],"requests":[111],"monitor":[114],"database":[115,126,141],"loads.":[116],"allows":[118],"us":[119],"adjust":[121],"available":[122],"system":[127],"needs":[131],"A":[134],"can":[136],"therefore":[137],"run":[138],"if":[142],"it":[143,185],"does":[144],"not":[145],"severely":[146],"impact":[147],"database.":[152,193],"Otherwise,":[153],"requester":[158],"replacement":[160],"denoted":[162],"what-if-query.":[163],"Such":[164],"proposes":[166],"similar":[170],"requester's":[176],"query,":[177],"secure":[179],"provides":[181],"acceptable":[182],"answers":[183],"when":[184],"executes":[186],"without":[187],"compromising":[188]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}