Vertica

HP Vertica

Industry	Enterprise Software & Database Management & Data Warehousing
Founded	2005
Founder	Andrew Palmer and Michael Stonebraker
Headquarters	Cambridge, MA
Key people	Colin Mahony (VP and General Manager) Matthew Cain (VP of Finance and Administration) Shilpa Lawande (VP of Engineering) Chris Selland (VP of Marketing)
Products	Vertica Analytics Platform Enterprise Edition, Vertica Analytics Platform Community Edition
Parent	Hewlett-Packard
Website	www.vertica.com

Vertica Systems is an analytic database management software company.^[1][2] Vertica was founded in 2005 by database researcher Michael Stonebraker, and Andrew Palmer. Former CEOs include Ralph Breslauer and Christopher P. Lynch.

Vertica was acquired by Hewlett Packard on March 22, 2011.^[3][4] The acquisition expanded the HP Software software portfolio for enterprise companies and the public sector.^[5]

Products

The cluster-based, column-oriented Vertica Analytics Platform is 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:

• Column-oriented storage organization, which increases performance of sequential record access at the expense of common transactional operations such as single record retrieval, updates, and deletes.^[6]
• Standard SQL interface with many analytics capabilities built-in, such as time series gap filling/interpolation, event-based windowing and sessionization, pattern matching, event series joins, statistical computation (e.g., regression analysis), and geospatial analysis.
• Out-of-place updates and hybrid storage organization, which increase the performance of queries, insertions, and loads, but at the expense of updates and deletes.
• Compression, which reduces storage costs and I/O bandwidth. High compression is possible because columns of homogeneous datatype are stored together and because updates to the main store are batched.^[7]
• Shared nothing architecture, which reduces system contention for shared resources and allows gradual degradation of performance in the face of hardware failure.
• Easy to use and maintain through automated data replication, server recovery, query optimization, and storage optimization.
• Support for standard programming interfaces ODBC, JDBC, ADO.NET, and OLEDB.
• High performance and parallel data transfer to statistical tools such as Distributed R, and the ability to store machine learning models, and use them for in-database scoring.^[8][9]

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.^[10]

As of late 2011, the Vertica Analytics Platform Community Edition^[11] is available for free with certain limitations, such as a maximum of one terabyte of raw data, three-node (servers) cluster, and limited support.

Optimizations

The Vertica Analytic Database 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. The product integrates with Hadoop^[12] to leverage HDFS within Vertica and provide access to Vertica's data through MapReduce.

The MicroStrategy business intelligence platform is optimized for the Vertica database through Vertica-specific SQL syntax.

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.^[13]

Versions and documentation

• HPE Vertica Analytics Platform 7.2.x^[14]
• HP Vertica Analytics Platform 7.1.x^[15]
• HP Vertica Analytics Platform 7.0.x^[16]
• HP Vertica Analytics Platform 6.1.x^[17]
• HP Vertica 6.0.x Enterprise Edition^[18]
• HP Vertica 5.1 Enterprise Edition^[19]
• HP Vertica Enterprise Edition 5.0^[20]
• HP Vertica Enterprise Edition 4.1^[21]

HP Haven

In June 2013, HP announced the Haven platform for analyzing and finding meaning from big data—petabytes of structured and unstructured information. HP Haven is driven by three analytical engines in HP's portfolio; Vertica, IDOL and Distributed R. For example, the integration of IDOL and Vertica allows users to connect to a variety of machine, business, human data sources and perform both standard and predictive analysis.

Company events

In January 2008, Sybase filed a patent-infringement lawsuit against Vertica.^[22] In January 2010, Vertica prevailed in a preliminary hearing,^[23] and in June, 2010, Sybase and Vertica resolved the suit, with the court dismissing all infringement claims.^[24] Under the leadership of Colin Mahony, Vertica has sponsored various technological events in the database industry.^[25]

