公开(公告)号：US11210184B1

公开(公告)日：2021-12-28

申请号：US15616888

申请日：2017-06-07

Applicant: Amazon Technologies, Inc.

Inventor： Anurag Windlass Gupta ,  Murali Brahmadesam ,  Changan Han ,  Alexandre Olegovich Verbitski ,  Xiaofeng Bao ,  Alisdair William Owens ,  Xiang Peng ,  Benjamin S. Ellis ,  Raman Mittal ,  Konstantin Dubinets ,  Tiffany Jianto ,  Venkatesh Nandakumar ,  Seungmin Wei

IPC: G06F11/14 ,  G06F16/23

Abstract: Online restore operations for a database engine can be performed. A request to restore a database to a previous state can be received. Previously stored content of the database, such as snapshot stored prior to the previous state, can be identified along with log records describing changes to be made to the content prior to the previous state. State information in a query engine can be updated based on the previously stored content and log records so that queries can be processed based on the state information at the database restore to the previous state.

公开(公告)号：US12130798B1

公开(公告)日：2024-10-29

申请号：US15625933

申请日：2017-06-16

Applicant: Amazon Technologies, Inc.

Inventor： Murali Brahmadesam ,  Changan Han ,  Raman Mittal

IPC: G06F16/23 ,  G06F3/06 ,  G06F16/22

CPC classification number: G06F16/2365 ,  G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F16/22

Abstract: Variable reclamation of data copies can be performed. Copies of data may be stored in a data store. The copies of the data may be available to restore or return the data to a state described in or based on one of the copies. One or more copies, or portions of a copy, may be selected for invalidation according to a variable rate. The variable rate may be determined based on accesses to the data. Selected copies, or portions of a copy, may then be invalidated.

公开(公告)号：US12072900B2

公开(公告)日：2024-08-27

申请号：US18159035

申请日：2023-01-24

Applicant: Amazon Technologies, Inc.

Inventor： Changan Han ,  Murali Brahmadesam ,  Anupriya Mathur ,  Navaneetha Krishnan Thanka Nadar

IPC: G06F16/2458 ,  G06F16/2455 ,  G06F16/248

CPC classification number: G06F16/2474 ,  G06F16/2455 ,  G06F16/248

Abstract: A database system may add a read-only query engine to perform read-only queries associated with points-in-time of a database. In various embodiments, the read-only query engine may be added in response to a manual request, an automatic refresh of a network endpoint, a query specifying a point-in-time, or a connection request. The read-only query engine may perform the point-in-time queries on a version the database at the point-in-time and return results for the queries. Upon completion of the queries or at a determined time, the database system may remove the read-only query engine. The specified point-in-time may refer to a current time, a prior time, or a future time with respect to the current time.

公开(公告)号：US11561864B1

公开(公告)日：2023-01-24

申请号：US16831651

申请日：2020-03-26

Applicant: Amazon Technologies, Inc.

Inventor： Murali Brahmadesam ,  Changan Han ,  Raman Mittal ,  Seungmin Wei

IPC: G06F16/17 ,  G06F16/182 ,  G06F16/27 ,  G06F11/14

Abstract: A point-in-time clone may be created for a database. A request to create the point-in-time clone may be received. The clone may be provided with access to a storage for the database that stores a history of modifications to the database applicable to return data of the database according to a state of the data at the specified point in time. The clone may then be updated so that the updates made to the clone are stored for subsequent access by the clone.

公开(公告)号：US11341001B1

公开(公告)日：2022-05-24

申请号：US16910820

申请日：2020-06-24

Applicant: Amazon Technologies, Inc.

Inventor： Murali Brahmadesam ,  Changan Han

IPC: G06F7/02 ,  G06F16/00 ,  G06F11/14 ,  G06F16/242 ,  G06F16/27 ,  G06F16/23

Abstract: Techniques are described for enabling a relational database service of a cloud provider network to provide online restore or “backtrack” capabilities that are unlimited in terms of an amount of time in the past to which a database can be restored. Database systems typically provide restoration capabilities that allow users to undo or revert to a prior state of the database. Restoring a database to a prior state can be useful in many different scenarios. For example, a user might restore a database to remove or rollback errors introduced into a database as a result of inadvertent changes to data or to a schema of the data stored in the database. As another example, database administrators or other users can use restore operations as part of testing modifications to a database schema when developing applications or other tools that use the database.

公开(公告)号：US10909143B1

公开(公告)日：2021-02-02

申请号：US15488329

申请日：2017-04-14

Applicant: Amazon Technologies, Inc.

