Data Modeling Basics Tutorial

Author: Allen
Publisher:
Publish Date: 2004-09-01
Features: This book does not require readers to have prior knowledge of relational modeling or practical programming experience. It is suitable for database designers, developers, and DBAs who wish to gain practical technical guidance in relational data modeling. Through numerous real-world applications, the book integrates fundamental theories of relational databases while incorporating practical experiences and techniques refined over the author's decade-long professional practice. It comprehensively and vividly presents what data modeling is and how to establish high-quality data models. The book is divided into three parts and one glossary. Part 1 covers the theoretical foundations and methodologies of data modeling, including basic relational theory and the types and levels of model analysis. Part 2 provides a detailed description of how to apply these theories and methods in practical work by constructing a data modeling example, including conceptual, logical, and physical three-stage modeling in transaction systems, as well as multidimensional modeling in data warehouse systems. Part 3 explains how modelers can add value to development teams. The appendix provides definitions for the specialized terms used in the book.