Amazon Technologies, Inc.

Ahmad Mohammad Radi Ahmad Alsmair

Saleem Mohideen

Navaneetha Krishnan Thanka Nadar

Gajanan Sharadchandra Chinchwadkar

Haritabh Gupta

Alexandre Olegovich Verbitski

Murali Brahmadesam

David Charles Wein

Grant Alexander McAlister

James Laurence Finnerty

Baskar Durairaj

Nanda Kaushik

Jan Engelsberg

Praveen Kannan

Aravind Kumar Kumar

Davor Prugovecki

Awisha Makwana

Sambhavi Raghuraman

Kiran Pillarisetty

Amit Krishnan

Sadagopan Nattamai Sathiyamoorthy

Li Che David Hsiao

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

Intelligent query routing may be performed across shards of a scalable database table. A router of a database system may receive an access request directed to one or more database tables. The router may evaluate the access request with respect to metadata obtained for the database tables to determine an assignment distribution of computing resources of the database system to data that can satisfy the access request. The router can select planning locations to perform the access request based on the assignment distribution of the computing resources. The router can cause the access request to be performed according to planning at the selected planning locations.

Intelligent query routing across shards of scalable database tables

Growing community of inventors

Seattle, WA, United States of America

Ahmad Mohammad Radi Ahmad Alsmair