Inventor： Murali Brahmadesam ,  Raman Mittal ,  Li-Che Hsiao ,  Konstantin Dubinets ,  Seungmin Wei ,  Xiaofeng Bao ,  Changan Han ,  Saleem Mohideen ,  Venkatesh Nandakumar ,  Xiang Peng

IPC: G06F16/00 ,  G06F16/27 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23

Abstract: Data pages of a database may be shared to create a copy of the database. A request to create a copy of the database may be received. Pointers to the data pages in the data store may be generated and stored as part of the copy of the database. When a request to read a data page in the copy of the database is received, the pointer to the data page may be accessed and the data page read from the database. When a request to modify a data page in the copy of the database is received, a modified version of the data page may be stored as part of the copy of the database and the pointer updated to point to the modified version of the data page.

公开(公告)号：US11914571B1

公开(公告)日：2024-02-27

申请号：US15926983

申请日：2018-03-20

Applicant: Amazon Technologies, Inc.

Inventor： Xiaofeng Bao ,  Murali Brahmadesam ,  Yi Ding ,  Niket Goel ,  Anurag Windlass Gupta ,  Kamal Kant Gupta ,  Changan Han ,  Tiffany Jianto ,  Tengiz Kharatishvili ,  Saileshwar Krishnamurthy ,  Bohan Liu ,  Saleem Mohideen ,  Punit Rajgaria ,  Joseph Andrew Tucek ,  Alexandre Olegovich Verbitski

IPC: G06F16/23 ,  G06F16/17 ,  G06F16/176

CPC classification number: G06F16/2315 ,  G06F16/1734 ,  G06F16/1767

Abstract: Optimistic concurrency may be implemented for multiple writers to a database. Writes to a database from different writers may succeed unless a conflict is detected at the data store for the database. For detected conflicts, a request to resolve the conflict between writes may be submitted to a primary writer, which may determine and provide a resolution of the conflict to the conflicting writers. The data store may then be updated to commit the selected write identified by the resolution of the conflict.

公开(公告)号：US20230281211A1

公开(公告)日：2023-09-07

申请号：US18159035

申请日：2023-01-24

Applicant: Amazon Technologies, Inc.

Inventor： Changan Han ,  Murali Brahmadesam ,  Anupriya Mathur ,  Navaneetha Krishnan Thanka Nadar

IPC: G06F16/2458 ,  G06F16/248 ,  G06F16/2455

CPC classification number: G06F16/2474 ,  G06F16/2455 ,  G06F16/248

Abstract: A database system may add a read-only query engine to perform read-only queries associated with points-in-time of a database. In various embodiments, the read-only query engine may be added in response to a manual request, an automatic refresh of a network endpoint, a query specifying a point-in-time, or a connection request. The read-only query engine may perform the point-in-time queries on a version the database at the point-in-time and return results for the queries. Upon completion of the queries or at a determined time, the database system may remove the read-only query engine. The specified point-in-time may refer to a current time, a prior time, or a future time with respect to the current time.

公开(公告)号：US11573969B1

公开(公告)日：2023-02-07

申请号：US16777741

申请日：2020-01-30

Applicant: Amazon Technologies, Inc.

Inventor： Changan Han ,  Murali Brahmadesam ,  Anupriya Mathur ,  Navaneetha Krishnan Thanka Nadar

IPC: G06F16/2458 ,  G06F16/248 ,  G06F16/2455

Abstract: A database system may add a read-only query engine to perform read-only queries associated with points-in-time of a database. In various embodiments, the read-only query engine may be added in response to a manual request, an automatic refresh of a network endpoint, a query specifying a point-in-time, or a connection request. The read-only query engine may perform the point-in-time queries on a version the database at the point-in-time and return results for the queries. Upon completion of the queries or at a determined time, the database system may remove the read-only query engine. The specified point-in-time may refer to a current time, a prior time, or a future time with respect to the current time.

公开(公告)号：US11455290B1

公开(公告)日：2022-09-27

申请号：US16915332

申请日：2020-06-29

Applicant: Amazon Technologies, Inc.

Inventor： Murali Brahmadesam ,  Nanda Kaushik ,  Changan Han ,  Kartikey Bhatt ,  Sangyong Hwang ,  Punit Rajgaria

IPC: G06F16/23 ,  G06F16/22 ,  G06F16/242 ,  G06F16/11 ,  G06F16/16 ,  G06F16/18 ,  G06F16/17

Abstract: Techniques for distributed database storage utilizing split volume types for redo log records and change log records are described. A database engine sends redo log data to a first set of page storage nodes and change log data to a second set of tuple storage nodes, where the change log data is stored in an indexed manner Client access to change log data may be provided through a separate set of streaming storage servers instead of through the database engine.