Vertica Blog

Vertica Blog

Analytics

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

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 Big Data Conference Registration is Open!

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...
Machine learning robot studying equations and graphs

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

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...
Analyze, Design, Develop, Implement, Evaluate cycle illustration

Evaluating Classifier Models in Vertica

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...
Blue and white targets with 3 arrows hitting bullseye on first one

Delivering personalized retail promotions using AI and predictive analytics

SO1.ai helps retailers leverage customer basket and loyalty data to deliver smart, automated promotional decisions at scale across millions of customers. The solution is fully automated and designed to fit a retailer’s specific business goals (i.e. revenues, profit optimization, customer satisfaction or brand sales). Want to learn more about the S01.ai solution?
Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

This week, some very cool things have gone into the newest version of the Vertica Analytics Platform that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do...
Machine learning robot studying equations and graphs

1 – Why Would You Do Machine Learning in a Database?

Co-authored with Paige Roberts. A lot of modern scalable analytical databases like Vertica allow you to do machine learning data analytics from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they...
Machine Learning programmer in glasses looks at graphs

Data Analytics and Machine Learning for Start-Ups on the Fast Track

Tuesday, 4/30/19 Workbar Back Bay 6:00-8:00 PM Are you a data-driven start-up that makes decisions based on insight from high-performance analytics and machine learning? Would you like to choose the best analytical tool/ML for the job beyond limited open source offerings, but don’t have the budget? Do you want to hear best practices on how...
Vertica One on One with Davin Potts, CEO Appliomics, Founder KNIME, Core Python Committer

One on One with Davin Potts: 3. Exciting News for Upcoming Python Release 3.8

At the recent Data Day Texas event, I sat down with Davin Potts and had a long conversation about a wide variety of subjects. I divided the conversation into multiple chunks by subject, and have been posting them one chunk at a time. In the first post, we discussed the wide variety of programming languages...
padlock with key on pile of chains

Data Day Texas: Keep Your Architecture Open and Avoid Mindset Lock-in

Data Day Texas is an event in Austin that was started about nine years ago by an old acquaintance of mine, Lynn Bender, who founded Global DataGeeks. The one big theme that struck me this year as running through the whole conference was the highly cooperative landscape that has developed between proprietary and open source...

Use MERGE to Update 1 Million Rows in 2 Seconds

This blog post was co-authored by Yassine Faihe, Michael Flower, and Moshe Goldberg. Updating One Million Records in Two Seconds To illustrate the true power of MERGE, this article describes how we used MERGE to demonstrate Vertica's performance at scale. SQL MERGE statements combine INSERT and UPDATE operations. They are a great way to update...

Analyze Mismatched Series with Event Series Joins

Event series occur in tables with a time column, most typically a TIMESTAMP data type. In Vertica, you perform an event series join to analyze two series in different tables when their measurement intervals don't align, such as with mismatched timestamps.