KReSIT Logo Kanwal Rekhi School of Information Technology
IIT Bombay
 Student Projects
 ASL BE/MCA Projects
 Ongoing Projects
 Past Projects
 Sponsored Projects

Home > Research > Projects > Asl > Ongoing 

Students' Projects

Implementation of Virtual Private Database (VPDmechanism for POSTGRES.)



Virtual private database table feature allows for the creation of customized data objects that dont physically exist but can be virtually generated out of objects that do. The emphasis in is to serve distributed applications (ASP Environment) where data-sharing across business units and between partner companies is the priority, and different users must view and handle common business objects in different ways.The VPD feature has been implemented in ORACLE 8i . The underlying concept is row-level security. It transparently adds predicates to user statements to limit down their access in a way that is transparent to the user, and the application.Oracle permits you to implement a table security policy that lets different groups of users see some portions of the table but not others. In an ASP environment, youd need to have multiple database instantiations, one for each customer--or, at the very least, multiple schemas--in order to maintain security. That would be a tremendous mplementationand maintenance headache. But with an app using row-level security, one database does the job and security is solid. When security policies are implemented on tables in this fashion, the table is secure, regardless of the mechanism used to access the table. The goal of the project is to build this VPD mechanism in to Postgres System.

Printer friendly    Comment
  Copyright © 2004 KReSIT, IIT Bombay. All rights reserved sitemap    
  Kanwal Rekhi School of Information Technology, Indian Institute of Technology Bombay, Powai, Mumbai - 400 076.
+91-22-2576 7901/02. Fax: +91-22-2572 0022
Designed by Kamlesh