Barker, KennethSingh, Sharmila2012-12-202013-06-152012-12-202012Singh, S. (2012). System Catalogue design for a Privacy Preserving Relational Database Management System (Master's thesis, University of Calgary, Calgary, Canada). Retrieved from https://prism.ucalgary.ca. doi:10.11575/PRISM/27964http://hdl.handle.net/11023/369The thesis presents a privacy system catalogue design for a relational database management system (RDBMS). The design includes the predicates of a privacy taxonomy [BAB+09] such as purpose (p), visibility (v), granularity (g) and retention (r). The aim here is to propose a normalized and implementable design for an RDBMS. The main contributions include a study of privacy predicates representation, the basic design of system tables, query processing, an analysis of the design and a partial implementation. Since additional privacy features affect query processing, an algorithm for the SELECT process is described, implemented and analyzed. An alternate design has been suggested as well to fully consider other design possibilities. Lastly, an example application is provided to help understand the proposed design. Design, analysis and implementation of the proposed design, and the query process along with the example system have allowed us to conclude that the design is normalized and implementable.engUniversity of Calgary graduate students retain copyright ownership and moral rights for their thesis. You may use this material in any way that is permitted by the Copyright Act or through licensing that has been assigned to the document. For uses that are not allowable under copyright legislation or licensing, you are required to seek permission.Computer SciencePrivacyRDBMSDatabaseDesignrelationalmaster thesis10.11575/PRISM/27964