Vertica named by InfoWorld as one of 8 databases supporting in-database machine learning

A Feb. 17 article in InfoWorld names Vertica as one of eight analytical platforms that offer in-database machine learning “right where your data resides.” Authored by contributing editor and reviewer Martin Heller, the article validates two of Vertica’s long-held principles: flexibility in ML modeling and training, and the ability to analyze data without transmitting it...

Technology Partnership with Jaguar Racing to Deliver Vertica Analytics at Jaguar Speed

Jaguar Racing announced that it has partnered with Micro Focus, ahead of season seven of the ABB FIA Formula E World Championship. Joining as the team’s official digital transformation, business resiliency, and analytics partner, Micro Focus will provide support to Jaguar Racing’s push for more points, podiums, and wins on the racetrack. Vertica plays a...

DX Radio Episode 3: Climate Corporation and Digital Agriculture

I have the honor of hosting the latest episode of DX Radio. It features The Climate Corporation’s Daniel McCaffrey, Vice president of Data and Analytics, and Erich Hochmuth, Big Data Architect Engineer, as they explore the digital transformation of farming.

List the Missing Dates in a Date Series

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)

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, https://www.vertica.com/blog/vertica-quick-tip-getting-every-n-th-row-table/ What if we don’t have a key like that in our table? No problem thanks to the ROW_NUMBER() Analytic Function! Say...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Extracting Log Data into Vertica With Regex Parsing

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...
Electronic medical record on digital smart device

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

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

Explore Popular Topics

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

Prepare for Your Multicloud Future Today

You only have to read as far as the subtitle of the 2020 Flexera State of the Cloud Report 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...

Constellation Research Report Finds Vertica 10 a Leading Choice

A few pages into a new, detailed overview of Vertica 10, produced by Constellation Research, principle analyst Doug Henschen summarizes the top new capabilities of Vertica 10 like this: In short, the Vertica team has steadily evolved the product to keep pace with the demands of organizations that seek to do the following: Unify diverse...
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...
Return on Investment ROI

What’s the Deal with Vertica TCO?

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 Vertica’s ROI. But why? Open source options are free. Vertica isn’t free....

Take Nothing but Memories. Leave Nothing but Footprints

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 tracking aircraft using a Raspberry Pi, Kafka and Vertica. For...

Announcing Vertica Integration with DbSchema

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