Vertica Blog

Vertica Blog

Security

OpenText Vertica 23.3

OpenText Vertica 23.3 – the Smarter Data Lakehouse

The latest release of the Vertica analytical database, now OpenTextTM VerticaTM  includes a lot of features that Vertica customers have been eagerly awaiting like: Resharding the database as needed Rollback snapshots that capture a moment in time without a whole other data copy Workload routing so you can automate directing specific queries to just the right...
Helpful Tips in blue text with magnifying glass

Restrict Modifying Table Rows (UPDATE/DELETE) Irrespective of User Privileges

Do you have a table with critical information such as SIEM events or credit card transactions? Do you want to be able to block user access to UPDATE/DELETE rows in those tables? From version 12.0.0, you can do this by setting the tables as IMMUTABLE. This means you can only insert data and not modify...
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...
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 Unify 2021 – Day 2 keynote spotlights a noble cause

At Vertica Unify 2021, the focus this week has been on the techniques and best practices around data analytics. Naturally. There’s a lot of technology to cover in this space, and we’re delighted to have so many of the best and brightest minds in virtual attendance, helping us deliver, explain, and demonstrate these things. And,...

Taking the pulse of cloud adoption trends: The Flexera “State of the Cloud” report

Before I joined Vertica, I worked in the cloud services world, first for a reseller and then for a Cloud Services Provider (CSP). During my time in this space I followed cloud adoption trends closely by necessity, and one of my favorite sources of data on the subject was RightScale’s (now Flexera’s)  “State of the...

Vertica 10.1.1 Goes Beyond Analytics with Support for Azure Cloud, Kubernetes, and Containers

With each release of Vertica, you can always count on major enhancements and features to help you address each step of the predictive analytics process with even more analytical functions and end-to-end machine learning capabilities. While Vertica 10.1.1 includes support for the latest version of PMML, 4.4, some useful new analytical functions, and a new...
Rocket to Moon with Vertica version 10.1

Vertica 10.1 Rockets Data Analytics to the Next Level

As of February 1, 2021, the new version of Vertica rockets analytical database technology to the next level. Vertica 10.1 continues to show our commitment to broad, powerful in-database machine learning by including our most requested algorithm – XGBoost. Management Console makes administering Vertica in the cloud even easier. Support for complex data types in...
Taking data analytics to the next level

Vertica 10 SP1 Takes Data Analytics to the Next Level

The first service pack for Vertica 10 brings even more incredible new features to the most flexible and scalable data analytics warehouse on the market.
Risk Analysis

How security risk is making sense to the corner office

As Big Data continues to get bigger, data volume is only one aspect of the expansion. Just as critical for CDOs and business leaders to get a handle on are the growing sources of data. Data sources are expanding, and becoming important as businesses look to capture data from every conceivable end-point – from IoT...
Who's awesome? BDC is awesome!

Top 10 Highlights from the Virtual Vertica BDC 2020

While it was a difficult decision to take the Vertica Big Data Conference 2020 virtual, the registration numbers, session reviews, and overall feedback confirmed that this was our most successful BDC ever! If you did not have a chance to register or missed any of the sessions, no worries. All sessions were recorded and PDFs...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...