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: Shaktizahn Maugami
Country: Burkina Faso
Language: English (Spanish)
Genre: Music
Published (Last): 14 June 2007
Pages: 320
PDF File Size: 13.50 Mb
ePub File Size: 13.98 Mb
ISBN: 288-1-40755-197-9
Downloads: 51137
Price: Free* [*Free Regsitration Required]
Uploader: Brakinos

SQL Performance, Part 3: Database Trends and ApplicationsSeptember 4, Big Data QuarterlyMay 11, Because of the data integrity issues associated with dirty reads, DBAs should keep track of the programs that specify an isolation level of UR.

Dirty read capability is implemented using the UR isolation level for uncommitted read. What do you think?

Craig Mullins

Why is this so? The focus of this book is on the… Unboxing My Book: Another bad approach is shifting the data, for example A — B, B — C, etc.


In other words, transactions exhibit ACID properties. Continuous delivery and the database. Wouldn’t it be nice if there were a place to turn for advice? So let me explain. First of all, there used to be a software company called Platinum Technology…. And importantly, it is also time to wind down …. The focus of this book is on the….

Craig S. Mullins – DB2 Developer’s Guide

Database Trends and ApplicationsJanuary 2, When a transaction is rolled mullnis, the data in the database will be restored to the original state before the transaction was started. Mullins for knowledge of DB2 and clear presentation style. Database Trends and ApplicationsOctober 10, Who Owns the Data?

Terms of Service Privacy Policy Contact. This information can be found in the Db2 Catalog. Second of a four part series on SQL performance; Part 2 focuses on query analysis and the ways that SQL gets turned into executable code.

When the bank receives the request, it performs the following tasks, which make up the complete business process. I wonder where this data came from? With DevOps, more frequent and higher quality program code migrations can occur, but additional work needs to be done to incorporate database change management into the process.


It is also good for enforcing uniqueness. So the hashing algorithm takes the input value and hashes it to a specific number that serves as a seed for a generator. You should look to avoid setting up poor data masking rules.

What type of data should be masked? Some data types, such as social security numbers or credit card numbers, can be generated directly from the seed value through mathematical operations. But as of the 19th Century, the final Thursday in November has been the customary celebration date.

SQL Performance, Part 2: This was well before the days of email and the Internet. 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 and Business Intelligence BI applications, or when a table or set of tables is used by a single user only which is rare.