<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">We are not the only ones thinking about this here is some research that some guys at MIT did <a href="http://people.csail.mit.edu/nickolai/papers/raluca-cryptdb.pdf">http://people.csail.mit.edu/nickolai/papers/raluca-cryptdb.pdf</a><div><br><div><div>On 15 Oct,2013, at 10:51 , Apostolos Emmanouilidis <<a href="mailto:aemmanou@redhat.com">aemmanou@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<meta http-equiv="Content-Type" content="text/html; CHARSET=UTF-8">
<meta name="GENERATOR" content="GtkHTML/4.6.4">
<div>
Solution #3 must be the most performance efficient one. However, my sense is that in order to achieve good matching results, the metadata would need to contain some keywords / keyphrases of the actual content which is encrypted. This sounds like exposing important information as unecrypted. Maybe a combination of #1 and #3 could be an option as well. The metadata could be encrypted, loaded into memory, decrypted and queried.
<br>
<br>
On Tue, 2013-10-15 at 10:17 +0200, Erik Jan de Wit wrote:
<blockquote type="CITE">
<pre>Don't know how feasible it is, but we could query the encrypted data without decrypting. We still have tables, columns and rows and with encrypted names and values. Then we could parse the sql statement and encrypt the names and values in it and then run it against the database. The returned result is then the only thing that needs to be decrypted. How does that sound? This approach will obviously give away that data in certain columns is the same, and maybe there is more downsides to this that I don't see.
Cheers,
Erik Jan
On 14 Oct,2013, at 21:47 , Summers Pittman <<a href="mailto:supittma@redhat.com">supittma@redhat.com</a>> wrote:
<font color="#737373">> One of the things that came up while discussing offline secure storage </font>
<font color="#737373">> on Android was how to query encrypted data.</font>
<font color="#737373">> </font>
<font color="#737373">> The first ideas that I could think of were:</font>
<font color="#737373">> </font>
<font color="#737373">> 1) Load encrypted files/data/databases into memory, decrypt them, query </font>
<font color="#737373">> them, return results and GC the decrypted data.</font>
<font color="#737373">> </font>
<font color="#737373">> 2) magical phonetic encryption</font>
<font color="#737373">> </font>
<font color="#737373">> 3) Include queryable decrypted metadata along with encrypted payloads. </font>
<font color="#737373">> The payloads will not be queryable and only be decrypted if metadata </font>
<font color="#737373">> matches the query.</font>
<font color="#737373">> </font>
<font color="#737373">> #1 has some benefits (easy to implement across platforms, doesn't </font>
<font color="#737373">> require a lot of work) and some draw backs (large datasets would eat </font>
<font color="#737373">> into available memory, whole dataset would be vulnerable to a VM attack).</font>
<font color="#737373">> </font>
<font color="#737373">> #2 is a placeholder for better ideas.</font>
<font color="#737373">> </font>
<font color="#737373">> #3 is interesting because it is a middle of the road approach. One of </font>
<font color="#737373">> the options for implementation I thought of would be to annotate fields </font>
<font color="#737373">> in the VO being stored as "privledged" and they would be the only ones </font>
<font color="#737373">> encrypted/decrypted when an object is stored or loaded.</font>
<font color="#737373">> </font>
<font color="#737373">> wdyt?</font>
<font color="#737373">> _______________________________________________</font>
<font color="#737373">> aerogear-dev mailing list</font>
<font color="#737373">> <a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a></font>
<font color="#737373">> <a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a></font>
_______________________________________________
aerogear-dev mailing list
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>aerogear-dev mailing list<br><a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>https://lists.jboss.org/mailman/listinfo/aerogear-dev</blockquote></div><br></div></body></html>