SUPPORT
Data Profile ("Mix") Ratio Row size [Bytes] # of Rows Data "unit"= 1 TB Perf_16c B/h #c load in 1H Qs per Sys./dayQs per Sys./day
# Rows [B] Raw Data [TB]
Sensors 20% 50 4,000,000,000 200,000,000,000 10 6.4 200 5,475
Transactions 10% 1,000 100,000,000 100,000,000,000 1 1.6 2,738 2,738
Email/SMS 20% 25,000 8,000,000 200,000,000,000 0.1 1.28 219 5,475
Documents 20% 500,000 400,000 200,000,000,000 0.1 0.064 10.950 5,475
Audio/Video 30% 100,000,000 3,000 300,000,000,000 0.001 0.048 0.082 8,213
Total of "Data Unit [1TB]" 100%   4,108,403,000 1,000,000,000,000   33 3,168 27,375

 

QUERIES CPU alloc. Query time on 1c Q/sec per core Q/day per core Qs per Sys./day
Light Queries 0.5 2.0 86,400 14,880,657
Medium Queries 50 0.02000 691 119,045
Complex Queries 5,000 0.00020 1.73 298
  %   0.67 87,093 15,000,000

 

QUERIES CPU alloc. Query time on 1c Q/sec per core Q/day per core Qs per Sys./day
Light Queries 0.5 2.0 86,400 14,880,657
Medium Queries 50 0.02000 691 119,045
Complex Queries 5,000 0.00020 1.73 298
  %   0.67 87,093 15,000,000

 

Size & Speed Requirements Total Ingest/Days # of Cores Storage Size [TB]
Data Capacity (TBs)     19,929
Ingest Speed (TB/Day) 548 24  
Queries per Day (million)   176  
Data Retention (Years)      
Data in Retention (% Total)      
# of Concurrent Users      
  Total 200 19,929