A number of Oracle partners are unleashing at OracleWorld products and services to speed Oracle databases.
Oracle Corp. partners including InfoCyclone, XIOTech Corp. and SofTrek are unleashing a torrent of products and services to speed Oracle databases, whether youre talking query speeds, technology to hasten cluster rollouts or outsourcing to quickly get Oracle work out of your hair.
Israel-based InfoCyclone will launch the latest version of its self-named database acceleration appliance on Tuesday at OracleWorld in San Francisco. This gadget sits between the application and database servers in a three-tier architecture and between the database client and database server in a client/server setup.
From there, InfoCyclone scrutinizes incoming queries to determine what should be sent to the production database and what can be handled by the appliance. The device sniffs Oracle log files to seek out so-called hot spots in the database, working off the adage that 90 percent of database queries use only 10 percent of the available data. It sends along transactional queries to the database, but it handles read queries itself by processing them on memory within the appliance.
That clears a lot of traffic off the database. InfoCyclone has other features that speed data retrieval, including partial replication, proprietary SQL engine algorithms, the ability to select the quickest path to data, automatic response to changed usage patterns, and the indexing of replicated data.
According to officials, those technologies augment data retrieval speeds by 10 times or more, with some clients experiencing 30 to 60 times faster query response times.
Jeff Cordeiro, CTO and CIO of Blue Dolphin Groupa dot-com that sells subscriptions to more than 1,000 magazinesstarted using the appliance about four months ago. Hes using it to speed reporting on online e-mail campaigns. Companies like his need up-to-the-hour information on how an e-mail campaign is doing vis-à-vis data points such as traffic spikes and the ways in which visitors are using the site. With a need to know within 2 hours how a campaign is doing, 10- to 30-minute or longer response times for queries were unacceptable.
The use of InfoCyclone is in fact cutting response time by orders of magnitude, he said. "The queries are all much better than what we were getting," said Cordeiro, in Sudbury, Mass., with some queries hitting response times that are up to 50 times faster than pre-appliance times.
New features revolve around manageability. A new management tool gives DBAs the ability to monitor not only queries handled by InfoCyclone but also those passed along to the database. This allows users to flag hot spots that are choking up the production database, executives said.
The new version will also automatically learn as new queries are written, according to Cordeiro, who has been working with InfoCyclone on the update. This capability will enable the appliance to build queries directly within the device, instead of going through the work of running a query against the database.
InfoCyclone is shipping now. It runs on a Linux operating system. The entry-level device contains 4GB and two CPUs and starts at about $50,000. A 16GB, four-CPU device starts at about $149,000.
Next page: XIOtech Slashes Linux Server Configuration.
Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.