Data Modeling Essentials, Third Edition: Simsion, Graeme, Witt, Graham: 9780126445510: Amazon.com: Books

$16.67 Shipping & Import Fees Deposit to Canada Details

Delivery Friday, July 21. Order within 22 hrs 3 mins

Or fastest delivery Wednesday, July 19

Deliver to Canada

In Stock

[{"displayPrice":"$81.95","priceAmount":81.95,"currencySymbol":"$","integerValue":"81","decimalSeparator":".","fractionalValue":"95","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"s9mL5dYEr9iCtWR4NyqrjdvsGRIvaCuj5DO%2F%2BJXHHpeLTks2Ribccnmdoze%2FlxVUAq2AjbyYN8Bxy92ZmGdEPqbG0RGQunti1qyfy2OxXR9hc%2Bo7eDTtwQSGq3l%2FZZfSwcicUsc1pUA%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0},{"displayPrice":"$22.44","priceAmount":22.44,"currencySymbol":"$","integerValue":"22","decimalSeparator":".","fractionalValue":"44","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"s9mL5dYEr9iCtWR4NyqrjdvsGRIvaCujtVEKAZgFy%2FrqPiceYXqheEUKrNDODv7HUEcBWnV01DSAMIqtSCLQ9fn4FA7gfxdxmcSQAwOMWqQwov18RMp7nHUPt7o7G7FX0qyiEwBAYoEsXbkLkBiaBeW4qMtxURP6VKEPh%2FePCyxS5HZGzptxvP4RyQET4rpX","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":0},{"displayPrice":"$81.95","priceAmount":81.95,"currencySymbol":"$","integerValue":"81","decimalSeparator":".","fractionalValue":"95","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"s9mL5dYEr9iCtWR4NyqrjdvsGRIvaCuj5DO%2F%2BJXHHpeLTks2Ribccnmdoze%2FlxVUAq2AjbyYN8Bxy92ZmGdEPqbG0RGQunti1qyfy2OxXR9hc%2Bo7eDTtwQSGq3l%2FZZfSwcicUsc1pUA%3D","locale":"en-US","buyingOptionType":"PICKUP","aapiBuyingOptionIndex":0}]

$$81.95 () Includes selected options. Includes initial monthly payment and selected options. Details

Payment

Secure transaction

Ships from

Amazon.com

Sold by

Amazon.com

Returns

Eligible for Return, Refund or Replacement within 30 days of receipt

Details

Payment

Secure transaction

We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more

Ships from

Amazon.com

Sold by

Amazon.com

Returns

Eligible for Return, Refund or Replacement within 30 days of receipt

This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.

Read full return policy

Add a gift receipt for easy returns

Delivery Friday, July 21

Or fastest delivery Wednesday, July 19. Order within 7 hrs 3 mins

Deliver to Canada

Used: Good | Details

Sold by Cape Creek Marketing

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

Have one to sell?

Flip to back Flip to front

See all 2 images

Follow the Author

Data Modeling Essentials, Third Edition 3rd Edition

by Graeme Simsion (Author), Graham Witt (Author)

4.2 55 ratings

See all formats and editions

Price

New from

Used from

"Please retry"

—

—

Paperback

"Please retry"

$81.95

$42.10

$14.00

eTextbook
$29.15 - $61.17 Read with Our Free App
Paperback
$22.44 - $81.95

24 Used from $14.00 11 New from $42.10

Data Modeling Essentials, Third Edition, covers the basics of data modeling while focusing on developing a facility in techniques, rather than a simple familiarization with "the rules". In order to enable students to apply the basics of data modeling to real models, the book addresses the realities of developing systems in real-world situations by assessing the merits of a variety of possible solutions as well as using language and diagramming methods that represent industry practice.

This revised edition has been given significantly expanded coverage and reorganized for greater reader comprehension even as it retains its distinctive hallmarks of readability and usefulness. Beginning with the basics, the book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management. It includes an entirely new section discussing the development of logical and physical modeling, along with new material describing a powerful technique for model verification. It also provides an excellent resource for additional lectures and exercises.

