1 / 22

Database Administration ISQA 436

Database Administration ISQA 436. Fall 2006 Mark Freeman markf@pdx.edu. Database Administration ISQA 436. Syllabus Books Attendance Grading WebCT http://psuonline.pdx.edu/ Use your PSU Odin account. DATABASE Applications. Oracle 10G (v10.2) Database server: SBALABS

iliana-burris
Download Presentation

Database Administration ISQA 436

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 AdministrationISQA 436 Fall 2006 Mark Freeman markf@pdx.edu

  2. Database AdministrationISQA 436 • Syllabus • Books • Attendance • Grading • WebCT http://psuonline.pdx.edu/ Use your PSU Odin account

  3. DATABASE Applications • Oracle 10G (v10.2) • Database server: SBALABS • Use for SQL and PL/SQL programming assignments • You will be assigned a user account • Local database server on lab desktops • Use for DBA lab assignments • SQL Developer • Enterprise Manager • Net configuration/management

  4. DATABASE • Remote connection • Oracle 10g client • Service • SBALABS • Host • IP Address (See install/config lab for details)

  5. What you should know • Basic SQL • INSERT, UPDATE and DELETE • SELECT • WHERE • ORDER BY • GROUP BY/HAVING • Joins (2 or 3 tables) • Basic DDL • CREATE, ALTER, DROP TABLE, etc

  6. What you should know • Referential Integrity • Primary and Foreign Keys • NULL • Know about: • Views • Functions, procedures, triggers • Indexes • Transactions

  7. WHAT WE WILL LEARN • Oracle Database Architecture • Administration • Basic DBA tasks • Backup and recovery • Storage management • Network management • Security management • PL/SQL programming • Internet database technology* *As time allows

  8. ORACLE TIMELINE* IBM employee E.F. Codd publishes theory of relational databases Oracle is founded by Larry Ellison, Bob Miner and Ed Oates Originally named SDL First commercial relational database is shipped! 1970 1974 1977 1978 1979 1980 Name changed to RSI Name changed to Oracle IBM develops System R UC Berkeley develops Ingres Neither becomes commercial before Oracle * Sources: http://math.hws.edu/vaughn/cpsc/343/2003/history.html http://www.oracle.com/corporate/history.html

  9. ORACLE TIMELINE Oracle begins development of Oracle Financials software Version 6.0 PL/SQL Oracle Financials released Version 3.0 on minicomputers written in C Version 6.2 Parallel Server 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 IBM releases DB2 Version 4.0 PC version Read consistency Version 5.0 Distributed database Client/server

  10. ORACLE TIMELINE Oracle becomes #1 database company for internet and ERP Oralce Applications ERP, Supply Chain, Manufacturing, etc.. Version 7.0 on Unix Very Large Databases (VLDB) Linux 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 $1 billion in sales Network PC Version 8.0, named Oracle8, Released 64-bit Oracle 8i Java OAS

  11. ORACLE TIMELINE Oracle 9i Release 2 Oracle 10g 2000 2001 2002 2003 2004 Oracle 9i Release 1 Internet Application Server (IAS)

  12. Oracle Documentation • All Oracle documentation is available online • http://www.oracle.com/pls/db102/homepage • Useful documents for this class* • Oracle Database Concepts • Database Administrator’s Guide • SQL Reference • PL/SQL User Guide an Reference * There are more than 200 Oracle documentation manuals

  13. DATABASE ADMINISTRATOR • What is a DBA? • Database Administrator • Default Blame Accepter? • What does a DBA do?

  14. DATABASE ADMINISTRATOR • DBA tasks: • Database Design and Planning • Database Installation and Upgrade • Backup and Recovery • Storage Management • Security Management • Network Administration • Performance Tuning • On-call Emergency Crisis Management

  15. DATABASE DESIGN AND PLANNING • Capacity planning • Number and speed of CPU • Memory • Disk space • Size and distribution of data files • Network • Firewall • Concurrancy • Distributed databases • Database parameters • Sizing and resource allocation • Standby and test databases

  16. DATABASE INSTALLATION AND UPGRADE • What products to install • Configuring the operating system • memory parameters • Oracle account • filesystem • Installing/configuring database and web servers • Installing client software • Planning and performing upgrades

  17. BACKUP AND RECOVERY • Develop backup and recovery plan • Implement backup procedures • Test recovery plans • Schedule exports and other special-needs backups

  18. STORAGE MANAGEMENT • Ensure enough disk space and data files for growth • Monitor growth • Schedule database reorganizations

  19. SECURITY MANAGEMENT • Create database user accounts and roles • Grant and revoke privileges • Maintain operating system security • Network security • firewall • Web server security • Encryption

  20. NETWORK ADMINISTRATION • Server network configuration • Client network configuration • Distributed database configuration • Managing connection capacity

  21. PERFORMANCE TUNING • Monitor performance • response time • resource contention • CPU • Memory • Disk • Network • Adjust database parameters accordingly • Assist in SQL statement tuning

  22. ON-CALL CRISIS MANAGEMENT • Anticipate emergencies and take preventative measures • Respond to pager at 3am • Keep a cool head • Call Oracle for support • Minimize damage • Minimize downtime

More Related