1 / 8

Introduction to Oracle

Introduction to Oracle. Ling Guo Feb 15, 2010. 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,

vevina
Download Presentation

Introduction to Oracle

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. 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 !

More Related