Date of Certifcation (mm/dd/yyyy) Technology Partner Step Throughput / Hour Number of Records in Fact Table (Memory) Operating System - Release RDBMS Release Technolgy Release BW Release Central Server DB server memory (MB) Certification Number 
02/08/2001 Compaq Step 1:
Load phase
 
Step 2: Realignment
 
Step 3:
Query phase Average no. of rows: 25,366,795


No. of rows: 108,287,407 
(total runtime: 1.05 hrs) 

Navigation steps: 46,094 
(CPU util. of central system: 99%) 116,800,000
(8 GB main memory) Compaq Tru64 Unix V. 5.1 Oracle 8.1.6 4.6 C 2.0 B Alphaserver ES40, 4-way Alpha 21264 EV68 833 MHz, 8 MB L2 Cache 8,192 2001004 
12/28/2000 Compaq Step 1: 
Load phase

Step 2: Realignment 

Step 3: 
Query phase Average no. of rows: 114,509,804 


No. of rows: 313,849,599 
(total runtime: 1.29 hrs) 

Navigation steps: 207,323 
(CPU util. of central system: 92%) 467,200,000
(32 GB main memory) Compaq Tru64 Unix V. 5.1 Oracle 8.1.6 4.6 C 2.0 B Alphaserver Model GS320, 32-way Alpha 21264 EV67 731 MHz, 4 MB L2 Cache 32,768 2000032 
06/16/2000 Compaq Step 1: 
Load phase 

Step 2: Realignment 

Step 3: 
Query phase Average no. of rows: 2,125,546 


No. of rows: 10,657,000 
(total runtime: 5.29 hrs)

Navigation steps: 38,815 
(CPU util. of central system: 95%) 116,800,000
(8 GB main memory) Windows 2000 MS SQL Server 2000 4.5 B 1.2 B ProLiant Model 8000, 8-way Pentium III Xeon 700 MHz, 2 MB L2 Cache 4,096 2000016 
01/31/2000 IBM Step 1: 
Load phase 

Step 2: Realignment 

Step 3: 
Query phase Average no. of rows: 3,144,179 


No. of rows: 14,600,000 
(total runtime: 8.13 hrs) 

Navigation steps: 115,570 
(CPU util. of central system: 84%) 58,400,000 
(4 GB main memory) AIX 4.3.3 DB/2 UDB 6.1 4.5 B 1.2 B IBM RISC System / 6000 Model S80, 24-way Power PC-RS64-III, 450 MHz, 8MB L2 cache 8,192 2000001