Data Migration
Data and database migration are key considerations for any system implementation, upgrade, or consolidation. Data migration happens for many reasons, like appliance upgrades or enhancements, server maintenance, or data center relocation. Read More
Test Data
RowGen produces test values in target database tables, flat files, and custom reports through either random data generation (based on the defined data type) or random selection (using different random pull methods) from data in “set files.” Read More
Data Masking/Protection
Data Privacy on Fire We’re still seeing data breach headlines burning across news outlets and social media, fast and hot:
The Equifax Breach was Entirely Preventable – Wired States Investigate Experian Data Breach – Krebs on Security ‘Heartbleed’ Bug in OpenSSL Exposes Millions of Online Passwords – Reuters Millions of Target Customers’ Credit, Debit Card Accounts May Be Hit by Data Breach – NBC News Neiman Marcus Data Breach Worse Than First Said – New York Times Retailers Hit by Credit-Data Breach Smaller Than Target’s – Bloomberg NewsAnd the fire burns on. Read More
Data Quality (DQ)
Note: This article, first published in 2014, refers to date reformatting technology in the SortCL data manipulation program central to the IRI CoSort data transformation product and larger IRI Voracity data management platform. Read More
IRI Business
The other day, two different companies selling me services asked if their offering were in my wheelhouse. Since I didn’t know I had a wheelhouse, I couldn’t answer them.I Read More
Data Quality (DQ)
Introduction
In this article, I suggest ways to move your company’s data towards a higher state of quality. The highest quality occurs when the data meets the needs of your company. Read More
Big Data
As the old English proverb says, “necessity is the mother of invention.” When it comes to modern business intelligence goals, these words of wisdom ring truer than ever. Read More
Big Data
Before Big Data became a buzz word and Gartner hype cycle fodder (never mind falling into the ‘Trough of Disillusionment‘), companies like IRI were handling it. Read More
Business Intelligence (BI)
About Standard Deviation
Standard Deviation is a statistical measure of variance between data values and their mean (or average value). Standard deviation is calculated as the square root of that variance. Read More
Test Data
The value of good test data to DBAs is well known:
“Testing of database-intensive applications has unique challenges that stem from hidden dependencies, subtle differences in data semantics, target database schemes, and implicit business rules. Read More
Data Transformation
Job schedulers are computer programs controlling other program executions behind the scenes, or as part of batch processes. This workload automation is typically coordinated so that traditional background data processing can be integrated with real-time business activities without depleting resources or interfering with other applications. Read More
