News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Arnold Daniels' Blog:
An alternative way of EAV modeling
July 31, 2008 @ 12:54:23

Arnold Daniels has posted some thoughts on a topics recently featured in a cover story by php|architect - EAV modeling.

I had seen this db structure in other project, but didn't know that it was called EAV. For those who don't read php|architect, EAV describes a method of saving a large set of attributes, only some of which apply to an individual entity. Normally you would create a table, with a row for each entity and save each attribute in a column. With EAV you save each attribute as a row.

He suggests two ways to do the modeling - the more "common" way and an alternative way that splits up the data types to make querying simpler (into scalars and arrays). A sample database structure and example query for it are included.

1 comment voice your opinion now!
eav modeling database attribute query common alternative method


blog comments powered by Disqus

Similar Posts

Ralph Schindler's Blog: Composite Rowsets For Many-To-Many Relationships Via Zend_Db_Table

Mayflower Blog: JavaScript Pitfalls for PHP-Developers

WebCheatSheet.com: Two New Tutorials - Database Export & Sending Email

PHP-Coding-Practices.com: How Table Migrations In CakePHP 1.2 Can Save Your Life

CodePoets.co.uk: How to use PHP and PEAR MDB2 (Tutorial)


Community Events











Don't see your event here?
Let us know!


introduction unittest hack component symfony2 framework language example hhvm podcast overview code opinion composer release facebook application package install security

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework