Sizing Estimates Deliverable Template

From MIKE2 Methodology

This deliverable template is used to describe a sample of the MIKE2.0 Methodology (typically at a task level). More templates are now being added to MIKE2.0 as this has been a frequently requested aspect of the methodology. Contributors are strongly encouraged to assist in this effort.

Deliverable templates are illustrative as opposed to fully representative. Please help add examples to this template that are representative of the proposed output.

An output of the Develop Physical Data Model task is the Sizing Estimates for the database.

Example Database Sizing estimate for a Data Mart

Listed below are example Database sizing estimates:

Sizing

The following represents the estimated level of sizing for the ABC datamart.

Disk Sizing based on there will be historical records as stated in the assumptions at Year 0 for Campaign, Cell, Campaign Communication, Email Campaign, Email Response, Activity, Opportunity and Purchase.

Disk Sizing	Initial Size (Year 0) In GB	End of Year 1 In GB	End of Year 2 In GB	End of Year 3 In GB
Size of Mart	774	1,512	1,663	2,044
w/Raid Level 5	929	1,815	1,996	2,453

"

Disk Sizing	Initial Size (Year 0) In GB	Year 1 In GB	Year 2 In GB	Year 3 In GB
Size of Mart	774	1,512	1,663	1,995
w/Raid Level 5	929	1,815	1,996	2.394

Database Sizing Detail

Database Sizing Detail

		Open Market
Information Groups	Estimated	Average	# of related	Total	Estimated
	Bytes	Frequency	customers	# Records	Total (in MB)
Misc. Client Info. and Dates	100	1	40,000,000	40,000,000	3815
Name (& related attributes)	773	1	40,000,000	40,000,000	29488
Address	440	1.1	40,000,000	44,000,000	18463
Phone	107	1	10,000,000	10,000,000	1020
Email	87	1	10,000,000	10,000,000	830
Contacts			0	0	0
Model Scores	82	2	40,000,000	80,000,000	6256
Profile (includes up to 15 purchased elements)	506	1.5	40,000,000	60,000,000	28954
Preferences	68	2	4,000,000	8,000,000	519
Survey History	139	0	0	0	0
Memberships	159	2	0	0	0
Source History	30	2	40,000,000	80,000,000	2289
Lead Source History	30	0	0	0	0
Grouping (HH, Co., Ownership, Roles, etc.)	100	1.1	40,000,000	44,000,000	4196
Referrals	114	0	0	0	0
Promotion Activity History	420	2	10,000,000	20,000,000	8011
Response Activity History	420	0	0	0	0
Interaction Activity History (related to MKT)	420	0	0	0	0
Opportunities/Sales Cycle Dispositions	210	0	0	0	0
Package/Tour/Stays/Merch. Purchase	124	0	0	0	0
Product Purchase (i.e. time share)	104	0	0	0	0
Loans	130	0	0	0	0
Product Usage	146	0	0	0	0
				Total	103840