Go to primary content
Oracle® Retail POS Suite 14.1/Merchandising 14.1 Implementation Guide
Release 14.1
E59307-03
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

4 Capacity Planning

This chapter lists the approximate hard drive sizes that are required at each store to be able to support the Data Import project.

The following assumptions were made to arrive at an approximate capacity:

Table 4-1 identifies the file sizes for components in the data import at a store.

Table 4-1 File Sizes

Type of Import One-Record Size in Bytes Peak Load (Number of Records) Peak File Size in Bytes

Item

950.00

15,000,000.00

14,250,000,000.00

Pricing

1,600.00

820,000.00

1,312,000,000.00

Store

710.00

5,000.00

3,550,000.00

Merchandise

300.00

5,000.00

1,500,000.00

Employee

1,400.00

30.00

42,000.00


Total Size of Files

15,567,092,000.00 Bytes

Table 4-2 identifies the sizes of data import bundles.

Table 4-2 Bundle Size

Bundle Size (jar Size)

Assuming 60% Compression Ratio in creating a jar

9,340,255,200.00

Bytes

Approximate Bundle Size

8,900.00

MB


8.69

GB


Table 4-3 identifies the required hard-drive capacities to enable a data import.

Table 4-3 Hard Drive Capacity

Seven files in Archive + One File in current


71,200.00

MB


69.53

GB

Approximate Hard Drive Size to retain the Bundles


70.00

GB

Footprint on DDI Store Server (the DDI remains the responsibility of the implementation team to implement) - assuming size of one Bundle


78.69

GB


Required Hard Drive Capacity (Approximate)

80.00 GB

Table 4-4 Item Import Data Volumes

Data Volumes

Item

800,000 – 1.5 million for peak season

1.5 million

5000 – 15,000 for delta

Item Location

See Item

See Item

Item (Merchandise) Hierarchy

number of departments

number of departments

groups

number of groups

number of hierarchies

number of hierarchies

Organizational (Store) Hierarchy

5000 stores, 6 levels

5000 stores, 6 levels

number of regions

number of districts per region

number of stores per district.

Tax data

See Item (since any tax information is limited to item-related attributes such as tax group ID).

*Tax information does not come from Oracle Retail Merchandising System .

See Item (since any tax information is limited to item-related attributes such as tax group ID).

*Tax information does not come from Oracle Retail Merchandising System.


Pricing Import Data Volumes

Data Volumes: 800000 price changes per day per store.