This text is the ideal reference for data modelers, data architects, database designers, DBAs, and systems analysts, as well as undergraduate and graduate-level students looking for a real-world perspective.

ISBN-10

0126445516
ISBN-13

978-0126445510
Edition

3rd
Publisher

Morgan Kaufmann
Publication date

November 18, 2004
Language

English
Dimensions

7.5 x 1.27 x 9.25 inches
Print length

560 pages
See all details

Frequently bought together

Data Modeling Essentials, Third Edition

$81.95

In Stock.

Ships from and sold by Amazon.com.

+

Internet Technologies and Information Services (Library and Information Science Text Series)

$70.00

In Stock.

Ships from and sold by Amazon.com.

Total price:

To see our price, add these items to your cart.

Try again!

Added to Cart

Choose items to buy together.

Lowest Pricein this set of products
Andy Oppel
26
Paperback
$26.79
$11.13 shipping
Most purchasedin this set of products
Joe Reis
262
Paperback
$43.99
$11.35 shipping
Highest ratedin this set of products
Margy Ross
642
Paperback
$53.46
$12.27 shipping
This item:
Graeme Simsion
55
Paperback
$81.95
$12.43 shipping
Steve Hoberman
104
Paperback
$44.95
$11.43 shipping
Barbara Carkenord
94
Paperback
$56.53
Get it as soon as Friday, Jul 21
$11.12 shipping
Only 1 left in stock - order soon.
Panos Alexopoulos
27
Paperback
$49.99
$10.91 shipping
Joseph B. Miller
15
Paperback
$70.00
$12.14 shipping
Robin Nixon
516
Paperback
15 offers from $10.75
Len Silverston
39
Paperback
$67.99
$11.86 shipping

Editorial Reviews

Review

"The perfect balance of theory and practice, giving the reader both the foundation and the tools to deliver high-quality data models." --Karen Lopez, Principal, InfoAdvisors, Inc.

"The complete guide to data modeling for the reflective practitioner. Students like this book and so do I -- it is clear and accessible without sacrificing rigor." --Professor Graeme Shanks, School of Business Systems, Monash University, Australia

"A unique, practical and comprehensive guide, providing an invaluable resource to anyone involved in data modeling from the novice to the expert data modeler." --Len Silverston, author of The Data Model Resource Book, Volumes 1 and 2.

"Includes an extraordinary amount of good, useful, and well articulated information about the field." --David Hay, President, Essential Strategies, Inc. and author of Data Model Patterns

"Data Modeling Essentials is a fresh look at an old topic...much more accesible and refreshing in its tone and attitude. Simsion's explanations are very clear and his examples easy to follow...This book is useful for both beginners and experienced data modelers who want a new innovative approach to the important task of documenting data requirements." - The Bridge --Barbara A. Carkenord

"The book is extremely well-written. It is humorous at times, full of useful anecdotes, and follows a very logical sequence...In summary, I found Data Modeling Essentials, Third Edition, very useful for data modelers at any level of experience." --DM Review

Review

A popular classic, substantially revised and expanded

Book Description

A popular classic, substantially revised and expanded.

From the Back Cover

Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.

The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective.

Features
· Thorough coverage of the fundamentals and relevant theory.
· Recognition and support for the creative side of the process.
· Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
· New material describing a powerful technique for model verification.
· Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
· Extensive online component including course notes and other teaching aids (www.mkp.com).|Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.

The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field,Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective.

Features
· Thorough coverage of the fundamentals and relevant theory.
· Recognition and support for the creative side of the process.
· Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
· New material describing a powerful technique for model verification.
· Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
· Extensive online component including course notes and other teaching aids (www.mkp.com).

About the Author

Graeme C. Simsion has over 25 years experience in information systems as a DBA, data modeling consultant, business systems designer, manager, and researcher. He is a regular presenter at industry and academic forums, and is currently a Senior Fellow with the Department of Information Systems at the University of Melbourne.

