Vertica Blog

Vertica Blog

machine learning

House diagram showing sensors for lights, weather, security, internal temp, etc.

The Internet of Things (IoT) and Smart Metering

Joy King, VP, Vertica Product Management & Product Marketing
July 17, 2018

Every month, my husband receives a driver’s report from Chevrolet, providing him with “feedback” on his driving behavior – everything from the intensity of his braking to the number of lane changes without a blinker to the distance and speed he drove in his Silverado truck. The report also provides specific details on the upcoming...

Announcing Vertica in Eon Mode for Amazon Linux 2, now available in AWS Marketplace

Sarah Lemaire, Manager, Vertica Documentation
June 28, 2018

Vertica is a blazingly fast SQL analytics database, enabling enterprises to access and derive meaningful insight into big data in sub-seconds or minutes rather than hours or days. Vertica powers the world’s most data driven organizations, delivering unmatched speed and scale with the full suite of advanced analytics and in database machine learning. Vertica for...

Introducing the Vertica ML-Python Library

Soniya Shah, Information Developer
June 21, 2018

This blog post was authored by Soniya Shah. One of the coolest things about working at Vertica is our amazing intern program, which often leads to full-time hires. Last year, the Vertica-ML-Python library, also known as vpython, was started as an internship project by Badr Ouali. A year later, he works for Vertica full time...

How to Code Vertica UDx

Soniya Shah, Information Developer
June 12, 2018

This blog post was authored by Ding-Qiang Liu. In analytic businesses supported by Vertica, complex processing logic is sometimes unavoidable. Using ANSI SQL might cause query strings to be much longer, and will slow the query with a huge volume data to query. If using Vertica SDKs, you can encapsulate that general computing logic in...

Make data analysis easier with dimensionality reduction

Soniya Shah, Information Developer
June 5, 2018

This blog post was authored by Anh Le. Introduction As the number of features in your data set grows, it becomes harder to work with. Visualizing 2D or 3D data is straightforward, but for higher dimensions you can only select a subset of two or three features to plot at a time, or turn to...

Machine Learning Key Terms

Soniya Shah, Information Developer
June 4, 2018

This blog post was authored by Soniya Shah. Machine learning seems to be everywhere these days – in the online recommendations you get on Netflix, the self-driving cars that hyped in the media, and in serious cases, like fraud detection. Data is a huge part of machine learning, and so are the key terms. Unless...
Programmer

What’s New in Vertica 9.1: Python SDK Expands

Soniya Shah, Information Developer
May 30, 2018

This blog post was authored by Monica Cellio. Using the Vertica SDK, you can write several types of user-defined extensions (UDxs) to add your own customizations. In a previous release the SDK added Python support for one type, scalar functions (UDSFs). In 9.1 we added Python support for transform functions (UDTFs). User-Defined Transform Functions (UDTFs)...

Vertica in Eon Mode: Revive

Soniya Shah, Information Developer
May 23, 2018

This blog post was authored by Soniya Shah. Overview An Eon Mode database keeps an updated version of its data and metadata in a communal storage location. After you shut down the database, the data continues to reside in communal storage. When you are ready to use the storage again, you can revive the database...

What’s New in Vertica 9.1: Precision-Recall Curve and F1-Score Machine Learning Evaluation Functions

Soniya Shah, Information Developer
May 14, 2018

This blog post was authored by Ginger Ni. The precision-recall curve is a measure for evaluating binary classifiers. It is a basic measure derived from the confusion matrix. In Vertica 9.1, we provide a new machine learning evaluation function PRC() for calculating precision and recall values from the results of binary classifiers. Along with the...

Unlock Data Analytics for Dynamic Workloads with Vertica 9.1

Soniya Shah, Information Developer
May 10, 2018

This blog post was authored by Sanjay Baronia. Today, cloud infrastructure has made it easier for organizations to consume services and deploy business applications with a pay-as-you-go, OPEX model. This provides a number of incentives to move data to the cloud, especially for variable workloads and use cases that require heavy compute for finite periods...

How do you use Vertica analytics and machine learning today?

Soniya Shah, Information Developer
May 4, 2018

One of the coolest aspects of Vertica is its in-database machine learning functionality. As part of our third round of product management surveys, we're asking you to take the time to answer how you use Vertica analytics today. We're hoping to get answers we can use to expand upon our growing analytics and machine learning...

What’s New in Vertica 9.1?

Soniya Shah, Information Developer
April 30, 2018

This blog post was authored by Soniya Shah. In Vertica 9.1 we introduce new functionality including: • Eon Mode, now available in production environments • Machine Learning Enhancements • Management Console Updates • Voltage SecureData Integration • Python UDTF • AWS Licensing Updates • Security Updates • Upgrade and Installation Changes • S3 Session Parameter...