fatkatie Posted May 24, 2017 Share Posted May 24, 2017 I've been asked to create an online inventory system for multiple vendors.The data should be stored in a way that allows searching on product parameters; the simple ones like color, size and other parameters like schedule times, expiration and must be of age.The vendor list is varied, including food, clothing, automotive parts, services and ... you name it.The parameters are so varied and rich that I can't come up with a simple scheme of how to record the information. I thought of a table with 'meta' columns that rely on a product characteristics to define them, or just a huge text field with a delimited list of paramters; like size:14, color:red, or product type tables; table_clothing, table_coatings, table_travel... My class analogy would be automotive_services extends product many times over.What ever I decide to do, I'll wind up chucking it as I've never thought about this kind of an inventory database. I'd like to hear from a e-commerce guy on how they did it.Thanks for any suggestions. Link to comment Share on other sites More sharing options...
requinix Posted May 24, 2017 Share Posted May 24, 2017 This would be a good job for a NoSQL-type database, or some similar mechanism. Otherwise the purely relational approach is an indexed key/value store (product ID, meta key, meta value) or two (first has product type + meta key, second has first's ID + meta value). A huge text field is definitely not the way to go. Link to comment Share on other sites More sharing options...
benanamen Posted May 24, 2017 Share Posted May 24, 2017 I agree with requinix. Take a look at MongoDB https://www.mongodb.com/ Link to comment Share on other sites More sharing options...
fatkatie Posted May 25, 2017 Author Share Posted May 25, 2017 Mongo? I think I'll start here: https://university.mongodb.com/courses/M101P/about Thanks both for the suggestions. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.