Database Design

Magento’s database design is one of its most controversial aspects. Key data aremodeled using the Entity Attribute Value method (EAV). Utilizing an EAVmodeling pattern allows for unlimited attributes on any product, category, customer, or order, but EAV also depletes a programmer’s ability to write ad-hoc queries against the data. Before we delve deep intoMagento’s database design, we will look at the basic way of communicating with the database – the resource.