Cover image for Data modeling essentials
Title:
Data modeling essentials
Personal Author:
Edition:
3rd ed.
Publication Information:
Amsterdam : Morgan Kaufmann Publishers, 2005
ISBN:
9780126445510
Added Author:

Available:*

Library
Item Barcode
Call Number
Material Type
Item Category 1
Status
Searching...
30000004987750 QA76.9.D26 S554 2005 Open Access Book Book
Searching...

On Order

Summary

Summary

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.


Author Notes

Graeme Simsion was born in Auckland, New Zealand. His education includes a BSc, GDipC and IS from Monash University, an MBA from Deakin University, a PhD from University of Melbourne, an Advanced Diploma of Screenwriting from RMIT, and a 2014 Diploma of Professional Writing and Editing, RMIT. His Ph.D thesis, Data Modeling: Description or Design, was published in 2006. He is a former IT consultant and the author of two nonfiction books on database design.

He won the 2012 Victorian Premier's Unpublished Manuscript Award for his book, The Rosie Project, which was published in 2013. It also won the Australian Book Industry's General Fiction Book of the Year for 2014 and the Australian Book Industry's Book of the Year for 2014. The screenplay for this book has been optioned to Sony Pictures Entertainment. In 2014 the sequel, called The Rosie Effect, made the New York Times bestseller list.

His 2016 novel, The Best of Adam Sharp, has been optioned by Vocab Films for a screenplay.

He has written numerous award-winning short stories. His most recent short stories include The Life and Times of Greasy Joe, The Big Issue, Like It Was Yesterday, Review of Australian Fiction, and Intervention on the Number 3 Tram, Melbourne Writers Festival.

(Bowker Author Biography)


Table of Contents

Part I Basics
Chapter 1 What is Data Modeling?
Chapter 2 Basics of Good Structure
Chapter 3 The Entity-Relationship Approach
Chapter 4 Subtypes & Supertypes
Chapter 5 Attributes and Columns
Chapter 6 Primary Keys and Identity
Chapter 7 Extensions and Alternatives
Part II Putting it Together
Chapter 8 Organizing the Data Modeling Task
Chapter 9 Understanding the Business Requirements
Chapter 10 Conceptual Modeling
Chapter 11 Logical Database Design
Chapter 12 Physical Database Design
Part III Advanced Topics
Chapter 13 Advanced Normalization
Chapter 14 Modeling Business Rules
Chapter 15 Time-Dependent Data
Chapter 16 Modeling for Data Warehouses and Data Marts
Chapter 17 Enterprise Data Models and Data Management