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 email@example.com or subscribe to Eric's RSS feed .
Read more about Business Intelligence/Analytics in Computerworld's Business Intelligence/Analytics Topic Center.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- The value of smarter oil and gas fields With global energy requirements continuing to rise, the exploration, development and production of new oil and gas resources are shifting to increasingly challenging...
- Smarter Environmental Analytics Solutions: Offshore Oil and Gas Installations Example This IBM Redbooks® Solution Guide describes a solution for implementing smarter environmental monitoring and analytics for oil and gas industries. The solution implements...
- Piecing Together the Business Intelligence Puzzle Business intelligence (BI) technology collects and analyzes company data, delivering relevant information to corporate decision-makers in an effort to produce favorable outcomes.
- Harness IT -- An Introduction to Business Intelligence Solutions Learn the key selection criteria required to provide your organization with the capability to address structured data, unstructured data and mobile demands so...
- Live Webcast Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing...
- The Software-Defined Data Center: Is your ADC ready? Data center transformation is accelerating beyond virtualization to next-generation cloud architectures and software-defined data centers, bringing new challenges for application performance, scalability and...
- Application Acceleration: Optimize the End-User Experience Watch this on-demand webcast and learn how you can optimize your web content, accelerate performance across any device and browser combination, and offload... All Business Intelligence/Analytics White Papers | Webcasts