 |
High Return On
Investment (ROI) - implementation time and cost |
| Low Total Cost of Ownership (TCO) -
relatively easy to maintain and change over time |
| Avoid typical conventional adapters in
federated systems short-term cost to build and
longer-term cost to maintain |
| No increased query load on existing systems,
unlike conventional adapters in federated systems |
| No cost to move data through Extract
Transform and Load (ETL) processes to a "one-size-fits-all" data warehouse - avoid
data schema transforms |
| Low cost for additional data storage, unlike
a data warehouse; however, indexes do require some additional storage |
|
No or low-cost evaluation/proof of concept/prototype |
| Works with most existing systems |
|
Can be quick and easy to deploy:
| Bundled, DBA-level enterprise tools – no special expertise
required |
|
|
Stable, proven reliability – used in legacy products for 24/7 mission-critical
operations |
| Very large number of records
| Up to 2.2 billion for 32-bit
version for a single data source - multiple 32-bit data partitions for up to almost 70 billion |
| 64-bit version planned for almost unlimited
number of records |
|
| Very large volumes of data (multi-terabytes) |
| Large number of concurrent users |
| Fastest available index and query
processing system |
| Rapid response to queries (typically, 10 to over 100 times faster than
other RDBMSs) - sub-second responses to
complex queries on a billion records - try it for yourself at www.whamtechdev.com |
| Real-time update rates of
100s to 10s
of 1000s of records per second on low-level, off-the-shelf servers
- try it for yourself at www.whamtechdev.com |
| Complex queries |
| Fast n-way table
joins using virtual query processing - no interim or temporary
tables |
| Fast range queries, including spatial and
date/time data (up to 5 million records/second) |
| Text search on structured, unstructured,
and semi-structured data sources |
| Highly flexible query and results data
integration and presentation |
| Little or no “optimization” needed |
| Stability (no data or index corruption
reported in last 15 years - core code is stable) |
| Established, proven technology (> 25 years) |
