Re: Logical DBA needed

KENDRICKS CHERYL wrote: > <snip>A Logical DBA is someone who understands the FULL Structure of the > DB(s), > but does no "Physical" management. I.E. Design it on paper (or today with > GUI Design Software, with full understanding of DB Design and the Business > Requirements). This could include actual naming of all the entity and their > relationships. Then the "Physical" DBA takes this information and with DDL > creates and manages the DB. > > I'm not surprised, of your statement. In the "UNIX"/Client Server World the > push has been on the Speed of Implementation, losing the "Design" Aspect of > DB creation and steps. So you have either those 100 table, non normalized > and non relational (in the logical) DB (a BUNCH OF TABLES and DATA) with > only one or two people who could really tell you how the DB objects relate. > Or someone creates a small DB and could really careless since the only > have two - ten tables. > <snip> This looks to be problem with the definition of the job. Normally the business requirement will be analyzed by Sr. Business Analysts. They don't hve to know much about DDL or DML statements, other than some basic knowledge of RDBMS. Their objective is to make a Total Requirement Specification (TRS) for the business application. Then the development DBA / Sr. Database Analyst, will chalk down reqired DDL statements. This is where the physical database gets designed and created (physically). The programmers uses DML statements to access the above database in their application modules. When the product is implemented in a site the DBA who supports the data center, makes sure that the database is up and running. He performs only house keeping tasks, not any DDL ( to create new tables, etc ) or DML statements ( to change the data ). This data center DBA has only one task, and that is to keep the data base up and running. The bottom line is that, at a development site there will be only one kind of DBA who designs and creates the database (DDL coading), at a data-center there will be another kind of DBA, who does the databse house keeping job. I don't know how the development DBA gets a "logical DBA" status and the data-center DBA gets a "physical DBA" status. -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com