A report that contains logical items

Table 1. Report that contains logical items. Database columns. Part 1 of 4.
Column number Name Index or filter Bytes
1 Account number Index 12
2 Report date Filter 4
3 Customer name Filter 24
Table 2. Report that contains logical items. Report profile. Part 2 of 4.
Report characteristic Report estimate
Volume of data per month (bytes) 8 000 000 000
Average statement size (bytes) 8000
Number of statements per month 1 000 000
Number of cycles per month 20
Largest cycle data size (bytes) 400 000 000
Largest single report file size (bytes) 400 000 000
Largest cycle (number of statements) 50 000
Number of database columns from Table 1 4
Life of data (months) 36
Number of weeks to cache data 26
Number of days to keep the index in the database 1098
Compression percentage (ratio) 0.13 (8:1) AFP
Table 3. Report that contains logical items. Disk storage requirements in bytes. Part 3 of 4.
Storage component Storage requirement
Temporary storage 600 000 000
Cache storage 7 436 000 000
Content Manager OnDemand database 5 400 000 000
Total disk storage required (bytes) 13 436 000 000
Table 4. Report that contains logical items. Archive storage requirements in bytes. Part 4 of 4.
Storage component Storage space requirement
Report data 41 184 000 000
Total archive storage required (bytes) 41 184 000 000