Your browser is not supported

For the best experience, use Google Chrome or Mozilla Firefox.

Big Bank, Big Data

Vertica enables large financial institution to better manage risk, reduce fraud, and enhance compliance

Outcomes

+ Accelerated risk analysis supports faster business decisions
+ Faster fraud detection protects bank customers, bank brand
+ Enables regulatory compliance despite fast-growing, fast-changing regulatory requirements

500x

Queries 500x faster

25%

Hardware footprint 25% the size of other solutions

Challenge

The bank’s decision to deploy Vertica software began around three years ago when it began consolidating its RISC platform reporting solutions. Krolnik, who had worked with Vertica previously, was tapped to head up the initiative; he oversaw an evaluation of six big data analytics solutions.

A Quarter of the Hardware – without Compromising Performance.

“We performed around 100 tests, from batch uploads to different types of analytics queries, on both our hardware and the vendors,’” Krolnik recalls.

Vertica emerged as the clear favorite.

First, the SQL analytics solution’s well-known query speed meant analysts could get results 500 times faster on their standard SQL or Oracle databases.

Cost-effectiveness was another benefit. “Vertica could run on 25% of the hardware footprint of the other solutions,” Krolnik says. The Vertica licensing framework also let the bank align the solution to its capacity needs. “Vertica doesn’t require a minimum buy of 100 terabytes, like other vendors.”

Krolnik’s team liked Vertica software’s development tools, which were compatible with an agile development approach. And finally, the bank was considering Hadoop, and Vertica is easily integrated with a Hadoop data repository.

Details

About Big Bank, Big Data

In the aftermath of the 2008 global financial crisis, banks woke to a new reality – one where big data is a business-critical priority. Banks were newly sensitized to risk, and more resolved than ever to avoid it. Regulatory scrutiny was heightened as governments tightened their oversight of marquee financial institutions.

Solution

Lightning-Fast Queries on Billons of Rows of Data

For a couple of years after the bank purchased Vertica, Krolnik worked on other IT projects. Then the bank decided to implement Hadoop, and he was recruited to lead the new project. So after a clean-up period, Krolnik’s team stood up Hadoop and migrated Vertica onto new hardware.

Along the way, the team also expanded the Vertica license from a single Terabyte to 70 – an expansion needed to support the bank’s increasingly demanding big data analytics needs. “Our analysts are querying billions of rows of data,” Krolnik says. “With Vertica, they can model extremely complex scenarios in minutes.”

Results

Reduced business risk, improved fraud detection and enhanced regulatory compliance – on an accelerated timeframe. “When you run a query in Vertica software, it’s going to be lightning fast,” Krolnik concludes. “It’s performance you wouldn’t think is possible.”

Related Stories

release-rel-2022-6-2-7617 | Wed Jun 22 16:06:53 PDT 2022
7617
release/rel-2022-6-2-7617
Wed Jun 22 16:06:53 PDT 2022
AWS