A Note on Volumes
Mutual fund clients typically have daily NAV records to support their implementation. The dynamic return calculations fetch these NAV records, and dynamically revalue each day up through the end date of the performance period based on options set on the field. The audit logging process takes this a step further and actually writes each intermediate day's calculated values to the audit tables. This can result in a large volume of records being written to the database. In addition, when a fund/date combo is rerun, the process first needs to flush the old records before rewriting the new records.
It is also worth noting that overlapping performance periods for the same fund have unique data. This means that for 2Â periods (1 year and 2 year ended 12/31/2005) each period has its own set of records (366 records for the 1 year and 732Â records for the 2 year period). The second year of the 2 year period is not the same as the recent 1 year period.
The grids in the following table are meant to provide an idea of the volume of data that can be produced.
Estimated Audit Records per Fund / Performance Frequency | ||
---|---|---|
Time | Frequency | Records/Fund* |
1 | Day | 2 |
1 | Month | 32 |
1 | Quarter | 91 |
1 | Year | 366 |
5 | Year | 1830 |
10 | Year | 3660 |
5981 | ||
|
The number of records grow every time you run the process for a new effective date. For example, if you run the process described in the previous table for 10 days in a row, you have approximately 59,810 audit records per fund.
The following table shows an example field rule (not recommended).
Extreme Volume Case Example (Not a Recommended Workflow) | |||
---|---|---|---|
 | Records/Fund | Funds in Report | Audit Records per Report |
1 Year No Load Pre Tax | 366 | 200 | 73200 |
1 Year No Load Post Tax | 366 | 200 | 73200 |
1 Year No Load Post Liq | 366 | 200 | 73200 |
5 Year No Load Pre Tax | 1830 | 200 | 366000 |
5 Year No Load Post Tax | 1830 | 200 | 366000 |
5 Year No Load Post Liq | 1830 | 200 | 366000 |
10 Year No Load Pre Tax | 3660 | 200 | 732000 |
10 Year No Load Post Tax | 3660 | 200 | 732000 |
10 Year No Load Post Liq | 3660 | 200 | 732000 |
ITDYear No Load Pre Tax* | 3660 | 200 | 732000 |
ITD Year No Load Post Tax* | 3660 | 200 | 732000 |
ITD Year No Load Post Liq* | 3660 | 200 | 732000 |
Sub total | 28548 | 200 | 5,709,600 |
*Assume 10 years of history |
The example in the previous table is an extreme case of what can happen if you attempt to log numerous fields for many funds. The fields are common for year end performance reporting but not necessarily for auditing. For example, there are three separate 1 year fields. Each would result in 366 audit records per fund, per effective date.
If you logged all fields for a representative set of 200 share classes, it would result in approximately 5.7 million audit records per effective date. This is not a recommended workflow.
As noted earlier you can configure the data archive engine to help manage database sizing.
Â