ORM stands for Object Relational Mapping. It’s a programming technique used to convert different types of data to Objects and vice versa.
In Magento, ORM is shown as Model (based on Zend Framework’s Zend_Db_Adapter), which further breaks down to two types of Models.
First is the “simple” i.e. Regular Models which is nothing but flat table or our regular table structure.
Second Model is EAV (Entity Attribute Value), which is quite complicated and expensive to query.
All Magento Models interacting with database are inherited from
Mage_Core_Model_Abstract class, which is further inherited from
Difference between two Models is, Simple Model is inherited from
while EAV is inherited from
So, to end up this question, when you want to get some data in Magento, you call it like this:
where 1 is the primary key id for some Regular/Simple table, while in EAV so many tables are joined to fetch just single row of data.