Reference data plays a key role in your business databases and must be free from defects of any kind. So why is it so hard to find information on this critical topic? Recognizing the dangers of taking reference data for granted, Managing Reference Data in Enterprise Databases gives you precisely what you've been seeking: A complete guide to the implementation and management of reference data of all kinds.
This book begins with a thorough definition of reference data, then proceeds with a detailed examination of all reference data issues, fully describing uses, common difficulties, and practical solutions. Whether you're a database manager, architect, administrator, programmer, or analyst, be sure to keep this easy-to-use reference close at hand.
* Solves special challenges associated with maintaining reference data.
* Addresses a wide range of reference data issues, including acronyms, redundancy, mapping, life cycles, multiple languages, and querying.
* Describes how reference data interacts with other system components, what problems can arise, and how to mitigate these problems.
* Offers examples of standard reference data types and matrices for evaluating management methods.
* Provides a number of standard reference data tables and more specialized material to help you deal with reference data, via a companion Web site
"synopsis" may belong to another edition of this title.
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 shows 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 realise your designs. --David Wall
Topics covered: Efficient database design as it relates to reference data, or data that's used to categorise 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 Organisation (ISO).
"About this title" may belong to another edition of this title.
Shipping:
£ 3.20
Within U.S.A.
Book Description Hardcover. Condition: new. New. Fast Shipping and good customer service. Seller Inventory # Holz_New_1558606971
Book Description Condition: new. Seller Inventory # FrontCover1558606971
Book Description Hardcover. Condition: new. New Copy. Customer Service Guaranteed. Seller Inventory # think1558606971
Book Description Hardcover. Condition: new. New. Seller Inventory # Wizard1558606971