Dynamic Column

[Guest]

Hello All,
My Problem: Dynamic column – Example, if there is an Employee details, I
should able to add or remove columns very easily.

Selected Model: Meta-data model – storing all the values as key and value
pair in a single table and two sporting tables for table name and column name
(in oracle database).

I hope this is not right choice, so Please advice about:

1) Disadvantage about the selected model
2) Any best model for the problem or
3) Any reference


Regards,
Nagarajan.

 

[Guest]

There isn't really any other good way of doing this. If you need the
flexibility it's going to cost you in complexity.

As the information about what fields there are is data, it's correct to
store that information in a table.

The alternative would be to change the actual layout of the table. That
is a really bad idea, as you then would store data in the metadata of
the table.