May 2, 2019 posted by

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. DB2 Developer’s Guide [Craig S. Mullins] on *FREE* shipping on qualifying offers. DB2 Developer’s Guide, Fourth Edition is completely revised.

Author: Tohn Akijas
Country: Eritrea
Language: English (Spanish)
Genre: Spiritual
Published (Last): 3 October 2006
Pages: 358
PDF File Size: 11.53 Mb
ePub File Size: 13.71 Mb
ISBN: 551-1-62988-301-2
Downloads: 90186
Price: Free* [*Free Regsitration Required]
Uploader: Kemi

Data masking is an important component of building any test bed of data — especially when data is copied from production.

Craig S. Mullins – DB2 Developer’s Guide

Because of the data integrity issues associated with dirty reads, DBAs should keep track of the programs that specify an isolation level of UR. Hope you all out there in Db2-land craib the book useful. First of all, there used to be a software company called Platinum Technology….

If a unique constraint is defined on the data different input values will result in different hashed values… and likewise, repeated input values will result in the same hashed output values in other words, duplicates.

For example, credit card numbers pass crsig checks, addresses have matching street names, zip codes, cities, and states, and so on It may consist of several steps and may comprise more than one physical transaction.

Craig S Mullins

From the earliest days of the country until Lincoln, the date Thanksgiving was observed differed from st… Data Masking: ACID is an acronym for atomicity, consistency, isolation, and durability. Read it to save yourself an enormous amount of pain and suffering.

What type of data should be masked? Thursday, November crzig, Happy Thanksgiving At run time, these rules are evaluated and the Masking Tool automatically identifies the involved data types and performs the required masking.

Additionally, if the data being accessed is already questionable, little harm can be done using a dirty read to access the information. Monday, December 17, Dirty Reads The focus of this book is on the…. Published and Available to be Ordered: Programs that read Db2 data typically access numerous rows during their execution and are susceptible to concurrency problems. And importantly, it is also time to wind down and relax with friends, family and loved ones.


Data masking protects the actual data but provides a functional substitute for tasks that do not require actual data values.

Mullins for knowledge of DB2 and clear presentation style. Poor Masking versus Good Masking. Oh, and I’ll probably watch some football, too Application programmers must understand how concurrency problems impact the access and modification of Db2 data. You can avoid all of the problems and hassles of data masking by using a product like BCV5 to mask your data effectively and accurately. What makes this book unique is the case studies illustrating various DB2 10 features and capabilities.

IDUG : Craig S Mullins

If DB2 is your profession, this book belongs on your desk. Personal information like name, mullibs, social security number, payment card details; financial data like account numbers, revenue, salary, transactions; confidential company information like blueprints, product roadmaps, acquisition plans.

The book is designed for ease of use both as a learning tool and a reference. Why is this so? In “real life,” though, true read only data is rare. And that means it is time to reflect on the past year — including all that we have accomplished and what is yet to be done. All materialfiles, umllins, and trademarks within this site are properties of their respective organizations. Some data types, such as social security mulluns or credit card numbers, can crakg generated directly from the seed value through mathematical operations.

The result of the CASE expression is returned in place of the column value in a row. Really, it makes sense to mask anything that should not be public information.

The input can be any string or a number. The following two queries can be used to find the applications using uncommitted reads. In other words, transactions exhibit ACID properties. Craig’s no-nonsense approach to DB2 topics could only come from the knowledge of having worked in the pits in-depth with DB2. For example, if the primary key is X, any foreign key referring to that PK would also contain the value X… and X always hashes to the same number, so the generated value would be the same for the PK and all FKs.


The number is calculated using the hashing algorithm, it is not a random number. There are many methods of masking data, some better than others. Our m odern idea of Thanksgiving was first officially called for in all states in by a presidential proclamation made by Abraham Lincoln.

Historically, Thanksgiving has been observed in the United States on various dates. Other types of data, like names or addresses, are picked from a set of lookup tables.

The tool offers dozens of masking algorithms implemented as Db2 user-defined functions UDFswritten in PL SQL so they are easy to understand and customize if you so desire. So let me explain. If the data is read only, a dirty read is fine because there are no changes being made to the data.

If the bank debits your account but does not give you your money, then you will not be satisfied. A dirty read can cause duplicate rows to be returned where none exist.

Craig Mullins

Because the hashing algorithm will always generate carig same number for the same input value you can be sure that referential constraints are taken care of. Terms of Service Privacy Policy Contact. If you want the ebook, it can be ordered from the same link below. A time to put down the work that consumes us most of the year and to celebrate and enjoy