I believe what you are referring to is the entity-attribute-value data model (sometimes referred to as the object-attribute-value model): http://en.wikipedia.org/wiki/Entity-Attribute-Value_model This database model is actually used in Magento, an open-source eCommerce PHP framework.
This is a highly specialized DB model that aims to solve problems caused by data-sparseness that is common to eCommerce, whereby you have many products (entities), each with different subsets of attributes and corresponding values. Cake was never designed to solve this problem, and is thus not well suited for this type of implementation; however, Cake does not enforce a specific DB design principle on you. You will lose many of the features that make Cake an attractive choice for development (ie. Auth component, ACL, etc.), but implementing an EAV DB design is nonetheless possible. Just don't ask me to do it. -J. On Sep 22, 3:42 pm, "Yodi Aditya" <[EMAIL PROTECTED]> wrote: > Can you give some reason why vertical database is bad and horrible? > This is one of many ebook i have read before (in attachment) > the title is "Storage and querying of E-commerce data" - IBM Almaden > Research Center. > > Google Big Table using vertical database too..(reading from some article...) > In my opinion, for big e-commerce, vertical database is right choices. > > But, i just wanna know if anybody using vertical database on CakePHP. > thanks for sharing ... > > On 9/22/08, leberle <[EMAIL PROTECTED]> wrote: > > > > > Sounds like a horrible idea....and bad DB design. > > If you have your DB in Boyce-Codd normal form, you will never have the > > need for such a DB layout... > > > But let me know about your experience :) > > > On Sep 21, 7:23 pm, "Yodi Aditya" <[EMAIL PROTECTED]> wrote: > > > I have reading about vertical database (column-store) on google last > > night. > > > it seem interesting method. > > > > Is anybody using vertical database with CakePHP? > > > Is vertical database good for designing some application using cakePHP? > > > > if someone has vertical database using cakePHP, please let me know.. > > > > Thanks > > > > P149.pdf > 211KViewDownload --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
