Transcript Lab PowerPoint - Personal Web Pages

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,
Microsoft
12.3%
Other
15.5%
Access, Sybase etc.
IBM
31.8%
Oracle
40.4%
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
Types of Database Users
 Database Administrators
 Security Officers
 Network Administrators
 Application Developers
 Application Administrators
 Database Users
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
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
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/ind
ex.html
Thank you !