Implementation of rule-based and user-oriented dynamic view
Chengyou Li · Jisuanji gongcheng yu sheji · 2007
PostgreSQL is an object-relational database management system.Based on the rule system of PostgreSQL,a user-oriented method to set up dynamic view is realized.Different views for different users are established by founding the rules for inserting,updating and deleting of view using system tables and system functions of PostgreSQL.Users connect to database by access interface LIBPQ and are authorized to access and operate views of themselves.This can separate users' data in the stage of database.