Reality there is a demand, the data in the table is stored encrypted, such as the amount of the number of requirements such as encryption, interface returned after some statistical data show that statistical data,

Thought to use temporary tables, start the data after decryption after joining the temporary table, league table query (such as sum, count) after return to clear data, the question now is a temporary table can only be effective, the current connection temporary table synchronization, if revised the amount of data, how to ensure that the temporary table data is the latest?

Have a great god meet this demand, under direction,

Mybatis springboot + + druid

CodePudding user response:

Since you can use a temporary table data decryption, the outer trim directly on the ground floor select can query the raw data (such as select * from (select * from table_name) t), and even the table to time t

CodePudding user response:

The data rarely? Use symmetric encryption line not line,

If the SQL can be make people go through, any encryption basic is in vain

CodePudding user response:

reference 1st floor a1767028198 response:

since you can use a temporary table data decryption, the outer trim directly select a layer also can query the raw data (such as select * from (select * from table_name) t), even with table when t line

to manage all the connections of the temporary table synchronization update problem,

CodePudding user response:

Before the oracle database has this function