Impact Factor:6.549
 Scopus Suggested Journal: UNDER REVIEW for TITLE INCLUSSION
Login Submit Paper Check Paper Status
IJCERT Journal ISSN(Online):2349-7084

International Journal
of Computer Engineering in Research Trends (IJCERT)

Scholarly, Peer-Reviewed, Open Access and Multidisciplinary


Welcome to IJCERT

International Journal of Computer Engineering in Research Trends. Scholarly, Peer-Reviewed,Open Access and Multidisciplinary

ISSN(Online):2349-7084                 Submit Paper    Check Paper Status    Conference Proposal

Know More
Back to Current Issues

Protecting Data in Relational Database Management System using Purpose and Role-Based Access Control

Suraj Krishna Patil, Suhas B. Bhagate, , ,
Affiliations
Computer Science & Engineering, TEI, Ichalkaranji, 416115, India
:10.22362/ijcert/2017/v4/i8/xxxx [UNDER PROCESS]


Abstract
Background/Objectives: Privacy is a key requirement in handling personal and sensitive data. The Database Management System (DBMS) stores such kind of data and also provides tools to access and analyze this data. Methods/Statistical analysis: The Role-Based Access Control (RBAC) regulates the access to resources based on the roles of individual users. Purpose Based Access Control (PuBAC) regulates the access based on the purpose for which data can be accessed. It regulates the execution of queries based on purpose. Findings: From the result, it is observed that some records accessed by considering the purpose and role-based access control are less than some records accessed by original and purpose based access control query result. The system is more secure than the previous one. Improvements/Applications: This work can be used in the organizations, government, and private offices academic institutes. It can be extended to support big data and conditional purpose based access control.


Citation
Suraj Krishna Patil, &Suhas B. Bhagate. (2017). Protecting Data in Relational Database Management System using Purpose and Role-Based Access Control. International Journal of Computer Engineering In Research Trends, 4(8), 336-340. Retrieved from http://ijcert.org/ems/ijcert_papers/V4I8004.pdf


Keywords : Privacy, Access Control, Query Rewriting

References
1.	J.Byun and N.Li, “Purpose based access control for privacy protection in a relational database system,” VLDB J., vol.17, no.4, pp. 603–619, 2008.
2.	M.E.Kabir and H.Wang, “Conditional purpose based access control model for privacy protection,” in Proc. 20th Australian Conference Australian Database, 2009, vol.92, pp. 135–142.
3.	P.Colombo and E.Ferrari, “Enforcement of purpose based access control within relational database management systems,” IEEE Transactions Knowledge Data Engineering, vol.26, no.11, pp.2703-2716, Nov 2014.
4.	P.Colombo and E.Ferrari, “Enforcing obligations within relational database management systems”, IEEE Transactions Dependable secure computing, vol.11, no.4, pp.318-331, Jul/Aug 2014.
5.	M. Jafari, P. W. Fong, R. Safavi-Naini, K. Barker, and N. P. Sheppard, “Towards defining Semantic foundations for purpose-based privacy policies,” in Proc. 1st ACM Conf. Data Appl. Security Privacy, 2011, pp. 213-224.
6.	P.Colombo and E.Ferrari, “Efficient enforcement of action-aware purpose-based access control within relational database management systems,” IEEE Transaction Knowledge Data Engineering, vol. 27, no.08, pp. 2134-2147, Aug 2015.
7.	M. Kabir, H. Wang, and E. Bertino, “A role-involved conditional purpose-based access control model,” in E-Government, E-Services and Global Processes, series IFIP Advances in Information and Communication Technology, vol. 334, M. Janssen, W. Lamersdorf, J. Pries-Heje, and M. Rosemann, Eds. Springer, 2010. 
8.	V.Nikitha, P.Jhansi , K.Neelima and D.Anusha ,” Data sets preparing for Data mining analysis by SQL Horizontal Aggregation,” International Journal of Computer Engineering In Research Trends.,vol.3,no.9,pp. 225-229,2014.
9.	Neelima Kuderu, Dr. Vijaya Kumari,” Relational Database to NoSQL Conversion by Schema Migration and Mapping ,”International Journal of Computer Engineering In Research Trends.,vol.3,no.9,pp. 506-513,2016.
10.	Jollu Jayachandrudu,M.Sri lakshmi,Dr.S.Prem Kumar,” Enhanced Independent Access to Encrypted Cloud Databases ,”International Journal of Computer Engineering In Research Trends.,vol.2,no.9,pp. 589-593,2015.


DOI Link : Not yet assigned

Download :
  V4I8004.pdf


Refbacks : There are currently no refbacks

Announcements

Authors are not required to pay any article-processing charges (APC) for their article to be published open access in Journal IJCERT. No charge is involved in any stage of the publication process, from administrating peer review to copy editing and hosting the final article on dedicated servers. This is free for all authors. 

News & Events

Latest issue :Volume 10 Issue 1 Articles In press

A plagiarism check will be implemented for all the articles using world-renowned software. Turnitin.


Digital Object Identifier will be assigned for all the articles being published in the Journal from September 2016 issue, i.e. Volume 3, Issue 9, 2016.


IJCERT is a member of the prestigious.Each of the IJCERT articles has its unique DOI reference.
DOI Prefix : 10.22362/ijcert


IJCERT is member of The Publishers International Linking Association, Inc. (“PILA”)


Emerging Sources Citation Index (in process)


IJCERT title is under evaluation by Scopus.

Key Dates

☞   INVITING SUBMISSIONS FOR THE NEXT ISSUE :
☞   LAST DATE OF SUBMISSION : 31st March 2023
☞  SUBMISSION TO FIRST DECISION :
In 7 Days
☞  FINAL DECISION :
IN 3 WEEKS FROM THE DAY OF SUBMISSION

Important Announcements

All the authors, conference coordinators, conveners, and guest editors kindly check their articles' originality before submitting them to IJCERT. If any material is found to be duplicate submission or sent to other journals when the content is in the process with IJCERT, fabricated data, cut and paste (plagiarized), at any stage of processing of material, IJCERT is bound to take the following actions.
1. Rejection of the article.
2. The author will be blocked for future communication with IJCERT if duplicate articles are submitted.
3. A letter regarding this will be posted to the Principal/Director of the Institution where the study was conducted.
4. A List of blacklisted authors will be shared among the Chief Editors of other prestigious Journals
We have been screening articles for plagiarism with a world-renowned tool: Turnitin However, it is only rejected if found plagiarized. This more stern action is being taken because of the illegal behavior of a handful of authors who have been involved in ethical misconduct. The Screening and making a decision on such articles costs colossal time and resources for the journal. It directly delays the process of genuine materials.

Citation Index

Citations Indices All
Citations 1026
h-index 14
i10-index 20
Source: Google Scholar

Acceptance Rate (By Year)

Acceptance Rate (By Year)
Year Rate
2021 10.8%
2020 13.6%
2019 15.9%
2018 14.5%
2017 16.6%
2016 15.8%
2015 18.2%
2014 20.6%

Important Links

 Home

 Aims and Scope

 Call for Papers

 Instructions for Authors

 Editorial Board

Archive

 Download

 Ethics & Policies

 Publication Ethics and
Publication Malpractice Statement

 Plagiarism Policy

 Copyright, Grants and
Ownership Declaration

 Refund Policy

 Open Access Overview

 Open Access License

 Permissions

Conference Proposal

 Peer Review

 Digital Library

 Register here

 Conference Proposal

 Special Issue Proposal

 Conference Proposal Guidelines

 Upcoming Conference

DOI:10.22362/ijcert