Smart Inventory Management and Database Sharding

摘要

A method for sharding a store inventory database is provided. The method may include separating a store inventory database into a first inventory database shard in a first inventory database server which has inventory data for a first group of items sold by a store and into a second inventory database shard in a second inventory database server which has inventory data for a second group of items sold by the store which are different than the first group of items. The method may also include associating a router with the sharded store inventory database, the router housing resident shard determination logic which comprises information which, for an item sold by the store, identifies an inventory database shard on which inventory data for the item is stored.

主权项

1. A computer system comprising:
a sharded store inventory database, the sharded store inventory database comprising:
a first inventory database shard in a first inventory database server, the first inventory database shard having inventory data for a first group of items sold by a store;a second inventory database shard in a second inventory database server, the second inventory database shard having inventory data for a second group of items sold by a store, the second group of items being different than the first group of items; a router associated with the sharded store inventory database, the router comprising shard determination logic, wherein the shard determination logic comprises information which, for an item sold by the store, identifies an inventory database shard on which inventory data for the item is stored.