Hi, I have a relational database (MySQL) with 200 tables in it. Now I want to reduce number of tables (If it helps in improving the application).
One approach is to use EAV database model. In which we can use a table to store ID and manadatory details and other table to store rest of the details in pair of attribute, and its value rowwise. for example look to tables Client Table ClientID FirstName LastName 1 Rocky B ClientAttribute Table ClientID(f.k) Attribute AttributeValue 1 Age 23 1 email [email protected] mean I am using rows to store attributes instead of columns. So problem is I have to convert, the 200 table database to EAV. Has anybody worked with EAV model, know its pros cons, and how to do this in rails. Please help in anyway. Thanks and regards Sumeet -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
