Chat
Request Info
Download
Overview DB2 UDB MongoDB MySQL Oracle SQL Server Sybase Teradata

Challenges


You have a performance bottleneck or flexibility issue in Oracle with:

  • unloading or loading large tables
  • routine utility operations (reorgs)
  • complex queries or outer joins
  • data (warehouse) integration or staging
  • table migration or replication
  • data discovery, classification or ERDs
  • data masking or encryption
  • SQL transforms or reports
  • test data population or subsetting
  • ODI (data warehouse ETL/ELT) performance

Typical solutions involve complex query analyses, histograms, custom tuning, and expensive appliances.

Solutions


Simple, affordable IRI Software addresses these issues. Services are also available for special needs.

Start with Oracle and other source data discovery and classification in the free IRI Workbench GUI for all the tools below.

Big Data Unload and Load Optimization
Use IRI FACT for Fast Extraction from Oracle. Dump data in parallel from Oracle tables to flat files. Flat files are the fastest, simplest way to stage big data, and the only portable interchange format for large scale data integration, migration, and backup/restore. Here's how you use IRI CoSort to speed Oracle loads:
  • sort on the primary index key of the target table
  • pipe the output to a SQL*Loader operation with the DIRECT=TRUE parameter
  • rebuild the indexes after the load
Pre-sorted, direct path loads are the fastest method for bulk table population.
Query & Reorg Acceleration

Value lookups and joins are faster when data are in key order. Reorganize tables often to:

  • maintain rows in the order of the most common, long-running queries
  • reclaim table space
  • create indexes faster
  • speed error-checking through views

The Offline Reorg wizard in the IRI Workbench (Eclipse GUI) automates the specification and use of FACT, CoSort, and SQL*Loader to perform en-masse Oracle table reorgs.

Use this wizard or any of its component pieces to optimize table reordering without impacting database users. With the space and time saved by offloading transforms and automating SQL*Loader, you can easily create and maintain multiple query tables.

Table / Data Migration and Replication
Use the data source explorer and IRI NextForm or CoSort SortCL jobs in the IRI Workbench to select and subset the data you need to migrate or replicate. Discover sources and define metadata. Acquire, target, and map data in the GUI. Define new data stores and formats ad hoc or en masse. Account for format masks, key, and other constraints.

Data Protection

Oracle column encryption may be cumbersome to implement. Ramp-up data security and privacy law compliance faster -- with more options and auditability -- using IRI FieldShield.

FieldShield offers a vast, database-agnostic array of easy-to-implement, column-level protection functions like encryption, masking, and pseudonymization. Call FieldShield standalone, or from database applications to protect table data at rest, or in motion through queries.

Transformation and Reporting

SQL transforms and reports perform 'order by', 'join', and 'group by' processing inside the database. That is an inherently inefficient place to take those actions when data volumes are large.

Online users can see a degradation in query performance, as the database has to adjust its internal resources to do the heavy lifting of data transformation. The SQL procedure defining those jobs are also lengthy and complex.

The same jobs designed in IRI Voracity ETL workflows, or written directly in the explicit 4GL of CoSort's SortCL program, run much faster -- outside the database! See this page if you use Oracle Data Integrator (ODI) or Oracle Warehouse Builder (OWB).

The IRI Workbench (Eclipse GUI) environment supports SortCL operations for single-pass transformation and reporting, or fast hand-offs to OBIEE and other BI tools (including direct ODA feeds to BIRT in Eclipse). Use FACT (to extract) and SortCL instead of, or alongside, Oracle, for big data integration and reporting.

Free up Oracle for the storage and retrieval it was designed for ... free up the money you've been saving for Exadata.

Enterprise Test Data Creation
To rapidly populate huge Oracle databases or ETL operations with safe, realistic data, use IRI RowGen. RowGen uses your data models to automatically generate and populate structurally and referentially correct test data. There is no need to access or mask production data. Data realism is achieved while still complying with data privacy laws. Alternatively, you can build production subsets automatically with the subsetting wizard in the IRI Workbench.

Request More Information

* indicates a required field.
IRI does NOT share your information.