Vertica Explained

Vertica
Industry:Database management & Data warehousing
Foundation:2005
Founder:Andrew Palmer and Michael Stonebraker
Location:Cambridge, MA, United States
Key People:Mark Barrenechea
Products:Vertica Analytics Database, Vertica SQL on Data Lake
Parent:OpenText

Vertica is an analytic database management software company.[1] [2] Vertica was founded in 2005 by the database researcher Michael Stonebraker with Andrew Palmer as the founding CEO. Ralph Breslauer and Christopher P. Lynch served as CEOs later on.

Lynch joined as Chairman and CEO in 2010 and was responsible for Vertica's acquisition by Hewlett Packard in March 2011.[3] [4] The acquisition expanded the HP Software portfolio for enterprise companies and the public sector group.[5] As part of the merger of Micro Focus and the Software division of Hewlett Packard Enterprise, Vertica joined Micro Focus in September 2017.[6] As part of OpenText acquisition of Micro Focus, Vertica joined OpenText in January 2023.

Products

The column-oriented Vertica Analytics Database was designed to manage large, fast-growing volumes of data and with fast query performance for data warehouses and other query-intensive applications. The product claims to greatly improve query performance over traditional relational database systems, and to provide high availability and exabyte scalability on commodity enterprise servers. Vertica runs on multiple cloud computing systems as well as on Hadoop nodes. Vertica's Eon Mode separates compute from storage, using S3 object storage and dynamic allocation of compute notes.[7]

Vertica's design features include:

Vertica's specialized approach aims to significantly increase query performance in data warehouses, while reducing hardware costs.[12]

Since 2011, Vertica has offered a limited-capacity community edition for free.[13]

In July, 2021, Vertica announced an SaaS offering, Vertica Accelerator, running on Amazon AWS.[14]

Optimizations

Vertica originated as the C-Store column-oriented database, an open source research project at MIT and other universities, published in 2005.[15] [16]

Vertica runs on clusters of commodity servers or on commercial clouds. It integrates with Hadoop,[17] using HDFS.

In 2018, Vertica introduced Vertica in Eon Mode, a separation of compute and storage architecture. The Eon architecture allows for elastic increase and decrease in compute capability as needed for workload elasticity. It also allows instantiation of multiple isolated sub-clusters dedicated to different workloads while maintaining a single shared data repository. It operates on shared object storage in the cloud, and also runs on object storage compatible hardware on-premises for private cloud implementations.

Version 10.1.1 of Vertica introduced Docker and Kubernetes support.[18]

Many BI, data visualization, and ETL tools work with Vertica Analytics Platform. Vertica supports Kafka for streaming data ingestion.

In 2021, Vertica released a connector for Spark.[19]

Vertica also integrates with Grafana, Helm, Go, and Distributed R.[20]

Company events

In January 2008, Sybase filed a patent-infringement lawsuit against Vertica.[21] In January 2010, Vertica prevailed in a preliminary hearing,[22] and in June, 2010, Sybase and Vertica resolved the suit, with the court dismissing all infringement claims.[23]

Since 2013, Vertica has held an annual user conference, now called Vertica Unify.[24]

External links

