vertica butterfly . 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 was 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 contents 1 products 2 optimizations 3 versions and documentation 4 hp haven 5 company events 6 see also 7 references 8 external links products edit 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 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 in late 2011 the vertica analytics platform community edition was available for free with certain limitations such as a maximum of one terabyte of raw data three node servers cluster and limited support . 11 optimizations edit 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 edit 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 edit 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 . 22 company events edit in january 2008 sybase filed a patent infringement lawsuit against vertica . 23 in january 2010 vertica prevailed in a preliminary hearing 24 and in june 2010 sybase and vertica resolved the suit with the court dismissing all infringement claims . 25 under the leadership of colin mahony vertica has sponsored various technological events in the database industry . 26 in june 2013 hewlett packard announced that vertica will be a core part of their big data initiative called haven . 27 in august 2013 hp vertica held its first big data conference 28 event in boston ma usa . this event was held again in 2014 and 2015 and is scheduled for 2016 . see also edit c store column oriented database r programming language greenplum mapreduce shared nothing architecture sybase iq references edit network world staff new database company raises funds nabs ex oracle bigwigs 1 linuxworld february 14 2007 brodkin j 10 enterprise software companies to watch 2 network world april 11 2007 hp news release hp to acquire vertica customers can analyze massive amounts of big data at speed and scale feb. 2011 hp news release hp completes acquisition of vertica systems inc. march 22 2011 . computerworld.com update hp to buy vertica for analytics . kanaracus . feb. 2011 . monash c are row oriented rdbms obsolete 3 dbms2 january 22 2007 monash c mike stonebraker on database compression comments 4 dbms2 march 24 2007 gagliordi natalie . hp adds scale to open source r in latest big data platform . zdnet . retrieved 17 february 2015 . 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 . one size fits all part 2 benchmarking results sect . 3.1 vertica announces community edition version of vertica analytic database . archived from the original on july 4 2015 . retrieved august 17 2016 . vertica hadoop integration . dbms2 . october 12 2010 . the vertica analytic database c store 7 years later pdf . vldb . august 28 2012 . documentation https my.vertica.com hpe haven documentation hpe vertica analytics platform 7 2 x product documentation documentation http www.vertica.com hp vertica documentation hp vertica 7 1 x documentation documentation http www.vertica.com documentation hp vertica analytics platform 7 0 x product documentation documentation http www.vertica.com documentation documentation 6 1 documentation http www.vertica.com documentation hp vertica documentation 6 0 x documentation http www.vertica.com documentation hp vertica 5 1 x enterprise edition product documentation documentation http www.vertica.com documentation hp vertica enterprise edition 5 0 product documentation documentation http www.vertica.com documentation hp vertica documentation 5 1 mike wheatley march 30 2015 . hp revamps haven big data platform with idol & vertica integration . silicon angle . retrieved august 17 2016 . sybase inc. v. vertica systems inc. texas eastern district court january 30 2008 . text monash c vertica slaughters sybase in patent litigation 5 dbms2 january 14 2010 vertica press release vertica resolves sybase patent lawsuits http www.vertica.com news press vertica resolves sybase patent lawsuits http www.vertica.com news events hp news hp unleashes the power of big data http www8.hp.com us en hp news press release.html id 1416090 hp vertica big data conference 2013 http www.vertica.com hp vertica big data conference 2013 external links edit 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 v t e hewlett packard hp inc. hewlett packard enterprise founders william hewlett david packard directors marc andreessen shumeet banerji rajiv l. gupta raymond j. lane ann livermore gary m. reiner patricia f. russo jim skinner meg whitman chairman executive officers meg whitman todd bradley dave donatelli martin fink henry gomez john hinshaw marty homlish george kadifa tracy keogh cathie lesjak mike nefkens john f. schultz bill veghte computer hardware products bladesystem compaq presario business desktops elitebook zbook probook integrity nonstop proliant pavilion touchsmart mini hp envy slate 500 consumer electronics and accessories calculators deskjet photosmart laserjet ipaq lightscribe palm scitex snapfish other divisions 3com arcsight indigo digital press scitex hp insight software procurve hp enterprise services tower software software mercury autonomy webos vertica hp quickplay hyperspace os hp ux openvms tippingpoint services hp helion hp cloud discontinued products compaq deskpro compaq evo compaq portable compaq prolinea compaq prosignia compaq systempro jornada omnibook ipod hp voodoopc touchpad closed division voodoopc logoworks hp ceos list of hp ceos in order co founders william hewlett and david packard john a. young lewis e. platt carly fiorina mark hurd l o apotheker meg whitman assets hp garage hp labs see also acquisitions agilent avago technologies verigy keysight technologies hp spying scandal products mission space retrieved from https en.wikipedia.org w index.php title vertica & oldid 739001098 categories software companies based in massachusettshewlett packard acquisitions navigation menu personal tools not logged intalkcontributionscreate accountlog in namespaces article talk variants views read edit view history more search navigation main pagecontentsfeatured contentcurrent eventsrandom articledonate to wikipediawikipedia store interaction helpabout wikipediacommunity portalrecent changescontact page tools what links hererelated changesupload filespecial pagespermanent linkpage informationwikidata itemcite this page print export create a bookdownload as pdfprintable version languages deutsch edit links this page was last modified on 12 september 2016 at 06 20 . text is available under the creative commons attribution sharealike license ; additional terms may apply . by using this site you agree to the terms of use and privacy policy . wikipedia is a registered trademark of the wikimedia foundation inc. a non profit organization . privacy policy about wikipedia disclaimers contact wikipedia developers cookie statement mobile view