Estimate the disk space you will need for Sterling Warehouse Management System.
The estimation methodology consists of three parts:
Keep the following information in mind before calculating the estimated disk space:
Use the following examples to help answer these questions:
The following solution lets you achieve this goal:
If you need to purchase storage to cover the first 3 years of implementation, that storage has to be sufficient for 3 years worth of data. At the end of year 3, your database has the data for the third year in the main transactional database while the data for the first and second years is in the history. In this example, you should enter the number 3 as the number of years worth of orders that you expect to keep in the database.
At the end of the tenth year, the database has the data for the tenth year in the main transactional database and the data for the fifth, sixth, seventh, eighth and ninth years in the history. Therefore, the database has six years (as dictated by the data retention policy) in the database. In this example, you should enter the number 6 as the number of years worth of orders that you expect to be kept in the database.
Use the following worksheet to help you estimate required disk space.
Step | Description | Disk Space |
---|---|---|
1. | Enter the number of years' worth of information to be kept in the system (retention time). | ___________ |
2. | Enter the number of orders you expect to be in the system during the time period specified in Step 1. | ___________ |
3. | Enter the number of order lines present in a typical order. | ___________ |
4. | Enter the number of order lines that are to be stored in the database (multiply the values provided in Step 2 and Step 3). | ___________ |
5. | Enter the order line multiplier: Choose one of the following
storage factors that most closely approximates a description of your Sterling Warehouse Management System system: (a) 30 KB - This is primarily used for order management with very little customization. (b) 35 KB - This is primarily used for order management with moderate amount of customization. |
___________ |
6. | Multiply the expected number of order lines from Step 4 and the storage factor from Step 5. | ___________ |
7. | The minimum base storage requirement. | 150 MB |
8. | The minimum operational storage requirements for Sterling Warehouse Management System. | 500 MB |
9. | Enter the total estimated storage obtained by adding the values from Step 6, Step 7, and Step 8. | ___________ |
If you are installing additional products, such as Sterling Business Intelligence or Sterling Business Intelligence Operational Reports, more space is required for data warehousing and moving large amounts of data among multiple databases. Consult the Sterling Business Intelligence topic "Disk Sizing" for this information.