Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Exclamation Basic Q: DBA role

    I've read on a DB book that the Responsibilities of Database Administrator (DBA) are among others

    1) Deciding the storage structure and access strategy
    2) Liaising with users
    3) Defining authorization checks and validation procedures
    4) Defining a strategy for back-up and recovery
    5) Monitoring performance and responding to changes in requirements

    Using MsAccess, i can't put hand on these features, any explanation on what they are meant for and how they are implemented ?

    thanks

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    I would imagine in this context, MS Access is used as an ADP. Therefore, the above points would apply to the corresponding DBMS.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Even in just a Access there are elements listed that must be done.

    1) Deciding the storage structure and access strategy
    Where and how is it stored? Split DB ? Synchronized DB?

    2) Liaising with users
    The end user is a costomer no matter the complexity of the application what they want determines your job security, listen to them.

    3) Defining authorization checks and validation procedures
    DB security.

    4) Defining a strategy for back-up and recovery
    Sounds self explanatory. Access may not have built in back up features Per Se, does the server where it resides?

    5) Monitoring performance and responding to changes in requirements
    Is the DB running slow? Coyld the Data be structured to improve performance. How is the server doing? Check the logs.

    My thoughts as I sit here and make an application to be used through out the organization. I'm thinking yeah I have to do all this and then some.
    Darasen

Posting Permissions

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