[转] EAV and row modeling in Xoops Engine data schema design |
||||
---|---|---|---|---|
Support Team
注册日期:
2006/11/30 20:48 来自 beijing
所属群组:
网站管理员 注册会员 Dev+Hack 资料整理组 等级: 30; EXP: 30
HP: 146 / 732 MP: 403 / 10791 |
EAV, or entry-attribute-value model, is known as open schema with better extensibility than row model by which data type of value columns are required to be pre-defined. On the other hand, row modeling provides easy manipulation with, likely, better performance. In legacy Xoops, configuration data model (“config”) is defined with EAV model while user data model (“users”) with row model. In Xoops Engine, configuration table is modeled with EAV, while user model design is kind of complex in Xoops Engine. Considering performance, data integrity, easy manipulation, user model is defined as three part:
More details coming soon …
2/13 20:13
|
|||
|