ER 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
Capturing Business Value with Enterprise Metadata Management
As data itself has become currency, the metadata describing it — and what happens to it — has also emerged as a core asset of modern business. Read More
An Introduction to Mashups
The concept of mashups is a simple one: combining separate, typically heterogeneous elements into a single, compound, and useful system. A stick, some rope, and a sharp rock all have their worthy independent uses; but, when combined, they become a spear to make hunting and survival easier. 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
DB Migration with the NextForm Multi-Table Wizard
The “Multi-Table Migration Wizard” in the DBMS edition of IRI NextForm software moves data from one database to another, multiple tables at a time. IRI Voracity platform users can also make use of this feature. 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
Using IRI Data Sources in BIRT
In the previous article, “Affordable BIRT Acceleration via CoSort,” we explained the nature and benefits of a new seamless integration between the SortCL big data preparation program in IRI CoSort and thus IRI Voracity and the Business Intelligence Reporting Tool (BIRT) in Eclipse. Read More
Affordable BIRT Acceleration via CoSort
Business Intelligence Reporting Tool (BIRT) is a free, open source, visual reporting platform for Eclipse, and the commercial foundation for rich analytic extensions available from Actuate. Read More