Vertica

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Vertica Systems, Inc.
Industry Enterprise Software & Database Management & Data Warehousing
Founded 2005
Headquarters Cambridge, MA
Products Vertica Analytic Database, Vertica Analytic Database Appliance, Vertica for the Cloud
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 expands the Enterprise software division of HP – HP Software’s information optimization, business intelligence and analytics portfolio for enterprise companies and the public sector.[5]

Contents

Products [edit]

The grid-based, column-oriented, Vertica Analytic Database 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. 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]
  • 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.

Vertica's specialized approach aims to significantly increase query performance in data warehouses. 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.[8]

On Nov 29, 2011, HP announced a new big data analytics platform, the "HP Next Generation Information Platform", based on a combination of Autonomy’s unstructured data analytics engine, IDOL 10, and Vertica’s analytics database.[9][10] The platform combines structured and unstructured data into a unified workflow.

Optimizations [edit]

The Vertica Analytic Database runs on grids of Linux-based commodity servers. It is also available as a hosted DBMS provisioned by and running on the Amazon Elastic Compute Cloud. It integrates with Hadoop.[11]

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.[12]

Company events [edit]

In January 2008, Sybase filed a patent-infringement lawsuit against Vertica.[13] In January 2010, Vertica prevailed in a preliminary hearing,[14] and in June, 2010, Sybase and Vertica resolved the suit, with the court dismissing all infringement claims.[15] Under the leadership of Jonathan Zuercher, Vertica has sponsored various technological events in the database industry.[16]

See also [edit]

References [edit]

  1. ^ Network World staff: "New database company raises funds, nabs ex-Oracle bigwigs”, [1] LinuxWorld, February 14, 2007
  2. ^ Brodkin, J: "10 enterprise software companies to watch", [2] 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?" [3] DBMS2, January 22, 2007
  7. ^ Monash, C: "Mike Stonebraker on database compression – comments”,[4]DBMS2, March 24, 2007
  8. ^ One Size Fits All? Part 2: Benchmarking Results (sect. 3.1)
  9. ^ "HP Unveils Autonomy/Vertica-based Big Data Analytics Platform". servicesangle.com. Retrieved 9 Feb 2012. 
  10. ^ "HP pairs Autonomy and Vertica software". computerworld.com. Retrieved 9 Feb 2012. 
  11. ^ "Vertica-Hadoop integration". DBMS2. October 12, 2010. 
  12. ^ "The Vertica Analytic Database: C-Store 7 Years Later". VLDB. August 28, 2012. 
  13. ^ Sybase, Inc. v. Vertica Systems, Inc. (Texas Eastern District Court January 30, 2008). Text
  14. ^ Monash, C: "Vertica slaughters Sybase in patent litigation”,[5]DBMS2, January 14, 2010
  15. ^ Vertica Press Release, "Vertica Resolves Sybase Patent Lawsuits" http://www.vertica.com/news/press/vertica-resolves-sybase-patent-lawsuits/
  16. ^ /http://www.linkedin.com/in/jonathanzuercher

External links [edit]