Data Modeling for Everyone

Data Modeling for Everyone by Sharon Allen epub pdf fb2

Title: Data Modeling for Everyone
Author: Sharon Allen
ISBN10: 1904347002
ISBN13: 978-1904347002
Publisher: Curlingstone (October 2002)
Language: English
Subcategory: Networking & Cloud Computing
Size PDF: 1777 kb
Size Fb2: 1874 kb
Rating: 4.6/5
Votes: 257
Pages: 500 pages
Other Format: rtf lrf lit doc

Data Modeling for Everyone by Sharon Allen

pdf epub fb2 djvu

Data Modeling is about gathering, documenting, and communicating the elements and structure of business information. What begins as a conceptual interplay of logical data units, through the application of relational theory, becomes the basis for creating a physical database design.

Data Modeling is a core skill for data professionals, and is a full time job for a small but growing number of IT practitioners. It is a crucial stage prior to good quality relational database design.

Data Modeling for Everyone is for those who:

Have no previous data modeling experience Want to understand the role of the data modeler in database design Need to know how to capture the essence of a system but don't know where to start Want more than just the theory and learn best from real world experience Require a book before other data design books – helping you develop a logical model rather than assuming one exists that needs to be implemented in a database

Data Modeling for Everyone provides a solid foundation in the following tools & techniques:

The different types of data modeling – enterprise, transactional, and dimensional The stages of analysis – developing conceptual, logical, and physical models What to do if you need to work with existing systems – reverse engineering and forensic analysis General principles for converting logical models to physical ones Modeling scope – focusing on what's important but allowing for future development of your model Defining detail – entity relationship (E/R), key based, and fully attributed models Documenting your understanding of the business in the model Graphical data modeling, focusing on the IDEF1X notation