Is 221: Database Administration

1. Is 221: Database Administration Lecture 1: Introduction to DBA. Information Systems Department

2. Outlines • Learn about Database administration • Database administration. • Database administrator. • Task, Role, Skills… • Identify the main DBA tools in the Oracle10g software suite. Information Systems Department

3. Database Administration Information Systems Department

4. Managing the Data is crucial Information Systems Department

5. Database Administration • Database Administration: A technical function that is responsible for physical database design and for dealing with technical issues such as security enforcement, database performance, and backup and recovery. Information Systems Department

6. Database Administration: • Database Administration • Size and Role of the data base varies from company to company. • DBA’s function is very dynamic. • Distributed Databases. • Internet Databases. • Object Oriented databases. Information Systems Department

7. DBA • A database administrator (DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database. Information Systems Department

8. DBA tasks • Install and upgrade the DBMS software on the server. • Optimize database performance. • Create and maintain user accounts. • Monitor data storage space. • Start and shut down the database. • Perform backup and recovery operations. Information Systems Department

9. DBA tasks • Install and upgrade developer client utilities. • Deploy finished database applications to users. • Assist developers in designing and creating database tables. • Assist developers in designing and creating form and report components and integrated database applications. • Assist in testing and debugging new applications. • Assist in training developers and users. Information Systems Department

10. DBA Role Association with: • Management • enterprise objectives. • time constraints for development. • budget constraints. • future plans. • organizational changes. Information Systems Department

11. DBA Role Association with: • Users • data requirements. • application priorities. • ownership of data. • archiving requirements. • Documentation. • response times. Information Systems Department

12. DBA Role Association with: • Application Development Staff • security/privacy controls. • education/training. • data integrity rules. • information about the database. • test plans etc. Information Systems Department

13. DBA Role Association with: • Operations Staff • availability requirements. • batch job priorities. • security procedures. • error recovery requirements. • performance monitoring etc. Information Systems Department

14. DBA Role Association with: • Software Vendors • Education/training needs. • Hardware requirements. • Documentation. • service support & maintenance. • utilities etc. Information Systems Department

15. DBA Role Association with: • Hardware Vendors • hardware capabilities. • expansion capability. • incompatibility with any existing hardware. • servicing requirements. • Training. • equipment failure. Information Systems Department

16. Knowledge and Skills • DBAs : • keep up with the complexities of database technologies. • have well-developed interpersonal and communication skills. • have an ability to understand data and how it will be used. • possess good process management and problem solving skills. • enjoy working within a team. Information Systems Department

17. Knowledge and Skills • DBAs : • are customer focused. • enjoy troubleshooting. • are critical thinkers and can use logic and reason to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems. • are active listeners and can give full attention to what people are saying and take the time to understand the points being made. Information Systems Department

18. DBAs possess good problem solving skills Information Systems Department

19. DBA tools in the Oracle10g Information Systems Department

20. Oracle10g • The Oracle10g RDBMS software suite includes everything you need to build/maintain a relational DB. • The basic software: • Runs the database engine • Manages the data storage for all information in the database • Provides tools to manage users, tables, data integrity, backups, and basic data entry • Includes additional tools and utilities that help monitor the performance and security of the database Information Systems Department

21. Overview of DBA Tools • Many of these tools become integrated in: • Central workspace • Enterprise Manager console • Database Control • Grid Control • Tools give you a way to work on the database • In a Windows-style environment • You must also understand how to work directly from the command line. Information Systems Department

22. Tools for Administering an Oracle Database: • Oracle Universal Installer • Database Configuration Assistant • Database Upgrade Assistant • Oracle Net Manager • Oracle Net Configuration Assistant • Oracle Enterprise Manager • Server Control Utility • SQL *Plus • Recovery Manager • Data Pump • SQL *Loader Information Systems Department

23. References • http://en.wikipedia.org/wiki/Database_administrator • http://www.acs.org.au/ictcareers/index.cfm?action=show&conID=200707200948211895 • Oracle 10g Database Administrator: Implementation and Administration • Modern Database Management • Database Administration • A Guide to Oracle 9i • Database Users & Administration • Oracle 11g Student Guide Information Systems Department