{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Topic 9 - Topic 9 Database Administration So you want to be...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Topic 9: Database Administration So you want to be a Database Administrator (DBA)? Most have heard about the six figure salaries that commercial DBAs are demanding and receiving within 3 to 5 years of experience. What you have not heard is the responsibilities and technical knowledge required of a DBA. Many databases must be administered 24 hours a day, 7 days a week, 365 days a year. Many DBAs monitor their Alert Files and have these files sent to them via email. Others sleep with their cell phones next to their bed. The duties of a DBA today are demanding. DBAs are responsible for the installation, configuration, administration, maintenance, security, performance, tuning, back-up, and recovery of the database(s). In short, the whole integrity of the database. He or she also must know current hardware configurations and operating systems. Additionally, the DBA also must interface with systems administrators, network managers, application programmers, and have some knowledge of their expertise. The DBA often works with end users as well. These are just a few of the responsibilities of a DBA. This section will cover only the rudimentary level of knowledge that a commercial DBA must have. There are a number of ways to attempt improving system performance as a way of also improving database performance. We will be looking as several of these appropriate for our class. General Guidelines for Better System Performance System Resou rces Client Server Hardware CPU The fastest possible Dual- core CPU or higher The fastest possible Multiple processors (Quad-core technology) RAM The maximum possible The maximum possible Hard Disk Fast SATA/EIDE hard disk with sufficient free hard disk space Multiple high-speed, high-capacity hard disks (SCSI/ SATA/Firewire/Fibre Channel) in RAID configuration Network High-speed connection High-speed connection Software Operating System Fine-tuned for best client application performance Fine-tuned for best client application performance Network Fine-tuned for best throughput Fine-tuned for best throughput Application Optimize SQL in client application Optimize DBMS server for best performance Table recreated based on Rob & Coronel. Database Systems: Design, Implementation, & Management (8th Edition). P.443, Table 11-1. Course Technology, 2009
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
After reading this topic, you should be able to: Describe how DBA's use various hardware components in their jobs. Discuss the various roles of a DBA in a database environment. Demonstrate an understanding of network and software architectures. Discuss the importance of database security and backup and recovery. Describe how DBA's use database tuning to improve database performance. Lesson 1: Hardware Considerations The modern DBA needs to posses a wide variety of knowledge and skills. A solid hardware background is one of the essential skill sets required of the DBA. After completing this lesson the student can: After reading this lesson, you should be able to: Identify various hardware platforms that are used with commercial DBMSs.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}