Written for database novices and pros alike, this book shows how to apply the practical techniques associated with data modeling and design to today's newest database architectures.

In clear, easy-to-understand language, the book first outlines fundamental database concepts such as logical and physical modeling, noramlization, and denormalization, then relates these ideas to advanced platforms including distributed homogeneous database, multi-database, and federated database architectures. Designers and managers who work client / server architectures and database systems quickly gain a solid grasp of multidimensional analysis techniques for on-line analytical processing (OLAP) and object-oriented database architectures.

The book also reveals how basic modeling and design techniques are used every day in real-world products such as CASE tools, relational database management systems, and object database management systems. Other detailed chapters review the ANSI/SPARC database model, explain how to gather the information necessary to build business and process models, describe SQL fundamentals and how to write advanced database applications, and more.

Adding to its value as a practical design tool, Data Modeling and Design for Today's Architectures also comes with software containing sample database applications, which illustrate key topics covered in the book. Created with Barlands Delphi, the applications feature sample screens, basic report generation, and DBASE IV databases.

Content - Preface, Chapter 1 Overview and Road Map, Chapter 2 The ANSI/SPARC Database Architecture and Derivations, Chapter 3 The Business Model, Chapter 4 The Process Model, Chapter 5 Normalization through Data Patterns, Chapter 6 The Logical Model, Chapter 7 The Data Dictionary, Chapter 8 Structured Query Language Fundamentals, Chapter 9 The Physical Model, Chapter 10 Distributed, Multidatabase, and Federated Models, Chapter 11 Multidimensional Models, Chapter 12 Object and Hybrid Relational Models, Chapter 13 CASE Tools, Chapter 14 A Generic Repository Model, Chapter 15 A Repository Maintenance Application Mockup, Index