|
Introducing a New Era in DBMS Performance & Efficiency |
|
|
|
|
Monday, 10 September 2007 |
|
by Vertica Systems The time for database innovation is now! 30-year-old OLTP DBMS technology is no longer able to support today's data warehouse and business intelligence workloads. Data volumes are too large, ad hoc query demands are too great, and users increasingly need real-time views of information. This paper describes a fresh approach to this dilemma. Through benchmark studies and architectural explanation, it describes how a DBMS designed specifically to handle the workloads of data warehouses, data marts and other query-intensive analytical applications is able to do the following: - Query 60x faster than Oracle and other OLTP databases
- Store and query 21TB of call detail record data using just 2TB of disk space
- Query 215x faster than a data warehouse appliance
- Reduce DBMS hardware costs from $500,000 to $30,000
This paper explains architectural innovations such as column database architecture, aggressive data compression, automatic database design, logless recovery, support for grid computing and concurrent loading and querying.
Source
|
