Practical International Data Management A guide to working with global names and address by Graham Rhind New data collection methods, such as the Internet; the globalization of economies and improving computer hardware and software are allowing companies to collect information about their customers and prospects in ever greater quantities and from increasingly further afield. Managing this data brings with it a whole raft of practical issues which most companies are unaware of and which, if ignored, are expensive and time-consuming to correct. This book details the problems that a company collecting and managing international names and addresses are likely to encounter, and suggests, where available, solutions and ways of preventing the problems arising. Topics tackled include database structure and data format, data cleaning and standardisation, language issues, personal name and address component management and de-duplication. This book can save you time and work, reduce costs and avoid error. It provides all known pitfalls for a company collecting and managing international names and addresses. It also provides solutions, and suggestions for preventing the problems from arising. As these problems can have enormous consequences in time, work and money trying to resolve them, as well as the consequent costs of possible loss of custom is the issues are badly handled, it can save a company a fortune in time and money. Furthermore, the book provides a view of data management from the point of view of the data and data quality, a new perspective for most data managers, helping them to make decisions which can improve data quality and save time and money at the same time, whilst potentially increasing customer satisfaction. Contents list: • Acknowledgements o Going Global o The global market • Data quality o The database and its structure o Before you start o The right person for the right job - peopleware o Resources o What is a database? o Database? Interface! o Data only o Which database structure should you use? o What information should you store in a database? • Principles of data management o Data storage • Database structure for international data o Database structure for international data • Practical international data management and standardisation o Standardisation o Localisation o Numeric or character fields o Casing o Address language o Acronyms and abbreviations o Punctuation o And, & and + o Articles o Diacritical marks o Quotation marks o Apostrophes • Languages o Writing systems o Transliteration o Writing direction o Diacritical marks o Languages and international database management in practice • Personal names o Global variations in naming conventions o Name changes by context o Name order o Casing o Name variety o Names in different languages o Nicknames o Gender o Householding o Form of address and academic titles o Seniority o Names as parts of addresses o Personal names in the address block o Handling personal names in practice • Company details, telephone numbers and job titles o The company name o Telephone and fax numbers o Job titles • Address data o The street address in practical terms o The mailing address o The postal code o Settlement names and sorting codes o Provinces and regions o Countries • Other international data o Dates o Times o Numbers • De-duplication o What is a duplicate Identifying duplicates o De-duplicating on company and address level o De-duplication methodologies • Effective international data collection - bringing the knowledge together o International data collection o Diacritical marks o Example Internet forms o Ideal international Internet data collection • Epilogue • Glossary • Bibliography • Index This book was published on 19th October 2001 at a price of GBP 60. You can order this book from a number of online sources by clicking on the links below: Amazon.com Amazon.co.uk If you have any questions about any of our products, or would like to order them, please contact us.

GRC Data Intelligence Expertise in Global Data

Reviews: Here are what readers and reviewers have said about this book:  - Great book for software developers who work for a company that sells internationally. Very useful information on how the world’s names and addresses are constructed. Most companies try to use US address standards for all names and addresses and fail. Amazon.com 2016 5 star "Can't do without it" rating: "... this book is invaluable ...[the author proposes] procedures and solutions that are realistic, workable and of direct relevance to key business objectives...[it] deserves to be widely read and heavily used...its very practical and business-oriented approach makes it a genuinely useful guide for anyone seeking to navigate through the subtleties and complexities (and heavy costs) of managing international personal data" Justin Arundale, "Managing Information", December 2002 "Graham's new book is a wake-up call for any company whose goals include international sales AND delivery of goods. It is clearly written with wonderful examples of what can go wrong, and instructions on correcting everything from proper usage of family names to diacritics to postal formats within language-specific regions. This is one reference work that will help ensure your mailing will arrive as promised". HS, President of a U.S. e-commerce company "The author is an enthusiast as well as being expert. His enthusiasm shows through the writing, and makes what might easily be an extremely dull technical manual readable and interesting.... this must be the definitive guide" Michael Cook, Emerald Journal - Journal of Documentation, volume 59 issue 3 "...this is an invaluable book. It should be read, and its lessons thoroughly absorbed, by everyone whose business involves the capture, storage, processing and printing of names and addresses...; it should sit permanently on the shelves of everyone who has a professional part to play in determining the methodology of such capture, storage, processing and printing.... a work of reference of permanent value". Robin Fairlie, "Interactive Marketing, the journal of the Institute of Direct Marketing", United Kingdom "I am leading a project developing a global marketing database. In preparation for my project, I ordered your book "Practical International Data Management". The book was very helpful and quickly educated me on the critical issues. Thank you." A manager is a US high-tech company "Our library recently bought a copy of "Practical International Data Management", which I am reading at the moment (and loving it)." Yateendra Joshi, Tata Energy Research Institute, New Delhi, India "Practical International Data Management is a great contribution to database literature and illuminates a very important data management topic. Readers will find many moments of enlightenment and come to appreciate the potential breadth and scope of a serious globalization and localization effort." Lee A. Spain, The Data Administration News "This book is written in a very simple, clear and practical way and should be a standard reference book in the IT department of a company. In summary, it is very useful for designing databases for international data and it would save a lot of time - and future problems - if database designers were to read the book before they started their projects." Professor Yau Lim Yip, University of Teeside Institute for the Management of Information Systems Journal, April 2002 "Managers of international databases, direct marketers, market researchers and telemarketing managers will find this work very informative and useful" Educational Book Review, India, May-June 2002