# Patent

## Title
Scalable precomputation system for host-opaque processing of encrypted databases

## Abstract

A method, system, and computer program product to generate results for a query to an encrypted database stored on a host are described. The system includes a host comprising a storage device to store the encrypted database, and a a secure processor to generate indexes and index metadata from the encrypted database, each index identifying records of the encrypted database associated with a range of data for at least one field stored in the records of the encrypted database and the metadata indicating the range of data identified by the associated index. The system also includes an interface of the host to receive the query, and a host processor to generate a sub-query form the query for each field associated with the query. Based on sub-query results obtained through the index metadata, the secure processor searches a subspace of the encrypted database to generate the results of the query.

## Background
DOMESTIC BENEFIT/NATIONAL STAGE INFORMATION
This application is a continuation of U.S. application Ser. No. 13/768,568 filed Feb. 15, 2013, the disclosure of which is incorporated by reference herein in its entirety.


BACKGROUND
The present invention relates generally to database queries, and more specifically, to queries of encrypted databases.
In many systems including databases of encrypted information such as financial and medical databases, for example, substantial parts of the databases must be decrypted only by secure hardware because of regulatory or other reasons. These encrypted databases are considered host-opaque because even the host that stores the database may not access the database contents. Instead, only one or more secure processors (secure coprocessors) may access the database. In such systems, when the database size exceeds the total capacity of the secure coprocessors, a large latency can result in conducting a traditional search. This can be especially true when data mining encrypted databases because data mining generally involves searching for correlations between different properties of database records.
SUMMARY
According to an embodiment of the present invention, a system to generate results for a query to an encrypted database includes a host comprising a storage device to store the encrypted database; a secure processor to generate indexes and index metadata from the encrypted database, each index identifying records of the encrypted database associated with a range of data for at least one field stored in the records of the encrypted database and the metadata indicating the range of data identified by the associated index; an interface of the host configured to receive the query; and a host processor configured to generate a sub-query form the query for each field associated with the query, wherein based on sub-query results obtained through the index metadata, the secure processor searches a subspace of the encrypted database to generate the results of the query.
According to another embodiment of the present invention, a computer program product stores computer-readable instructions which, when processed by a first processor, cause the first processor to implement a method of generating results of a query to an encrypted database stored on a host. The method includes generating indexes from the encrypted database, each index identifying records of the encrypted database associated with a range of data for at least one field stored in the records of the encrypted database; generating index metadata associated with each index, the index metadata indicating the range of data identified by the associated index; determining a subspace of search within the encrypted database based on sub-query results obtained through the index metadata; and searching the subspace of the encrypted database to generate the results of the query.
Additional features and advantages are realized through the techniques of the present invention. Other embodiments and aspects of the invention are described in detail herein and are considered a part of the claimed invention. For a better understanding of the invention with the advantages and the features, refer to the description and to the drawings.



BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS
The subject matter which is regarded as the invention is particularly pointed out and distinctly claimed in the claims at the conclusion of the specification. The forgoing and other features, and advantages of the invention are apparent from the following detailed description taken in conjunction with the accompanying drawings in which:
FIG. 1 is a block diagram of a system to search an encrypted database according to an embodiment of the invention;
FIG. 2 is a data flow diagram of a query operation according to an embodiment of the invention;
FIG. 3 illustrates exemplary sub-query indexes used to generate the sub-query output according to an embodiment of the invention;
FIG. 4 is a flow diagram of a method of outputting query results for a query of an encrypted database according to an embodiment of the invention; and
FIG. 5 illustrates incremental indexing of a database according to an embodiment of the invention.



