US 12,072,900 B2
Adding a read-only query engine to perform queries to a point-in-time of a write-accessible database
Changan Han, Kirkland, WA (US); Murali Brahmadesam, Tiruchirapplli (IN); Anupriya Mathur, Santa Clara, CA (US); and Navaneetha Krishnan Thanka Nadar, Bothell, WA (US)
Assigned to Amazon Technologies, Inc., Seattle, WA (US)
Filed by Amazon Technologies, Inc., Seattle, WA (US)
Filed on Jan. 24, 2023, as Appl. No. 18/159,035.
Application 18/159,035 is a continuation of application No. 16/777,741, filed on Jan. 30, 2020, granted, now 11,573,969.
Prior Publication US 2023/0281211 A1, Sep. 7, 2023
Int. Cl. G06F 16/2458 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01)
CPC G06F 16/2474 (2019.01) [G06F 16/2455 (2019.01); G06F 16/248 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
a plurality of nodes, respectively comprising one or more processors and a memory that implement a database service, wherein the plurality of nodes have separate, respective access over a network to a distributed data storage service that stores a database to perform to perform queries in parallel, and wherein the database service configured to:
receive a read-only query that includes a timestamp that specifies a point-in-time for reading from a version of the database corresponding to the specified point-in-time, wherein the database service continued to accept modifications to the database and perform the modifications after the specified point-in-time;
receive a second query to the database;
perform, using a first one of the plurality of nodes assigned the read-only query, the read-only query that reads from the version of the database corresponding to the specific point-in-time, wherein the query reads data in the version of the database that was updated or deleted after the specific point in time;
perform, using a second one of the plurality of nodes assigned the second query, the second query;
return a result for the read-only query based on the data; and
return a result for the second query.