Skip the navigation

NextAction taps Oracle 10g for database marketing operations

‘I like stability more than features,’ says CTO Steve Helle

By Eric Lai
May 2, 2006 12:00 PM ET

Computerworld - Some people choose databases from Oracle Corp. because of their cutting-edge features, but Steve Helle, chief technology officer at Denver area database marketing firm NextAction Corp., wanted something else.

“I like stability more than features,” said Helle. And no wonder: When Helle arrived at Westminster, Colo.-based NextAction in mid-2004, the company was plagued with near-weekly crashes of its core database, which aggregates and analyzes consumer purchasing data from more than 1,100 retailers such as Home Depot and Williams-Sonoma.

NextAction uses a custom-written extract, transform and load (ETL) tool to clean up and import the data. Unlike competing consumer databases that can aggregate only where and when a consumer goes shopping, NextAction can also tell what the consumer actually bought at each store, according to Helle.

In 2004, the company’s 13TB data warehouse was spread across five Microsoft SQL Server 2000 databases. But within a year, the fast-growing firm’s database had grown to 30TB spread across eight instances of SQL Server 2000. “My guys were working 70 to 80 hours a week,” he said. “We were dying on the vine.”

NextAction’s data warehouse was growing too fast to easily manage on SQL Server, said Helle, and it would crash so often that the process of mining data for retailers grew from three and a half days to eight days -- a major problem, since the data mining took place weekly. “That’s what really impacted revenue, the fact that it failed quite often,” Helle said.

One of the first actions Helle, a 15-year veteran of database marketing, took was to convince his boss that NextAction would need to upgrade to new hardware and a new database to handle its intensive and fast-growing data needs.

Partly because the rest of NextAction was mostly a Microsoft .Net environment, Helle tested the then-beta version of SQL Server 2005 against Oracle 10g, both of which had 64-bit versions.

Microsoft treated Helle well, putting NextAction into a special program for extremely large databases that included plenty of support. But within two weeks, the results were clear to Helle. “SQL Server has made great strides in the past couple of years. But like I told the Microsoft guys, it’s hard to match [Oracle’s] 15 years of evolution,” he said.

Not only was Oracle Enterprise Manager 10g much more stable, it was also much faster, Helle said. “We ran about 20 benchmarks. Creating applications was, on average, eight times faster on Oracle. Loading data was about 12 times faster. An updating statement that died after 1.5 days on SQL Server without completing took one hour and 10 minutes to finish on Oracle.”



Additional Resources
Forrester Consulting - Optimizing Users and Applications in a Mobile World
WHITE PAPER
Solving application issues over the WAN requires careful consideration. Based on their independent research, Forrester Consulting offers recommendations on how to tackle application performance issues, insufficient bandwidth and the inability to quickly restore users in a disaster.

Read now.

Security KnowledgeVault
WHITE PAPER
Security is not an option. This KnowledgeVault Series offers professional advice how to be proactive in the fight against cybercrimes and multi-layered security threats; how to adopt a holistic approach to protecting and managing data; and how to hire a qualified security assessor. Make security your Number 1 priority.

Read now.

Cut Communications Costs Once and for All
WHITE PAPER
New IP-based communications systems are being deployed by small and midsized businesses at a rapid rate. Learn how these organizations are enabling faster responsiveness, creating better customer experiences, speeding office or mobile interactions, and dramatically reducing existing communications costs.

Read now.

White Papers
X-Ray of the PCI Process-4 Proactive Steps
This white paper from Forrester Research Inc., helps break PCI into understandable components. Security and risk professionals will gain knowledge and insight into...
Forrester: Economic Impact of Switching to Google Apps
Content provided by Google

Read this Forrester report on the "total economic impact" of Google Apps, and learn how switching to Google Apps creates...
Intelligent Systems: Unlocking Hidden Business Value with Data
An intelligent system enables data to flow across an enterprise infrastructure, spanning the devices where valuable data is gathered from employees and customers,...
Concepts of NonStop SQL/MX
For DBAs and developers who are familiar with Oracle solutions and want to learn about NonStop SQL/MX, this whitepaper provides an overview of...
HP Advanced Information Services for SAP In-Memory Appliance (SAP HANA)
Organizations are eager to connect the vast amounts of data available within and outside their businesses to compete more effectively and make better...
Webcasts
Quantifying the Business Value of VMware View - Webcast
Many enterprises have discovered that the use of virtualization to support desktop workloads creates a range of significant benefits. These benefits include price...
Good to Great - How to Take Business Analytics to the Next Level
By attending this webcast you will learn how you can implement an effective BA strategy that will deliver maximum strategic value to your...
Supporting Mobile Productivity With A Limited IT Budget
Join us and hear from Kaseya mobile IT management experts as we discuss core strategies for supporting the mobile revolution on a shoestring...
User Experience Monitoring
In this webinar, you will learn hints & tips for improving end-user response times from Forrester Research analyst, Jean-Pierre Garbani.
Hints & Tips Cisco
Overwhelmed by tracking your Vblock, Flexpod or Cisco UCS performance? Spend one hour with Nimsoft to learn how you can eliminate the overhead...
Newsletter Sign-Up

Receive the latest news test, reviews and trends on your favorite technology topics

Choose a newsletter
  1. View all newsletters | Privacy Policy
IT Jobs