HPE Vertica, designed with speed, scalability, simplicity, and openness at its core, provides blazing-fast speed (queries run 50-1,000x faster), petabyte-scale (store 10-30x more data per server), and openness and simplicity (use any BI/ETL tools, Hadoop, etc.) — all at 30% of the cost of traditional data warehouse solutions.
Listen to the recorded replay of one of our most popular webinars this year. Chuck Bear, Vertica Developer at HPE, discusses how pre-aggregating data accelerates popular queries in the Vertica SQL analytics database so you can take full advantage for dashboards, reports, and other "serve" use cases that demand subsecond response times.
HPE Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. HPE Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
Vertica SQL Analytics Platform Key Features
Real-Time Loading and Querying
Load data up to 10x faster than traditional row-stores by using a unique time travel transactional model that ensures extremely high query concurrency, while simultaneously loading new data into the system. Ensure near-real-time availability of information and use Flex Tables to query the dark data in your system. Learn more about HPE Vertica Flex Tables.
Advanced In-Database Analytics
Vertica offers a robust and ever growing set of Advanced In-Database Analytics functionality so that customers can conduct the analytics computations closer to the data, and get immediate answers from a single place without the need to extract information to a separate environment for processing. Keeping the data in-database is especially critical as the size of data sets shifts from terabytes to petabytes and beyond.
Database Designer and Administration Tools
Allow for powerful tuning and control with minimal administration effort using Vertica’s Database Designer and Administration Tools. In traditional database environments, DBAs spend a lot of time and money identifying performance problems and optimizing a database physical design, usually after their users have already encountered problems and SLAs have not been met.
Columnar Storage & Execution
It's no wonder why all of the major data warehousing vendors are trying to morph their outdated architectures to leverage columnar technology- column stores offer significant gains in performance, I/O, storage footprint, and efficiency when it comes to analytic workloads. Why read and retrieve all columns in the database if you don’t need all of them?
Aggressive Data Compression
Vertica operates on encoded data which dramatically improves analytic performance by reducing CPU, memory, and disk I/O at processing time. Traditional RDBMS systems are not able to operate on compressed data. A typical row-oriented database system will often expand to 3-5X its original raw data size once auxiliary physical structures like indexes and materialized views are added. Vertica on the other hand will end up reducing the original data size to 1/5th or 1/10th its original size even with our high-availability redundancy turned on.
Scale-Out MPP Architecture
The speed, scale and rapid growth of today’s information exceed what even the largest of supercomputers could ever handle alone, which is why Massively Parallel Processing (MPP) systems are becoming the norm. Vertica delivers a simple, yet highly robust and scalable MPP solution for the masses with linear scaling and native high availability on industry standard hardware.
Fully experience the HPE Vertica Analytics Platform at no cost and no time limit! Manage and analyze up to 1 TB of data across three nodes for an unlimited time, and explore dark data sitting in semi-structured formats across your enterprise.
Leading performance advertising company Criteo targets ads to 1.1 billion internet users per month with pinpoint accuracy with the predictive analytical power of HPE Vertica. Learn more in this short video.
DreamWorks Animation tapped the Vertica solution to allowed creative teams to look at massive amounts of render data to reveal trends and reduce query processing time. During the production process, creative teams often construct multiple scenarios for directors to review. Real-time knowledge around how much computing time these frames required was invaluable to the creation of Kung Fu Panda 3.
Three challenges facing financial services are external. The fourth is self-inflicted: trying to manage modern business using old tools. This Frost & Sullivan report details how SQL analytics and Big Data financial services will bring you into the new digital world.
Go behind the scenes of the HPE Big Data Platform, the only platform that enables you to harness and gain insights from 100% of your organization's data -- machine data, business data, and human data. Register for an upcoming webcast, or watch a replay of one of our many topics, delivered by our engineers.
Conservation International (CI) partnered with HP "to generate real-time data for monitoring long-term trends in tropical biodiversity through a global network of field stations, providing an early warning system on the status of biodiversity to effectively guide conservation action." CI’s Director of Information Systems, Eric Fegraus, says "What we have been able to do is bring analytics and a data-driven approach to building indices of wildlife communities in tropical forests, and be able to monitor them in near-real-time."
Since Supercell began developing games for tablets in 2011, the Finnish company has had two top-grossing games for the iOS platform, “Clash of Clans” and “Hay Day,” both released in 2012. Behind the scenes, Supercell has adopted the HP Vertica Analytics Platform for real-time gaming data analytics. With HP Vertica, Supercell has an analytics platform and partner to support its tremendous growth.
BlaBlaCar enables 20 million members to share a trip and costs when they travel to the same location. It handles 4 million events a day. An advanced Big Data analytics solution helped it improve customer experience, campaign analytics, and new product testing.
Cardlytics relied on Microsoft SQL Server as its main database platform, but the company needed to better manage voluminous data and improve processing speed. After completing a successful proof of concept, Cardlytics implemented HP Vertica SQL analytics. The company now has a scalable platform that handles large volumes of data, provides dramatically faster returns on queries, and requires significantly less maintenance time.
Cerner Corporation’s Millennium® solution platform not only provides Electronic Health Records for health care providers, but also helps those providers optimize processes to speed the delivery of care and eliminate waste and error. When the company’s legacy data warehousing solution could no longer support the need for near-real-time data analysis, it turned to HP Vertica.
Financial services organization, China PnR, suffered a data explosion and its existing tool could no longer cope with loading and aggregating data and performing real-time queries. China PnR used HP Vertica to build a data warehousing analytics platform.