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.

About CoSORT / Innovative Routines International (IRI), Inc.
Founded in 1978 and headquartered in Melbourne, Florida, IRI develops and markets high-speed data sorting, reporting and ETL software for UNIX and Windows data centers. CoSORT tools perform and accelerate large-volume: mainframe sort and data migrations, database reorgs, data warehouses, report generation, and, third-party software applications. The CoSORT package has 18 user interfaces, all of which leverage a record-setting, parallel sort engine in a proprietary coroutine architecture. Many of these interfaces seamlessly replace slower, third-party sorts. CoSORT’s primary native interface, SortCL, can also simultaneously: select, sort/merge/join, aggregate, calculate, convert, reformat and report. IRI’s core products: CoSORT, FAst extraCT (FACT) for Oracle, and RowGen file simulator, are represented in more than 30 international offices. For additional information, visit www.cosort.com.

About RightOrder, Inc.
Founded in 1999 and headquartered in Santa Clara, California, RightOrder develops and markets infrastructure software that improves the performance, scalability and flexibility of business critical applications. RightOrder’s flagship product, QueryEdge, leverages the company’s unique, patented Index Fabric Engine technology to increase business productivity for large enterprises by improving, by orders of magnitude, the performance of query-intensive applications. Completely transparent, QueryEdge is seamlessly installed on existing systems and requires no architectural changes. It accelerates the performance of the most resource-consuming queries in BI, Data Warehouses, Enterprise Reporting, OLAP and other query-intensive, business-critical applications by reducing requirements for disk I/O, CPU time, and memory. For additional information, visit www.rightorder.com.

###

CoSORT and SortCL are trademarks of Innovative Routines International (IRI), Inc. RightOrder’s solutions, RightOrder, the RightOrder logo, QueryEdge, and Index Fabric are trademarks of RightOrder, Inc. © 2005 IRI, Inc. and RightOrder, Inc.

Editorial Contacts:
Lisa Mangino, CoSORT / IRI, Inc. 321-777-8889, ext. 224, or lisam@cosort.com.
Marilyn Callaghan, RightOrder PR Counsel, Callaghan Communications, 650-342-6087, or marilyn@callaghan.com.