1 / 12

Database Administration: Additional Issues

This resource provides an in-depth exploration of database administration (DA) and database management (DBA) functions as taught at the University of California, Berkeley. It covers essential topics such as data administration responsibilities, database design, implementation, monitoring, and maintenance. The document details corporate strategy development, database analysis, security protocols, and user training. It emphasizes the importance of data integrity, backup, recovery procedures, and the evaluation of new technologies in supporting organizational data resources effectively.

jereni
Télécharger la présentation

Database Administration: Additional Issues

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Administration:Additional Issues University of California, Berkeley School of Information Management and Systems SIMS 257: Database Management Database Management -- R. Larson

  2. Terms and Concepts • Data Administration • Responsibility for the overall management of data resources within an organization • Database Administration • Responsibility for physical database design and technical issues in database management • Data Steward • Responsibility for some subset of the organization’s data, and all of the interactions (applications, user access, etc.) for that data Database Management -- R. Larson

  3. Review • DA and DBA functions Database Management -- R. Larson

  4. Database Planning Database Analysis Growth & Change Operation & Maintenance Database Design Database Implementation Database System Life Cycle Note: this is a different version of this life cycle than discussed previously Database Management -- R. Larson

  5. Database Planning:DA & DBA functions • Develop corporate database strategy (DA) • Develop enterprise model (DA) • Develop cost/benefit models (DA) • Design database environment (DA) • Develop data administration plan (DA) Database Management -- R. Larson

  6. Database Analysis:DA & DBA functions • Define and model data requirements (DA) • Define and model business rules (DA) • Define operational requirements (DA) • Maintain corporate Data Dictionary (DA) Database Management -- R. Larson

  7. Database Design:DA &DBA functions • Perform logical database design (DA) • Design external models (subschemas) (DBA) • Design internal model (Physical design) (DBA) • Design integrity controls (DBA) Database Management -- R. Larson

  8. Database ImplementationDA & DBA functions • Specify database access policies (DA & DBA) • Establish Security controls (DBA) • Supervise Database loading (DBA) • Specify test procedures (DBA) • Develop application programming standards (DBA) • Establish procedures for backup and recovery (DBA) • Conduct User training (DA & DBA) Database Management -- R. Larson

  9. Operation and Maintenance:DA & DBA functions • Monitor database performance (DBA) • Tune and reorganize databases (DBA) • Enforce standards and procedures (DBA) • Support users (DA & DBA) Database Management -- R. Larson

  10. Growth & Change:DA & DBA functions • Implement change control procedures (DA & DBA) • Plan for growth and change (DA & DBA) • Evaluate new technology (DA & DBA) Database Management -- R. Larson

  11. Issues/functions in Database Administration • Planning and Design (we have already looked at theses processes in detail) • Data Integrity • Backup and Recovery • Security Management Database Management -- R. Larson

  12. Today • Additional issues • Handling special data considerations • Database/Data Dictionary • Database Building in SQL (maybe) Database Management -- R. Larson

More Related