Study on methods for data confidentiality and data integrity in relational database

On the basis of the analysis of the security demands of the database, this paper proposes a novel method that simultaneously assures the confidentiality and the integrity of data items. The basic concept of this method is adding a verification table to existing database tables to the existing database tables, and the verification items for each original data item are stored in the verification table. By using the line label and line concatenation techniques, this method not only assures the confidentiality of a database that has important and sensitive data, but also effectively protects data from being modified, exchanged, added or deleted illegally. A formal analysis and verification of this method is provided.