Melbourne, Florida-based IRI specializes in the development of industrial strength ETL and data sorting technology. The company’s CoSORT system is best described as a proprietary parallel sort engine that excels in bulk-loading and transformations of data to quicken up analytic queries.
IRI argues that by pre-sorting data, IT developers can side-step the database’s native indexing methods, which are much slower. Proponents also argue that pre-sorting radically decreases storage overheads during the initial load phase. IRI says that tests of its CoSORT against Oracle’s native SQL*Loader have yielded up to 10 times faster loading times.
IRI boasts that IBM’s record-breaking record-setting TPC-H (decision support) benchmark for loads and queries at the 300 gigabyte scale in 2000 was a direct result of CoSORT’s ability to quickly sort and load multiple tables in different index orders.
CoSORT is coupled with RightOrder’s QueryEdge software which optimizes the performance of large complex Oracle queries up to hundreds of times faster, according to officials at the Santa Clara, California-based company. The software integrates into the database via Oracle’s Data Cartridge interface.
Just as CoSORT does during load and ETL jobs, QueryEdge reduces the requirements of system resources during query jobs [disk I/O, CPU time, memory and storage], said David Friedland, IRI’s vice president of business development.
