Apparatus and method for supplying secure relational query results from a semi-structured document database
An apparatus has a processor and a memory connected to the processor. The memory stores instructions executed by the processor to receive a relational query at a semi-structured document database. An access permissions index is looked-up for available documents for a user submitting the relational query. The relational query is resolved against relational schema within a relational schema index for the available documents to produce secure relational query results. The secure relational query results are supplied.
1. An apparatus, comprising:
a processor; and
a memory connected to the processor, the memory storing instructions executed by the processor to:
ingest and store within a semi-structured document database a semi-structured document with access permissions,
form an access permissions index entry for the semi-structured document within an access permissions index,
form a relational schema index entry for the semi-structured document within a relational schema index;
and resolve a relational query against the semi-structured document database utilizing the access permissions index and the relational schema index, wherein the memory storing instructions executed by the processor to resolve the relational query include instructions to:
look-up within the access permissions index available documents for a user submitting the relational query,
resolve the relational query against relational schema within the relational schema index for the available documents to produce secure relational query results, and
supply the secure relational query results.
2. The apparatus of claim 1 wherein the available documents for the user submitting the relational query are based upon a role of the user submitting the relational query.
3. The apparatus of claim 1 wherein the access permissions index includes individual entries specifying a list of documents available for a read permission role.
4. The apparatus of claim 1 wherein the relational schema index includes individual entries specifying a row identification, a row value, a column identification, a column value and a document identification.