Vertica Blog

Constellation Research Report Finds Vertica 10 a Leading Choice

Posted September 14, 2020 by Mike Perrow, Senior Product Marketing Writer/Editor

Read More

Electronic medical record on digital smart device

Vertica in Good Health: Ingesting, Securing, and Analyzing Healthcare Data

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
September 29, 2020

Electronic Medical Records and new personal healthcare technology, particularly medical devices, generate a huge amount of data. Organizations including Cerner and Philips Healthcare rely on Vertica for . How can Vertica help you analyze this data? Vertica excels at data ingest and provides hundreds of built-in SQL and analytic functions with broad integration with programming...
Taking data analytics to the next level

Vertica 10 SP1 Takes Data Analytics to the Next Level

Kevin Xu, Information Developer
September 21, 2020

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.

List the Missing Dates in a Date Series

Jim Knicely, Vertica Field Chief Technologist
October 22, 2020

The TIMESERIES clause in Vertica makes it easy to list all of the gap days (that is, those that are missing) from a series of dates. Say I have this simple date series: As you can see, there are several dates missing from the series (2020-10-30, 2020-11-02, 2020-11-03 and 2020-11-04). I can list these absent...
Compass rose with true north pointing to "Helpful Tips" text

Getting Every Nth Row from a Table (Enhanced)

Jim Knicely, Vertica Field Chief Technologist
October 20, 2020

In a previous Vertica Quick Tip we learned how to query every Nth row from a table when we had a unique ID column having sequential values (that is, from a sequence). See, What if we don’t have a key like that in our table? No problem thanks to the ROW_NUMBER() Analytic Function! Say I...

Extracting Log Data into Vertica With Regex Parsing

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
October 5, 2020

Formatted text such as system logs hold a huge amount of actionable data if you can extract and discover the content. If there is a pattern to the lines, then you can build a Vertica regex parser to extract fields and contents into Vertica for query and analysis at scale. Vertica’s regex parser uses Perl-like...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

A cloud of data points with a businessman's hand holding it up on a black background

Prepare for Your Multicloud Future Today

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
September 17, 2020

You only have to read as far as the subtitle of the to understand that more and more organizations are adopting a multi-cloud strategy – cloud spend is rising as organizations adopt multi-cloud strategies and put more workloads and data in the cloud. This ninth annual report, based on 750 global cloud decision-makers, revealed that...
Risk Analysis

How security risk is making sense to the corner office

Ken Pfeil, Chief Security Architect
September 10, 2020

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...
Return on Investment ROI

What’s the Deal with Vertica TCO?

Paige Roberts, Vertica Open Source Relations Manager
August 26, 2020

Recently, a colleague of mine was trying to express why Vertica had such a low total cost of ownership (TCO). It’s not obvious. Our customers rave about the fast return on investment. We have a half dozen excellent case studies from third-parties showing . But why? . Vertica isn’t free. Yet our TCO is lower....

Explore Popular Topics

DBadmin
SQL
Best Practices
machine learning
Advanced Analytics
VSQL
Cloud
Eon Mode
Vertica
Analytics
AWS
Time series
IoT
Partner Integrations
Security

Take Nothing but Memories. Leave Nothing but Footprints

Mark Whalley, Corporate Systems Engineer
August 25, 2020

For those who have read my previous blog postings, attended one of our Big Data & Machine Learning Meetups, or have met me at one of the many trade shows or conferences over the years, you will be all too aware of my love for . For those who are not aware, a Raspberry Pi...

Announcing Vertica Integration with DbSchema

Amrita, Information Developer
August 10, 2020

DbSchema is an intuitive GUI database designer to design, document, and manage complex databases. It provides interactive schema layouts to visually edit the schema without any SQL queries, view data from multiple tables, synchronize the schema over multiple databases, and generate random data. We are pleased to announce this integration to enable users to quickly...

Vertica outperforms competing cloud analytical platforms in third-party benchmark study

Mike Perrow, Senior Product Marketing Writer/Editor
August 7, 2020

Vertica proven to be faster, more affordable, and more scalable in terms of concurrency in third-party benchmark over Amazon Redshift and an unnamed data cloud platform Choosing a cloud-based big data analytics platform for your organization’s analytical needs is seldom an easy task, and it can’t be the first step on your big data journey....

The Unified Analytics Warehouse Reaches your Data, Wherever it Lives

Joy King, VP, Vertica Product Management & Product Marketing
July 23, 2020

You may have noticed something interesting about the next generation enterprise data warehouse (EDW) vendors. They’re all pushing to ensure all data moves to the same place for analytics purposes, which of course means their particular data store. This is very worrisome to me because it involves two levels of lock in: 1) underlying infrastructure...