Back to results
US 12,222,921 B1Granted
Database management techniques for concurrent write request processing
AssigneeOptum, Inc.
InventorPaul W. Vaughan
Life of this patent
Estimating the term…
Abstract
Various embodiments of the present invention provide methods, apparatuses, systems, computing devices, computing entities, and/or the like for facilitating efficient and effective execution of database management operations. For example, various embodiments of the present invention describe techniques for performing one or more database update operations given a concurrent write request group for a database using P concurrent request processor computing nodes, a match result serialization queue, and a centralized match result serializer computing node.
Claims20
A computer-implemented method comprising:
- receiving, by one or more processors, a concurrent write request associated with a concurrent write request group;
- determining, by the one or more processors, a selected request processor computing node of a plurality of concurrent request processor computing nodes for the concurrent write request;
- generating, by the one or more processors and using the selected request processor computing node, a concurrent match result determination for the concurrent write request, wherein the concurrent match result determination describes a proposed database aggregate for the concurrent write request;
- in response to generating the concurrent match result determination, generating, by the one or more processors, an unprocessed match result entry for the concurrent match result determination in a match result serialization queue, wherein:
- (i) the match result serialization queue describes a serialization ordering of one or more unprocessed match result entries, (ii) each unprocessed match result entry of the one or more unprocessed match result entries corresponds to an unprocessed concurrent match result determination that has not been processed, and (iii) processing a particular unprocessed concurrent match result determination comprises generating a match result validation determination for the particular unprocessed concurrent match result determination;
- and
- initiating, by the one or more processors, the performance of one or more database update operations for a database using the match result serialization queue.
4 more elements
A system comprising memory and one or more processors communicatively coupled to the memory, the one or more processors configured to:
- receive a concurrent write request associated with a concurrent write request group;
- determine a selected request processor computing node of a plurality of concurrent request processor computing nodes for the concurrent write request;
- generate, using the selected request processor computing node, a concurrent match result determination for the concurrent write request, wherein the concurrent match result determination describes a proposed database aggregate for the concurrent write request;
- in response to generating the concurrent match result determination, generate an unprocessed match result entry for the concurrent match result determination in a match result serialization queue, wherein:
- (i) the match result serialization queue describes a serialization ordering of one or more unprocessed match result entries, (ii) each unprocessed match result entry of the one or more unprocessed match result entries corresponds to an unprocessed concurrent match result determination that has not been processed, and (iii) processing a particular unprocessed concurrent match result determination comprises generating a match result validation determination for the particular unprocessed concurrent match result determination;
- and
- initiate the performance of one or more database update operations using the match result serialization queue.
4 more elements
One or more non-transitory computer-readable storage media including instructions that, when executed by one or more processors, cause the one or more processors to:
- for each receive a concurrent write request associated with a concurrent write request group;
- determine a selected request processor computing node of a plurality of concurrent request processor computing nodes for the concurrent write request;
- generate, using the selected request processor computing node, a concurrent match result determination for the concurrent write request, wherein the concurrent match result determination describes a proposed database aggregate for the concurrent write request;
- in response to generating the concurrent match result determination, generate an unprocessed match result entry for the concurrent match result determination in a match result serialization queue, wherein:
- (i) the match result serialization queue describes a serialization ordering of one or more unprocessed match result entries, (ii) each unprocessed match result entry of the one or more unprocessed match result entries corresponds to an unprocessed concurrent match result determination that has not been processed, and (iii) processing a particular unprocessed concurrent match result determination comprises generating a match result validation determination for the particular unprocessed concurrent match result determination;
- and
- initiate the performance of one or more database update operations using the match result serialization queue.
4 more elements
Dependencies are inferred from the claim text.