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.