In June 2013, Hewlett-Packard announced that Vertica will be a core part of their big data initiative called Haven.^[26]

In August 2013, HP Vertica held its first Big Data conference^[27] event in Boston, MA USA. This event was held again in 2014 and 2015 and is scheduled for 2016.

See also

• C-Store
• Column-oriented database
• R (programming language)
• Greenplum
• MapReduce
• Shared nothing architecture
• Sybase IQ

References

1. Network World staff: "New database company raises funds, nabs ex-Oracle bigwigs”, LinuxWorld, February 14, 2007
2. Brodkin, J: "10 enterprise software companies to watch", Network World, April 11, 2007
3. HP News Release: “HP to Acquire Vertica: Customers Can Analyze Massive Amounts of Big Data at Speed and Scale” Feb. 2011
4. HP News Release: “HP Completes Acquisition of Vertica Systems, Inc.” March 22, 2011.
5. ComputerWorld.com: “Update: HP to buy Vertica for analytics.” Kanaracus. Feb. 2011.
6. Monash, C: "Are row-oriented RDBMS obsolete?" DBMS2, January 22, 2007
7. Monash, C: "Mike Stonebraker on database compression – comments”,DBMS2, March 24, 2007
8. Gagliordi, Natalie. "HP adds scale to open-source R in latest big data platform". ZDNet. Retrieved 17 February 2015.
9. Prasad, Shreya; Fard, Arash; Gupta, Vishrut; Martinez, Jorge; LeFevre, Jeff; Xu, Vincent; Hsu, Meichun; Roy, Indrajit (2015). "Enabling predictive analytics in Vertica: Fast data transfer, distributed model creation and in-database prediction". ACM SIGMOD International Conference on Management of Data (SIGMOD).
10. One Size Fits All? Part 2: Benchmarking Results (sect. 3.1)
11. http://www.vertica.com/content/vertica-announces-community-edition-version-of-vertica-analytic-database/
12. "Vertica-Hadoop integration". DBMS2. October 12, 2010.
13. "The Vertica Analytic Database: C-Store 7 Years Later" (PDF). VLDB. August 28, 2012.
14. Documentation https://my.vertica.com/hpe-haven-documentation/hpe-vertica-analytics-platform-7-2-x-product-documentation/
15. Documentation http://www.vertica.com/hp-vertica-documentation/hp-vertica-7-1-x-documentation/
16. Documentation http://www.vertica.com/documentation/hp-vertica-analytics-platform-7-0-x-product-documentation/
17. Documentation http://www.vertica.com/documentation/documentation-6-1/
18. Documentation http://www.vertica.com/documentation/hp-vertica-documentation-6-0-x/
19. Documentation http://www.vertica.com/documentation/hp-vertica-5-1-x-enterprise-edition-product-documentation/
20. Documentation http://www.vertica.com/documentation/hp-vertica-enterprise-edition-5-0-product-documentation/
21. Documentation http://www.vertica.com/documentation/hp-vertica-documentation-5-1/
22. Sybase, Inc. v. Vertica Systems, Inc. (Texas Eastern District Court January 30, 2008). Text
23. Monash, C: "Vertica slaughters Sybase in patent litigation”,DBMS2, January 14, 2010
24. Vertica Press Release, "Vertica Resolves Sybase Patent Lawsuits" http://www.vertica.com/news/press/vertica-resolves-sybase-patent-lawsuits/
25. http://www.vertica.com/news/events/
26. HP News - HP Unleashes the Power of Big Data http://www8.hp.com/us/en/hp-news/press-release.html?id=1416090
27. HP Vertica Big Data Conference 2013 http://www.vertica.com/hp-vertica-big-data-conference-2013/

External links

• HPE Software official site
• Official website
• Official user community
• Unofficial Vertica User Google Group
• Ex-Vertica CEO pledges to build high-speed railway for Big Data
• The Vertica Database Forums - User 2 User Support
• Independent Blog for the HPE Vertica Platform