Introduction to Oracle

1. Introduction to Oracle Ling Guo Feb 15, 2010

2. Database(RDBMS) Software Review • Oracle RDBMS (Oracle Cooperation)4()6 • Oracle 10g Express version • DB2 (IBM) • IBM DB2 Express-C • SQL Server (Microsoft) • SQL Server Express/ Developer version • Others: MySQL, PostgreSQL, Access, Sybase etc.

3. Factors for Selecting RDBMS Software • Platform and System Requirement • Support Data Types • Application function • Program language Supporting • Analysis Ability • Internet Ability • Price and Performance • Ease of Use and Documentation

4. Types of Database Users • Database Administrators • Security Officers • Network Administrators • Application Developers • Application Administrators • Database Users

5. Tasks of Database Administrators • Evaluate the Database Server Hardware • Install the Oracle Database Software • Plan the Database • Create and Open the Database • Back Up the Database • Enroll System Users • Implement the Database Design • Back Up the Fully Functional Database • Tune Database Performance

6. Tasks of Application Developers • Designing and developing the database application • Designing the database structure for an application • Estimating storage requirements for an application • Specifying modifications of the database structure for an application • Relaying this information to a database administrator • Tuning the application during development

7. Practice with Oracle Express • On campus: • http://coit-ora01.uncc.edu:8080/isqlplus/ • Oracle Database 10g Express Edition • Free of charge, and may be installed on any size machine, supporting up to 4GB of user data and running on a single processor, using a maximum of 1GB memory. • Ideal database for developers • Great starter database for students and database administrator • Tutorial: • http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm • Download: • http://www.oracle.com/technology/software/products/database/xe/index.html

8. Thank you !