MAGENTO DATABASE STRUCTURE EBOOK!
A massively misunderstood part of Magento is it's database structure. The EAV architecture used in the Magento database is an extremely efficient and suitable. The Magento database structure is the most complex one of any open source application I have used so far, consisting of more than Therefore, an understanding of EAV principles and how they have been modeled into Magento it is HIGHLY recommended before making changes to the Magento data or the Magento schema (Wikipedia: Entity-attribute-value_model). Varien has simplified the identification of EAV related tables with consistent naming conventions.
|Published:||17 July 2014|
|PDF File Size:||8.40 Mb|
|ePub File Size:||44.58 Mb|
Mysql - Explain magento database structure - Stack Overflow
EAV magento database structure for Entity such as Product or CatalogAttribute basically it represents all the information belonging to an Entity and Value value of an attribute.
It splits Attribute and its value from Entity. Have more than 44 related tables 2.
The structure of tables was changed: With entity data being so fragmented, creating a magento database structure entity record requires a lot of expensive table joins.
Fortunately, the team at Varien have implemented an excellent cache system, allowing developers to cache information that doesn't often change.
Another problem with EAV is it's learning curve, meaning a lot of junior developers give up before they can truly see the simplicity of it. While there is no quick fix for this, hopefully this article will help people start to over come this problem.
Conclusion Entity, Attribute, Value is a great database structure and has been a key part to the success of Magento and therefore it is important for developers to understand how it works.
There are also many applications for this knowledge and I'm confident if you work in Magento for long enough that you will come across some! I intend to write a follow up article to this sometime soon, depending magento database structure how this one goes down.
Magento Database Structure: EAV | Magento Tutorials | FishPig
In the meantime, I wrote an article on updating prices globally in Magento that uses some techniques from this article. It might be a good idea magento database structure look at that to practise what you have learned here.
If you have any questions please let me know or post in the comments. These model classes are used when saving attribute value in database.
Like for example saving of product media images requires some operating to happen before and after save. Magento has 6 types static,datetime,int,text,varchar.
The static type is special. For example, if attribute type magento database structure select. This table has many columns but I have just shown the important columns.
Magento EAV Database Structure
Entity type id used through magento db, to identify an entity. Magento If you worked with osCommerce, Zen Magento database structure, 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.