Data Masking/Protection
Editor’s Note: Note that this article refers to older but still supported methods for obfuscating PII elements like dates of birth and ages in IRI FieldShield. Read More
Data Masking/Protection
Data masking is one method to combat the nearly 72,000 documented breaches of personally identifiable information (PII) that occur every day. With data privacy breaches still at unacceptably high levels, how can companies protect PII such as their national ID numbers across their myriad sources of data? Read More
Big Data
Finding more speed when loading big data is a challenge in ETL, reorg, and very large database (VLDB) index populate operations. Read More
Test Data
The Netherlands uses a method to identify their citizens called the Burgerservicenummer, or BSN. This has replaced the SoFi number. If you would like more information about the SoFi number, refer to the SoFi section below. Read More
Test Data
The Social Security Number (SSN) in the United States is similar to many other forms of national identification around the world, such that it is a number or set of characters that is designated to a citizen or person who has entered the country for an extended stay on a visa. Read More
Test Data
Fiscal Codes in Italy are used in much the same way Social Security numbers are used in the United States. The “Codice Fiscale” identifies citizens, taxpayers, or any other person who has entered the country for an extended stay on a visa. Read More
Big Data
Big Data Problem Big data volumes are growing exponentially. This phenomenon had been happening for years, but its pace began a more rapid acceleration in 2012. Read More
Test Data
Database Test Data Usage – This blog caught my eye because of its title, Do the right thing when testing with production data. It struck me as oxymoronic, since we know production data should not be used for testing at all …
Of course we know how tempting it is to use production data for testing applications, simulating databases, prototyping ETL operations, and just about anything else that needs to work with the real thing. Read More
Data Migration
Data migration is done using NextForm; IRI’s data migration utility for converting large files into different formats and/or translating field-level data into other types. The current version converts between uniform XML and text files, LDIF and CSV, Vision and ISAM, MF COBOL variable-length files and Excel, etc. Read More
Business Intelligence (BI)
Data franchising is the 2003 term coined by Richard Sherman of Athena Solutions to refer to the staging or packaging of large data sets into clean, usable chunks for decision-making, particularly through business intelligence (BI) and analytic software. Read More
Data Transformation
Changing between column and row formats is an online analytical processing (OLAP) activity that optimizes data structures for queries and reports.
A pivot transformation turns multiple rows of data into one, denormalizing a data set into a more compact version by rotating the input data on a column value. Read More
