HP Vertica is an analytic database management software company. A columnar data storage platform designed to handle large volumes of data, enabling fast query performance in traditionally intensive scenarios. The product improves query performance over relational database systems, provides high-availability, and petabyte scalability on commodity enterprise servers. It is also part of the HP Haven platform, which is focused on analytics of big data sources, including petabytes of structured and unstructured information. The integration of IDOL and HP Vertica within HP Haven connects users to many business, machine, and human data sources. This helps perform both standard and predictive analysis.
Why Vertica?
- A shared grid-based database architecture that allows Vertica to scale effectively on clusters of commodity CPUs.
- It is a high-performance, ACID-compliant database system with a lightweight transaction and concurrency control scheme. This is optimized towards loading and querying data. Vertica’s failure recovery model is based on snapshot isolation (a generational storage model) and data replication, rather than traditional log-based methods.
- Monitoring and administration tools and APIs for gauging utilization, profiling execution, backup and disaster recovery, etc.
- Vertica uses the latest TLS protocol to authenticate client and server communications. The authentication mechanisms work with third party certificate authorities