Provided is a method to obtain a first query indicating a set of fields of a record of a first data store and generate a plurality of queries based on the first query, where the plurality of queries includes a shared set of parameters. The method includes storing a plurality of query values identifying the plurality of queries in an in-memory data store, determining a second query comprising the shared set of parameters based on the plurality of queries, and locking a set of values of the record based on the second query. The method includes retrieving a query response comprising the set of values with the second query, fulfilling the plurality of queries stored in the in-memory data store based on the set of values, and generating a response to the first query based on the fulfilled plurality of queries.
Legal claims defining the scope of protection. Each claim is shown in both the original legal language and a plain English translation.
12. The medium of claim 1, the operations further comprising determining a database type based on the request, wherein generating the plurality of queries comprises generating the plurality of queries based on the database type.
13. The medium of claim 1, wherein retrieving the query response comprises storing the retrieved query response in the second, in-memory data store.
A system and method for managing and retrieving query responses in a distributed computing environment addresses the challenge of efficiently storing and accessing large volumes of query data while minimizing latency. The system includes a first in-memory data store for storing query requests and a second in-memory data store for storing query responses. When a query is received, it is stored in the first data store, and the system retrieves the corresponding query response from the second data store. The retrieved response is then stored in the second data store to ensure it remains accessible for future requests. This approach optimizes performance by leveraging in-memory storage, which provides faster access times compared to traditional disk-based storage systems. The system may also include a query processing module that processes incoming queries, a response generation module that generates responses based on the processed queries, and a synchronization mechanism to maintain consistency between the two in-memory data stores. The method ensures that query responses are quickly retrievable and reduces the need for repeated computations, improving overall system efficiency.
15. The medium of claim 1, the operations further comprising storing the set of values in a tamper-evident, distributed ledger encoding records of a plurality of previous values in a directed acyclic graph of cryptographic hash pointers, wherein the tamper-evident, distributed ledger is stored in a peer-to-peer network.
17. The medium of claim 1, wherein generating the plurality of queries comprises steps for generating the plurality of queries.
18. The medium of claim 1, wherein the operations comprise steps for caching queries.
20. The medium of claim 1, wherein the unlocking the set of values of the record includes only unlocking the set of values of the record for the second query.
This invention relates to database systems and specifically to methods for managing access to data records in a database. The problem addressed is controlling access to sensitive data in a database while allowing certain queries to retrieve the data without exposing it to unauthorized users. The invention provides a system where a database record is locked by default, but specific queries can unlock the record to retrieve its values while maintaining security for other operations. The system involves a database that stores records, each containing a set of values. A first query is executed to lock the set of values of a record, preventing unauthorized access. A second query is then executed to unlock the set of values of the same record, but only for the second query. This selective unlocking ensures that the record's values are accessible only to the second query and not to other operations or users. The locking and unlocking mechanisms are implemented using database commands or transactions that enforce access control policies. The invention ensures that sensitive data remains protected while allowing controlled access for specific queries, improving data security in database environments.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
September 9, 2021
October 18, 2022
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.