Get Info From Database, or Build Inferred Info?

Posted by Zaemz on Programmers See other posts from Programmers or by Zaemz
Published on 2013-10-21T17:50:52Z Indexed on 2013/10/21 22:03 UTC
Read the original article Hit count: 278

Filed under:
|
|

Does it make more sense to store and retrieve properties or information directly related to an item in a database, or, say in such a case that a product's ID could describe information about it, should the information be gathered from that?

Example: Item SKU -- 4HBU12

4 - is the number of motors
H - the voltage
B - the color, blue
U - the model
12 - the length

Should I store those individual attributes as well as the SKU, or should I store only the SKU and build the attributes from it?

© Programmers or respective owner

Related posts about design

Related posts about database