SHARD DETERMINATION LOGIC FOR SCALABLE ORDER AND INVENTORY MANAGEMENT ARCHITECTURE WITH A SHARED TRANSACTIONAL DATABASE

摘要

A method for sharding a store order database and order management application is provided. The method may include a computer router associated with a store receiving, from a customer computer, a query regarding an order. The router may use resident shard determination logic to identify a database shard which pertains to the order and which is part of a store order database having multiple database shards. The router may transmit information regarding the order to a database server which implements the identified database shard and which implements an order management system application layer. The database server may process information regarding the order and transmit information regarding the order to the customer computer.