4 Mayıs 2013 Cumartesi

IDENTIFY YOUR DATABASE AND REQUIREMENTS


You could identify your needs and requirements with filling this form. Select your database and control database costs. In addition you must consider sector necessaries.

"Database Requirements Form

Express Edition
Express Edition
 
Standard Edition One
Standard Edition One
 
Standard Edition
Standard Edition
 
Enterprise Edition
Enterprise Edition
 

*************Availability ***************
 
1. Is your database mission critical ? RTO (recovery time objective) and RPO (Recover Point Objective) values?
 
2. Do you need 7/24 access of Database?
 
3. Do you need backup and recovery ? What is the needed method for backup? (RMAN, Incremental, Daily, Hot/Cold backup etc..) 
 
4. Do you have any Disaster Recovery documentation?

*******************Scalability******************
 
5. How large is your database ? What is the needed Actual disk space by application schema sufficient by 2 years ?
 
6. What data types do you need ?  (Binary, Lob, Large, Partition keys, Tables, Index type etc..)
 
7. What is the database archiving method? How long archived data must be kept ?
 
8. What are the minimum physical requirements of database server ? (Storage, Memory, Cpu Requirements etc.. )
 
9. What is the Directory Structure of the database server ?
 
*******************Security******************
10.  How many concurrent users will have database access? And What must be their usage profiles?
 
11.  Is there a platform dependency or requirement? ( OS, Database version etc..)
( Oracle specified Options )
 
12.  Is Oracle Enterprise Linux 5.5 and Oracle Database 11g Standart Edition 11.2.0.3.5 (Latest version at May-2013) Latest suitable for the database server?
 
13.  What are the needed options during the database installation (text, spatial, partioning etc…)?
 
14.  Oracle psu patch transition is needed regularly. Is there any risk while psu patch transitions. Is there a version that doesn’t fit application?
 
15.  Will the applications users be created on database? If it is so what are the minimum access that should be given and what is the minimum rights for application schema user ,too ?
 
16.  Database passwords should be case sensitive and consists of punctuation characters. Is the application server suitable for this situation?



MYSQL Admin "Basic"