DETAILED DESCRIPTION
As noted above, searching or data mining large encrypted databases can result in large latencies when the database size exceeds the total capacity of the secure coprocessors that are required to decrypt the databases. Embodiments of a system and method are described herein that address searching encrypted databases. Specifically, a scalable pre-computation system facilitates scaling for any size of encrypted database by pre-computing or pre-filtering contents to a level accessible even by an untrusted host.
FIG. 1 is a block diagram of a system to search an encrypted database 120 according to an embodiment of the invention. The system includes a host 100. The host 100 may be an untrusted host, meaning that the host 100 may store but not access the contents of an encrypted database 120 stored in a memory device 110 of the host 100. The encrypted database 120 may have any structure for organizing the records 123 that comprise the database 120 and is further detailed with reference to FIG. 5 below. Each of the records 123 may include one or more fields 125 of information. The host 100 may also include an interface 130 by which a search may be entered, for example, one or more processors 140, and an output device 150 which may include, for example, a display or a network communication port. One or more secure processors 160 are part of or interface with the host 100. The secure coprocessors 160 (when more than one secure processor 160 is available) form one or more “trust domains,” which are groups of devices with synchronized symmetric keys. Devices within the same group are essentially interchangeable and are afforded the same level of trust. Synchronized coprocessors 160 offer scalable aggregate performance. However, as noted above, even with the aggregation of processing power afforded by multiple processors 160, a user-tolerated response time may be infeasible when a large secured database 120 must be searched. Exemplary embodiments of the process used to facilitate a search of the database 120 are detailed below.
FIG. 2 is a data flow diagram of a query operation according to an embodiment of the invention. From the encrypted database 120 of interest, a set of encrypted indexes 210 is generated and may be stored in the memory device 110 of the host 100. The indexes may be generated by the secure processors 160 offline prior to the query being received. Each index 210 may be a single or multi-field 125 (combined) index 210, and indexes 210 may be redundant. For example, if a database 120 of financial transactions is considered, one index 210 (A) may indicate records 123 related to transactions of $0-$50. Another index 210 (B) may indicate records 123 related to transactions of $25-$75 and that occurred between Jun. 1, 2012 to Dec. 31, 2012. Yet another index 210 (C) for the same exemplary database 120 may indicate records 123 related to transactions that occurred between Jan. 1, 2012 to Dec. 31, 2012. Thus, index 210 (A) is a single field 125 index 210 as is index 210 (C). Index 210 (B) is a combined field 125 index 210 that combines a range of transaction values and dates of the transactions. Both index 210 (A) and index 210 (C) have some redundancy with records 123 indicated by index 210 (B). In the case of index 210 (A), the transaction amounts from $25 to $50 overlap, and in the case of index (C), the transaction dates from Jun. 1, 2012 to Dec. 31, 2012 overlap with those of index 210 (B). In generating the indexes 210, the record 123 structure may be considered, as well as frequency query types. For example, if transaction amounts are often queried in conjunction with transaction dates, more combined indexes 210 may be generated combining amount and date field 125 ranges.
Each index 210 is associated with respective index metadata 220 that, unlike the secure database 120 and indexes 210, is viewable by the host 100. The index metadata 220, like the indexes 210, may be generated offline prior to any query being received. To be clear, the generation of indexes 210 and corresponding index metadata 220 may be regarded as preprocessing rather than query processing. This preprocessing—especially the generation of indexes 210, which may require filtering of the full database 120 multiple times—facilitates the scalability and reduction of latency for subsequent queries as detailed below. The index metadata 220 gives insight into the records 123 associated with each index 210. The metadata 220 need not identify records 123 like the index 210 but can be thought of as a guide or directory to the index 210 summarizing the contents of the records 123 included in the index 210. For example, the metadata 220 associated with index 210 (A) in the example described above would indicate that records 123 related to transaction amounts of $0 to $50 are included in the index 210 (A). When a query is received by the host 100, rather than searching through the entire database 120 using the secure processors 160, the host 100 breaks down the query into sub-queries that may be used to search the metadata 220 information. For example, considering an encrypted database 120 of financial transaction records 130 again, assume that the query is “transactions between $25 and $50 made in January and February of 2012.” Then the query may be broken down into transactions between $25 and $50 and transactions made in January and February of 2012. Each of those two sub-queries could be searched with the index metadata 220 rather than by having to search the encrypted indexes 210 of encrypted database 120. The sub-query of the metadata 220 results in sub-query indexes 230 which are any indexes 210 that match any of the sub-queries. The sub-query indexes 230 are processed by the secure processors 160 in the manner detailed with reference to FIG. 3 and yield the intermediate results 240 and the sub-query output 250, which identifies the search subspace of interest or the subset of the records 123 of the database 120 that should be searched by the processors 160 with the original query to generate the query output 260.
FIG. 3 illustrates exemplary sub-query indexes 230 used to generate the sub-query output 250 according to an embodiment of the invention. Sub-query indexes 230 Y1 and Y2 may relate to transaction time. Continuing the example discussed with reference to FIG. 2 (exemplary query of transactions between $25 and $50 made in January and February of 2012), Y1 and Y2 are indexes 210 that include transaction records 123 for January and February of 2012. Sub-query indexes 230 X1, X2, and X3 are indexes 210 that include transaction records 123 with amounts between $25 and $50. The gray bars shown in FIG. 3 represent the records that fit one of the sub-query criteria, and the black blocks represent the intersection of sub-queries. For example, one of the gray rows associated with index 210 Y1 may indicate one or more records 123 of transactions in January, 2012, while one of the gray columns associated with index 210 X3 (indicated as “one index match”) may indicate one or more records 123 associated with transactions for amounts between $30 and $35. The intersection of those two gray lines (indicated as “intersection of index matches”) is a black box that represents a subset of records 123 that meet both the transaction amount and transaction time criteria of the query. The black boxes in FIG. 3 result in the sub-query output 250, which is a bit vector for each of the sub-query indexes 230 that indicates the records within those sub-query indexes 230 where the query criteria intersect. This process of determining the intersection of query criteria relating to different fields 125 is necessary when the query involves two fields 125 (transaction amount and transaction date) as in the example discussed above and is also used when the query involves three or more fields 125. However, when the query involves only one field 125, the sub-query and query are the same and a search (by the host 100 rather than the secure processors 160) of the metadata 220 is sufficient to identify the sub-query output 250 or records 123 for search by the secure processors 160 without additionally determining the intersection of fields 125.
FIG. 4 is a flow diagram of a method of outputting query results for a query of an encrypted database according to an embodiment of the invention. At block 410, generating indexes 210 from the database 120 is done offline by secure processors 160, according to embodiments of the invention, to reduce latency associated with a subsequent database 120 query. Generating index metadata 220 in association with each index 120 at block 420 is also done offline. Because the metadata 220 only provides a guide or directory to the contents of the associated index 210, the metadata 220 is accessibly by the non-secure host 100 that may store the encrypted database 120. Receiving and decomposing a query into sub-queries at block 430 facilitates the host 100 processor 140 (rather than the secure processor 160) searching the metadata 220 to identify sub-query indexes 230 at block 440. A sub-query refers to a query of a single field 125, because a query may specify search criteria for two or more fields 125. The sub-query indexes 230 identify indexes with potential matches to the query. The secure processors 160 use the sub-query indexes 230 for identifying intersections among the sub-query indexes 230 to generate sub-query output 250 at block 450. That is, indexes 210 (from step 410) that are identified as sub-query indexes 230 are cross-referenced (when the query involves more than one field) to generate the sub-query output 250 as discussed with reference to FIG. 3. When the sub-query output 250 has been generated and indicates the subspaces of the database 120 that must be searched in detail, the secure processors 160 perform searching the database 120 subspaces indicated by the sub-query output 250 at block 460. Outputting the query results at block 470 is a scalable process because of the indexing and the pre-computation of the intersection spaces.
FIG. 5 illustrates incremental indexing of a database according to an embodiment of the invention. The database 120 according to embodiments of the invention need not be static or read-only. However, the scalability and efficiency of the pre-computation (done through the use of the metadata 220) are affected by frequent changes in the database 120 because of the need for re-indexing. In embodiments of the invention, the database 120 is “append only,” meaning that records may be added from time to time, but changes necessitating re-indexing do not occur. FIG. 5 shows a meta-index 510 that may combine multiple indexes 210 as a way to preliminarily filter the database 120 entries. FIG. 5 shows that the meta-index 510 may include an updated portion of an index 210, added since the last indexing. Also, updated records may be located in no more than two lookups using the meta-index 510, as shown in FIG. 5.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used herein, the singular forms “a”, “an” and “the” are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms “comprises” and/or “comprising,” when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one more other features, integers, steps, operations, element components, and/or groups thereof.
The description of the present invention has been presented for purposes of illustration and description, but is not intended to be exhaustive or limited to the invention in the form disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the invention. The embodiment was chosen and described in order to best explain the principles of the invention and the practical application, and to enable others of ordinary skill in the art to understand the invention for various embodiments with various modifications as are suited to the particular use contemplated
The flow diagram depicted herein is just one example. There may be many variations to this diagram or the steps (or operations) described therein without departing from the spirit of the invention. For instance, the steps may be performed in a differing order or steps may be added, deleted or modified. All of these variations are considered a part of the claimed invention.
While the preferred embodiment to the invention had been described, it will be understood that those skilled in the art, both now and in the future, may make various improvements and enhancements which fall within the scope of the claims which follow. These claims should be construed to maintain the proper protection for the invention first described.

