Data Modeling for Quality

Delivering benefits through attention to detail

Graham Witt

$71.95 $60.77

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Technics Publications LLC
20 January 2021

Data warehousing; Database software; Computer science

This book is for all data modelers, data architects, and database designers―be they novices who want to learn whats involved in data modeling, or experienced modelers who want to brush up their skills.

A novice will not only gain an overview of data modeling, they will also learn how to follow the data modeling process, including the activities required for each step. The experienced practitioner will discover (or rediscover) techniques to ensure that data models accurately reflect business requirements. This book describes rigorous yet easily implemented approaches to: modeling of business information requirements for review by business stakeholders before development of the logical data model; normalizing data, based on simple questions rather than the formal definitions which many modelers find intimidating; naming and defining concepts and attributes; modeling of time-variant data; documenting business rules governing both the real world and data; data modeling in an Agile project; managing data model change in any type of project; transforming a business information model to a logical data model against which developers can code; implementing the logical data model in a traditional relational DBMS, an SQL:2003-compliant DBMS, an object-relational DBMS, or in XML. Part 1 describes business information models in-depth, including: the importance of modeling business information requirements before embarking on a logical data model; business concepts (entity classes); attributes of business concepts; attribute classes as an alternative to DBMS data types; relationships between business concepts; time-variant data; generalization and specialization of business concepts; naming and defining the components of the business information model; business rules governing data, including a distinction between real-world rules and data rules. Part 2 journeys from requirements to a working data resource, covering: sourcing data requirements; developing the business information model; communicating it to business stakeholders for review, both as diagrams and verbally; managing data model change; transforming the business information model into a logical data model of stored data for implementation in a relational or object-relational DBMS; attribute value representation and data constraints (important but often overlooked); modeling data vault, dimensional and XML data.

By: Graham Witt
Imprint: Technics Publications LLC
Country of Publication: United States
Dimensions: Height: 235mm, Width: 190mm, Spine: 16mm
Weight: 526g
ISBN: 9781634629133
ISBN 10: 1634629132
Pages: 304
Publication Date: 20 January 2021
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active

Graham Witt has had four decades of experience in assisting businesses and government departments to acquire relevant and effective IT solutions, and manage information effectively. He has developed specialist expertise in a variety of areas, in particular data modeling and business rules. He has presented papers at conferences in Australia, the US, the UK, France and Germany, as well as meetings of DAMA (the Data Management Association) - in Australia and the US - and ACS (the Australian Computer Society). He has developed and delivered training courses in data modeling, database design and business rules, and delivered them in Australia, the US and Canada. He co-authored with Graeme Simsion the widely-used textbook, Data Modeling Essentials, and Morgan Kaufmann published his book Writing Effective Business Rules in February 2012. Graham has also written articles on natural language business rule statements for the Business Rules Journal.