Graham C. Witt is an independent consultant with over 30 years of experience in assisting enterprises to acquire relevant and effective IT solutions. His clients include major banks and other financial institutions; businesses in the insurance, utilities, transport and telecommunications sectors; and a wide variety of government agencies. A former guest lecturer on Database Systems at University of Melbourne, he is a frequent presenter at international data management conferences.

Product details

Publisher ‏ : ‎ Morgan Kaufmann; 3rd edition (November 18, 2004)
Language ‏ : ‎ English
Paperback ‏ : ‎ 560 pages
ISBN-10 ‏ : ‎ 0126445516
ISBN-13 ‏ : ‎ 978-0126445510
Item Weight ‏ : ‎ 2.45 pounds
Dimensions ‏ : ‎ 7.5 x 1.27 x 9.25 inches

Best Sellers Rank: #462,386 in Books (See Top 100 in Books)
- #33 in Computer Programming Structured Design
- #207 in Data Modeling & Design (Books)
- #315 in Data Processing

Customer Reviews:
4.2 55 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.

Graeme Simsion

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Graeme Simsion is a former IT consultant and the author of two nonfiction books on database design who decided, at the age of fifty, to turn his hand to fiction. His first novel, The Rosie Project, was published in 2013, followed by sequels The Rosie Effect and The Rosie Result. The books have sold some 5 million copies in 40 languages. Graeme's other international bestsellers include The Best of Adam Sharp and Two Steps Forward (sequel Two Steps Onward) written with his wife, Anne Buist. The Novel Project is a step-by-step guide to writing. His latest book is Creative Differences and Other Stories; the title story is a novella about a writing couple. Graeme lives in Australia and is a frequent speaker at book events and writing seminars.

Customer reviews

4.2 out of 5

55 global ratings

5 star
4 star
3 star
2 star
1 star

How customer reviews and ratings work

Sort reviews by

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

An outstanding book

Reviewed in the United States 🇺🇸 on June 29, 2009

Verified Purchase

This is a book structured in three parts.

Part one addresses the basics in data modeling. The need for modeling when designing databases is explained and alternative modeling approaches such as ER and UML discussed. The ER approach is the one developed in detail. Usual data modeling concepts such as Classes, Generalization, Specialization, Attributes, Relationships, Normalization, etc. are introduced and explained here.

The chapter on primary keys discusses the different candidates for key selection and provides valuable guidelines for choosing them. A short chapter on extensions and alternatives to the ER approach, in which the UML notation is addressed, ends part one.

Part two is about the organization of the data modeling task and the data modeling cycle, from the requirements phase to the conceptual, then to the logical data models. Each phase is developed in detail and illustrated through sensibly chosen examples. Thorough pro and con argumentation is provided. How data modeling fits in the project perspective, the role of different actors involved - the business specialist, the data modeler, the database designer, etc. - and project organization matters are addressed too.

Part three addresses advanced normalization - BCNF, 4NF and 5NF - in terms that are as simple and accessible as reasonably possible, compared to other data modeling books that pretend achieving the same level of completeness. Modeling of time-dependent data and business rules, barely avoidable in real-life databases, is also covered.

A short chapter of 21 pages on data warehouses and data marts addresses OLAP data modeling. That's plenty, as the book mainly focuses on OLTP data modeling. Another short chapter whose purpose is to provide a quick overview of enterprise data modeling and of data management aspects in general ends the book.

This is a well-written, well-illustrated and complete book that I liked very much. I highly recommend it. Without doubt, it's an outstanding book written by capable and rigorous authors.

It's also a thick and dense book that beginners should precede by shorter, introductory readings.

5 people found this helpful

Great Book for Data Modelers, Data Architects and Developers

Reviewed in the United States 🇺🇸 on June 2, 2021

Verified Purchase

