Hello.
(Sorry, if my English is not good enouth) I have an idea of developing a tool that could be integrated into your development environment (thinking of Eclipse) that could help you when you're working on classes structure and it's relational mapping. For example, if you need to add some classes into your object model, you also have to propogate these changes to mapping file and DB schema manually. The same thing you face when you modifying you database. I want to produce a syncronizing module that will try to propogate changes automatically in both directions (from classes to mapping and database and from database to mapping and classes) according to certain mapping strategies, thus keeping co-evolution of both of your models (object and relational). There are some tools providing various syncronization mechanisms, but all of them based on the autogeneration, so your models are offen being full re-generated. Also they support only one strategy, when every class is mapped to its own table and every class attribute has its own column. Also such tools does not provide correct strategies for inheritance, abstract classes mapping etc. - all of these makes you to perform modifications of models and mapping manually. Do you think such idea is worth developing? Or you know some other efficient techniques for keeping object and relational models synchronized? Thamk you.
|