On-Demand: Pre-Aggregating Data for Rapid Analysis
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.
Watch Now
Purpose-Built Big Data Analytics
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.
Read the OverviewHPE 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, on demand, 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
Designed with a unique time travel transactional model that ensures extremely high query concurrency, while simultaneously loading new data into the system, Vertica is often able to load data up to 10x faster than traditional row-stores as a result of this design. In addition, Vertica was purpose built with a hybrid in-memory/on-disk architecture to ensure near-real-time availability of information. In-memory and on-disk locations are automatically queried during an analytic operation, and return a single result to the requestor.
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.
Vertica Advanced Analytics Products and Services
The Real Stars of DreamWorks Animation Kung Fu Panda 3
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.
Read More
How Vertica is Helping Financial Services Institutions Take on Big Data - and Win
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.
Read the ReportGo "Under the Hood" of the HPE Big Data Platform
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.
Watch Now
Get the Vertica Community Edition for Free!
Gain access to all the features and functionality of HPE Vertica (no cost and no time limit). Manage and analyze up to 1 TB of data across three nodes for an unlimited time. Join the MyVertica community and access downloads, documentation, FAQs, user forums, and other helpful resources.
Start Your Free TrialRide the IoT Wave
Forecasts predict the global Internet of Things (IoT) market will grow to $1.7 trillion and IoT data will account for 10% of world data by 2020. Discover new solutions that will help you effectively and securely collect, process, and analyze the coming wave of IoT data.
Read the News
Case Studies
IT Consulting
How to Get Personal, Using Big Data
Norjimm LLC helps their clients decide how to best manage their data. The data often has many sources of streaming and real-time feeds. "We help customers understand that Big Data is a moving target, and with Vertica we have solutions to that problem."
Read the Case StudyReal-Time Data
Improving Global Biodiversity with HP Vertica and Conservation International
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."
Read the Case StudyData Analysis
BlaBlaCar Drives the Sharing Economy
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.
Watch Now
Supercell Adopts HP Vertica Analytics Platform
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.
Read MoreScalable Platform
Cardlytics serves up success with HP Vertica
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.
Read the Case StudyOptimize Processes
HP Vertica helps to optimize health information solutions
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.
Read the Case StudyData Warehousing
China PnR Builds Scalable, Real-time Data Warehouse Analytics Platform
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.
Read Now
The Future of BI as a Service with GoodData and HP Vertica
This interview highlights how GoodData expands the realms and possibilities for delivering business intelligence (BI) and data warehousing as a service using HP Vertica. Learn how they're exploring new technologies across more data types for more types of users -- all in the cloud.
Read the TranscriptResources
Related Products and Services
Engage with the Big Data Community
Join the conversation about Big Data, information governance, data protection and digital marketing.
- Key Features
- Screen Shots
- Details
- Demos
- Videos
- Case Studies
- Try Now
- Resources
- Community
- Top
Have a question?