David.. I checked about emodeler , and seems like it is specific to mac.
EOModeler, one of Apple's WebObjects development tools, provides you with a simple way to manage a great deal of the complexity associated with databases. EOModeler lets you graphically design your object/data model. (link http://www.mactech.com/articles/mactech/Vol.16/16.10/BuildanEOModel/index.html ) I see dot as an open standard for similar usage, and http://graphviz.org/ can plot them. is it easy to extend the current implementation in ofbiz to output into dot or similar format? Also, how much time we spend on it depends on the usage. I was using the diagrams just to visualize the relationships and to see and understand data if I ever need to use sql directly. I fully support an open software for that, but for my purpose the tool worked great. I could detailed the steps so that others can collaborate and modify. But the steps are, 1. Install the freeware software 2. make a JDBC connectivity to the database (I used the derby runtime files with the standatd distribution) 3. select the tables, and plot the relationship based on the FK. Well this may subject to argument, as you may select the right tables if you know how they are related. I selected them based on name, and got a decent graph. 4. Export to JPEG/PDF. thanks, Babu. ________________________________ From: David E Jones-4 [via OFBiz] <ml-node+1472355-1548253...@n4.nabble.com> To: bsreekanth <babu.sreeka...@yahoo.com> Sent: Sun, February 7, 2010 4:32:47 PM Subject: Data Model Diagrams (was Re: Key data model relationship pages in Wiki) If people are interested in making diagrams there is some stuff build into OFBiz to export "eomodeld" files. That particular file format can be imported by a few tools, but mostly on the Mac (my preferred tool being OmniGraffle). Unfortunately the weeks I put into that code, organizing the entities into groups, and then creating and organizing diagrams for the groups, was done while I was part of Hotwax Media so I don't actually have any rights to the diagrams any more, and I'm not sure what the situation is with them (a Hotwax rep would have to answer that I guess). I've thought about doing a new export and creating a new set of diagrams, but the amount of work required to layout all of the diagrams again is well beyond what this is worth to me... :) It would be great to see another pass at this be done fully open so that various people could participate and share the load. To do so would require agreeing on some file formats at least, and possibly tools as well (which makes it difficult, at best). The eomodeld files that OFBiz exports are NOT diagram files, but can be imported into a diagramming tool. From there a diagram file can be exported and maintained going forward. BTW, for new and changed entities it is probably more work to redo the export and layout than it is to modify the diagram files, so creating the diagram file from the eomodeld files probably only needs to be done once. The output formats that I can do easily with OmniGraffle include: Visio XML, PICT Vector, SVG, EPS Vector, PDF Vector, and various rendered pixel/bit-map formats that are probably not of much use. BTW, just to note Visio XML is only supported by a limited number of tools and is not the same as the Visio binary files. The alternative would be to write some other export code to write the model in a different format. On a side note, there is some stuff to write eomodeld files for services as well (with ECAs joining the services together). -David On Feb 7, 2010, at 2:35 PM, bsreekanth wrote: > Adrian, > thanks for the feedback. the graph is generated from the database tables, > and may have to look at how to do the same from xml schema definitions. the > easiest to do would be explaining the sql and ofbiz data types, and how they > maps. I can point to the configuration where it also shows how it differ for > different databasses. > thanks, > babu > -- > View this message in context: > http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html > Sent from the OFBiz - User mailing list archive at Nabble.com. ________________________________ View message @ http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472355.html To unsubscribe from Re: Key data model relationship pages in Wiki, click here. -- View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472406.html Sent from the OFBiz - User mailing list archive at Nabble.com.