I've been a data modeler for many years and think this book, plus the Kimball Data Warehouse Toolkit and Len Silverston's three book set on reference data models are the best.

I was afraid that Hadoop and NoSQL killed OLTP and OLAP data modelling, but it seems many startups have created a real mess data model wise and that data modelling as a discipline is making a comeback. Poor data models lead to excessive hacks and patchwork code.

2 people found this helpful

Good, detailed book

Reviewed in the United States 🇺🇸 on August 5, 2006

Verified Purchase

I'm a data architect at a small tech company, now working mostly with data warehouses, and was looking to refresh my data modeling skills. After reading Amazon reviews about different modeling books I chose this one and have not been disappointed. Rather than reading it from front to back, I read the first couple hundred pages and am now skipping around and reading sections that interest me.

The book is logically put together, and has a very detailed contents index, which makes finding relevant information easy. The sections I have read not only explain the theory but also give good examples putting the theory into practice. However, they sometimes seem to place too much emphasis on a theoretical approach that would never be used in the real world.

Overall I find this book very useful and have marked it up with sticky notes for sections I'll revisit for my next database modeling design.

5 people found this helpful

Truly a Mixed Bag of Goods!

Reviewed in the United States 🇺🇸 on November 22, 2009

Verified Purchase

There is a great deal of excellent material contained within the corpus of this text. But to be fair, much of the material is also far less than first rate. In particular, the first and last chapters were excellent. These provided, respectively, an overview of the discipline, with some philosophical underpinnings, and a very excellent, sensible, and readable review of Enterprise Data Modeling strategy. On the other side of the ledger, the chapter on subtypes was very weak, as were several others.

One supposes that such a mixed bag of goods results from two writers attempting together to produce a common message. In this case, that attempt fails. And what we see instead are two markedly different forms of outreach and instruction. I didn't care to discover which author wrote which section. But the results were obvious. It is up, in my view, to the authors and the editors to sort this out in hopes of producing a better quality result in the future.

We would recommend the book, in a qualified sense, to the practictioner. The excellence does outweigh, and prevail over, the mediocrity, even though it is, at times, a "close run thing", as someone famously said. And we would hope also that the authors and editors would take these candid comments to heart. God bless.

7 people found this helpful

Great Background Information

Reviewed in the United States 🇺🇸 on November 30, 2010

Verified Purchase

For me, this was a good book to reinforce what I knew, as well as to try to pick up some key insights that might have escaped me. It covered the majority of database design concepts which I have picked up over the last few years of practical experience in one volume. I would recommend this as a really good place to start out if you are just learning to deal with database design, or if you are starting out with system application design and need to understand how it integrates with the underlying databases.

Sir Not Appearing in this Review

Book scores a 10 on Data Modeling

Reviewed in the United States 🇺🇸 on October 31, 2009

Verified Purchase

Data Modeling Essentials scores a perfect 10 on the subject of data modeling. The topic is difficult and yet this book makes it possible for any aspiring data modeler to be effective if he or she is willing to put in the time. The book is easy to read. The examples are very good. The topic is challenging but with this tutorial you have a chance to be a good data modeler. Even if you are a developer or DBA not responsible for data modeling you will definitely be glad you purchased this book. Just do it.

2 people found this helpful

Top reviews from other countries

Ian C

I have learned that some of the approaches described in ...

Reviewed in Canada 🇨🇦 on May 28, 2015

Verified Purchase

I have learned that some of the approaches described in this book are outdated. As a third edition, it updates some very old material.

Amazon Customer

Excellent

Reviewed in the United Kingdom 🇬🇧 on September 4, 2016

Verified Purchase

Well-structured and written practical book. Would definitely recommend to those starting out on data modeling as this provides you with valuable information in an accessible style.

See all reviews

Get to Know Us

Make Money with Us

Amazon Payment Products

Let Us Help You

English $USD - U.S. Dollar United States

© 1996-2023, Amazon.com, Inc. or its affiliates