ISBN 0-89006-877-1
Angelo R. Bobak
504 pages.
Copyright 1997.









Description

Written for database novices and pros alike, this new book helps you strengthen your command of the underlying theory and practical techniques associated with data modeling and design -- and shows you how to better apply these concepts 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, normalization, and denormalization, then relates these ideas to advanced platforms including distributed homogeneous database, multi-database, and federated database architectures. You quickly gain a solid grasp of multi-dimensional analysis techniques for on-line analytical processing (OLAP) and object oriented database architectures, and learn how basic modeling and design techniques are used every day in real-world products. The book also reviews the ANSI/SPARC database model, explains how to gather the information necessary to build business and process models, describes SQL fundamentals and how to write database applications, and more.

Table of Contents

Overview and Road Map. The ANSI/SPARC Database Architecture and Derivations. The Business Model. The Process Model. Normalization Through Data Patterns. The Logical Model. The Data Dictionary. Structured Query Language Fundamentals. The Physical Model. Distributed, Multidatabase, and Federated Models. Multidimensional Models. Object and Hybrid Relational Models. CASE Tools. A Generic Repository Model. A Repository Maintenance Application Mockup.

Software Included

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 Borlands Delphi™, the applications feature sample screens, basic report generation, and DBASE IV databases. One 3.5" IBM PC-compatible diskette.

Related Titles

Data Warehousing and Data Mining for Telecommunications ; Rob Mattison
Multimedia Database Management Systems ; Guojun Lu
Advanced ANSI SQL Data Modeling and Structure Processing Systems ; Michael M. David
Data Quality For The Information Age ; Thomas C. Redman