The Orca and IRI Voracity
Intelligent. Fierce. Powerful. Fast. Voracious.
Killer whales, or orcas thrive in every world ocean and in many seas. They are intelligent, lively, and highly social creatures that form close, matrilineal groups. Read More
Introduction to Slowly Changing Dimensions (SCD)
A dimension is a structure that categorizes a collection of information so that meaningful answers to questions regarding that information may be obtained. Dimensions in data management and data warehouses contain relatively static data; however, this dimensional data can change slowly over time and at unpredictable intervals. Read More
Data Quality and Fuzzy Searching
IRI is now also delivering fuzzy search functions, both in its free database and flat-file profiling tools, and as available field-function libraries in IRI CoSort, FieldShield, and Voracity to augment data quality, security, and MDM capabilities. Read More
Creating E-R Diagrams in IRI Workbench
The Entity-Relationship Diagram (ERD), or entity relationship model, is a visual depiction of database tables (entities) and how they are linked through primary and foreign keys (relationships) to each other. Read More
Schema Migration: Relational to Star
Note: This article showcases the migration of a relational database (RDB) model to star schema using the Eclipse IDE for the IRI Voracity data management platform (and its included products) called IRI Workbench, following an introduction to both types of schema. Read More
How to Generate DB Test Data
IRI RowGen users can generate structurally and referentially correct synthetic test data for an entire database in a single operation. The test data reflects production characteristics (such as values ranges and frequencies) normally encountered in database or ETL operations, but does not require access to, or the masking of, real data. Read More
Easier Big Data Prep for R
Among analytic tools for statistical computation and graphics, R has shown an increase in popularity among data miners, and in the development of its open source language. Read More
Database Migration in IRI NextForm
The “Multi-Table Migration Wizard” in the DBMS edition of the IRI NextForm data migration tool maps and moves data from one database to another, multiple tables at a time. Read More
Database Profiling in IRI Workbench
Editors Updates: Q2’16: In addition to the database profiling wizard in the data discovery menu group in IRI Workbench described below, IRI has introduced robust data classification that enables the application of field rules for multi-source data transformation and protection through data class libraries. Read More
Connecting to 84 More Data Sources
Data architects and data scientists, as well as DBAs and governance teams, may need to use or migrate data in legacy file formats and databases. Additionally, the ability to mash-up those sources with newer file and database repositories is important in data integration (ETL) and analytic projects, as well as in data profiling for data loss prevention and privacy law compliance. Read More
Master Data Management with Git
Master Data Management (MDM) is a strategic enterprise information management (EIM) life cycle initiative designed to foster the consistency and accurate maintenance of master (or reference) data. Read More