Notes and References

  1. Network World staff: "New database company raises funds, nabs ex-Oracle bigwigs", http://www.linuxworld.com/news/2007/021407-vertica-oracle.html LinuxWorld, February 14, 2007
  2. Brodkin, J: "10 enterprise software companies to watch", http://www.networkworld.com/news/2007/041107-enterprise-software-companies-to-watch.html?page=9 Network World, April 11, 2007
  3. http://www.hp.com/hpinfo/newsroom/press/2011/110214xb.html HP News Release: "HP to Acquire Vertica: Customers Can Analyze Massive Amounts of Big Data at Speed and Scale" Feb. 2011
  4. http://www8.hp.com/us/en/hp-news/article_detail.html?compURI=tcm:245-907883&pageTitle=HP%20Completes%20Acquisition%20of%20Vertica%20Systems,%20Inc. HP News Release: "HP Completes Acquisition of Vertica Systems, Inc." March 22, 2011.
  5. http://www.computerworld.com/s/article/9209327/Update_HP_to_buy_Vertica_for_analytics?source=rss_news ComputerWorld.com: "Update: HP to buy Vertica for analytics." Kanaracus. Feb. 2011.
  6. https://siliconangle.com/2020/04/13/vertica-survives-software-industry-turmoil-to-emerge-as-key-cloud-and-big-data-player-verticabdc-guestoftheweek/ SiliconAngle: "Vertica survives software industry turmoil to emerge as key cloud and big data player" Albertson.
  7. https://www.microfocus.com/about/press-room/article/2019/micro-focus-announces-vertica-in-eon-mode-for-pure-storage/ Press Release: "Micro Focus Announces Vertica in Eon Mode for Pure Storage" Sept 17, 2019
  8. Monash, C: "Are row-oriented RDBMS obsolete?" http://www.dbms2.com/2007/01/22/are-row-oriented-rdbms-obsolete/ DBMS2, January 22, 2007
  9. Monash, C: "Mike Stonebraker on database compression – comments",http://www.dbms2.com/2007/03/24/comments-stonebraker-data-compression/DBMS2, March 24, 2007
  10. News: Gagliordi. Natalie. HP adds scale to open-source R in latest big data platform. 17 February 2015. ZDNet.
  11. Prasad. Shreya. Fard. Arash. Gupta. Vishrut. Martinez. Jorge. LeFevre. Jeff. Xu. Vincent. Hsu. Meichun. Roy. Indrajit. Enabling predictive analytics in Vertica: Fast data transfer, distributed model creation and in-database prediction. ACM SIGMOD International Conference on Management of Data . 2015.
  12. http://nms.csail.mit.edu/~stavros/pubs/osfa.pdf One Size Fits All? Part 2: Benchmarking Results (sect. 3.1)
  13. Web site: Vertica Announces Community Edition Version of Vertica Analytic Database . https://web.archive.org/web/20150704002958/http://www.vertica.com/content/vertica-announces-community-edition-version-of-vertica-analytic-database/ . July 4, 2015 . August 17, 2016 .
  14. https://www.prnewswire.com/news-releases/vertica-announces-early-access-of-vertica-eon-accelerator-301313251.html PR Newswire: "Vertica Announces Early Access of Vertica Accelerator" Micro Focus. June 15, 2021.
  15. Book: Brodie . Michael L. . Stonebraker . Mike . Abadi . Daniel J. . Batkin . Adam . Chen . Xuedong . Cherniack . Mitch . Ferreira . Miguel . Lau . Edmond . Lin . Amerson . Madden . Sam . O'Neil . Elizabeth . O'Neil . Pat . Rasin . Alex . Tran . Nga . Zdonik . Stan . C-store: a column-oriented DBMS . Making Databases Work: The Pragmatic Wisdom of Michael Stonebraker . Association for Computing Machinery/Morgan & Claypool. 2018 . 491–518 . 10.1145/3226595.3226638 . 9781947487192. 3439184 .
  16. Web site: The Vertica Analytic Database: C-Store 7 Years Later . August 28, 2012 . VLDB.
  17. Web site: Vertica-Hadoop integration . October 12, 2010 . DBMS2.
  18. https://www.vertica.com/blog/vertica-10-1-1-goes-beyond-analytics-with-support-for-azure-cloud-kubernetes-and-containers/ Vertica Blog: "Vertica 10.1.1 Goes Beyond Analytics with Support for Azure Cloud, Kubernetes, and Containers" Healey. April 30,2021
  19. Web site: Vertica Spark Connector. GitHub. 25 February 2022.
  20. Web site: Vertica. GitHub.
  21. Sybase, Inc. v. Vertica Systems, Inc. . Texas Eastern District Court . January 30, 2008 . http://dockets.justia.com/docket/court-txedce/case_no-6:2008cv00024/case_id-107871/.
  22. Monash, C: "Vertica slaughters Sybase in patent litigation",http://www.dbms2.com/2010/01/15/vertica-sybase-ipatent-litigation/DBMS2, January 14, 2010
  23. Vertica Press Release, "Vertica Resolves Sybase Patent Lawsuits" http://www.vertica.com/news/press/vertica-resolves-sybase-patent-lawsuits/
  24. https://events.vertica.com/unify

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Vertica".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.