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: Bralkis Bragami
Country: Albania
Language: English (Spanish)
Genre: Environment
Published (Last): 11 April 2012
Pages: 170
PDF File Size: 6.17 Mb
ePub File Size: 19.42 Mb
ISBN: 122-3-47190-602-6
Downloads: 57493
Price: Free* [*Free Regsitration Required]
Uploader: Arashihn

And here is crait that tip was: If the bank gives you the money but does not debit the account, the bank will be unhappy.

Craig Mullins

Well, now there is! At the beginning over every year many of us take the time to make resolutions for the upcoming year.

First of a four part series on how SQL is turned into executable code. Craig has three decades of experience in all facets of database systems development including developing and teaching DB2 and SQL classes, systems analysis and design, database and system administration, and data analysis crai modeling.

Consider the following sequence of events: Database Trends and ApplicationsMay 8, An Imperative for Compliance and Governance For those who do not know, data masking is a process that creates structurally similar data cdaig is not the same as the values used in production.


Craig S. Mullins – DB2 Developer’s Guide

SQL Performance, Part 1: Mullins has done a good job of transforming highly technical information into easily understandable text. Why cgaig this so? Continuous delivery and the database. BCV5 uses hash functions that map an input value to a single numeric value see Figure 1.

Craig S Mullins

Application programmers must understand how concurrency problems impact the access and modification of Db2 data. Personal information like name, address, social security number, payment card details; financial data like account numbers, revenue, salary, transactions; confidential company information like blueprints, product roadmaps, acquisition plans.

First of all, there used to be a software company called Platinum Technology…. Database Trends and ApplicationsOctober 10, BCV5 and Data Masking.

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. What is Muloins Data? Historically, Thanksgiving has been observed in the United States on various dates.

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

It is hard to believe that yet another year has come and gone well, almost and that the holiday season is once again upon us. Monday, December 17, Dirty Reads More and more devices are being connected mullins the Internet and they are generating more and more data. The input can be any string or a number. Have you ever wanted to put together a presentation and de…. So the hashing algorithm takes the input value and hashes it to a specific number that serves as a seed for a generator.


Masking while copying data is generally most useful when copying data from a production environment into a test or QA system. TDANApril 18, Database Trends and ApplicationsMarch 7, Customer and end- user expectations for interacting with computerized systems have changed—and technology changes to accommodate these requirements. It seems that businesses these days have abdicated any responsibility for ethically managing the collection and usage of data.

Database Trends and ApplicationsDecember 4, Here’s wishing you and yours a healthy, happy, relaxing Thanksgiving day!

IBM Systems Magazine – Learning to Code Efficient Db2 SQL

In a mailbox and delivered by a postal worker. The following two queries can be used to find the applications using uncommitted reads. If DB2 is your profession, this book belongs on your desk.

So, when is it a good idea to implement dirty reads using the UR isolation level? The transaction performing the withdrawal must complete all of these steps, or none of these steps, or else one of the parties in the transaction will be dissatisfied.

DevOps and the Database.