Amazon Technologies, Inc.

Aravind Kumar Kumar

Saleem Mohideen

Navaneetha Krishnan Thanka Nadar

Praveen Kannan

Jan Engelsberg

Murali Brahmadesam

Grant Alexander McAlister

Sanjay Shanthakumar

James Laurence Finnerty

Nanda Kaushik

Ahmad Mohammad Radi Ahmad Alsmair

Haritabh Gupta

Gajanan Sharadchandra Chinchwadkar

Raghavendran Gururajan

Amit Krishnan

Kiran Pillarisetty

Sambhavi Raghuraman

Awisha Makwana

Davor Prugovecki

Replication of a client-managed table may be configured across shards of system-managed tables in a database system for improved query performance. A client-managed table may be identified to replicate as a complete copy of the table respectively collocated with two or more shards of one or more other system-managed tables. The complete copy may be stored in respective storage volumes of the two or more shards of the one or more other system-managed tables. Metadata for performing access requests at a database system may be updated to identify the client-managed table as collocated with the two or more shards of the one or more other system-managed tables.

Configuring replication across shards of scalable database tables for improved query performance

Shard management may be implemented for scalable database tables. A table may be identified as aligned with another table of the database according to a common shard key across multiple shards that are mapped to respective storage volumes of a data store of the database according to a placement hierarchy. Different portions of the table may be stored across the shards as respective table slices with corresponding portions of the other table as respective other table slices with same values of the shard key. Metadata for performing access requests to the database may be updated to identify individual ones of the table slices stored with individual ones of the other table slices as respective table slice groups that are mapped to respective ones of the shards in the placement hierarchy.

Shard management for scaling database tables

Growing community of inventors

Sammamish, WA, United States of America

Aravind Kumar Kumar