Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

RESOURCE PORTALS
View all Portals

WEB SEMINARS
Scheduled Events

RESEARCH VAULT
White Paper Library
Research Papers

CAREERZONE
View Job Listings
Post a job

Advertisement

INFORMATION CENTER
DM Review Home
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

GENERAL RESOURCES
Bookstore
Buyer's Guide
Glossary
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

DM REVIEW
About Us
Press Releases
Awards
Advertising/Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

IRI and RightOrder Partner to Speed Oracle ETL and Queries

    Online News published in DMReview.com
July 13, 2005

Innovative Routines International (IRI), Inc. ("The CoSORT Company"), the pioneer in high-volume data sorting and ETL acceleration software for open systems, and RightOrder, Inc., a premier provider of infrastructure software that improves the performance, scalability and flexibility of business-critical applications by orders of magnitude, announced the formation of a technical and marketing alliance. The partnership is designed to help each company strengthen their roles in the data warehouse ETL and business intelligence/data warehouse applications markets through concept sharing and customer referrals.

IRI's high-performance file sorting software, CoSORT, has long been associated with the direct acceleration of bulk loads and the indirect acceleration of queries. According to IRI Senior Development Engineer, Amrita Thakur, "pre-sorting bypasses the database's (slower) indexing method and reduces overhead and temporary storage space required during the load. Pre-CoSORTed loads through Oracle's SQL*Loader and other RDBMS bulk load utilities have been up to 10 times faster than unsorted loads. CoSORT's ability to quickly sort and load multiple tables in different index orders led to IBM's record-setting TPC-H (decision support) benchmark for loads and queries (at the 300GB scale factor) in 2000."

RightOrder's QueryEdge software directly improves the performance of large, complex Oracle queries - by up to hundreds of times faster. Because it is seamlessly integrated into the database architecture (through Oracle's Data Cartridge Interface), QueryEdge requires no changes to the application or schema, nor any data duplication or caching. Its non-intrusive, no-risk deployment allows DBAs and ETL architects to easily determine the extent of query speed improvements. "Just as CoSORT does during load jobs, QueryEdge reduces the requirements of system resources during query jobs (disk I/O, CPU time, memory and storage), increasing scalability by freeing system resources for other applications," said IRI VP of Business Development, David Friedland. "Together, we will provide data warehouse customers a comprehensive, end-to-end solution."

"By combining CoSORT and QueryEdge, both sides of the database load and query continuum are dramatically accelerated," observed RightOrder's Vice President of Product Development, Jeff Byard. "Both companies' products fit seamlessly into existing Oracle environments - from high-volume ETL and reorg operations to complex, multi-table-join queries."

For example, with CoSORT's FAst extraCT (FACT) software for Oracle, a data warehouse architect can pipe multi-gigabyte tables directly into CoSORT SortCL scripts that can produce many sorted load and report targets at once. One or more of these (file or pipe) outputs can be inputs to SQL*Loader. Once in the tables, Oracle's cost-based SQL optimizer (CBO) can direct QueryEdge to perform the most complex queries on the tables. Both companies have developed a confidential-level of understanding of each other's technologies and will refer users to the joint solutions.
...............................................................................

For more information on related topics visit the following related portals...
ETL.

This piece has been brought to you by the DM Review Editorial staff.

Solutions Marketplace
Provided by IndustryBrains

Design Databases with ER/Studio: Free Trial
ER/Studio delivers next-generation data modeling. Multiple, distinct physical models based on a single logical model give you the tools you need to manage complex database environments and critical metadata in an intuitive user interface.

Verify Data at the Point of Collection: Free Trial
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.

Free EII Buyer's Guide
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.

Data Mining: Levels I, II & III
Learn how experts build and deploy predictive models by attending The Modeling Agency's vendor-neutral courses. Leverage valuable information hidden within your data through predictive analytics. Click through to view upcoming events.

Click here to advertise in this space


E-mail This Online News E-Mail This Online News
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Advertisement
advertisement
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.