Virtual Private Database (VPD) ensures the privacy of information and prevents direct data leakage through computer terminals by providing Fine-grained Access Control (FGAC). This paper firstly introduces the security requirements of the test database management system and based on which, further analyzes the existing shortcomings in access control technology. Through a brief introduction of VPD, the security design of the test database management system is then described, in which both the security and flexibility of the system are increased and the information leaks and other security related problems of the system are solved.

A data analysis system for the general commodity sales information is researched on and further designed. The key problems of designing this system are that, it should enable the system to adjust to user-data with different structures, enable users to define or change data structures as well as retrieval methods. Through the research on the general structure and retrieval method of the commodity sales data, the system realizes users' customization of the database, thus is applicable to sales data with different structures. This paper focuses on the structure of the database, the creation method and process of the database by the user, the structure of the data dictionary and data exchange between database and software, with case examples in the final illustration.