Hi Folks,

What is the recommended strategy for persisting a large polymorphic heirarchy. The heirarchy is large, 17 classes and counting. Some classes have BLOBs in them. These objects also include an ordered/indexed collections of themselves, sort of like composite pattern.

What is available is a property on the base [/b]type[/b] which can be used as a discriminator.

I would prefer to use a table per class. Presently using Postgres, but can switch to Oracle or SQL Server if needed. Please let me know what is the recommended strategy for this.

Thank you very much,
Dinesh