Vertica Blog

Vertica Blog

machine learning

Happy dog running in grass

Vertica Big Data Conference 2020 – Are You Excited Yet?

Joy King, VP Product & GTM Strategy, Vertica
October 25, 2019

The Vertica Big Data Conference (BDC) clock is ticking and my excitement is growing by the minute! I want to make sure that our Vertica community is up to date on the latest news, especially some of the General Session speakers and Breakout tracks. And let’s not forget one of the most special components of...
Red arrow points to silver ball with 4 red arrows pointing away representing dividing a single thing into multiple

Parallel Processing Using Partitions With Vertica UDx

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
October 17, 2019

You can add functionality to Vertica using UDx, but what if you need to process more data than can be efficiently processed in a single thread or a single node? Vertica can divide data into partitions defined with the OVER() clause and distribute computing across nodes. This partition processing is "shared-nothing" similar to the Map...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

Paige, Vertica Open Source Relations Manager
October 16, 2019

The winds of change have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon...
Vertica and Python logos stacked

Extending Vertica with Python functions: Adding NumPy FFT as a UDx

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
October 14, 2019

User-Defined Transform Function (UDTF) support for Python UDx were added back in Vertica 9.1, allowing you to add a much greater range of existing libraries and functions to Vertica. In this example, I'll add Fast Fourier Transform (FFT) from the NumPy package. FFT is a way to transform time-domain data into frequency-domain data. My test...
Clusters of points colored differently by grouping on a black background

Finding the “K” in K-means Clustering With a UDx

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
October 4, 2019

You can apply k-means clustering to partition data points into k different groups. Along with the data, the number of clusters "k" is an input to the algorithm. Common examples like the Iris data set tell you upfront how many different groups exist, so you set k=3. What if you don't know how many clusters...

Vertica Big Data Conference Registration is Open!

Ben, Senior Product Marketing Manager
September 16, 2019

We’re excited to announce that registration is live for the next Vertica Big Data Conference (BDC), held March 30 – April 2, 2020, at the Encore Boston Harbor Hotel. Don’t miss out on the early bird pricing rate of $695 (a $300 savings), along with buy 3 get 1 free group discounts!   What is...

7 Critical Capabilities for Embedded Analytics

Ben, Senior Product Marketing Manager
September 12, 2019

Software and technology vendors serving a range of industries – from security to healthcare – are increasingly turning to embedded data analytics as a way to deliver value-added services and applications to their customers...
Focused young woman working at laptop in office

The Vertica Academy Is Open for Learning

Joy King, VP Product & GTM Strategy, Vertica
September 9, 2019

One of the greatest impacts from digital transformation, both from a personal and professional point of view, is not just the democratization of data - a very popular topic here at Vertica! - but the democratization of knowledge. Today, we are excited to announce the new Vertica Academy, a platform that offers self-paced, technical training...
Machine learning robot studying equations and graphs

2 – How to Calculate a Correlation Matrix – Data Exploration for Machine Learning

Arash Jalel Zadeh Fard, Senior Software Engineer at Vertica
September 5, 2019

In the first machine learning in a database post, we discussed some of the reasons why it makes sense to do your machine learning data analytics inside the database. This will be the first post where we discuss some of the steps involved in the in-database machine learning workflow. Generally, the first thing you need...
Woman holding onto seat as high wind blows her hair and lots of data points past

Strong Winds of Change at Chief Data & Analytics Officers Event

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
August 14, 2019

Last week, Vertica sponsored the Chief Data & Analytics Officer event in Chicago. As a first-time sponsor, we were cautiously optimistic that we could meet with data and analytics leaders that were, according to event organizer IQPC, “…on the forefront of capitalizing on data and analytics in the enterprise as the volume, availability, and complexity...
Analyze, Design, Develop, Implement, Evaluate cycle illustration

Evaluating Classifier Models in Vertica

Arash Jalel Zadeh Fard, Senior Software Engineer at Vertica
August 2, 2019

Co-authored by Elizabeth Michaud Vertica provides an out-of-the box machine learning toolset that covers a complete data science workflow. The toolset includes several distributed functions for evaluating both classifier and regressor machine learning models. The goal of this blog post is to demonstrate how you can use the built-in functions for evaluating the prediction performance...
Cloud pattern in circuit board

Vertica Ranked #1 Cloud Data Warehouse

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
July 30, 2019

July has been quite an exciting month for Vertica. Our three keynote presenters are now confirmed for the Vertica Big Data Conference 2020 – Vertica founder and Turing Award winner Dr. Michael Stonebraker, kingpin of the famous MIT blackjack team Jeffrey Ma, and renowned analyst Ray Wang of Constellation Research. And, in addition to receiving...