MySQL - UNCC Department of Software and Information Systems

righteousgaggleΔιαχείριση Δεδομένων

31 Ιαν 2013 (πριν από 4 χρόνια και 11 μήνες)

197 εμφανίσεις

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,


Access, Sybase etc.


IBM
31.8%
Oracle
40.4%
Microsoft
12.3%
Other
15.5%
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 !