 |
|
|
|
Benchmarks
The Dataupia benchmark was conducted in the Fall of 2007 and evaluated a number of standards to measure operational BI efficiency including:- Number of simultaneous CPU queries
- Amount of data that can be loaded and refreshed
- Speed at which users can access queries across 24 months of data
Performance
The benchmark highlights the Dataupia Satori Server's ability to manage constantly changing data without causing performance degradation in the system by measuring data volume and load and refresh times. Specific benchmarks include:- Data volume - two data sources were used during the benchmark tests, one 58 billion rows and one 117 billion rows representing 24 months of data
- Load times - 70 MB of data per second
- Refresh rate - data loaded at continuous 15 minute intervals
- Drill down capabilities - 24 months of detail data was accessed in only five seconds
Response Rate
The benchmark also provides insight into the Dataupia Satori Server's ability to run simultaneous versus concurrent queries without impacting system performance. Simultaneous queries refer to the number of CPU queries running at exactly the same moment, while performance indicates the speed across different volumes of data. The data below shows that even when the number of simultaneous queries increased, response times remained remarkably fast. Specific performance benchmarks for pre-aggregated calculations across multiple dimensions include:- 100 simultaneous queries averaged 4.8 seconds response per query
- 512 simultaneous queries averaged 8.1 seconds response per query
- 768 simultaneous queries averaged 13.8 second response per query
Data Center "Greenness"
As "green" computing becomes increasingly important in business; Dataupia's benchmark revealed the reduced environmental impact data warehouse initiatives can have on the data center.The Dataupia Satori Server consumes less than 10 percent of the energy, including power and cooling, that a traditional storage server configuration consumes. In addition, the Dataupia Satori Server's low energy and space requirements use 50 times less energy than a SAN architecture to house similar amounts of data.
