Website www.vertica.com | Founded 2005 | |
![]() | ||
Industry Enterprise Software & Database Management & Data Warehousing Key people Colin Mahony (SVP and General Manager)Joy King (VP of Product Marketing & Product Management)Misha Davidson (Director of Engineering) Products Vertica Analytics Platform Enterprise Edition, Vertica SQL on Hadoop, Vertica Analytics Platform Community Edition Profiles |
Vertica Systems was an analytic database management software company. Vertica was founded in 2005 by database researcher Michael Stonebraker, and Andrew Palmer. Former CEOs include Ralph Breslauer and Christopher P. Lynch.
Contents
- Big data simplified with hp vertica
- Products
- Optimizations
- Versions and documentation
- Company events
- References
Vertica was acquired by Hewlett Packard on March 22, 2011. The acquisition expanded the HP Software software portfolio for enterprise companies and the public sector group.
Big data simplified with hp vertica
Products
The cluster-, column-oriented Vertica Analytics Platform was designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The product claims to drastically improve query performance over traditional relational database systems, provide high-availability, and petabyte scalability on commodity enterprise servers.
Its design features include:
Vertica's specialized approach aims to significantly increase query performance in data warehouses, while reducing the total cost of ownership by reducing the hardware footprint. One example of a use case detailed in a research paper shows a performance improvement of hundreds of times with Vertica in a specific application due to the use of the vertical DBMS approach.
In late 2011, the Vertica Analytics Platform Community Edition was made available for free with certain limitations, such as a maximum of one terabyte of raw data, three-node (servers) cluster, and community-based support.
Optimizations
The Vertica Analytics Platform runs on cluster of Linux-based commodity servers. It is also available as a hosted DBMS provisioned by and running on the Amazon Elastic Compute Cloud and Microsoft Azure, ensuring no infrastructure or platform lock in. The product integrates with Hadoop to leverage HDFS via External Tables with ORC and Parquet Readers and can be installed on Hadoop nodes in a co-located manner as Vertica for SQL on Hadoop (a separate offering, priced by per node).
A range of BI, data visualization, and ETL tools are certified to work with and integrate with the Vertica Analytics Platform. For example, the MicroStrategy business intelligence platform is optimized for the Vertica database through Vertica-specific SQL syntax.The Vertica Marketplace lists many of these.
Several of Vertica’s features were originally prototyped within the C-Store column-oriented database, an academic open source research project at MIT and other universities. The system's architecture is described in a 2012 VLDB paper.
Versions and documentation
Company events
In January 2008, Sybase filed a patent-infringement lawsuit against Vertica. In January 2010, Vertica prevailed in a preliminary hearing, and in June, 2010, Sybase and Vertica resolved the suit, with the court dismissing all infringement claims. Under the leadership of Colin Mahony, Vertica has sponsored various technological events in the database industry.
In August 2013, HP Vertica held its first Big Data conference event in Boston, MA USA. This event was held again in 2014, 2015, and 2016, and is scheduled for 2017.
In 2016, HPE published its first O'Reilly book, The Big Data Transformation - Understanding Why Change is Actually Good for Your Business.