Designing Effective Database Systems

Rebecca M. Riordan - Collection Database

354 pages, parution le 10/03/2005

Ajouter à une liste

Indisponible

Résumé

The Software Developer's Step-by-Step Guide to Database Design

World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren't database experts. No matter how messy or complex your data challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it.

Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field's clearest introduction to dimensional database modeling-practical insight for designing today's increasingly important analytical applications.

One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability.

This book will teach you to

Understand relational database models, structures, relationships, and data integrity principles
Define database system goals, criteria, scope, and work processes
Construct accurate conceptual models: relationships, entities, domain analysis, and normalization
Build efficient, secure database schema
Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more
Architect and construct easy, efficient interfaces for querying and reporting
Learn from practice examples based on Microsoft's Northwind sample database

Riordan has helped thousands of professionals master database design and development, earning Microsoft's coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.

L'auteur - Rebecca M. Riordan

Rebecca M. Riordan is the author of Microsoft SQL Server 2000 Programming Step By Step (Microsoft Press, 1999). She has worked as a consultant, systems analyst, and senior technical support engineer for Microsoft Australia and she studied database design and analysis at the University of California, Irvine. Rebecca was also a presenter at 1994 and 1995 TechEd sessions, overing topics ranging from reusable system components to searching data stores.

Sommaire

Preface
Acknowledgments
Relational Database Theory
- Basic Concepts
- Database Structure
- Relationships
- Data Integrity
- Relational Algebra
Dimensional Database Theory
- Basic Dimensional Concepts
- Fact Tables
- Dimension Tables
Designing Database Systems
- The Design Process
- Defining the System Parameters
- Defining the Work Processes
- The Conceptual Data Model
- The Database Schema
- Communicating the Design
Designing The User Interface
- The Interface as Mediator
- User Interface Architectures
- Representing Entities in Form Design
- Choosing Windows Controls
- Maintaining Database Integrity
- Reporting
- User Assistance
Bibliography
Glossary
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Addison Wesley
Auteur(s)	Rebecca M. Riordan
Collection	Database
Parution	10/03/2005
Nb. de pages	354
Format	17,5 x 23,5
Couverture	Broché
Poids	727g
Intérieur	Noir et Blanc
EAN13	9780321290939
ISBN13	978-0-321-29093-9