{"id":"https://openalex.org/W2991637085","doi":"https://doi.org/10.4018/ijsi.2020010105","title":"Use of Purpose and Role Based Access Control Mechanisms to Protect Data Within RDBMS","display_name":"Use of Purpose and Role Based Access Control Mechanisms to Protect Data Within RDBMS","publication_year":2019,"publication_date":"2019-11-25","ids":{"openalex":"https://openalex.org/W2991637085","doi":"https://doi.org/10.4018/ijsi.2020010105","mag":"2991637085"},"language":"en","primary_location":{"id":"doi:10.4018/ijsi.2020010105","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijsi.2020010105","pdf_url":null,"source":{"id":"https://openalex.org/S4210228539","display_name":"International Journal of Software Innovation","issn_l":"2166-7160","issn":["2166-7160","2166-7179"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Software Innovation","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/A5058237637","display_name":"Suraj Krishna Patil","orcid":null},"institutions":[{"id":"https://openalex.org/I4210103544","display_name":"DKTE Society's Textile and Engineering Institute","ror":"https://ror.org/014bdwq31","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210103544"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Suraj Krishna Patil","raw_affiliation_strings":["D.K.T.E. Society's Textile and Engineering Institute, Ichalkaranji, India"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"D.K.T.E. Society's Textile and Engineering Institute, Ichalkaranji, India","institution_ids":["https://openalex.org/I4210103544"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004175924","display_name":"Sandipkumar Chandrakant Sagare","orcid":"https://orcid.org/0000-0003-2774-9399"},"institutions":[{"id":"https://openalex.org/I4210103544","display_name":"DKTE Society's Textile and Engineering Institute","ror":"https://ror.org/014bdwq31","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210103544"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Sandipkumar Chandrakant Sagare","raw_affiliation_strings":["D.K.T.E. Society's Textile and Engineering Institute, Ichalkaranji, India"],"raw_orcid":"https://orcid.org/0000-0003-2774-9399","affiliations":[{"raw_affiliation_string":"D.K.T.E. Society's Textile and Engineering Institute, Ichalkaranji, India","institution_ids":["https://openalex.org/I4210103544"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5056303896","display_name":"Alankar Shantaram Shelar","orcid":"https://orcid.org/0000-0002-4321-9104"},"institutions":[{"id":"https://openalex.org/I4210103544","display_name":"DKTE Society's Textile and Engineering Institute","ror":"https://ror.org/014bdwq31","country_code":"IN","type":"education","lineage":["https://openalex.org/I4210103544"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Alankar Shantaram Shelar","raw_affiliation_strings":["D.K.T.E. Society's Textile and Engineering Institute, Ichalkaranji, India"],"raw_orcid":"https://orcid.org/0000-0002-4321-9104","affiliations":[{"raw_affiliation_string":"D.K.T.E. Society's Textile and Engineering Institute, Ichalkaranji, India","institution_ids":["https://openalex.org/I4210103544"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210103544"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.27360627,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":"8","issue":"1","first_page":"82","last_page":"91"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T10237","display_name":"Cryptography and Data Security","score":0.9994999766349792,"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/T10764","display_name":"Privacy-Preserving Technologies in Data","score":0.9987000226974487,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/role-based-access-control","display_name":"Role-based access control","score":0.8524259924888611},{"id":"https://openalex.org/keywords/access-control","display_name":"Access control","score":0.7770015001296997},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7338051795959473},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.6746854782104492},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.6111823320388794},{"id":"https://openalex.org/keywords/mandatory-access-control","display_name":"Mandatory access control","score":0.5688740611076355},{"id":"https://openalex.org/keywords/enforcement","display_name":"Enforcement","score":0.5668864846229553},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5283342599868774},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.45822983980178833},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.4509701728820801},{"id":"https://openalex.org/keywords/control","display_name":"Control (management)","score":0.4420728385448456},{"id":"https://openalex.org/keywords/discretionary-access-control","display_name":"Discretionary access control","score":0.42793500423431396},{"id":"https://openalex.org/keywords/computer-access-control","display_name":"Computer access control","score":0.4255439341068268},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.21787694096565247}],"concepts":[{"id":"https://openalex.org/C45567728","wikidata":"https://www.wikidata.org/wiki/Q1702839","display_name":"Role-based access control","level":3,"score":0.8524259924888611},{"id":"https://openalex.org/C527821871","wikidata":"https://www.wikidata.org/wiki/Q228502","display_name":"Access control","level":2,"score":0.7770015001296997},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7338051795959473},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.6746854782104492},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.6111823320388794},{"id":"https://openalex.org/C2777407602","wikidata":"https://www.wikidata.org/wiki/Q1888932","display_name":"Mandatory access control","level":4,"score":0.5688740611076355},{"id":"https://openalex.org/C2779777834","wikidata":"https://www.wikidata.org/wiki/Q4202277","display_name":"Enforcement","level":2,"score":0.5668864846229553},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5283342599868774},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.45822983980178833},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.4509701728820801},{"id":"https://openalex.org/C2775924081","wikidata":"https://www.wikidata.org/wiki/Q55608371","display_name":"Control (management)","level":2,"score":0.4420728385448456},{"id":"https://openalex.org/C48814466","wikidata":"https://www.wikidata.org/wiki/Q1228590","display_name":"Discretionary access control","level":4,"score":0.42793500423431396},{"id":"https://openalex.org/C44415380","wikidata":"https://www.wikidata.org/wiki/Q17008721","display_name":"Computer access control","level":3,"score":0.4255439341068268},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.21787694096565247},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.4018/ijsi.2020010105","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijsi.2020010105","pdf_url":null,"source":{"id":"https://openalex.org/S4210228539","display_name":"International Journal of Software Innovation","issn_l":"2166-7160","issn":["2166-7160","2166-7179"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Software Innovation","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.6700000166893005,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1554214151","https://openalex.org/W1967221886","https://openalex.org/W1968571612","https://openalex.org/W1980437932","https://openalex.org/W1986950008","https://openalex.org/W2003367163","https://openalex.org/W2090930794","https://openalex.org/W2166444898","https://openalex.org/W2209587831"],"related_works":["https://openalex.org/W2148952798","https://openalex.org/W3138978413","https://openalex.org/W1596015467","https://openalex.org/W4386618948","https://openalex.org/W2475594486","https://openalex.org/W2382286253","https://openalex.org/W2358662376","https://openalex.org/W1503896993","https://openalex.org/W2234340074","https://openalex.org/W2183827907"],"abstract_inverted_index":{"Privacy":[0,34],"is":[1,15,61],"the":[2,89,95,106,131],"key":[3],"factor":[4],"to":[5,27,91,108,139],"handle":[6],"personal":[7,45],"and":[8,25,29,46,70,80,137],"sensitive":[9,47],"data,":[10],"which":[11,76,114],"in":[12,63,74],"large":[13],"chunks,":[14],"stored":[16],"by":[17],"database":[18],"management":[19],"systems":[20],"(DBMS).":[21],"It":[22,119],"provides":[23],"tools":[24],"mechanisms":[26,52],"access":[28,50,56,59,72,85,90,102,107],"analyze":[30],"data":[31,38,115],"within":[32,141],"it.":[33],"preservation":[35],"converts":[36],"original":[37],"into":[39],"some":[40],"unknown":[41],"form,":[42],"thus":[43],"protecting":[44],"information.":[48],"Different":[49],"control":[51,60,73,86,103],"such":[53],"as":[54],"discretionary":[55],"control,":[57],"mandatory":[58],"used":[62],"DBMS.":[64],"However,":[65],"they":[66],"hardly":[67],"consider":[68],"purpose":[69,112],"role-based":[71],"DBMS,":[75],"incorporates":[77],"policy":[78],"specification":[79],"enforcement.":[81],"The":[82,127],"role":[83],"based":[84,93,101,110,124],"(RBAC)":[87],"regulates":[88,105,120],"resources":[92,109],"on":[94,111,125],"roles":[96],"of":[97,122,133],"individual":[98],"users.":[99],"Purpose":[100],"(PuBAC)":[104],"for":[113],"can":[116],"be":[117],"accessed.":[118],"execution":[121],"queries":[123],"purpose.":[126],"PuRBAC":[128],"system":[129],"uses":[130],"policies":[132],"both,":[134],"i.e.":[135],"PuBAC":[136],"RBAC,":[138],"enforce":[140],"RDBMS.":[142]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1}],"updated_date":"2026-06-11T06:19:23.411458","created_date":"2025-10-10T00:00:00"}