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 |
|
|
