High-Speed Databases Rev Corporate Apps

New technologies for hyperperformance are speeding transaction processing and analytics.

By Gary Anthes

January 16, 2006 12:00 PM ET

Computerworld - Relational database management systems have become all but ubiquitous in enterprise computing since 1970, when they were first devised by E.F. Codd. But as powerful and flexible as those databases are, they've proved inadequate for a handful of ultrademanding applications that have to process hundreds or thousands of transactions per second and never go down. Now, the very-high-performance database technologies that sprang up to serve these niche markets, such as options trading and telephone call processing, are poised to move into mainstream computing.


Image Credit: Richard Borge

Some of the new products simply move the action from disk to memory, where access is a million times faster. Others are more radical departures from tradition, such as "streaming" technologies that store queries and pass data through them rather than run queries against stored data. Still others have found clever ways to sidestep much of the overhead -- such as table locking -- associated with the traditional RDBMS.
While some of these products do "store" data in memory-resident data-bases -- either relational or object-oriented -- the tools are primarily designed to speed transaction processing and analytics, not to act as data repositories.
Thanks for the Memory
Interact Inc., a Lincoln, Neb.-based communications service provider, has for more than 10 years used the in-memory database capabilities of Hewlett-Packard Co.'s NonStop servers to do real-time pricing of incoming telephone calls. But the big, expensive computers were overkill for some Interact customers, such as small mobile telephony resellers, says Tom Massey, director of business development.
So 18 months ago, Interact began to offer a call-pricing service that runs on Linux and Unix servers and uses Oracle Corp.'s TimesTen In-Memory database. "NonStop is big iron and more geared to larger operators," Massey says. "Linux and Unix platforms scale down much better, and operators often prefer them because they are not knowledgeable about NonStop."
Oracle acquired the TimesTen technology last June. Oracle saw the in-memory database as a way to extend its enterprise back-end data storage capabilities to high-performance real-time applications such as Interact's. Interact uses Oracle for back-end data storage as well and does not yet interface those databases with TimesTen, but Massey says he plans to do so.
"We need sub-10-millisecond response time, and you can't get that performance out of an Oracle relational database," says Ed McKee, director of applications at Interact. "To get that kind of performance, the amount of iron you'd have to have would be very significant."
On the other hand, he notes, the in-memory TimesTen product isn't suitable for large-scale data

Recommend Digg Twitter ShareThis

Email Print Send Feedback Reprints

Additional Resources

Xerox

Win a color printer!

By using solid ink technology only from Xerox, you could save up to 65% by printing color for the cost of black and white. Enter for a chance to WIN a PhaserTM 8860 network color printer!

Microsoft

Upgrade to Internet Explorer 8 today.

Save time and mitigate security risk. Deploy it now.

Sybase

NEXT-GENERATION MOBILITY PLATFORMS

In this white paper, IDC analyzes the role of next-generation mobile enterprise platforms as organizations seek a more strategic deployment of mobile solutions.

Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.

White Papers & Webcasts

Tapping the Full Potential of Sales and Marketing Data for Pharmaceuticals
As pharmaceutical manufacturers face an era of sharply reduced sales and marketing budgets, increasingly complex and restrictive regulations, and rapidly changing demand patterns...

Improving Quality of Service for Oracle Database with My Oracle Support
(Source: Oracle) Oracle's Willie Hardie and Oracle Support Expert Sean Bingham discuss how My Oracle Support optimizes the quality of support provided to...

Bloor Research: Netezza and the HP Oracle Database Machine
HP and Oracle have recently announced the HP Oracle Database Machine. This has been positioned by Oracle as a competitor to Netezza and...

Usability Is Everything
Learn what sets Workday's HR and Payroll solutions apart from the competition....

Risk Readiness and Redundancy: PCI Compliance Automation
(Source: Symantec) This paper examines compliance regulations surrounding the Payment Card Industry Data Security Standards, the challenges it puts on IT Security and...

The Value of Real SaaS at Workday
Cost savings, speed to value, and innovation brought to the enterprise by Workday's software-as-a-service solutions for HR and Payroll....

How to Populate Your CMDB in Four Steps
Generally, CMDBs populated by discovery tools alone simply aren't usable. They fail because they contain massive amounts of irrelevant information. You avoid this...

SaaS at Flextronics, Inc.
Dave Smoley, CIO of Flextronics, discusses the real value of software-as-a-service and why he chose Workday for his HR solution....

The Metrics Driven Organization: Your Business in Challenging Times
This white paper discusses how metrics increase visibility and sharpen decision making to ensure excellent customer service, rising revenue and growth....

Why Compliance Pays
This OnDemand webcast explores the relationship that firms with best compliance records have higher revenue, greater customer retention, lower financial losses from data...

All White Papers | All Webcasts