ParAccel to speed up data appliance with flash memory
Move will boost read speeds by up to 15 times
Computerworld - ParAccel Inc. will release a version of its columnar database appliance with flash memory attached to the server's motherboard that it says will boost data reading speeds by up to 15 times.
The flash memory cards will be connected to the CPUs of the ParAccel Scalable Analytic Appliance II via a PCI Express (PCIe) interface. That is much faster than using flash memory in the form of solid-state drives (SSDs) connected via the speediest hard-disk interfaces, said Barry Zane, the company's CTO.
The flash cards will be supplied by "the biggest name in enterprise flash," said Zane. That is likely Fusion-io, the flash storage startup that has Apple co-founder Steve Wozniak as chief scientist and is widely considered the leader in high-performance flash storage.
The flash-enabled SAA II will be officially available this quarter, but some ParAccel customers are already trying it out, Zane said. ParAccel already offers SAA II customers the option to use flash storage arrays from EMC Corp.
ParAccel apparently jumps ahead of the pack of data warehousing upstarts, which include Greenplum Inc., Netezza Inc., Aster Data Inc., and others. Two established players have preceded it, however.
Teradata Inc. announced the Extreme Performance Appliance 4555 that uses flash-based SSDs last October and plans to release it the first half of this year.
Zane argued that ParAccel's configuration -- which uses 640 GB of flash per server appliance -- beats Oracle for data warehousing.
"The amount of flash they are using per server is significantly lower than ours," Zane said. "That makes wonderful sense for OLTP (transactional) databases, where you can keep things like heads of indices or small recently-used tables, but it doesn't make sense for data warehouses where you're analyzing huge swathes of data."
Teradata's use of SSDs, meanwhile, will likely lead to the problem of "disk controllers not designed for high-speed flash constraining your I/O rate," he said.
Zane grants that flash memory remains too expensive per-byte for many customers. But for those needing high performance, flash is nearly equal to regular disk drives on a price-per-MB-transferred-second basis.
He argues also that ParAccel's design -- which includes heavy compression and excludes indices, materialized views and projections -- means that its databases take up much less space than rivals.
"Other databases where the storage is bloated out are going to have more trouble leveraging flash in a cost-effective way," he said.
Eric Lai covers Windows and Linux, desktop applications, databases and business intelligence for Computerworld. Follow Eric on Twitter at @ericylai, send e-mail to firstname.lastname@example.org or subscribe to Eric's RSS feed .
Read more about Business Intelligence/Analytics in Computerworld's Business Intelligence/Analytics Topic Center.
- Big Data, Big Mess: Sound Risk Intelligence Through Complete Context This paper examines the insecurity of the small businesses in the supply chain and offers tips to close those backdoors into the enterprise.
- CIOs strive to harness Big Data while keeping an eye on the bottom line Read this whitepaper to learn how Red Hat Storage Server allows CIOs to confidently support business growth, manage cost and risk, capitalize on...
- Enterprise architects challenged to manage data explosion Read this whitepaper to find out how Red Hat Storage Server can allow enterprises to quickly and confidently deliver business applications that minimize...
- Software Asset Management: Ensuring Today's Assets Today's trends like BYOD and SaaS are new and exciting in terms of how they will help make our jobs more productive but...
- Live Webcast Charting Your Analytical Future - "Making predictive analytics part of your business processes" Webinar This session will show how predictive analytics can be used throughout the organization by anyone looking for answers and how organizations can make...
- Charting Your Analytical Future - "Making predictive analytics part of your business processes" Webinar This session will show how predictive analytics can be used throughout the organization by anyone looking for answers and how organizations can make...
- Capturing Data in Motion: Delivering Real-Time Insight from Data Streams This webcast will help organizations of all types and sizes learn about a technology and business strategy for tapping into the wealth of... All Business Intelligence/Analytics White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!