Click here to Skip to main content
15,922,427 members
Home / Discussions / Database
   

Database

 
AnswerRe: single DataSet having multiple DataTables from multiple databases Pin
Richard Deeming15-Jun-17 1:51
mveRichard Deeming15-Jun-17 1:51 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Hailu Worku Obsse16-Jun-17 2:17
professionalHailu Worku Obsse16-Jun-17 2:17 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Richard Deeming16-Jun-17 2:22
mveRichard Deeming16-Jun-17 2:22 
AnswerRe: single DataSet having multiple DataTables from multiple databases Pin
Mycroft Holmes15-Jun-17 13:16
professionalMycroft Holmes15-Jun-17 13:16 
GeneralRe: single DataSet having multiple DataTables from multiple databases Pin
Eddy Vluggen16-Jun-17 3:18
professionalEddy Vluggen16-Jun-17 3:18 
QuestionError in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
indian1437-Jun-17 13:12
indian1437-Jun-17 13:12 
AnswerRe: Error in SSIS Connection says (Test connection failed because of an error in initializing provider. ORA-12541: TNS:no listener) Pin
mike1402125-Jun-17 21:53
mike1402125-Jun-17 21:53 
QuestionI need advice on storing application level encrypted data. Pin
Gilbert Consellado5-Jun-17 18:26
professionalGilbert Consellado5-Jun-17 18:26 
I just want to ask, what is your solution on storing encrypted data on database? And also how you do searching on it? For now the subject database server is mysql.

Disk level encryption is not an option. I also research about database level encryption but, MySql TDE is not for me, and also if you migrate to other database server in my understanding you need to re-encrypt all the data.

So my last bet is application level encryption. And I tried to implement it using AES-GCM, but on this I will lose database searching, because encrypting the same data with the same key and id will produce different results. Now I got an idea but, i don't know what would be the risk implementing it. I was thinking blind indexing.

What I am planning to do is to store 2 version of the encrypted data. first the data will be encrypted with aes-gcm, then store another version of it using one-way encryption on this same data will produce the same hash. So the first encryption is reversible but not searchable, while the second one is not reversible but I can do whole word searching.

The obvious drawback of this is speed. But I want also to ask if in security perspective is it feasible? And also how do you do a search query on encrypted database using the partial text of the data?

Thank you
SuggestionRe: I need advice on storing application level encrypted data. Pin
Kornfeld Eliyahu Peter5-Jun-17 20:50
professionalKornfeld Eliyahu Peter5-Jun-17 20:50 
QuestionHow do I write the insert sql statement for the following scenario ? Pin
karengsh3-Jun-17 22:30
karengsh3-Jun-17 22:30 
AnswerRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 13:49
professionalMycroft Holmes4-Jun-17 13:49 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 20:41
karengsh4-Jun-17 20:41 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes4-Jun-17 20:58
professionalMycroft Holmes4-Jun-17 20:58 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh4-Jun-17 22:12
karengsh4-Jun-17 22:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes5-Jun-17 12:05
professionalMycroft Holmes5-Jun-17 12:05 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh10-Jun-17 19:12
karengsh10-Jun-17 19:12 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes10-Jun-17 20:45
professionalMycroft Holmes10-Jun-17 20:45 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh11-Jun-17 17:38
karengsh11-Jun-17 17:38 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes11-Jun-17 23:39
professionalMycroft Holmes11-Jun-17 23:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 18:55
karengsh14-Jun-17 18:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 20:10
Mazahir Habib1-Jun-17 20:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 22:16
professionalJohn C Rayan1-Jun-17 22:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 22:25
professionalMycroft Holmes1-Jun-17 22:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 13:59
indian1431-Jun-17 13:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 1:18
mveRichard Deeming2-Jun-17 1:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.