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
Test Data
This article is the last of a 4-step series introduced here.
Step 4: Test Data Sharing & Persistence
Being able to modify, deploy, store, and re-use test data is important. Read More
Data Quality (DQ)
This article is part of a 4-step series introduced here. Navigation between articles is below.
Step 3: Test Data Generation & ProvisioningIn prior steps outlined in this series, you have determined the purpose and properties of the data, and who will produce and consume it. Read More
IRI Business
This article is part of a 4-step series introduced here. Navigation between articles is below.
Step 2: Test Data Needs Assessment
Once the questions of who needs test data for what — and who will be dealing with it along its lifecycle are answered (see Step 1) — a deeper dive is needed into the specific technical aspects of the data itself. Read More
Test Data
This article is part of a 4-step series introduced here. Navigation between articles is below.
Step 1: Goal Setting & Team BuildingSomeone needs test data to do something, like:
stress-testing the functions and performance of applications prototyping database load/query and DW ETL/ELT operations benchmarking prospective new hardware or software outsourcing development or proofs of concept demonstrating systems with real-looking, but not real, sample dataIn all these cases, the most realistic data possible is needed, but it should also be safe and de-personalized. Read More
Test Data
Welcome to IRI’s primer on test data management. This is the opening article, which is followed by a 4-step series.
IntroductionAs anyone familiar with the challenges of healthcare.gov Read More
IRI Business
Imagine it’s time to write a headline for your blog article. You just spent hours drafting, in your opinion, a masterpiece. You selected a great keyword or two as the basis of your subject and compiled some great content to make that keyword shine. Read More
MDM
Background
Lines of business do not think in terms of metadata per se. Users want to know what information is available, and where it is. They want to know if the data is reliable, protected, who’s using it, where it came from and how it’s been changed. Read More