Changing from horizontal to single table inheritance
Changing from horizontal to single table inheritance
- Subject: Changing from horizontal to single table inheritance
- From: Mark Wardle <email@hidden>
- Date: Fri, 04 Oct 2013 17:09:29 +0100
| Hi all,
When I originally planned the schema used for our clinical application, I used horizontal inheritance. As use has increased, I perceive that horizontal inheritance will not scale for more and more entities. Perhaps I should spend time measuring the performance impact, but I am planning on ever increasing the number of child entities (they act as data collection forms) and so I think single-table inheritance is a better fit.
I have two questions.
1. Is there an easy way of migrating? I can see that I could set-up a wholly new type of entity / sub entities and then manually migrate old entity data into the new ones. This sounds like a considerable piece of work.
2. What happens in single-table inheritance if you have a clash of property names but the column name is different (or for that matter the same).
Any advice much appreciated!
Mark
-- Dr. Mark Wardle Consultant Neurologist, University Hospital Wales, Cardiff, UK Email: email@hidden or email@hidden Twitter: @mwardle Telephone: 02920745274 (secretary) or facsimile: 02920744166
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden