Insbridge Batch 2.0 Storage Estimation Reference
Given the tremendous variability in the volume of data stored by the Insbridge Rating process, Oracle
Insbridge provides a formula to help calculate the data storage required by the Batch 2.0 process. This calculation is based off the physical data file storage for Insbridge file based rating.
The calculations should be performed per Line of Business and the Sample Data used for each Line of Business should be known to be representative of that Line of Business.
Line of Business Sample Data Information
|
Input XML files |
A Sample Set of Policy XML files. This sample should represent your forecasted business. |
|---|---|
|
Input XML file size |
Total Physical storage size at the operating system level for the Input XML files. This number should be in bytes. |
|
Sample Number of Policies |
Number of Policies included in the Input XML files. |
|
Output XML files |
A Sample set of Rating XML Results files (Rating Results.) This sample should represent your forecasted business. |
|
Output XML file size |
Total Physical storage size at the operating system level for the Output XML files. This number should be in bytes. |
|
Sample Number of Ratings |
Number of Rating Results included in Output XML files. |
Line of Business Forecasts
|
Forecasted Number of Policies per day |
Number of policies to be loaded into the Batch 2.0 database per day. |
|---|---|
|
Forecasted Number of Ratings per day |
Number of Rating Results to be loaded into the Batch 2.0 database per day. |
|
Input Retention Duration |
Number of days a policy is expected to be kept in the database before being purged. |
|
Rating Result Retention Duration |
Number of days a Rating result is expected to be kept in the database. |
Line of Business Calculations
|
Average Policy size |
(Input XML file size) / (Sample Number of Policies) |
|---|---|
|
Average Rating Result size |
(Output XML file size) / (Sample Number of Ratings) |
|
Input Storage per day |
(Forecasted Number of Policies per day) x (Average Policy size) |
|
Output Storage per day |
(Forecasted Number of Ratings per day) x (Average Rating Result size) |
|
Input Storage estimation |
(Input Storage per day) x (Input Retention Duration) |
|
Output Storage estimation |
(Output Storage per day) x (Rating Result Retention Duration) |
|
Approximate Line of business Database Size |
(Input Storage estimation) + (Output Storage estimation)
Standard conversions may be used to represent this number in Megabytes, etc. (For Megabytes please divide by 1,048,576) |
Note: If the retention policy is rolling two months as opposed to a moving window then the Database Size should be doubled.
