| |
This project already in operation consists of a viewfinder Web of ERM (Entity-Relationship Model) diagrams able to generate the relational models and also SQL code.
|
| |
|
| |
| If sometimes you have seen yourselves in the need to design and to maintain a relational database, you will know how important is a good documentation of the whole design process, from the ERM to the final SQL code. And mainly how much it costs to maintain this documentation updated whenever we make modifications to the database and, very specially in free software projects. |
| |
| |
| Several graphical tools exist that allow to represent the ERM of a database. Some of them even can, with greater or smaller success, generate the relational model for us out of the ER-digram. All this is not too important for small models like the typical library or film-rent system. But when one is involvesd in more complex projects, representing the data modeling in a readable way gets more and more difficult. And the modifications and extensions get more and more expensive.
Dividing the schemes in smaller blocks can help to facilitate the understanding, but it multiplies the work and it makes the study difficult. In the end, tired of so many graphical "(f)eines" (*), I have chosen to implement my own solution myself. And I believe that the result has been worth the trouble :-)
(*) In catalan: eines = tools and feines = works. |
| |
