Posted by Craig S. Mullins at AM No comments: . The tool offers dozens of masking algorithms implemented as Db2 user-defined functions (UDFs). Craig Mullins. You may know Craig from his popular books: Db2 Developer’s Guide, 6th edition and Database Administration: The Complete Guide to DBA. Craig S Mullins is president & principal consultant of Mullins Consulting, Inc., is an IBM Information Champion, and an IBM Gold Consultant for DB2. Craig has.

Author: Yok Arashicage
Country: Malaysia
Language: English (Spanish)
Genre: Health and Food
Published (Last): 24 October 2017
Pages: 345
PDF File Size: 4.61 Mb
ePub File Size: 4.81 Mb
ISBN: 872-1-61779-794-9
Downloads: 54454
Price: Free* [*Free Regsitration Required]
Uploader: Mezizuru

But how to make the decision to change jobs? Because the hashing algorithm will always generate the same number for the same input value you can be sure that referential constraints are taken care of.

Those of you who are regular readers of my blog know that I have written one of the most enduring books on Db2 called DB2 Developer’s Guide.

The results of running a transaction will record the effects of a business process—a complete business process. It draws upon the author’s day-to-day experiences as a DB2 system administrator, database mhllins, and database analyst. Wouldn’t it be nice if there were a place to turn for advice? With all of the data breaches and accusations of improper data usage in the news these days, the question of who owns data looms large. The focus of this umllins is on the… Unboxing My Book: Masking while copying data is generally most useful when copying data from a production environment into caig test or QA system.

Or you can mask data in-place enabling you to mask the contents of an existing set of tables without making another copy.

When the bank receives the ddb2, it performs the following tasks, which make up the complete business process. Fourth and final part of my series of posts on SQL performance; Part 4 provides a quick overview of several additional aspects of SQL optimization that we have yet to discuss. At a high level, both scalability and elasticity help to improve availability and performance when demand is changing, but what exactly are these two things?


Take a look at the data masking capabilities of BCV5 and decide for yourself what you need to protect your valuable data and comply with the industry and governmental regulations on that data.

The Masking Tool comes with several pre-defined lookup tables that contain thousands of names and millions of addresses in many different languages. What are the Database Scalability Methods?

Craig Mullins, Author at IBM IT Infrastructure Blog

Poor Masking versus Good Masking. At any point within the transaction, the decision can be made to stop and roll back the effects of all changes since the last COMMIT. So the hashing algorithm takes the input value and hashes it to a specific number that serves as a seed for a generator. But back to today’s topic He is also a regular contributor to several online data- and database- related portals and blogs.

Why is this so? A dirty read can cause duplicate rows to be returned where none exist. All of the generated data is plausible, but not the real data. In “real life,” though, true read only data is rare.

You request the money either in person by handing a slip to a bank teller or by using an ATM Automated Teller Machine. Regular readers should have noticed that the logo and basic design of the blog has been “spiffed” up a bit. Personal information like name, mulljns, social security number, payment card details; financial data like account numbers, revenue, salary, mllins confidential company information like blueprints, product roadmaps, acquisition plans.

Historically, Thanksgiving has been observed in the United States on various dates. Have you worked on a cool application or figured out a nifty way of managing your databases? And importantly, it is also time to wind down …. So the point of this blog post is just to commemorate the occasion, as t his month, Novembermarks the 30th anniversary of the first tip, which was mailed out to Db2 users in November Each of these four qualities is necessary for a transaction to be designed correctly.


Craig S Mullins

If the UR isolation level was specified for mul,ins second transaction, it would read the changed data even though it had yet to be committed. DevOps and the Database.

When using uncommitted reads, an application program can read data that has been changed, but not yet committed. Application programmers must understand how concurrency problems impact the access and modification of Db2 data. Database Trends and ApplicationsMay 8, TDANApril 18, With all that history aside, I am just looking forward to celebrating with family and eating a nice, juicy turkey!

This article discusses the predominant architectures for implementing database clustering to achieve scalability. So each month, Db2 DBAs would eagerly anticipate receiving the latest tip of the month from Platinum Happy Thanksgiving Just a quick post today to wish all of craog readers in the US and everywhere, really a very Happy Thanksgiving.

IDUG : Craig S Mullins

The input value is hashed to a number that is used as a seed for a generator. Tighten Database- Application Integration. Third of a four part series on SQL performance; Part 3 focuses on the access methods that are used when multiple tables are accessed by SQL joins. I know I did