There are a number of performance problems inherent in very large database (VLDB) environments, including:
- Searching, profiling and classifying data
- Query response
- Bulk loads
- Data (PII) masking
- Monitoring, protecting, and auditing
- Migration and replication
- Large scale testing
Any product you license from IRI includes the free IRI Workbench GUI, built on Eclipse, which features multiple tools for data discovery in any JDBC-connected source.
Filter, sort, join, aggregate, reformat and otherwise transform and target table in multiple sources and formats in IRI Voracity workflow and transform mapping diagrams.
Use IRI FACT (Fast Extract) to parallel-unload tables to flat files via native drivers for Oracle, DB2, Sybase, SQL Server, MySQL, Altibase, Greenplum and Teradata.
Sort on the primary index key with CoSort, pipe the results to SQL*Loader, DB2 Load, bcp, etc., and rebuilt the index later.
Set granular access control and SQL execution policies, monitor traffic without impacting the DB, and create query and report-ready audit logs with IRI Chakra Max alone or bundled with a Voracity subscription.
Use IRI RowGen to automatically parse DDL, generate (and modify) the test data, and populate with pre-configured loader scripts.
Use IRI Voracity or IRI NextForm DB Edition to discover, map, replicate, and load data in new target tables, while also being able to transform, mask, and report at the same time.