Software // Information Management
News
5/21/2008
06:30 PM
50%
50%

Reinvent The Data Warehouse With Column-Store Databases And Appliances

These approaches beat out conventional databases in price and performance. Here's how to find products that fit with your company's data analysis needs.

PERFORMANCE IN A BOX

What most data warehouse appliances have in common, whether built on row- or column-store databases, is a massively parallel processing, shared-nothing architecture. MPP means that the query load is spread across many processors, or nodes, usually on commodity hardware running Linux. Shared nothing means that each node is independent, with its own memory and storage. The result is high performance without the expense of the high-powered, symmetric multiprocessor servers that typically run conventional data warehouses.

Appliances also are gaining ground because they're easier to deploy and maintain than conventional warehouses, which have to be tuned, optimized, and, lately, clustered to perform in large-scale deployments. Trading on this appeal, column-store database vendors, including ParAccel, Sybase, and Vertica, have introduced software-hardware bundles built on third-party hardware.

In the case of Teradata, which was the first to bundle hardware and software in an MPP, shared-nothing architecture (without calling it an appliance), the upstarts are competing primarily on price. Teradata responded last month with its own appliances--one for data marts and one for small warehouses--while also upgrading the performance and scalability of its core EDW product.

Previous
3 of 4
Next
Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest, Dec. 9, 2014
Apps will make or break the tablet as a work device, but don't shortchange critical factors related to hardware, security, peripherals, and integration.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of December 7, 2014. Be here for the show and for the incredible Friday Afternoon Conversation that runs beside the program!
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.