Designing a database for warehouses
Scenario
We are looking at developing a product which will effectively be a
warehousing system. If you imagine a library - A library can have a
physical layout (isles) then on the shelves we have books of various
sizes, ages, categories, paper types (attributes). Then within the books,
we could have more books (like chapters or short stories). This can be
divided and divided (we've not decided on the limit yet). Now, each time
something happens - a shelf is moved, renamed, a book is moved, deleted,
added, renamed, etc... we need to keep track of those events - an audit
trail (who performed the action, what they did, when they did it... etc).
I am wondering, does anyone have any good design tips, links etc for me?
Our main concern is query speed since we could potentially have 100k's or
even millions of items to manage.
What are we looking to use?
C#
mvc 4
.net 4.5
Sql server 2012 (although we are open to other suggestions)
VS2012
Any advice would be greatly appreciated. Thanks.
No comments:
Post a Comment