Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2009
    Posts
    4

    Logical data model - DBA responsibility?

    Should DBAs be responsible for a logical data model?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no

    business analysts are responsible for the logical model -- entities and attributes and primary/foreign keys

    DBAs are responsible for the physical data model -- tables and columns and surrogate keys, oh my
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    I'd disagree, but only because personally, I think a good DBA should double as a Business Analyst.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    can a good business analyst double as a DBA?

    if you say no, then there goes your credibility...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    The logical and the physical sides of data modeling are distinct, but they are often done by the same person due to business necessity.

    In an extremely large project/organization, it is quite possible to have three logical modelers. One modeling pure business needs, one refining those business models into pure logical models, one to handle the expression of the logical model in terms of the application space or spaces (think of OOP versus CODASYL versus iPhone). On the physical side, there could be one specialist projecting each application space model into the appropriate physical model or models.

    Not many projects approach this kind of complexity, and the vast majority of projects can be handled cradle-to-grave by a single modeler if that modeler has sufficient training and experience. Most businesses can only afford one modeler!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    can a good business analyst double as a DBA?

    if you say no, then there goes your credibility...
    In many organizatons, a few DBAs support several business analysts, in addition to doing some of this work themself. Most business analysts are neither logical nor physical database admins.

    The places i've been that obtained the best results was when the "team" had some overlap between "who does what" . The DBAs were often associated with multiple implementation teams.

  7. #7
    Join Date
    Aug 2008
    Posts
    147
    The Data Architect – aka Modeler, looks at the wider use of data , they should be involved at the outset of the project ensuring : metadata , defining enterprise use ,logic data models are established. The process is independent of the RDBMS.
    When the logical models are created ,the Database Architect decides which RDBMS and how the infrastructure is implemented.
    In my experience - there tends to be quite a bit of cross - over. Very good Data Architects tend to have a level of expertise in Data Migration Tools, database design etc
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •