Rating:
(3 reviews)
Author: Visit Amazon's Malcolm Chisholm Page
ISBN : 1558606971
New from
Format: PDF
Download for free books Free Managing Reference Data in Enterprise Databases (The Morgan Kaufmann Series in Data Management Systems) Hardcover for everyone book 4shared, mediafire, hotfile, and mirror link
Amazon.com Review
Managing Reference Data in Enterprise Databases explores technologies and techniques for managing data that's used to categorize or sort data, with emphasis on keeping it clean, consistent, and current. Reference data, in the lingo of author Malcolm Chisholm, is primarily any data that is used to categorize other data. The U.S. Postal Service abbreviations "PA" for Pennsylvania and "HI" for Hawaii are examples of reference data. Under Chisholm's definition, reference data is generally
not data that exists on a remote system, or that another organization maintains. This book has an academic tone and steers clear of implementation issues that exist in particular database management systems (DBMS); it's a platform-independent engineer's handbook, full of structural diagrams, standard SQL queries, and pseudocode.
Using the clear and widely understood IDE1FIX means of graphically representing table relationships, the author shows how reference tables exist alongside other database contents. He presents some of the reference data problems that pop up in real life (in one succinct example, he writes about getting bonds rated "AAA" to come ahead of bonds rated "A," even though "A" comes first in ASCII sorts). His content will make you think about how to redesign your databases to use reference data more reliably, and offer you enough advice to enable you to realize your designs. --David Wall
Topics covered: Efficient database design as it relates to reference data, or data that's used to categorize other pieces of data. Sections deal with establishing table relationships, deciding on special values (such as those for "none" versus "not applicable"), and dealing with multiple languages. There's also information on referring to remotely maintained reference data, such as abbreviations lists maintained by the International Standards Organization (ISO).
Review
"This is a great book! I have to admit I wasn't enthusiastic about the idea of a book with such a narrow topic initially, but, frankly, it's the first professional book I've read page to page in one sitting in a long time. It should be of interest to DBAs, data architects and modelers, programmers who have to write database programs, and yes, even managers. This book is a winner."
—Karen Watterson, Editor, SQL Server Professional
"Malcolm Chisholm has produced a very readable book. It is well-written and with excellent examples. It will, I am sure, become the Reference Book on Reference Data."
—Clive Finkelstein, "Father" of Information Engineering,
Managing Director, Information Engineering Services Pty Ltd
See all Editorial Reviews
Direct download links available for Free Managing Reference Data in Enterprise Databases
- Series: The Morgan Kaufmann Series in Data Management Systems
- Hardcover: 387 pages
- Publisher: Morgan Kaufmann; 1 edition (September 11, 2000)
- Language: English
- ISBN-10: 1558606971
- ISBN-13: 978-1558606975
- Product Dimensions: 1.1 x 7.4 x 9.2 inches
- Shipping Weight: 2.1 pounds
Free Managing Reference Data in Enterprise Databases
This unique book fills a much needed void in data architecture and system design. Reference data is too often done as an afterthought when data architecture starts taking form. Worse, it is too often misused, resulting in no clear boundaries between transaction data structures and real reference data.