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
If you're doing that a lot in your database, personally I'd recommend
looking at one of the NoSQL types such as CouchDB or Cassandra. Most of my
work is neatly normalised tables, but if I had a lot of really freeform data
as you seem to, that's where I'd look.
On the other hand, if you did
On 9 March 2010 18:59, Sumeet Panchal sumeetpanch...@gmail.com wrote:
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.
The only EAV data model I've used in anger is the back-end of the PHP
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
4 matches
Mail list logo