Data Modeling Essentials, Third Edition by Graeme Simsion  (21)
$44.70
|
Master Data Management and Customer Data Integration for a Global Enterprise by Alex Berson (2)
$37.79
|
The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises by Len Silverston (31)
$52.00
|
The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries by Len Silverston (16)
$56.00
|
Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information (TM) by Danette McGilvray  (4)
$49.45
|
This item is not eligible for Amazon Prime, but millions of other items are. Join Amazon Prime today. Already a member? Sign in.
Customers Who Bought This Item Also Bought
Editorial Reviews
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.
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 an excellent book that brings out for the first time a comprehensive view of the problems and opportunities that are associated with reference data as part of an organisation's information systems...He also provides excellent summaries of the risks and benefits that can accrue when considering establishing an operational reference data management service. He highlights the important aspects of reference data value maintenance involving data ownership and data stewardship" -- Arthur Haynes
Chairman, British Computer Society's Data Management Specialist Group -- Review
See all Editorial Reviews
Product Details
|