[BioSQL-l] Re: ERD Creation

[Hilmar Lapp]

I'll have to check whether I have v4.1. It looks though like it can also reverse-engineer from DDL SQL.
 
    -hilmar

	-----Original Message----- 
	From: Barry Moore [mailto:barry.moore at genetics.utah.edu] 
	Sent: Tue 2/15/2005 4:29 PM 
	To: Jason Stajich 
	Cc: Hilmar Lapp; biosql-l at open-bio.org 
	Subject: Re: [BioSQL-l] Re: ERD Creation
	
	

	That looks like it will work great Jason.  Thanks.  Hilmar, this program
	will allow me to import ERWIN 4.1 XML model.  Would it be possible to
	get and ERWIN XML dump of the bio-sql model from you (that I could then
	import into DBDesigner to add my local tables)?
	
	Barry
	
	Jason Stajich wrote:
	
	> DBDesigner isn't too bad for mysql schemas.
	> http://www.fabforce.net/dbdesigner4/
	>
	> --
	> Jason Stajich
	> jason.stajich at duke.edu
	> http://www.duke.edu/~jes12/
	>
	> On Feb 16, 2005, at 7:05 AM, Hilmar Lapp wrote:
	>
	>> None of them was even close, sadly.
	>>
	>> There was three requirements though that I had that you may not care
	>> about. First, I needed the tool to read in an existing model in DDL
	>> (data definition language, i.e., CREATE blah, ALTER blah, etc) SQL
	>> and then allow me to modify it. Second, I needed the tool to be able
	>> to generate DDL from the modified model. Third, I needed the tool to
	>> support Oracle with its generated DDL.
	>>
	>> ERWin distinguishes between a logical model and a physical model. It
	>> applies rules that you can configure when translating (or sync'ing)
	>> between logical and physical model. For instance, my logical BioSQL
	>> model follows the table naming convention known from the mysql/Pg
	>> schemas and uses only standard SQL92 types, whereas the physical
	>> model is for Oracle, applies prefixes to all table names to avoid
	>> name clashes, and uses better-suited Oracle SQL types where
	>> applicable. The physical model also defines indexes, whereas the
	>> logical model only defines primary key column(s), foreign key
	>> relationships, and alternative key column(s).
	>>
	>> I found that feature very helpful while the schema was actively
	>> undergoing changes; now it's so stable it's not that important anymore.
	>>
	>> So, depending on what you're trying to do an open-source tool may be
	>> sufficient. Just the last thing I wanted to do was to draw it up in
	>> e.g. Dia, b/c that just gives you a lot of grief without much benefit
	>> except the diagram.
	>>
	>>     -hilmar
	>>
	>> On Feb 15, 2005, at 11:12 AM, Barry Moore wrote:
	>>
	>>> $4K! Ouch.  Have you used any open source or less expensive
	>>> alternatives that you found worthwhile?
	>>>
	>>> Barry
	>>>
	>>> Hilmar Lapp wrote:
	>>>
	>>>> ERWin (from CA). Does a good job but very expensive. -hilmar
	>>>>
	>>>> On Monday, February 14, 2005, at 10:39  PM, Barry Moore wrote:
	>>>>
	>>>>> Hi Hilmar-
	>>>>>
	>>>>> What software did you use to create that ERD for BioSQL?
	>>>>>
	>>>>> Barry
	>>>>>
	>>>>> --
	>>>>> Barry Moore
	>>>>> Dept. of Human Genetics
	>>>>> University of Utah
	>>>>> Salt Lake City, UT
	>>>>>
	>>>>>
	>>>>>
	>>>>>
	>>>
	>>> --
	>>> Barry Moore
	>>> Dept. of Human Genetics
	>>> University of Utah
	>>> Salt Lake City, UT
	>>>
	>>>
	>>>
	>>>
	>> --
	>> -------------------------------------------------------------
	>> Hilmar Lapp                            email: lapp at gnf.org
	>> GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
	>> -------------------------------------------------------------
	>>
	>> _______________________________________________
	>> BioSQL-l mailing list
	>> BioSQL-l at open-bio.org
	>> http://open-bio.org/mailman/listinfo/biosql-l
	>>
	
	--
	Barry Moore
	Dept. of Human Genetics
	University of Utah
	Salt Lake City, UT