Tag Archives: eav

Creating an EAV based model(s) in Magento

4th DEC 2011 | Posted by Branko Ajzele in Extensions, Magento, Programming
Featured Image

Magento database heavily utilizes an Entity-Attribute-Value (EAV) data model. However, the cost of flexibility is often complexity. The process of manipulating EAV data in Magento is often more difficult than manipulating flat relational tables.

All Magento Models inherit from the Mage_Core_Model_Abstract. Difference between simple Model or an EAV Model is its Model Resource.

To build a model with proper collection object in Magento you need 4 things Read more

5

Magento’s database layout and its EAV structure

15th SEP 2010 | Posted by Mladen Lotar in Database, Magento
Featured Image

Greetings fellow developers! Today I’ll try to explain the principles of EAV system and Magento’s implementation of it. This is a tutorial / explenation for beginners, so please be patient and even try to draw the logic on a paper if you don’t understand it. A small notice before we start. I won’t use specific SQL query examples since this will be a simplified example of principles of the EAV.
Read more

9

Magento 1.4 new things in EAV attributes

12th MAR 2010 | Posted by Domagoj Potkoc in Database, Magento
Featured Image

If you install new version of Magento 1.4, you can see that existing differences in structures of eav attributes. Earlier all data of EAV attributes were in table eav_attribute, now in new version eav_attribute table is smaller, beacuse a lot of fileds moved in new tables.
Read more

6

Escape from EAV the Magento way

12th JUN 2009 | Posted by Branko Ajzele in Database, Magento
Featured Image

One of the differences between Magento eCommerce platform and lets say WordPress, when looked from developer point of view, is “avoid raw queries” approach. For a web application, Magento is massive system. His database, although not so massive but surely breathtaking with around 220 tables forces you to use “eye candy” EAV model to do even simple things. Read more

20

Magento MySQL database diagram

20th OCT 2008 | Posted by Tomislav Bilic in Database, Magento
Featured Image

If you worked with osCommerce, Zen Cart, CRE Loaded or any similar eCommerce platform before, you might find Magento database structure quite confusing when you see it for the first time. I advise you not to rush too much figuring out what is what by glancing through database. Try to spend first few hours getting familiar with some background. For purposes of flexibility, the Magento database heavily utilizes an Entity-Attribute-Value (EAV) data model. As is often the case, the cost of flexibility is complexity. Is there something in Magento that is simple from developers point of view?

Read more

27