Vertica Blog

Vertica Blog


OpenText Welcomes Micro Focus Customers, Partners, and Employees

OpenText CEO and CTO Mark Barrenechea blogs on how the Micro Focus acquisition expands OpenText's mission to help enterprise professionals secure their operations, gain more insight into their information, and better manage an increasingly hybrid and complex digital fabric. Read his article here.
SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...

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

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

Cloud Without Compromises

Most organizations are spinning up new analytical workloads and the big industry pundits all say they should move them to the cloud. Whether your workload requirement is for business intelligence, machine learning, or both, the cloud is the place to do it. But a lot of analytical databases on the cloud are giant black boxes....

New O’Reilly Book: Accelerate Machine Learning with a Unified Analytics Architecture

Every company I’ve ever encountered needs business intelligence (BI). Increasingly, in multiple industries, more and more also need machine learning (ML) or artificial intelligence (AI) to stay competitive or gain an edge. Eventually, it should be as easy for an organization to put an ML model to work as it is to put a new...

Embed analytics in applications to transform your technology business

At AWS re:Invent in Las Vegas, I’ve had several conversations with developers who’ve stopped by the booth. One of the questions I’ve asked them all is, “Are you embedding analytics into your application?”

Don’t take your foot off the electrons

With blazingly fast query performance, and access to 700 in-database functions, Vertica has meant that Jaguar Race Engineers and Strategists have been able to glean important insights into the data and make critical performance adjustments to the powertrain, suspension, steering, braking and power management that were just not possible prior to the introduction of Vertica.

It’s Time to Start Adding Intelligence to the Business of Financial Services

Banking and Financial Services executives need to convert the embarrassingly rich amount of data at their disposal into real time insights, for improving the customer experience and maximizing operational efficacy. Yet many business analysts and data scientists in financial services struggle with data silos, outdated infrastructure, and operationalizing artificial intelligence and machine learning. Join Jerry...

Judging at the International Customer Experience Awards 2021

The International Customer Experience Awards (ICXA®) celebrates the incredible work done by Customer Experience (CX) professionals all over the world. Awards International – the world’s premier awards event organization with offices in the UK, United Arab Emirates, and Serbia – has been leading the charge on CX since they founded the first event of this...

Announcing Vertica Version 11

Vertica Unified Analytics Platform version 11 delivers GA support for Docker containers and Kubernetes, advanced machine learning and time series capabilities, and increased analytical performance.

Vertica and Grafana – A New Partnership

You asked and we heard you big time!!! We are very excited to announce our official partnership with Grafana  and the launch of the signed Vertica Grafana Plugin. Grafana is an open-source analytics tool that enables you to visualize and query data in real-time. Its informative dashboards allow you to view data from different sources....