摘要
PostgreSQL是一种对象关系型数据库管理系统。利用PostgreSQL的规则系统,实现了一种面向用户的动态视图建立的方法。该方法利用PostgreSQL的系统表、系统函数,通过创建视图的插入、更新、删除规则,动态的创建会话用户的视图。用户通过访问接口LIBPQ连接到数据库,授权访问和操作自己的视图。在数据库一级对用户数据进行了隔离。
PostgreSQL is an object-relational database management system. Based on the rule system ofPostgreSQL, 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 systto database by access interface LIBPQ and are authoem tables and system functions of PostgreSQL. Users connect rized to access and operate views of themselves. This can separate users' data in the stage of database.
出处
《计算机工程与设计》
CSCD
北大核心
2007年第4期988-989,共2页
Computer Engineering and Design
关键词
规则
面向用户
动态视图
数据隔离
权限
rule
user-oriented
dynamic view, data separate
privilege