Vertica Blog

Vertica Blog

Advanced Analytics

Extracting Log Data into Vertica With Regex Parsing

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
October 5, 2020

Formatted text such as system logs hold a huge amount of actionable data if you can extract and discover the content. If there is a pattern to the lines, then you can build a Vertica regex parser to extract fields and contents into Vertica for query and analysis at scale. Vertica’s regex parser uses Perl-like...
Electronic medical record on digital smart device

Vertica in Good Health: Ingesting, Securing, and Analyzing Healthcare Data

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
September 29, 2020

Electronic Medical Records and new personal healthcare technology, particularly medical devices, generate a huge amount of data. Organizations including Cerner and Philips Healthcare rely on Vertica for data analysis. How can Vertica help you analyze this data? Vertica excels at data ingest and provides hundreds of built-in SQL and analytic functions with broad integration with...
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...
Risk Analysis

How security risk is making sense to the corner office

Ken Pfeil, Chief Security Architect
September 10, 2020

As Big Data continues to get bigger, data volume is only one aspect of the expansion. Just as critical for CDOs and business leaders to get a handle on are the growing sources of data. Data sources are expanding, and becoming important as businesses look to capture data from every conceivable end-point – from IoT...

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,...

Let Business Intelligence and Data Science Coexist!

Mike Perrow, Senior Product Marketing Writer/Editor
May 11, 2020

Business intelligence and data science frequently compete for resources, and BI got there first. Vertica in Eon Mode subclusters can help them coexist.