|
|
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
As you can see from the graph below, the value a business attains from it data directly correlates to how effectively users can get answers to their questions. These benchmarks highlight the Dataupia Satori Server's ability to scale to accommodate a broader mix of users as well as improving query performance time.
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 |
Load Times |
Refresh Rate |
Drill Down Capabilities |
Two data sources were used:
58 billion rows
117 billion rows
|
70 MB of data per second
|
Data loaded at continuous 15 minute intervals
|
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 |
512 Simultaneous Queries |
768 Simultaneous Queries |
|
4.8 seconds response/query
|
8.1 seconds response/query
|
13.8 seconds response/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.
|
|
|
