CoSort big data preparation doubles SAP's Business Objects reporting speed

Issued by Global Research Partners for SPI Group
Johannesburg, 26 Aug 2013

SPI, the African distributor for utility software products and services to the open systems segment of the IT industry and the sole sub-Saharan Africa distributor for USA-based Innovative Routines, today announced that the latter, a long-time leader in big data transformation and data-centric protection technology, is confirming a significant performance improvement method for users of SAP's Business Objects. When IRI's CoSort is used to stage the source data first, Business Objects generates report outputs in half the time.

Premanandham Govindaraju, a Senior BI architect at Unisoft Infotech in Singapore, demonstrated how CoSort prepares, or franchises, huge table and file data for Business Objects in a single job script and I/O pass. "CoSort's processing of the raw data was completed with incredible speed in the file system, and doubled the throughput of the overall BI process," Govindaraju observed.

In Govindaraju's benchmark, a report requiring the sorting, joining and aggregation of two data sources (100MB and 50MB files) took Business Objects 70 seconds to complete on an Intel Core i3 CPU 380 @ 2.53GHz running Windows. When CoSort transformed the data first, however, the subsets were available to Business Objects in 23 seconds. Business Objects then needed another six seconds to present that data in the same report, but the total processing time, to produce the same report on the same data, was only 29 seconds.

Intelligent Solutions President, and Founder of the Boulder BI Brain Trust, Claudia Imhoff has blogged for the B-eye-Network about "operational BI" and latencies in the BI delivery process that come from weak infrastructural tools. "IRI's CoSort is a game-changing engine in operational BI because it removes the transformation overhead of big data from the reporting layer," she remarked, and added that "BI users can more quickly perform both predictive and what-if analyses with CoSort's pre-packaged datasets."

For further information, please contact Chris Anderson at tel. (+27) 11 234 1560; fax (+27) 11 234 1387; e-mail chris@spi.co.za.

IRI brings big database protection technologies to Eclipse

IRI, The CoSort Company

Founded in 1978, Innovative Routines International (IRI) is an independent software vendor specialising in data processing and protection. Headquartered in Melbourne, Florida, IRI has licensing and support offices in more than 30 cities worldwide. Its flagship CoSort package transforms and reports on big data, migrates legacy sorts, and replaces many SQL, shell and 3GL programs. CoSort-compatible tools include FACT (Fast Extract), FieldShield (data masking), NextForm (data conversion), and RowGen (test data).

SPI

SPI is a company that provides utility software products and services to the open systems segment of the IT industry. It is the sole sub-Saharan Africa distributor for USA-based FacetCorp; USA-based Innovative Routines; USA-based Help/Systems, the new owners of Open Systems Management; Privileged User Manager from Australia-based Applecross Technologies; France-based Esker; and UK-based Xi Software. SPI also develops some of its own software utilities to complement the overseas products it distributes.

SPI has a wide and varied customer base and includes organisations such as Aspen Pharmacare, Johannesburg Municipality, University of Johannesburg, Metropolitan Health Group, Nampak, National Brands, Stellenbosch University, UCT and Unisa.

Editorial contacts