Amazon Technologies, Inc.

Li-Che Hsiao

Raman Mittal

Murali Brahmadesam

Yuri L Volobuev

Punit Rajgaria

Saleem Mohideen

Xiaofeng Bao

Changan Han

Seungmin Wei

Xiang Peng

Konstantin Dubinets

Venkatesh Nandakumar

Benjamin S Ellis

Shanpei Zhou

Peng Gu

Backup and restore of client-managed tables and system-managed tables in a same database may be performed. A request to restore a database with both a client-managed table and system-managed table may be received. The request may specify a point in time to restore the database. A metadata volume for the database that describes both the client-managed table and the system-managed table may be restored and used to identify the volumes for both the client-managed table and shards of the system-managed table. Redo logs for each of the volumes may be used according to timestamps that are synchronized according to a time synchronization service to generate restored versions of the volumes for the client-managed table and the shards of the system-managed table from backup copies, which can then be made available for accessing the database.

Backup and restore of client-managed and system-managed database tables

Direct storage loading may be used to add data to a database. New data may be added to a database, using nodes different than a database engine to access a database. The addition of the new data may be assigned to different nodes. The nodes may obtain the data and store the data to storage locations according allocated space in the database by the database engine. The new data can then be made available for access at the database engine.

Direct storage loading for adding data to a database

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.

Shared pages for database copies

Growing community of inventors

Stanford, CA, United States of America

Li-Che Hsiao