## Claims

1. A system to generate results for a query to an encrypted database, the system comprising:
a host comprising a storage device configured to store the encrypted database;
a secure processor configured to generate encrypted indexes and unencrypted index metadata from the encrypted database, each encrypted index identifying records of the encrypted database associated with a range of data for at least one field stored in the records of the encrypted database and each unencrypted index metadata indicating the range of data for each of the at least one field identified by the associated encrypted index;
an interface of the host configured to receive the query; and
a host processor configured to generate a sub-query from the query for each field associated with the query and to search the unencrypted index metadata with each sub-query to generate sub-query results, the sub-query results indicating sub-query indexes, wherein
based on the sub-query results obtained through the unencrypted index metadata, the secure processor searches a subspace of the encrypted database associated with the sub-query indexes to generate the results of the query.

2. The system according to claim 1, wherein the secure processor generates the encrypted indexes and the unencrypted index metadata offline prior to receiving the query.

3. The system according to claim 1, wherein the encrypted database and the encrypted indexes are inaccessible to the host processor.

4. The system according to claim 1, wherein the host processor searches the unencrypted index metadata for each sub-query to identify the sub-query indexes associated with each sub-query, the sub-query indexes being encrypted indexes that meet the criteria of each associated sub-query.

5. The system according to claim 4, wherein the secure processor obtains the sub-query results as an intersection of the sub-query indexes associated with different fields when the query is associated with two or more fields.

