RE: Data Modeling?
Yes, Rational Data Architect should support Informix. At the Chicago IIUG meeting yesterday there was a demo on it. Quite impressive and worth checking out. If you have an IBM rep, ask him/her about it. Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Ian Michael Gumby Sent: Thursday, December 07, 2006 2:53 PM To: Uricha@mcao.maricopa.gov; informix-list@iiug.org Subject: RE: Data Modeling? > >Is it a 'norm' that DBA's use a data model (both logical and physical) >to design a database? >or >Are data models mostly used as a 'post-design' afterthought, to document >what is physically already implemented? > >In most shops that I have worked, we never used a model. And if they did >have a data model, it was never up-to-date. >The model was an after-thought for documentation purposes... It was done >after the table was implemented in Production. > >Is there a good modeling tool for Informix 10? >Is there any one 'data modeling' design class that is better then >others? > Now this is a loaded question... Separate the logical from the physical. A physical model helps the DBAs plan out how to lay out the data to get the most bang for the buck. The logical model helps when you need to determine the relationship between tables, constraints , etc... The logical model helps those who grok database design. Some shops swear by using models. Others ignore them and treat the database as a persistence of objects. IMHO, you'd be a fool not use a modeling tool. A good tool will shave time off of development. With respect to which tool, I've liked Erwin in the past, although the 3K pricetag and I'm not sure if the latest release supports IDS makes it less than desirable. (I support multiple platforms and RDBMSs) I've downloaded a copy of the Rational Data Architect trial version. (Actually Its going on in another window right now.) Its an eclipse plug in, and I've noticed that you can click on DB2 support. Didn't see IDS there. Will let you know what I think of it. ... _________________________________________________________________ Stay up-to-date with your friends through the Windows Live Spaces friends list. http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http:/ /spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================