The drug market-analysis team at Wolters Kluwer Health used to turn away customers every month. It wasn’t because they didn’t have enough staff to handle every data request from customers in the pharmaceutical industry. The problem was that their Oracle-based data warehouse couldn’t handle all the requests quickly enough.

“Because of the processing times to perform the queries in Oracle, we were literally capacity-bound in terms of . . . the amount of work we were able to get out of the door in a month,” says Emory Heisler, vice president of global IT services for the Wolters Kluwer healthcare analytics team in Phoenix. “We had to turn work away.”

This changed about a year ago when the healthcare analytics division switched a portion of its data warehousing from Oracle to Netezza.

Netezza offers a data warehouse appliance that bundles hardware, software and storage capacity in one prepackaged unit. Complex data-analysis queries that used to take days now take minutes, Heisler says.

Netezza says the unique aspect of its system is the placement of processing power right next to the data storage, which eliminates the need to shuttle records sets back and forth between storage systems and processors.

Wolters Kluwer’s healthcare analytics team, which provides drug-utilization data to companies like Pfizer and GlaxoSmithKline, now stores 9T bytes of data on a Netezza system, and about 40T bytes on an Oracle system. The division continues to use Oracle for queries that are not particularly time-sensitive, but Heisler says productivity has increased 25% in the portion of the company that is using Netezza. In addition, the company has saved money because the Netezza database doesn't require as much internal staff to maintain, he says. For users, the simplicity of the data warehouse appliance is “eye-popping,” he adds.

Netezza claims its product lets data queries be performed 10 to 100 times faster than systems like the one made by Oracle. In some cases, this is true, says analyst Richard Winter, president of research and consulting firm Winter Corp. in Waltham, Mass. But Oracle’s data warehousing product is more mature and better able to handle the most complex database structures, says Winter, who has consulted for both Oracle and Netezza.

Whitepapers

• Symantec State of the Data Center Report
• Gene Kim's Practical Steps to Mitigate Virtualization Security Risks
• Monitoring and Managing App Performance
• Monitoring and Managing VoIP
• SNMP Monitoring: One Critical Component to Network Management
• SNMP Monitoring: One Critical Component to Network Management

View more DATA CENTER whitepapers

Webcasts

• Managing the End User Experience-A Real World Example of Success
• Best Practices for Deploying WAN Optimization for Disaster Recovery
• Tips and Techniques for Remote Data Backup and Delivery
• WAN Optimization Landscape
• Oracle Database 11g: Advances in Compression, Real Application Testing and Data Guard
• Solutions to the Toughest IT Challenges in Remote Offices

View more DATA CENTER webcasts

Special Reports

• Data Centers: At the center of the action
• Executive Guide: Data Center Decisions
• Get More From Your WAN
• Executive Guide: Storage Heats Up
• Network World Executive Guide: Perfecting Application Performance Management

View more DATA CENTER special reports