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: Negis Akinogar
Country: Spain
Language: English (Spanish)
Genre: Automotive
Published (Last): 19 April 2008
Pages: 87
PDF File Size: 2.93 Mb
ePub File Size: 9.74 Mb
ISBN: 984-7-39087-531-3
Downloads: 35084
Price: Free* [*Free Regsitration Required]
Uploader: Voodoorn

The input can be any string or a number. A transaction is an atomic unit of work with respect to recovery and consistency. Ccraig the earliest days of the country until Lincoln, the date Thanksgiving was observed differed from st… Data Masking: Posted by Craig S.

To summarize, a transaction—when executed alone, mullisn a consistent database—will either complete, producing correct results, or terminate, with no effect. The link provides more det…. 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.

Some data types, such as social security numbers or credit card numbers, can be generated directly from the seed value through mathematical operations. The goal should be to mask your data such that it works like the actual data, but does not contain any actual data values or any processing artifacts that make it possible to infer information about the actual data. The book is designed for ease of use both as a learning tool and a reference.

That can wreak havoc on data integrity Because of the data integrity issues associated with dirty reads, DBAs should keep track of the programs that specify an isolation level of UR. For example, credit card numbers pass validity checks, addresses have matching street names, zip codes, cities, and states, and so on If the data is read only, a dirty read is fine because there are no changes being made to the data.


Mullins has done a good job of transforming highly technical information into easily understandable text. Application programmers must understand how concurrency problems impact the access and modification of Db2 data. If you want the ebook, it can be ordered from the same link below. If DB2 is your profession, this book belongs on your desk. Order DB2 Developer’s Guide6th edition.

The Masking Tool comes with several pre-defined lookup tables that mullind thousands of names and millions of addresses in many different languages. Historically, Thanksgiving has been observed in the United States on various dates.

And yes, I said mailed. In either case the resulting condition of the database will be a consistent state. Why is this so? Dirty read capability is implemented using the UR isolation level for uncommitted read.

Mullims number is calculated using the hashing algorithm, it is not a random number. Well, back in the day, Platinum was one of the most innovative marketers in the world of Db2, and they used to mail out a monthly tip about how to use Db2 more efficiently. In “real life,” though, true read only data is rare.

Each of these four qualities is necessary for a transaction to be designed correctly.

Whether you are a DB2 expert or just want to broaden your knowledge, a systems programmer or a programmer, this book contains an enormous amount of data which is beautifully presented.

Mask data when copying or mask-in-place. At run time, these rules are evaluated and the Masking Tool automatically identifies the involved data types and performs the required masking. Terms of Service Privacy Policy Contact. Such a capability is important to be in….

Mullins Consulting, Inc. (Craig S. Mullins)

To be in compliance, all PII must be masked or changed, and if it is changed, it should look plausible and work the same as the data it is masking. Masking while copying data is generally most useful when copying mullis from a production environment into a test or QA system.

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 and modeling.


Examples include access to a reference, code, or look-up table where the data is non-volatilestatistical processing on large amounts of data, analytical queries in data warehousing crait Business Intelligence BI applications, or when a table or set of tables is used by a single user only which is rare.

The dirty read capability can provide relief to concurrency problems and deliver faster performance in specific situations. So let me explain.

Craig Mullins

Poor Masking versus Good Masking. A dirty read can cause duplicate rows to be returned where none exist. First of all, there used to be a software company called Platinum Technology…. Regular readers should have noticed that the logo and basic design of the blog has been “spiffed” up a bit. If the bank debits your account but does not give you your money, then you will not be satisfied.

Monday, November 12, Data Masking: It has been in print for over twenty years in 6 different editions. Masked data does not kullins sensitive data to those using it for tasks like software testing and user training.

Have you ever wanted to put together a presentation and de…. But often this is done without a thorough investigation of the possible implications.

Happy Thanksgiving Just a quick post today to wish all of my readers in the US and everywhere, really a very Happy Thanksgiving. Wouldn’t it be nice if there were a place to turn for advice? Thursday, November 22, Happy Thanksgiving If you’ve bought a….

And importantly, it is also time to wind down and relax with friends, family and mulline ones.

Well, now there is! Generally speaking, I think blogs are mostly for ….

Leave a Reply