Ideas on how to scale a shared inventory database???

We have a database today that holds all of our shared inventory. How do we scale out ? We run into concurrency issues today as mutliple users may want to access the same inventory,etc.

Im sure its a common problem.. So how do folks implement this while also having faster response to available inventory and also ensuring no downtime

Thanks

Comments

[Paul Mayer]

Have a look at sparesFinder - www.sparesfinder.net . They manage Virtual Inventories for many companies using a web based set of tools allowing inventory from multiple systems aggregated and searched.