Should I use EAV model?

by

Great question, but of course, there is no “one true way”. As per @BenV, Magento does use the EAV model. My experience with it has been overwhelmingly positive, however it does trip up other users. Some considerations:

1. Performance.
EAV requires complex, multi-table joins to populate your object with the relevant attributes. That does incur a performance hit. However, that can be mitigated through careful caching (at all levels through the stack, including query caching) and the selective use of denormalization. Magento does allow administrators to select a denormalized model for categories and products where the number of SKUs warrants it (generally in the thousands). That in turn requires Observers that trigger re-indexing (always good!) and updates to the “flat” denormalized tables when product data changes. That can also be scheduled or manually triggered with a prompt to the administrator.

2. 3rd Party User Complexity
If you ever plan to make this application available to other users, many will find EAV too complex and you’ll end up dealing with a lot of bleating and uninformed abuse on the user forums (ref Magento!!).

3. Future extensibility and plugin architecture.
There is no doubt that the EAV model really comes into it’s own when extensibility is a factor. It is very simple to add new attributes into the model while minimizing the risk of breaking existing ORM and controller code.

4. Changes in datatype
EAV does make it a little harder to alter attribute datatypes. If your initial design calls for a particular attribute datatype that changes in future (say int to varchar), it means that you will have to migrate all the records for that attribute to the corresponding table that matches the new datatype. Of course, purists would suggest that you get the design right first time, but reality does intrude sometimes!

5. Manual product imports
One thing that EAV makes almost impossible is importing products (or other entities) into the database using SQL and/or phpMyAdmin-style CSV/XML. You’ll need to write an Importer module that accepts the structured data and passes it through the application’s Model layer to persist it to the database. That does add to your complexity.

More Related Contents:

  1. ALTER TABLE in Magento setup script without using SQL
  2. Magento – Retrieve products with a specific attribute value
  3. How do i edit home page of magento
  4. How do I create a simple ‘Hello World’ module in Magento?
  5. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  6. Magento – Quote/order product item attribute based on user input
  7. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  8. How to do left join in Doctrine?
  9. Default value in Doctrine
  10. Doctrine 2 and Many-to-many link table with an extra field
  11. Adding attributes to customer entity
  12. How to select randomly with doctrine
  13. Select entries between dates in doctrine 2
  14. Why is Magento so slow? [closed]
  15. How to re-save the entity as another row in Doctrine 2
  16. Subquery in doctrine2 notIN Function
  17. Programmatically add product to cart with price change
  18. How to set up entity (doctrine) for database view in Symfony 2
  19. Why I can not login to magento backend using google chrome
  20. How to get a one-dimensional scalar array as a doctrine dql query result?
  21. How to access Magento user’s session from outside Magento?
  22. How to use a findBy method with comparative criteria
  23. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  24. PayPal gateway has rejected request. Security header is not valid (#10002: Security error Magento
  25. How to setup a cron job in Magento module?
  26. Magento – Passing data between a controller and a block
  27. Query on a many-to-many relationship using Doctrine with Symfony2
  28. Doctrine2 association mapping with conditions
  29. How can I use DATE() in Doctrine 2 DQL?
  30. Skip Checkout in Magento for a downloadable product

Leave a Comment