Vertica Blog

Vertica Blog

Analytics

Taking data analytics to the next level

Vertica 10 SP1 Takes Data Analytics to the Next Level

Kevin Xu, Information Developer
September 21, 2020

The first service pack for Vertica 10 brings even more incredible new features to the most flexible and scalable data analytics warehouse on the market.

Constellation Research Report Finds Vertica 10 a Leading Choice

Mike Perrow, Senior Product Marketing Writer/Editor
September 14, 2020

A few pages into a new, detailed overview of Vertica 10, produced by Constellation Research, principle analyst Doug Henschen summarizes the top new capabilities of Vertica 10 like this: In short, the Vertica team has steadily evolved the product to keep pace with the demands of organizations that seek to do the following: Unify diverse...
Return on Investment ROI

What’s the Deal with Vertica TCO?

Paige Roberts, Vertica Open Source Relations Manager
August 26, 2020

Recently, a colleague of mine was trying to express why Vertica had such a low total cost of ownership (TCO). It’s not obvious. Our customers rave about the fast return on investment. We have a half dozen excellent case studies from third-parties showing Vertica’s ROI. But why? Open source options are free. Vertica isn’t free....

Take Nothing but Memories. Leave Nothing but Footprints

Mark Whalley, Manager, Vertica Education
August 25, 2020

For those who have read my previous blog postings, attended one of our Big Data & Machine Learning Meetups, or have met me at one of the many trade shows or conferences over the years, you will be all too aware of my love for tracking aircraft using a Raspberry Pi, Kafka and Vertica. For...

Vertica outperforms Redshift and Snowflake in third-party benchmark study

Mike Perrow, Senior Product Marketing Writer/Editor
August 7, 2020

Vertica proven to be faster, more affordable, and more scalable in terms of concurrency in third-party benchmark over Amazon Redshift and Snowflake Choosing a cloud-based big data analytics platform for your organization’s analytical needs is seldom an easy task, and it can’t be the first step on your big data journey. Earlier steps should include...
unified analytics warehouse graphic

The Unified Analytics Warehouse Reaches your Data, Wherever it Lives

Joy King, VP Product & GTM Strategy, Vertica
July 23, 2020

You may have noticed something interesting about the next generation enterprise data warehouse (EDW) vendors. They’re all pushing to ensure all data moves to the same place for analytics purposes, which of course means their particular data store. This is very worrisome to me because it involves two levels of lock in: 1) underlying infrastructure...
The Earth

“awk” sed Grep, “whoami?”. Time CC if bash makes head or tail and sort > plain.txt and make us API

Mark Whalley, Manager, Vertica Education
July 13, 2020

Things to do whilst confined to barracks due to COVID-19 For those who know me well, having worked in IT for four decades, will know that I can be a bit of a Luddite when it comes to new-fangled technology. Give me a character-based, green-screen PuTTY application over any pointy-clicky interface.  Let me use vsql...
Unified Data Analytics Warehouse

How can you get the value out of Hadoop that you were promised?

Mike Perrow, Senior Product Marketing Writer/Editor
June 29, 2020

Since Hadoop’s initial release 14 years ago, untold volumes of data have been stored in HDFS (Hadoop Distributed File System). Spread across a virtual landscape of data-inspired organizations, those data lakes are wide, and deep. Companies have made tremendous investments in Hadoop over the years, and data continues to pour into their data lakes. You...
Analytics human interest stories

Making a Difference with Analytics – Inspiring Human Interest Stories

Joy King, VP Product & GTM Strategy, Vertica
June 18, 2020

I wake up before the sun rises, head to my home office, parse through the emails that have flowed in overnight, and look at my calendar to prepare for my day. I fill daylight hours with meetings, research, more meetings, writing … and more meetings. Sometimes, it is exhausting and even a little overwhelming. So,...

Award Winning – Vertica Proves It

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
June 12, 2020

June has been quite a month of industry recognition for Vertica and its customers. Fresh off earning top leadership position in GigaOm’s Radar Report for Evaluating Data Warehouse Platforms, Vertica has once again been named to this year’s DBTA 100 Companies that Matter Most in Data, a special list that salutes today’s top companies in...

Delivering BI at Cloud Scale in Record Time with Smart Database Management

Maura McGinnis
June 1, 2020

The complexities of cloud-based data at scale led Domo to use Vertica both to help power their flagship product and to glean metadata to tune and optimize their ecosystem. Their internal system, called “Domo4Domo,” uses a rules-based AI engine, with elements of machine learning, to identify and eliminate conditions that cause poor performance. By achieving...
Visual Storytelling

VSQL, Visual Storytelling through Query Language

Moshe Goldberg, Vertica System Engineer
May 21, 2020

This tip expands on my earlier post: “Pure Vertica SQL Graph Flavors” Visual story telling has not just the ability to capture attention, it make things simple to understand. Consider the following to boost your query result set readability. What is the visual correlation between CPU utilization and Canary Queries elapsed time?      ...