6. The system according to claim 4, wherein the secure processor obtains the sub-query results as the sub-query indexes when the query is associated with one field.

7. A computer program product, embodied in a non-transitory computer-readable medium, storing computer-readable instructions which, when processed by a first processor, causes the first processor to implement a method of generating results of a query to an encrypted database stored on a host, the method comprising:
generating encrypted indexes from the encrypted database, each encrypted index identifying records of the encrypted database associated with a range of data for at least one field stored in the records of the encrypted database;
generating unencrypted index metadata associated with each encrypted index, the unencrypted index metadata indicating the range of data for each of the at least one field of the associated encrypted index;
decomposing the query into a sub-query associated with each field in the query and searching the unencrypted index metadata with each sub-query to obtain sub-query indexes as the sub-query results;
determining a subspace of search within the encrypted database based on the sub-query results obtained through the unencrypted index metadata; and
searching the subspace of the encrypted database defined by the sub-query indexes to generate the results of the query.

8. The computer program product according to claim 7, wherein the generating the encrypted indexes and the unencrypted index metadata is done offline prior to receiving the query.

9. The computer program product according to claim 7, wherein the determining the subspace of search includes obtaining the sub-query indexes identified by a second processor of the host that decomposes the query into the sub-query for each field associated with the query and searches the unencrypted index metadata, accessible by the second processor of the host, for each sub-query to identify the sub-query indexes associated with each sub-query, the sub-query indexes being encrypted indexes that meet the criteria of each associated sub-query.

10. The computer program product according to claim 9, further comprising obtaining the sub-query results as an intersection of the sub-query indexes associated with different fields when the query is associated with two or more fields.

11. The computer program product according to claim 9, further comprising obtaining the sub-query results as the sub-query indexes when the query is associated with one field.