Database Sizing Require
Total
Users : 65
Maximum
Number of concurrent users : 20
Complexity
of transaction : Light -30% Medium
- 30% Heavy - 40%
Number of read/writes per second : Read - 19000 Writes
- 2600
Heavy
Batch Load : Yes
Archive Logs :
Yes
High
Number of index and constraints : Yes
High
Availability Data replication : Yes
TimeSeries :
Yes
Disk
Size : 125 GB
Virtual
Environment : Yes
Platform : Intel
Type
of System : OLTP + DSS (Mix Workload)
Data
Transformations : Multiple data
transformations
MIS
Reports : 30
-Multiple data access points : SPSS, CPLEX
, Contract Management, Cognos an Cognos TM1 Software
-Without built-in Time Series, data processing may go double. It
will have significant impact on reads as lots of data sorting will be required