Vertica Blog

Vertica Blog

Advanced Analytics

Break the bias – and predict brake bias

The theme for this year’s International Women’s Day (IWD) was given the name #BreakTheBias to get us to imagine a gender equal world. A world free of bias, stereotypes, and discrimination, a world that is diverse, equitable, and inclusive, where difference is valued and celebrated. Together, we can protect women’s equality. At Micro Focus, as...

Unleash the Power of Vertica and Apache Spark Using the Upgraded Spark Connector

This post is authored by Alex Le What is Apache Spark? Apache Spark is a distributed compute engine that provides a robust API for data science, machine learning, or to work with big data. It is fast, scalable, simple, and supports multiple languages, including Python, SQL, Scala, Java, and R. Backed by the Apache 2.0...

Vertica Grafana Plugin just got an Upgrade!

A new version of the Vertica Grafana Plugin is now available. You can download it from the Vertica GitHub page or the Grafana website. With many of our customers using the Vertica Grafana plugin, addition of the new Vertica Performance Dashboard makes it easy to visualize metrics. You can now create dashboards, quickly import it...
A key with Anomaly Description written on it

Detect Outliers Using Isolation Forest

The Isolation Forest (IForest) algorithm is a powerful and scalable algorithm for identifying outliers in your data. It uses a unique approach which focuses directly on characterizing outliers instead of normal data points. Specifically, IForest focuses on the two quantitative properties of outliers: they are few and different. A scalable implementation of the Isolation Forest algorithm is available...

Announcing our Integration with Chata

We’re thrilled to announce our new integration with AutoQL, a natural language interface to database system (NLIDB) by Chata. You can now use this conversational AI solution to ask questions, get insights, and analyse your data in Vertica. This exploration covers the implementation process, deployment options, how to connect to Vertica, and use the AutoQL...

When the typewriter is broken: Vertica’s Event-Based Windows to the rescue

Those of you who read my blog post “Take nothing but memories. Leave nothing but footprints” may recall my passion for using Raspberry Pi computers to capture IoT data from aeroplane transponders and GPS satellites, then feeding that streaming data into Apache Kafka and to integrate it with Vertica and perform near real-time analytics and...

What’s needed for a happy software dev team in data analytics?

For an organization to excel at data analytics, the IT team needs to coordinate a number of different disciplines and personnel with experience in those disciplines. This usually includes data analysts, data engineers, and, increasingly, data scientists. The data engineering discipline is sometimes thought of as the plumbing that, like pipes in a house, delivers...

VerticaPy Unify 2022 Sessions

Vertica Unify 2022 is a great time to learn about Vertica, its new features, and best practices. To complement the many great presentations at Vertica Unify 2022 both in Boston and Paris, I’m very excited to present two sessions: one on VerticaPy best practices, and another general session on VerticaPy and its features. VerticaPy is...

No need to extract data from your database to do your analytics!

While taking a long-awaited, and, IMHO some well-deserved R&R in the sun, I heard that ping notification coming from my backpack, and not being one who can ignore such things, reached for my iPad. With my OOTO email response already set, I should be able to ignore most incoming messages, texts and otherwise, safe in...
Vertica Version 12

Announcing Vertica Version 12

Vertica is pleased to announce version 12 of our unified analytics platform. Since the introduction of Vertica version 11 around June last year, several releases have gone out. Our release cycle has become more continuous, and the Vertica engineering team packs a lot of capabilities into every release. What this means is that a LOT...

Vertica Wins the Gold in Bloor Market Update

Know Your Options for Analytical Databases and Data Warehouses For CDOs and CIOs, there have never been more options to choose from when deciding where to run their analytical workloads. Analytical databases and data warehouses are two popular options – with the data warehouse market experiencing 10% annual growth and many new entrants* – particularly...

Vertica for Time Series Analytics and IoT

When you want to make a prediction – stocking levels for items in your store, predicting energy usage so supply is ready, or being proactive about equipment failures – those predictions often rely on time-series data, a series of data points measuring the same signal or process through time. By analyzing that data, companies can...