Method for storing data in a relational database and relational database server
View Patent ↗The invention relates to a method for storing data in a relational database, comprising a plurality of tables, wherein the data is stored in these tables, wherein each row of each table is provided with an original primary key for identification, and wherein foreign keys are provided for cross-referencing different tables of the relational database, wherein the primary keys are encrypted, wherein the foreign keys are encrypted based on the encrypted primary keys and wherein for each table where a primary key is referenced as a foreign key an encrypted pointer is stored to link the corresponding encrypted foreign key to the encrypted primary key. The present invention further relates to a relational database server.
1. A method for storing data in a relational database, comprising:
a plurality of tables, wherein the data is stored in these tables, wherein each row of each table is provided with an original primary key for identification, and wherein foreign keys are provided for cross-referencing different tables of the relational database,
wherein the primary keys are encrypted, that the foreign keys are encrypted based on the encrypted primary keys and that for each table where a primary key is referenced as a foreign key an encrypted pointer is stored to link the corresponding encrypted foreign key to the encrypted primary key.
2. The method according to claim 1 , wherein the primary keys and/or the foreign keys are encrypted by symmetric encryption.
3. The method according to claim 1 , wherein multiple occurrences of foreign keys in the same table are linked consecutively based on at least a prior occurrence.
4. The method according to claim 3 , wherein for the first occurrence of a foreign key in a table this foreign key is generated by encrypting the corresponding encrypted primary key and a value for table identification.
5. The method according to claim 1 , wherein pointers are encrypted with an encryption key different from an encryption key for encrypting the primary keys and/or foreign keys.
6. The method according to claim 1 , wherein a control table is generated.
7. The method according to claim 1 , wherein at least one encryption key for encrypting the primary keys and/or the pointers is stored outside the relational database.
8. The method according to claim 1 , wherein the encrypted foreign keys are stored in form of a linked list starting from the foreign key that links to the primary key.
9. The method according to claim 1 , wherein the primary keys are provided in a form of extra identifiers.
10. A relational database server for storing data, the relational database comprising a server configured to provide a plurality of tables, to store the data in these tables, to provide each row of each table with an original primary key for identification, and to provide foreign keys for cross-referencing different tables, wherein the relational database server is configured to encrypt the primary keys, to encrypt the foreign keys based on the encrypted primary keys and to store an encrypted pointer to link the corresponding encrypted foreign key to the encrypted primary key for each table where a primary key is referenced as a foreign key.
11. The relational database server according to claim 10 , wherein the relational database server is connected to a encryption server, wherein the encryption server is configured to provide encryption keys for encrypting the primary keys and/or the pointers.