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: 380
        
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