Vertica

from Wikipedia, the free encyclopedia
Vertica Systems, Inc.
legal form Partnership
founding 2005
Seat Billerica ( Massachusetts )
Website www.vertica.com

Vertica Systems is an American software company that produces analytical database systems. Vertica was founded in 2005 by Michael Stonebraker and Andrew Palmer. The company is led by entrepreneur Christopher P. Lynch, who has held executive positions at Wellfleet Communications , Prominet, Lucent , Arrowpoint Communications, Cisco , Acopia Networks and most recently F5 Networks. The board includes Scott Thompson, PayPal president and former Cisco board member Cheng Wu. The advisory board include former Oracle -Führungskräfte Jerry hero and Ray Lane and the former CTO of IBM at Don Haderle.

In February 2011, Hewlett-Packard announced its intention to acquire Vertica and completed the acquisition on March 22, 2011. The acquisition expands HP’s business intelligence and analytical information systems offering for large companies and the public sector. Hewlett-Packard is thus replacing its own data warehouse system Neoview , which is based on HP NonStop technology and is not very successful on the market .

Products

The grid- based, column-oriented Vertica Analytic Database was developed in order to be able to handle large, rapidly growing data volumes ( big data ) with very fast query performance in the data warehouse area (and other query-intensive applications) . The design features include:

  • Column-oriented memory organization that optimizes sequential access at the expense of transactional operations such as access to individual data records, updates and deletions.
  • Out-of-place updates and hybrid storage organization that optimize queries, inserts and loading processes, but at the expense of updates and deletions.
  • Data compression , storage costs and I / O - bandwidth reduced. Strong compression is possible because columns of one data type are stored together and updates to the central memory area are organized in batches .
  • Shared nothing architecture that facilitates the parallelization of processes and enables the system to continue working in the event of hardware failure.

Vertica's special approach aims to significantly improve performance in the data warehouse. An application example in a research article shows a performance improvement by a factor of several hundred with Vertica through the use of vertical database organization in a specific application.

Optimizations

The Vertica Analytic Database running on Grids of Linux - Commodity - servers . For example, it is offered by Amazon Web Services with Hadoop integration.

MicroStrategy's business intelligence platform is optimized for Vertica using a specific SQL syntax.

Some of Vertica's features were first prototyped in the columnar C-Store database , an open source research project by MIT and other universities.

There are no indexes in the Vertica database . The function of the indices is assumed by the so-called projections : those column sets that would be indexed in a row-oriented database in order to speed up the search are duplicated and saved in a sorted manner. This is possible thanks to the high degree of compression (50 to 90% according to the manufacturer).

Legal cases

In January 2010, published reports that Vertica won a hearing at which they successfully against by Sybase labored patent infringement could defend.

supporting documents

  1. ^ Network World staff: "New database company raises funds, nabs ex-Oracle bigwigs", [1] LinuxWorld , February 14, 2007
  2. ↑ J. Brodkin: "10 enterprise software companies to watch", archived copy ( memento of the original from May 18, 2007 in the Internet Archive ) Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice. Network World , April 11, 2007 @1@ 2Template: Webachiv / IABot / www.networkworld.com
  3. ↑ HP News Release: “HP to Acquire Vertica: Customers Can Analyze Massive Amounts of Big Data at Speed ​​and Scale” Feb. 2011
  4. ↑ http://www.computerworld.ch/news/software/artikel/hp-kauf-sich-bi-know-how-55756/ Computerworld.ch
  5. ↑ http://www.hp.com/hpinfo/newsroom/press/2011/110322c.html
  6. ↑ ComputerWorld.com: "Update: HP to buy Vertica for analytics." Kanaracus. February 2011.
  7. ↑ http://www.information-age.com/channels/information-management/news/1602133/hp-reboots-bi-strategy-with-vertica-buy.thtml Information Age
  8. ↑ Monash, C: "Are row-oriented RDBMS obsolete?" [2] DBMS2 , January 22, 2007
  9. ↑ Monash, C: "Mike Stonebraker on database compression - comments", [3] DBMS2 , March 24, 2007
  10. ↑ One Size Fits All? Part 2: Benchmarking Results (sect.3.1) (PDF; 214 kB)
  11. ^ Vertica-Hadoop integration. In: DBMS2. Retrieved October 12, 2010 .
  12. ↑ Vertica Whitepaper on Architecture (PDF; 1.2 MB) ( Memento of the original from March 18, 2013 in the Internet Archive ) Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice. @1@ 2Template: Webachiv / IABot / www.vertica.com
  13. ↑ Monash, C: "Vertica slaughters Sybase in patent litigation", [4] DBMS2 , Jan. 14, 2010
  14. ^ Sybase, Inc. v. Vertica Systems, Inc., Texas Eastern District Court January 30, 2008

Web links