Re: Database Design

--- "Art S. Kagel" <kagel@bloomberg.net> > wrote: >Ian Vellosa wrote: >> >> Hi, >> >> I would guess that as the DBA you should be designing the database with >> input from the other two! You should be putting in the majority of the >> design input as you will be the person who looks after the database long >> after the others have run for the hills! >> >> But then again, this is just my humble opinion! >> >> See Ya >> IV >> >> "Andy Jiang" <ajiang@mail.lumley.co.nz> wrote in message >> news:MjAq5.1278$eZ8a.6357484@news.xtra.co.nz... >> > Hi everyone >> > >> > I would ask a very general question about DBA role here. >> > >> > I am not quite sure what is exactly DBA's job regarding database design. >> Is >> > there any cut edge between jobs of business analyst , programmer and DBA? >> > Most topics covered here are about informix database itself. >> > >> > Giving a new project from beginning, what will a DBA start with? Involving >> > business analysis? Creating databse, tables, primary key, foreign key, >> > constraint and index? > >When I was a programmer I used to think: the DBA should worry about the >server and leave my schemas alone. Then I became the DBA and tried to >implement my laisez faire philosophy. The result is a massive profusion of >databases, tables unrelated to each other in the same database, critical >databases that should be dependent on referential integrity with none, >databases that cannot be kept in sync across two servers because they use >serial keys and are updated separately, applications dependent on closely >related data in three databases that are maintained separately, etc. It is >a DBA's nightmare. In my next life I will be a hardass and design all of >the databases myself! Take a lesson. > >Art S. Kagel I would imagine that depends on the programmer and the DBA. A conscientious programmer is concerned with normalization and data integrity, etc. I've talked with DBA's who don't like referential integrity and, as a programmer I've yet to convince an employer that it's important enough to implement, but I try. My guess is that your attitude as a programmer was not that much different than it is as a DBA. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net